Thanks for your answer. That looks rather unconventional ;) Rainer
> I apologize but I saw this post late. I had a problem with connection > pooling using Oracle and JNDI. To get around it I had to do something like > this: > > In conf\server.xml > > <Resource name="jdbc/mydb" auth="Container" > type="oracle.jdbc.pool.OracleConnectionPoolDataSource" /> > <ResourceParams name="jdbc/mydb"> > <parameter> > <name>user</name> > <value>user</value> > </parameter> > <parameter> > <name>password</name> > <value>password</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>oracle.jdbc.driver.OracleDriver</value> > </parameter> > <parameter> > <name>driverName</name> > <value>jdbc:oracle:thin:@oracle.ds:1521:db</value> > </parameter> > </ResourceParams> > > In WEB-INF/web.xml > > <web-app> > > <servlet> > <servlet-name>OracleConnectionPool</servlet-name> > <servlet-class>aOracleConnectionPool</servlet-class> > <load-on-startup>1</load-on-startup> > </servlet> > > <resource-ref> > <res-ref-name>jdbc/mydb</res-ref-name> > <res-type>oracle.jdbc.pool.OracleConnectionPoolDataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > </web-app> > > OracleConnectionPool.java > > try { > Context initCtx = new InitialContext(); > OracleConnectionPoolDataSource ocpds = new > OracleConnectionPoolDataSource(); > ResourceBundle rb = ResourceBundle.getBundle("database"); > ocpds.setURL(rb.getString("url")); > ocpds.setUser(rb.getString("user")); > ocpds.setPassword(rb.getString("password")); > initCtx.rebind("axesdb", ocpds); > } catch (SQLException sqlex) { > sqlex.printStackTrace(); > } catch (Exception ex) { > ex.printStackTrace(); > } > > In your code: > > Context initCtx = new InitialContext(); > OracleConnectionPoolDataSource ocpds = > (OracleConnectionPoolDataSource)initCtx.lookup("mydb"); > PooledConnection pooledConnection = ocpds.getPooledConnection(); > Connection connection = pooledConnection.getConnection(); > Statement statement = connection.createStatement(); > ResultSet resultSet = statement.executeQuery(sql); > > Good Luck! > > Kevin > > Kevin Andryc > Web Systems Engineer > MISER > http://www.umass.edu/miser/ > Phone: (413)-545-3460 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 13, 2002 03:12 PM > To: Tomcat Users List > Subject: Re: Connection pooling doesn't work for me ... Help !! > > Hi, > > well I got stuck with the same problem as the others: > I cannot get a connect to the DB via JNDI. > > Just a simple idea: can the problem be the MySQL Driver? > Is there maybe someone out there to give some hints how to look into this > "blackbox" JNDI to see what is going wrong(Craig ?) > > Thanks for any help! > > Rainer > > ----- Original Message ----- > From: "Neil Milne" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <[EMAIL PROTECTED]> > Sent: Thursday, June 13, 2002 2:56 PM > Subject: Re: Connection pooling doesn't work for me ... Help !! > > > > I'm using the JNDI Datasource setup fine with Tomcat 4.0.3 and Sybase. > > In server.xml I have: > > > > <Resource name="jdbc/db" auth="Container" > > type="javax.sql.ConnectionPoolDataSource"/> > > <ResourceParams name="jdbc/db"> > > <parameter> <name>driverClassName</name> > > <value>com.sybase.jdbc2.jdbc.SybDriver</value> </parameter> > > <parameter> <name>user</name> <value>user</value></parameter> > > <!-- other driver specific db params... --> > > <parameter> <name>initialPoolSize</name> <value>5</value></parameter> > > </ResourceParams> > > > > There's no need to specify a factory as Tomcat has a Datasource resource > > factory built in. > > > > Note that I've used the ConnectionPoolDataSource class - not sure if > > this makes a difference. > > > > HTH > > Neil. > > > > ----- Original Message ----- > > from: Martin Jacobson <[EMAIL PROTECTED]> > > date: Thursday, June 13, 2002 1:40 pm > > subject: Re: Connection pooling doesn't work for me ... Help !! > > > > > anthony.dodd wrote: > > > > > > > Hi > > > > > > > > I've posted a solution see "Generic DataSource Resource Factory > > > > Available. JDBC Data Source" on the tomcat user maillist. > > > > > > > > Tony > > > > > > > Yes, but... > > > > > > > > > Like many others on this list, I too have been unable to get the > > > std > > > JNDI DataSource thingy working; as an interim measure, I > > > implemented a > > > workaround (which does at least work!), but I refuse to be defeated! > > > > > > > > > > > -- > > 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]> > > > -- > 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]>