Tomcat 5.5.20 - DataSource.

Tried this a lot to no avail so far.

Any help would be hugely appreciated.

Did 3 things:

1. added datasource using admin app

2. Created conf\Catalina\localhost\gppdashboard.xml

<Context path="/gppdashboard" docBase="${catalina.home}/webapps/gppdashboard" debug="5" reloadable="true" crossContext="true">

<ResourceLink global="jdbc/sinc" name="jdbc/sinc" type="javax.sql.DataSource"/>

</Context>

C:\ProgramFiles\ApacheGroup\Tomcat5.0.28\conf\Catalina\localhost\axis.xml

3. Put ojdbc14.jar in common/endorsed & common/lib

I got this exception.

org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver ofclass'oracle.jdbc.driver.OracleDriver'for connect URL'gpb-ds3-s.wfd.us.ml.com:1521:gpbodss1'

at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDat

aSource.java:780)

[1234 byte] By [saurabh_guptaa] at [2007-11-26 16:53:48]
# 1

Can't say I've ever used the admin app.

But this connection url looks funny: gpb-ds3-s.wfd.us.ml.com:1521:gpbodss1

I would expect it to be: jdbc:oracle:thin:@gpb-ds3-s.wfd.us.ml.com:1521:gpbodss1

At a guess, using the admin app would just configure the server.xml file.

If you can, take a look at the server.xml file, and see what the admin app has generated in there for this datasource.

Hope this helps,

evnafets

evnafetsa at 2007-7-8 23:21:29 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
That was it. Thanks :)
saurabh_guptaa at 2007-7-8 23:21:29 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...