tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rashmi Rubdi" <rashmi....@gmail.com>
Subject Re: Oracle JDBC connection Tomcat 5.5
Date Sat, 12 May 2007 21:31:41 GMT
On 5/11/07, Zdeněk Vráblík <zdenek@vrablik.org> wrote:
> Hi all,
>
> I am configuring jdbc datasources on Tomcat 5.5.23.
>
> I followed this document to configure orcle database with Tomcat
> http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat1p.html

Sorry I didn't go through the instructions in the above link , I would
follow the instructions for Oracle 10g here:
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html
look for the title: Oracle 8i, 9i & 10g


> I am not able to see datasource in web admin.
> datasource configuration:
>
> <Resource name="sisPool"
>           auth="Container"
>           type="oracle.jdbc.pool.OracleDataSource"
>           factory="oracle.jdbc.pool.OracleDataSourceFactory"
>           username="USER_51319"
>           password="USER_51319"
>           driverClassName="oracle.jdbc.OracleDriver"
>           url="jdbc:oracle:thin:@192.168.100.119:1521:orcl"
>           maxActive="20" maxIdle="10" maxwait="-1"/>
>
> Everything works fine with this configuration:
> <Resource name="sisPool"
>           auth="Container"
>           type="javax.sql.DataSource"
>                   factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
>           username="USER_51319"
>           password="USER_51319"
>           driverClassName="oracle.jdbc.driver.OracleDriver"  or
> driverClassName="oracle.jdbc.driver.OracleDriver"
>           url="jdbc:oracle:thin:@192.168.100.119:1521:orcl"
>           maxActive="20" maxIdle="10" maxwait="-1"/>
>
> I need get OracleConnection instead of Connection.

I think you also need classes12.jar

>
> There is not any error or exception in log files.
> I have ojdbc14.jar in common/lib directory.
> I am able to use even Oracle JGeometry objects with common Connection,
> but I need OracleConnection.
>
> My configuration:
> Windows XP,
> JDK  5_09
> Tomcat 5.5.23
> Oracle 10G 10.2.0.1
>
> Do you have any idea, what I am doing wrong?

Most likely you need Oracle's classes12.jar

> How could I get any error or exception? Logs in tomcat/logs dirrectory
> are correct. I have there only info outputs from my test application.
>
> Thanks.
>
> Regards,
> Zdenek Vrablik
>

Regards
Rashmi
Mime
View raw message