Hi Rashmi,
thans for reply.
Configuration that is described in link you sent me works fine.
Problem is when I change
the datasource factory to Oracle datasource factory. Than is not
possible to find this datasource through JNDI lookup and this
connection disappear from admin console.
I think that ojdbc14.jar is newer version of oracle drivers and it
works fine with standard datasource factory
org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory and
javax.sql.DataSource. It stops work when I use oracle datasource
factory
factory="oracle.jdbc.pool.OracleDataSourceFactory" and datasource type
type="oracle.jdbc.pool.OracleDataSource".
What I need is any solution how get OracleConnection instead of
Connection to use.
Do I miss any parameter in resource 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"/>
Thanks.
Zdenek
On 5/12/07, Rashmi Rubdi <[EMAIL PROTECTED]> wrote:
On 5/11/07, Zdeněk Vráblík <[EMAIL PROTECTED]> 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
