tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Smith" <a...@csolve.net>
Subject Re: I'll kill JNDI
Date Tue, 15 Jun 2004 11:15:43 GMT
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" <kunthar@gmx.net>
To: <tomcat-user@jakarta.apache.org>
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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message