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