I can confirm that postgresql works ok with DBCP. All of my persistent
components call the same connection code, whatever the database. It is doing
the following :
public static Connection Connect(String resourcename)
throws javax.naming.NamingException, java.sql.SQLException
{
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup(resourcename);
return ds.getConnection();
}
The resourcename passed in will be something like "jdbc/asl". An example
server.xml entry looks
like :
<ResourceParams name="jdbc/asl">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>org.postgresql.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:postgresql://132.1.6.8:5432/asl</value> <!-- asl is a
database that has been created in postgres -->
</parameter>
<parameter>
<name>username</name>
<value>bsuser</value> <!-- not the real user I'm using -->
</parameter>
<parameter>
<name>password</name>
<value>bspassword</value> <!-- not the real password I'm using -->
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
Hope this helps.
Adam Smith
----- Original Message -----
From: "Kunthar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 13, 2004 12:19 PM
Subject: I'll kill JNDI
> Hi all,
>
> I've installed apache 2.049 + Tomcat 5.0.26 + PostgreSQL and i could
> connect apache to tomcat after painful night with mod_jk2.
> So far so good.
> I could do regular jdbc connection by using traditional
> Class.forName(ZOBARA) method to my existing fair pgsql.
> Then i wanted to try my first application's jdbc connection with DBCP
> Pool exist on Tomcat. You know, we need it for bunch of reasons.
> I've read the documentation and also downloaded related JNDI reference
> from sun (which is completely makes blah blah about LDAP)
> Check List;
> 0. rh-postgresql3.jar copied to $CATALINA_HOME/common/lib and removed
> from the all other locations.
> 1. Server.xml changed for postgre jdbc driver as described. (Checked for
> context tags)
> 2. web.xml changed as described.
> 3. My application connection element uses clear sample
> // Obtain our environment naming context
> Context initCtx = new InitialContext();
> Context envCtx = (Context) initCtx.lookup("java:comp/env");
>
> // Look up our data source
> DataSource ds = (DataSource)
> envCtx.lookup("jdbc/mydb");
>
> 4. Built this holly mess with ant by using build.xml
> 5. Point to my page and see this
> "java.sql.SQLException: No connection"
>
> Is there any single one have an idea what's going on???
> I've double checked all the things. If anyone using postgreSQL with DBCP
> please give me a hint.
>
> Thanks
> Take care all
>
>
> Note: Turkish list fellows just drop me a line :=)
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
