struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ZYD" <eljavan...@hotmail.com>
Subject Re: What's the best choice for connection pooling with Struts and PostgreSQL
Date Tue, 04 Nov 2003 12:51:18 GMT
Thanks Paul,

Could you please give me some code snippet about that factory parameter from the server.xml
?

Thanks again.

bruce

> You're mising the factory parameter from your server.xml ResourceParams 
> section. BTW, you don't need that stuff in your struts config file if 
> you're using JNDI.


----- Original Message ----- 
From: "Paul Thomas" <paul@tmsl.demon.co.uk>
To: "ZYD" <eljavanino@hotmail.com>
Cc: "struts-user" <struts-user@jakarta.apache.org>
Sent: Wednesday, November 05, 2003 3:10 AM
Subject: Re: What's the best choice for connection pooling with Struts and PostgreSQL


> 
> On 04/11/2003 02:43 ZYD wrote:
> > I tried to use Tomcat's datasource pool via JNDI, but things not going
> > well.
> > 
> > I got the following exception when I tried to get connection:
> > 
> > org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of
> > class '
> > ' for connect URL 'null', cause:
> > java.lang.NullPointerException
> >         at java.util.StringTokenizer.<init>(StringTokenizer.java:146)
> >         at org.postgresql.Driver.parseURL(Driver.java:251)
> >         at org.postgresql.Driver.acceptsURL(Driver.java:159)
> >         at java.sql.DriverManager.getDriver(DriverManager.java:232)
> >         at 
> > org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
> > rce.java:743)
> >         at 
> > org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
> > .java:518)
> >         at cpool.struts.action.LogonAction.testJNDI(LogonAction.java:185)
> >         at cpool.struts.action.LogonAction.execute(LogonAction.java:60)
> > ....................................................
> > ....................................................
> > 
> > In struts-config.xml, I added the following:
> > 
> >    <data-source>
> >      <set-property property="autoCommit" value="false"/>
> >      <set-property property="description" value="Data Source
> > Configuration"/>
> >      <set-property property="driverClass" value="org.postgresql.Driver"/>
> >      <set-property property="maxCount" value="4"/>
> >      <set-property property="minCount" value="2"/>
> >      <set-property property="password" value=""/>
> >      <set-property property="url" value="jdbc:postgresql:cpool"/>
> >      <set-property property="user" value="cpool"/>
> >    </data-source>
> > 
> > In server.xml:
> > 
> > <Resource name="jdbc/CPool" auth="Container"
> > type="javax.sql.DataSource"/>
> >   <ResourceParams name="jdbc/CPool">
> >   <parameter>
> >     <name>username</name>
> >     <value>cpool</value>
> >   </parameter>
> >   <parameter>
> >     <name>password</name>
> >     <value></value>
> >   </parameter>
> >   <parameter>
> >     <name>driverClassName</name>
> >     <value>org.postgresql.Driver</value>
> >   </parameter>
> >   <parameter>
> >     <name>url</name>
> >     <value>jdbc:postgresql:cpool</value>
> >   </parameter>
> >   <parameter>
> >     <name>maxActive</name>
> >     <value>8</value>
> >   </parameter>
> >   <parameter>
> >     <name>maxIdle</name>
> >     <value>4</value>
> >   </parameter>
> >  </ResourceParams>
> > 
> > Then, I wrote the following method in an Action to test the connection:
> > 
> > public void testJNDI()
> >  {
> >   try
> >   {
> >    Context initCtx = new InitialContext();
> >    Context envCtx = (Context)initCtx.lookup("java:comp/env");
> >    if (envCtx != null)
> >    {
> >     TTools.consolePrint("LogonAction", "envCtx", envCtx.toString());
> >    }
> >    //DataSource ds = (DataSource)envCtx.lookup("jdbc/CPool");
> >    DataSource ds =
> >     (DataSource)initCtx.lookup("java:comp/env/jdbc/CPool");
> > 
> >    Connection conn = ds.getConnection();
> >    if (conn != null)
> >    {
> >     TTools.consolePrint(conn, "Conn", conn.toString());
> >    }
> >    conn.close();
> >   }
> >   catch (NamingException e)
> >   {
> >    // TODO Auto-generated catch block
> >    e.printStackTrace();
> >   }
> >   catch (SQLException e)
> >   {
> >    // TODO Auto-generated catch block
> >    e.printStackTrace();
> >   }
> >  }
> > 
> > Does this problem sounds familiar to you ?
> > Please give some advice on this, thanks in advance.
> 
> You're mising the factory parameter from your server.xml ResourceParams 
> section. BTW, you don't need that stuff in your struts config file if 
> you're using JNDI.
> 
> -- 
> Paul Thomas
> +------------------------------+---------------------------------------------+
> | Thomas Micro Systems Limited | Software Solutions for the Smaller 
> Business |
> | Computer Consultants         | 
> http://www.thomas-micro-systems-ltd.co.uk   |
> +------------------------------+---------------------------------------------+
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org
> 
> 
Mime
View raw message