THANKS, RUSSELL!!! Such a foolish mistake! But they are so as a rule, aren't they? Now JDBC CONNECTION HAS BEEN CREATED! Thanks to all who have replied and helped me to solve this problem!
All the best, Viktor -----Ursprungliche Nachricht----- Von: Russell Castagnaro [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 22. Oktober 2001 19:32 An: Skladov, Victor Betreff: Re: Help! Cocoon 2: Problem with connection to remote Oracle DB 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]> --------------------------------------------------------------------- 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]>
