You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by John McNally <jm...@collab.net> on 2002/06/20 22:29:06 UTC
Re: [jdbc2pool] Database "" does not exist in the system catalog
????
Some of the property names are incorrect. Try correcting these and then
once you get it working you can add more configuration.
remove these lines:
> <parameter><name>maxActive</name><value>100</value></parameter>
> <parameter><name>maxIdle</name><value>30000</value></parameter>
> <parameter><name>maxWait</name><value>100</value></parameter>
Then replace
<parameter><name>defaultMaxConnections</name><value>30</value></parameter>
<parameter><name>maxExpiryTime</name><value>3600</value></parameter>
<parameter><name>connectionWaitTimeout</name><value>10</value></parameter>
<parameter><name>logInterval</name><value>10</value></parameter>
with
<parameter><name>defaultMaxActive</name><value>100</value></parameter>
If you still do not get a valid connection, check catalina's logs for
errors encountered trying to deploy the objects into jndi. Please let
me know how it goes.
john mcnally
On Thu, 2002-06-20 at 11:56, Brian Millett wrote:
> I am running tomcat 4.1.3-b, latest cvs co (this am) of commons-sandbox
> (commons-lang-1.0-dev.jar, jdbc2pool-4.1.jar, commons-pool.jar, &
> commons-dbcp.jar) on a redhat 7.2, jdk build 1.4.0_01-b03.
>
> My server.xml cruft is: (inside of the /examples context)
> <!-- TROPICOSDB -->
> <Resource name="jdbc/tropicosDB"
> auth="Container"
> type="org.apache.commons.jdbc2pool.adapter.DriverAdapterCPDS"/>
> <ResourceParams name="jdbc/tropicosDB">
> parameter><name>factory</name>
>
> <value>org.apache.commons.jdbc2pool.adapter.DriverAdapterCPDS</value>
> </parameter>
> <parameter><name>maxActive</name><value>100</value></parameter>
> <parameter><name>maxIdle</name><value>30000</value></parameter>
> <parameter><name>maxWait</name><value>100</value></parameter>
> <parameter><name>user</name><value>XXXXXX</value></parameter>
> <parameter><name>password</name><value>XXXXX</value></parameter>
> <parameter>
> <name>driver</name>
> <value>org.postgresql.Driver</value></parameter>
> <parameter>
> <name>url</name>
> <value>jdbc:postgresql://vlad:5432/tropicos</value>
> </parameter>
> </ResourceParams>
> <!-- TROPICOS -->
> <Resource name="jdbc/tropicos" auth="Container"
> type="org.apache.commons.jdbc2pool.Jdbc2PoolDataSource"/>
> <ResourceParams name="jdbc/tropicos">
> <parameter><name>factory</name>
> <value>org.apache.commons.jdbc2pool.Jdbc2PoolDataSource</value>
> </parameter>
> <parameter><name>dataSourceName</name>
> <value>java:comp/env/jdbc/tropicosDB</value>
> </parameter>
> <parameter><name>defaultMaxConnections</name><value>30</value></parameter> <parameter><name>maxExpiryTime</name><value>3600</value></parameter> <parameter><name>connectionWaitTimeout</name><value>10</value></parameter> <parameter><name>logInterval</name><value>10</value></parameter>
> </ResourceParams>
> <!-- END JDBC/JNDI -->
>
> OK, now in the web.xml in the /examples/WEB-INF dir I have:
> <resource-ref>
> <description>
> Resource reference to a factory for java.sql.Connection
> instances that may be used for talking to a particular
> database that is configured in the server.xml file.
> </description>
> <res-ref-name>jdbc/tropicosDB</res-ref-name>
>
> <res-type>org.apache.commons.jdbc2pool.adapter.DriverAdapterCPDS</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
> <resource-ref>
> <description>
> Resource reference to a factory for java.sql.Connection
> instances that may be used for talking to a particular
> database that is configured in the server.xml file.
> </description>
> <res-ref-name>jdbc/tropicos</res-ref-name>
>
> <res-type>org.apache.commons.jdbc2pool.Jdbc2PoolDataSource</res-type>
> <res-auth>Container</res-auth>
> </resource-ref>
>
>
> OK, I now try to access a servlet DBDumperPool where this section of
> code causes an error:
> Context initCtx = new InitialContext();
> Context envCtx = (Context) initCtx.lookup("java:comp/env");
> DataSource ds = (DataSource)envCtx.lookup("jdbc/tropicos");
> // Connect to database
> out.println("<h1>Connecting to Database JNI Context =
> jdbc/tropicos</h1>");
> Connection conn = ds.getConnection();
> out.println("<h1>Connected...Now creating a statement</h1>");
> st = conn.createStatement();
>
>
> The error is:
> java.lang.RuntimeException: Backend start-up failed: FATAL 1: Database
> "tropicos" does not exist in the system catalog.
>
> at
> org.apache.commons.jdbc2pool.KeyedCPDSConnectionFactory.makeObject(KeyedCPDSConnectionFactory.java:173)
> at
> org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Unknown
> Source)
> at
> org.apache.commons.jdbc2pool.Jdbc2PoolDataSource.getConnection(Jdbc2PoolDataSource.java:879)
> at
> org.apache.commons.jdbc2pool.Jdbc2PoolDataSource.getConnection(Jdbc2PoolDataSource.java:821)
> at DBDumperPool.testDB(DBDumperPool.java:105)
> at DBDumperPool.doGet(DBDumperPool.java:29)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>
>
> Line 105 is Connection conn = ds.getConnection();.
>
>
> I've tried real hard to understand how to setup the jdbc2pool package
> with tomcat. I do not know what a KeyedCPDSConnection is.
>
> What is the correct steps?
>
> Any hints, ideas, etc would be very helpful.
>
> Thanks.
> --
> Brian Millett
> Enterprise Consulting Group "Shifts in paradigms
> (314) 205-9030 often cause nose bleeds."
> bpm@ec-group.com Greg Glenn
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: [jdbc2pool] Database "" does not exist in the system catalog
????
Posted by "Brian P. Millett" <bp...@ec-group.com>.
On Thu, 2002-06-20 at 15:29, John McNally wrote:
> Some of the property names are incorrect. Try correcting these and then
> once you get it working you can add more configuration.
>
> remove these lines:
>
> > <parameter><name>maxActive</name><value>100</value></parameter>
> > <parameter><name>maxIdle</name><value>30000</value></parameter>
> > <parameter><name>maxWait</name><value>100</value></parameter>
>
> Then replace
>
> <parameter><name>defaultMaxConnections</name><value>30</value></parameter>
> <parameter><name>maxExpiryTime</name><value>3600</value></parameter>
> <parameter><name>connectionWaitTimeout</name><value>10</value></parameter>
> <parameter><name>logInterval</name><value>10</value></parameter>
>
> with
>
> <parameter><name>defaultMaxActive</name><value>100</value></parameter>
>
DUH!! I had tried the TorqueClassicDataSource and forgot to change the
parameters back. Oh well, I did the change, but with the same result as
before. I get 0 errors in catalina.out, nor the other logs. Just the
'Database "tropicos" does not exist in the system catalog' error.
Thanks.
>
> If you still do not get a valid connection, check catalina's logs for
> errors encountered trying to deploy the objects into jndi. Please let
> me know how it goes.
>
> john mcnally
>
> On Thu, 2002-06-20 at 11:56, Brian Millett wrote:
> > I am running tomcat 4.1.3-b, latest cvs co (this am) of commons-sandbox
> > (commons-lang-1.0-dev.jar, jdbc2pool-4.1.jar, commons-pool.jar, &
> > commons-dbcp.jar) on a redhat 7.2, jdk build 1.4.0_01-b03.
> >
> > My server.xml cruft is: (inside of the /examples context)
> > <!-- TROPICOSDB -->
> > <Resource name="jdbc/tropicosDB"
> > auth="Container"
> > type="org.apache.commons.jdbc2pool.adapter.DriverAdapterCPDS"/>
> > <ResourceParams name="jdbc/tropicosDB">
> > parameter><name>factory</name>
> >
> > <value>org.apache.commons.jdbc2pool.adapter.DriverAdapterCPDS</value>
> > </parameter>
> > <parameter><name>maxActive</name><value>100</value></parameter>
> > <parameter><name>maxIdle</name><value>30000</value></parameter>
> > <parameter><name>maxWait</name><value>100</value></parameter>
> > <parameter><name>user</name><value>XXXXXX</value></parameter>
> > <parameter><name>password</name><value>XXXXX</value></parameter>
> > <parameter>
> > <name>driver</name>
> > <value>org.postgresql.Driver</value></parameter>
> > <parameter>
> > <name>url</name>
> > <value>jdbc:postgresql://vlad:5432/tropicos</value>
> > </parameter>
> > </ResourceParams>
> > <!-- TROPICOS -->
> > <Resource name="jdbc/tropicos" auth="Container"
> > type="org.apache.commons.jdbc2pool.Jdbc2PoolDataSource"/>
> > <ResourceParams name="jdbc/tropicos">
> > <parameter><name>factory</name>
> > <value>org.apache.commons.jdbc2pool.Jdbc2PoolDataSource</value>
> > </parameter>
> > <parameter><name>dataSourceName</name>
> > <value>java:comp/env/jdbc/tropicosDB</value>
> > </parameter>
> > <parameter><name>defaultMaxConnections</name><value>30</value></parameter> <parameter><name>maxExpiryTime</name><value>3600</value></parameter> <parameter><name>connectionWaitTimeout</name><value>10</value></parameter> <parameter><name>logInterval</name><value>10</value></parameter>
> > </ResourceParams>
> > <!-- END JDBC/JNDI -->
> >
> > OK, now in the web.xml in the /examples/WEB-INF dir I have:
> > <resource-ref>
> > <description>
> > Resource reference to a factory for java.sql.Connection
> > instances that may be used for talking to a particular
> > database that is configured in the server.xml file.
> > </description>
> > <res-ref-name>jdbc/tropicosDB</res-ref-name>
> >
> > <res-type>org.apache.commons.jdbc2pool.adapter.DriverAdapterCPDS</res-type>
> > <res-auth>Container</res-auth>
> > </resource-ref>
> > <resource-ref>
> > <description>
> > Resource reference to a factory for java.sql.Connection
> > instances that may be used for talking to a particular
> > database that is configured in the server.xml file.
> > </description>
> > <res-ref-name>jdbc/tropicos</res-ref-name>
> >
> > <res-type>org.apache.commons.jdbc2pool.Jdbc2PoolDataSource</res-type>
> > <res-auth>Container</res-auth>
> > </resource-ref>
> >
> >
> > OK, I now try to access a servlet DBDumperPool where this section of
> > code causes an error:
> > Context initCtx = new InitialContext();
> > Context envCtx = (Context) initCtx.lookup("java:comp/env");
> > DataSource ds = (DataSource)envCtx.lookup("jdbc/tropicos");
> > // Connect to database
> > out.println("<h1>Connecting to Database JNI Context =
> > jdbc/tropicos</h1>");
> > Connection conn = ds.getConnection();
> > out.println("<h1>Connected...Now creating a statement</h1>");
> > st = conn.createStatement();
> >
> >
> > The error is:
> > java.lang.RuntimeException: Backend start-up failed: FATAL 1: Database
> > "tropicos" does not exist in the system catalog.
> >
> > at
> > org.apache.commons.jdbc2pool.KeyedCPDSConnectionFactory.makeObject(KeyedCPDSConnectionFactory.java:173)
> > at
> > org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Unknown
> > Source)
> > at
> > org.apache.commons.jdbc2pool.Jdbc2PoolDataSource.getConnection(Jdbc2PoolDataSource.java:879)
> > at
> > org.apache.commons.jdbc2pool.Jdbc2PoolDataSource.getConnection(Jdbc2PoolDataSource.java:821)
> > at DBDumperPool.testDB(DBDumperPool.java:105)
> > at DBDumperPool.doGet(DBDumperPool.java:29)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> >
> >
> > Line 105 is Connection conn = ds.getConnection();.
> >
> >
> > I've tried real hard to understand how to setup the jdbc2pool package
> > with tomcat. I do not know what a KeyedCPDSConnection is.
> >
> > What is the correct steps?
> >
> > Any hints, ideas, etc would be very helpful.
> >
> > Thanks.
> > --
> > Brian Millett
> > Enterprise Consulting Group "Shifts in paradigms
> > (314) 205-9030 often cause nose bleeds."
> > bpm@ec-group.com Greg Glenn
> >
> >
> > --
> > To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> > For additional commands, e-mail: <ma...@jakarta.apache.org>
> >
>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
Brian Millett
Enterprise Consulting Group "Shifts in paradigms
(314) 205-9030 often cause nose bleeds."
bpm@ec-group.com Greg Glenn
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>