like here - this is the reference for that info below. http://www.nabble.com/svn-commit:-r556449----tomcat-container-tc5.5.x-webapps-docs-jndi-datasource-examples-howto.xml-t4083357.html
-----Original Message----- From: Propes, Barry L [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 10:05 AM To: Tomcat Users List Subject: RE: OracleConnectionPoolDataSource how do you know the user and password won't work from the context? Are you just trying to store it elsewhere or did you try it? Also, on the driver reference, I saw something on Oracle's site suggesting the use of: oracle.jdbc.OracleDriver, I believe, rather than the full oracle.jdbc.driver.OracleDriver it had said the latter was deprecated. However, that may not be the crux of your problem but you could try it. I have not experimented with the getPooledConnection method so I can't say, but I think it is that you're using PooledConnection rather than Connection. -----Original Message----- From: "Julio J. Suárez Salinero" [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 9:43 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource I have get it to work from a context resource. I've had to specify a factory attribute. Currently context.xml is this: <Context path="/test" docBase="test" debug="0" reloadable="true" > <Resource name="jdbc/test" auth="Container" type="oracle.jdbc.pool.OracleConnectionPoolDataSource" factory="oracle.jdbc.pool.OracleDataSourceFactory" maxActive="0" maxIdle="-1" maxWait="-1" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@192.168.1.47:1521:GLOBALDB" /> </Context> User and password doesn't work in context.xml. I have used a getPooledConnection overload: Context ctx = (Context) initCtx.lookup("java:/comp/env"); OracleConnectionPoolDataSource fuenteDatos = (OracleConnectionPoolDataSource) ctx.lookup("/jdbc/test"); pc = fuenteDatos.getPooledConnection(dbUser, dbPassword); dbUser and dbPassword are loaded from a configuration file. Now, I can set pool maximum size in context.xml, but it still creates only one connection and doesn't allow two users to log in at the same time. Perhaps I am reusing PooledConnection instead of Connection??? Christopher Schultz escribió: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Barry, > > Propes, Barry L wrote: > >> are you importing the following packages? >> >> You maybe should. >> >> import javax.naming.Context; >> import javax.naming.InitialContext; >> import javax.naming.NamingException; >> > > Erm.... if he weren't importing those packages, his code wouldn't > compile. The OP has a problem with /configuration/: > > >>>> I'm Trying to connect a JSP tomcat-based application to Oracle >>>> using OracleConnectionPoolDataSource and related classes. I have >>>> used javax.sql.DataSource an it did work fine. I have made >>>> changes I need for using that classes and when I get the >>>> DataSource it throws exception "javax.naming.NamingException: >>>> Cannot create resource instance". >>>> > > Something is wrong in here: > > >>>> <Resource >>>> name="jdbc/test" auth="Container" >>>> type="oracle.jdbc.pool.OracleConnectionPoolDataSource" >>>> > > I wonder if Tomcat doesn't really know what to do with this "type". Why > do you want to use the OracleConnectionPoolDataSource specifically? > > >>>> driverClassName="oracle.jdbc.pool.OracleConnectionPoolDataSource" >>>> > > This is probably wrong. This class is the same as the one you used for > "type", which probably extends javax.sql.DataSource. You want something > that implements java.sql.Driver. Re-check the Oracle documentation to > see what driver class you should really be using. > > - -chris > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFGnrp09CaO5/Lv0PARAmwgAJ9015dCPWCJvYjYwLBSkPKcAYWuCgCgtrCm > ef63dCd2d0OJUHKoxR0X9Xc= > =u7e9 > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
