cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Skladov, Victor" <Skla...@his.de>
Subject Help! Cocoon 2: Problem with connection to remote Oracle DB
Date Mon, 22 Oct 2001 16:00:38 GMT
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://skladov@his.de




---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message