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.
-----Original Message-----
From: "Julio J. Suárez Salinero" [mailto:julio@(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:@(protected)" />
</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@(protected)
> To unsubscribe, e-mail: users-unsubscribe@(protected)
> For additional commands, e-mail: users-help@(protected)
>
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
