You need to use user="test" instead of username="test". This should work in the context.xml file.
-----Original Message----- From: "Julio J. Suárez Salinero" [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 8:16 AM To: Tomcat Users List Subject: Re: OracleConnectionPoolDataSource Propes, Barry L escribió: > 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? > > Because when I set user and password in the context (username="test" password="test") and get the connection with pc = fuenteDatos.getPooledConnection(); it throws "invalid arguments in call". I have to put them in getPooledConnection. I have tried 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. > > Thanks for the advice. I'll try it. > I have not experimented with the getPooledConnection method so I can't say. > > > -----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] > > --------------------------------------------------------------------- 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]
