tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julio J. Suárez Salinero" <ju...@miracle-soft.com>
Subject Re: OracleConnectionPoolDataSource
Date Wed, 18 Jul 2007 13:07:19 GMT
Zdeněk Vráblík escribió:
> Hi,
>
> There is error in driverClassName.
>
> Try use this:
> driverClassName="oracle.jdbc.driver.OracleDriver"
>
Thanks, but I already have tested that with the same results.
> Zdenek
>
> On 7/18/07, "Julio J. Suárez Salinero" <julio@miracle-soft.com> wrote:
>> 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".
>>
>> Changes I have made are these:
>>
>> In context.xml:
>>
>> <Context path="/test" docBase="test" debug="0"
>> reloadable="true" >
>> <Resource
>> name="jdbc/test" auth="Container"
>> type="oracle.jdbc.pool.OracleConnectionPoolDataSource"
>> maxActive="0" maxIdle="-1" maxWait="-1"
>> removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true"
>> username="test" password="test"
>> driverClassName="oracle.jdbc.pool.OracleConnectionPoolDataSource"
>> url="jdbc:oracle:thin:@192.168.1.109:1521:GLOBALDB" />
>> </Context>
>>
>> In web.xml (only resource-ref):
>>
>> <resource-ref>
>> <res-ref-name>jdbc/test</res-ref-name>
>> <res-type>oracle.jdbc.pool.OracleConnectionPoolDataSource</res-type>
>> <res-auth>Container</res-auth>
>> </resource-ref>
>>
>> Code that creates connection:
>>
>> initCtx = new InitialContext();
>> ctx = (Context) initCtx.lookup("java:/comp/env");
>> fuenteDatos = (OracleConnectionPoolDataSource) ctx.lookup("/jdbc/test");
>> PooledConnection pc = fuenteDatos.getPooledConnection();
>> con = pc.getConnection();
>>
>> I have searched in google and found some examples that use
>> oracle.jdbc.driver.OracleDriver in driverClassName. I have also tried
>> this option with the same results. I suppose bug is elsewhere.
>>
>> I have tried to create DataSource instance in the code instead of get it
>> from resource. Doing this it drops no error and page works, but I don't
>> know how can I control maximun number of pooled connections. This is the
>> code I have used for that:
>>
>> initCtx = new InitialContext();
>> OracleConnectionPoolDataSource fuenteDatos = new
>> OracleConnectionPoolDataSource();
>> fuenteDatos.setDataSourceName("oracle.jdbc.pool.OracleConnectionPoolDataSource");

>>
>> fuenteDatos.setURL(dbURL);
>> fuenteDatos.setDescription(DS);
>> fuenteDatos.setUser(dbUsuario);
>> fuenteDatos.setPassword(dbPassword);
>> initCtx.rebind(DS, fuenteDatos);
>> pc = fuenteDatos.getPooledConnection();
>>
>> But it creates only one connection and doesn't allow two users to log in
>> at the same time.
>>
>> Please. I need help.
>>
>>
>> ---------------------------------------------------------------------
>> To start a new topic, e-mail: users@tomcat.apache.org
>> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
>> For additional commands, e-mail: users-help@tomcat.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


-- 


---


*Julio Javier Suárez Salinero*

*Departamento de programación*

AVISO LEGAL: Este mensaje contiene información confidencial para ser 
leída exclusivamente por el destinatario. Su contenido no constituye un 
compromiso para el remitente salvo ratificación escrita por ambas 
partes. Queda prohibida la reproducción, publicación, divulgación, total 
o parcial del mensaje así como el uso no autorizados por el emisor. En 
caso de recibir el mensaje por error se ruega su comunicación al 
remitente lo antes posible.

LEGAL WARNING: This message contains confidential information for the 
exclusive use of the recipient. Its contents do not constitute a 
commitment by the sender except where provided for in a signed agreement 
between both parties. Any unauthorised disclosure, use or dissemination, 
either whole or partial, is prohibited. If you are not the intended 
recipient of the message, please notify.


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message