Looks like that worked! Many thanks! :) Now my question is, since I'm using javax.sql.DataSource as the ResourceType, how do I know if I'm using the connection pool or opening a new connection each time I request a connection?
The factory associated with the resource is org.apache.commons.dbcp.BasicDataSourceFactory Does this factory provide connection pooling? If not, how do I change the implementation to use pooling? Once I'm using pooling, how do I find out how many connections are in use? How do I find out if a connetion I am about to get will come from the pool or if a new connection is being created? Etc. Is there a page somewhere that references this information? Thanks again. On Tue, 21 Dec 2004 16:03:42 -0500, Phillip Qin <[EMAIL PROTECTED]> wrote: > Can you try javax.sql.DataSource in <Resoure>? You use javax.sql.DataSource > in resourcelink then the type in resource has to be the same. > > -----Original Message----- > From: David Uctaa [mailto:[EMAIL PROTECTED] > Sent: December 21, 2004 3:26 PM > To: Tomcat Users List > Subject: Re: Difficulty connecting to DB2 for iSeries from Tomcat 5.0.28 > > <Resource type="com.ibm.as400.access.AS400JDBCConnectionPoolDataSource" > auth="Container" scope="Shareable" name="jdbc/MYDATASOURCE"/> > > On Tue, 21 Dec 2004 15:02:58 -0500, Phillip Qin <[EMAIL PROTECTED]> > wrote: > > I assume you have something like this in your server.xml > > > > <Resource name="jdbc/MYDATASOURCE" auth="Container" scope="Shareable" > > type="javax.sql.DataSource" /> > > > > Is there any warning or exception in catalina.out or any other log > > files? > > > > -----Original Message----- > > From: David Uctaa [mailto:[EMAIL PROTECTED] > > Sent: December 21, 2004 1:52 PM > > To: Tomcat Users List > > Subject: Re: Difficulty connecting to DB2 for iSeries from Tomcat > > 5.0.28 > > > > If the name of the global resource in server.xml is defined as > > <GlobalNamingResources> > > <Resource [attribs] name="jdbc/MYDATASOURCE"/> > > <ResourceParams name="jdbc/MYDATASOURCE"> > > <param>...</param> > > </ResourceParams> > > </GlobalNamingResources> > > > > then the resourcelink in context.xml is > > > > <Context [attribs]> > > <ResourceLink > > global="jdbc/MYDATASOURCE" > > name="jdbc/MYDATASOURCE" > > type="javax.sql.DataSource"/> > > </Context> > > > > (not sure if listing the exact datasource specification would be a > > security breach, so I'm munging the actual datasource name, but > > everything else is the same, including upper/lower case) > > > > On Tue, 21 Dec 2004 13:39:07 -0500, Phillip Qin > > <[EMAIL PROTECTED]> > > wrote: > > > What is the resourcelink in your context.xml? > > > > > > > > > -----Original Message----- > > > From: David Uctaa [mailto:[EMAIL PROTECTED] > > > Sent: December 21, 2004 12:27 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: Difficulty connecting to DB2 for iSeries from Tomcat > > > 5.0.28 > > > > > > No matter what i do, the JNDI lookup is returning null. What causes > > > a JNDI lookup to return null when the resource is defined in the > > > <GlobalNamingResources> section of server.xml? Should I put the > > > resources into <NamingResources> in my context.xml? > > > > > > On Mon, 20 Dec 2004 13:52:29 -0500, David Uctaa <[EMAIL PROTECTED]> > > > wrote: > > > > I am running Tomcat 5.0.28 on Win XP SP1. We have DB2 running on > > > > 2 iSeries servers. When I attempt to look up a DataSource from > > > > JNDI to get a connection from it, the JNDI lookup is returning > > > > null. > > > > > > > > I am using IBM's JTOpen library for the JDBC drivers, and I am > > > > attempting to use Tomcat to manage the connection pooling. I am > > > > following the instructions I saw listed here: > > > > http://www.itjungle.com/fhg/fhg060204-story01.html . I am trying the > > > > first option, using the Commons DBCP connection pool. > > > > > > > > I have attached copies of my server.xml and the context > > > > configuration file webappname.xml. The code I am using to access > > > > the data source is pretty generic: > > > > > > > > Context initCtx = new InitialContext(); > > > > Context ctx = (Context) initCtx.lookup("java:comp/env"); > > > > DataSource ds = (DataSource) ctx.lookup("jdbc/myFirstDataSource"); > > > > Connection conn = ds.getConnection(); > > > > > > > > It turns out the that ctx.lookup call is returning null, as if it > > > > can't find the JNDI resource, and I can't figure out what I have > > > > misconfigured. > > > > > > > > Any and all help will be greatly appreciated. > > > > > > > > > > > > > > > > > > -------------------------------------------------------------------- > > > - > > > 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] > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > !DSPAM:41c886e8314441869949623! > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
