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
|