aspose file tools*
The moose likes JBoss/WildFly and the fly likes How to use configured datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "How to use configured datasource " Watch "How to use configured datasource " New topic
Author

How to use configured datasource

satish bodas
Ranch Hand

Joined: Jun 19, 2008
Posts: 116
Have set up a Postgres Datasource .

I now wanted to make use of it in my code .

Here is my configured datasource :: ( postgres-ds.xml )


After server startup I see the following in the logs ::


So looks like the Datasource is up and running

Questions ::
1 >
Can I use this datasource from a JSP to access the database ?
If yes can someone point me to a code example ?

2 >The above file is located here :: JBOSS_HOME\server\default\deploy

Does this mean that if I have two applications A & B - they can both access the same DB using this Datasource ?

3 >
Can I make the datasource more private ( as in only visible to my application ? )

Thanks ,
~satish
[ July 03, 2008: Message edited by: satish bodas ]
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10263
    
168

Can I use this datasource from a JSP to access the database ?

Yes you can, but not recommended. JSPs are meant for just rendering the view

If yes can someone point me to a code example ?


Here's an example:




2 >The above file is located here :: JBOSS_HOME\server\default\deploy

Does this mean that if I have two applications A & B - they can both access the same DB using this Datasource ?


Yes, they can through JNDI lookup.

Can I make the datasource more private ( as in only visible to my application ? )


You can package the datasource within your application instead of placing it in the deploy folder. But once its available in the JNDI namespace, it can be looked up by other applications, provided they know the jndi-name of your datasource.


[My Blog] [JavaRanch Journal]
satish bodas
Ranch Hand

Joined: Jun 19, 2008
Posts: 116
Thanks for the help - its working .

~satish
satish bodas
Ranch Hand

Joined: Jun 19, 2008
Posts: 116
Thanks for the help - its working .


Yes you can, but not recommended. JSPs are meant for just rendering the view


Agreed - was trying out a quick example of db connectivity .

Thanks for helping out .

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to use configured datasource