Re: JNDI Datasource example

Mag Gam wrote:

>Does anyone have a GOOD example of PostgreSQL with Tomcat using JNDI? I
>was looking at
>http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html
>but the code they provided really did not help. If someone has some code
>please post it. Thanks in advance!
>
>
Just case you were using the same approach as I did and used the tomcat
admin application to create the JNDI resource

Lets assume a datasource named "jdbc/testds" and a context named "testctx"

put your postgres jdbc driver into $TOMCAT/common/lib, restart Tomcat

Create the datasource using the tomcat admin application, use
org.postgresql.Driver as driverClass and
jdbc:postgresql://localhost/<database> as URL

insert the following in your applications WEB-INF/web.xml:
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/testds</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

Create a META-INF/context.xml and insert:
<Context path="/testctx" reloadable="true">
<ResourceLink name="jdbc/testds" global="jdbc/testds"
type="javax.sql.DataSource"/>
</Context>

Use the following code to lookup the datasource:
try{
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("JNDI could not create InitalContext ");

Context envContext = (Context)ctx.lookup("java:/comp/env");
datasource = (DataSource)envContext.lookup(jndiName);

} catch(Exception e) {
e.printStackTrace();
}

this works for me...

cu Harry