Hello friends!
I use Tomcat 4.0.1, Cocoon 2 on Linux (SuSe 7) and try to get a
connection to Oracle 8.1.6 DB, which is located on another server. SuSe
server has no Oracle-Client installed.
I've made the folllowing entries in configuration files:
In cocoon.xconf:
<datasources>
<jdbc name="ConnectionName">
<pool-controller min="5" max="10" oradb="true"/>
<dburl>oracle:jdbc:thin:@server.his.de:1521:mydb</dburl>
<user>admin</user>
<password>pass</password>
</jdbc>
</datasources>
in web.xml:
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For Oracle Database: -->
oracle.jdbc.driver.OracleDriver
</param-value>
</init-param>
I have renamed the Oracle-Driver zip file classes12.jar and put it in
WEB-INF/lib folder.
And I get the following message in cocoon.log file:
org.apache.avalon.excalibur.datasource.JdbcConnection: could not be
instantiated.
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance
(Unknown Source)
at
org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(Unknown
Source)
at
org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(Un
known Source)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(Un
known Source)
at
org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(Unknown
Source)
at
org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(Unknown
Source)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:484)
I tried the connection also with Java-Application on the same server and
it runs!
I don't know what else I must do. Has anyone already experienced this or
has any idea or suggestions?
I would be very grateful for your help!
Regards,
Viktor Skladovs
mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
