How to use configured datasource

[satish bodas]

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 )

    
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>PostgresDS</jndi-name>
<connection-url>jdbc  :-P	  ostgresql://localhost:5432/postgres</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
<password>postgres</password>
 
<metadata>
<type-mapping>PostgreSQL 8.0</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

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

 
18:01:19,671 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=PostgresDS' 
to JNDI name 'java  :-P	  ostgresDS'   

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]

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:

Context ctx = new InitialContext()
DataSource ds = (DataSource) ctx.lookup("java:/PostgresDS");

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.

[satish bodas]

Thanks for the help - its working .

~satish

[satish bodas]

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 .