Thanks for the help. I saw this before, but after giving it a closer look I realized I needed to add the appropriate jars and use the dbcp factory class. Now that it actually at last connects, what is the best way to use this? I stress-tested a bit, and I started to get errors showing up in the log that say this in the stack trace:
java.util.NoSuchElementException: Timeout waiting for idle object at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source) at org.apache.commons.dbcp.PoolingDataSource.getConnection(Unknown Source) at org.apache.commons.dbcp.BasicDataSource.getConnection(Unknown Source) This is after the stress test has been running a few seconds. I suspect I'm not using the DataSource and Connection correctly. Should I keep a Singleton that holds one DataSource instance, and always use it to do getConnection? I tried that, and seem to get the same results. Any help appreciated. > -----Original Message----- > From: Jacob Kjome [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 03, 2002 9:25 AM > To: Tomcat Users List; [EMAIL PROTECTED] > Subject: Re: MS Driver (again) > > > Hello Sean, > > See this email. It has links to a few resources that tell about a > proven way to use DBCP. > > http://marc.theaimsgroup.com/?l=tomcat-user&m=102242646003357&w=2 > > Take a look at your parameters. For instance, "user" should be > "username". Just check and double check that all your configuration > is proper and matches up with an example that has been proven to work > (link above). > > Jake > > Monday, June 03, 2002, 9:25:33 AM, you wrote: > > SL> Has anyone gotten either the Beta 2 or the finalized > driver to work via DataSource? I am getting > SL> nowhere fast with this - does it even work? I *can* > connect w/o using DataSource, but I'm trying > SL> to get database pooling working with Tomcat connecting to > a MS SQL Server 2000 database, and > SL> this seems like it should be a viable option. Thanks in advance. > > SL> Here is the relevant code snippet: > > SL> Context ctx = new InitialContext(); > SL> Context envCtx = (Context)ctx.lookup("java:comp/env"); > SL> System.out.println("Got first context."); > > SL> NamingEnumeration enum =ctx.listBindings("java:comp/env/jdbc"); > SL> while( enum.hasMore() ) { > SL> System.out.println("Binding: " + > ((Binding)enum.next()).toString() ); > SL> } > SL> DataSource ds = > (DataSource)envCtx.lookup("jdbc/nutrosDB"); > SL> System.out.println("Got the second context."); > > SL> if (ds != null) > SL> { > SL> System.out.println("Getting the > connection from the context."); > SL> connection = ds.getConnection(); > SL> } > > SL> ================================== > SL> DataSource is null. Here is the output: > > SL> Got first context. > SL> Binding: nutrosDB: > org.apache.naming.ResourceRef:Reference Class Name: > javax.sql.DataSource > SL> Type: scope > SL> Content: Shareable > SL> Type: auth > SL> Content: Container > SL> Type: user > SL> Content: xxxx > SL> Type: factory > SL> Content: com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory > SL> Type: password > SL> Content: xxxx > SL> Type: url > SL> Content: > jdbc:microsoft:sqlserver://192.168.9.253;user=xxxx;Password=xx > xx;DatabaseName=NutrosDev > SL> Type: driverClassName > SL> Content: com.microsoft.jdbc.sqlserver.SQLServerDriver > SL> Type: database > SL> Content: NutrosDev > > SL> Got the second context. > SL> ===================================== > > SL> Here is the server.xml snippet: > SL> <Resource name="jdbc/nutrosDB" auth="Container" > SL> type="javax.sql.DataSource"/> > SL> <ResourceParams name="jdbc/nutrosDB"> > SL> <parameter> > SL> <name>database</name><value>NutrosDev</value> > SL> </parameter> > > SL> <parameter> > SL> > <name>factory</name><value>com.microsoft.jdbcx.sqlserver.SQLSe > rverDataSourceFactory</value> > SL> </parameter> > > > SL> <parameter> > SL> > <name>driverClassName</name><value>com.microsoft.jdbc.sqlserve > r.SQLServerDriver</value> > SL> </parameter> > > SL> <parameter> > SL> > <name>url</name><value>jdbc:microsoft:sqlserver://192.168.9.25 > 3;user=xxxx;Password=xxxx;DatabaseName=N > SL> utrosDev</value> > SL> </parameter> > > SL> <parameter> > SL> <name>user</name><value>xxxx</value> > SL> </parameter> > SL> <parameter> > SL> <name>password</name><value>xxxx</value> > SL> </parameter> > SL> </ResourceParams> > > SL> And the web.xml snippet: > SL> <resource-env-ref> > SL> <description>test jdbc/nutrosDB</description> > SL> > <resource-env-ref-name>jdbc/nutrosDB</resource-env-ref-name> > SL> > <resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type> > SL> </resource-env-ref> > > > > > > SL> -- > SL> To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > SL> For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > > -- > Best regards, > Jacob mailto:[EMAIL PROTECTED] > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>