AW: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Skladov, Victor]

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> 
SV> 
SV>   
SV>   oracle:jdbc:thin:@server.his.de:1521:mydb
SV>   admin
SV>   pass
SV> 
SV>   

SV> in web.xml:

SV>   
SV>   load-class
SV>   
  
SV> 
SV> oracle.jdbc.driver.OracleDriver

SV>   
SV> 

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,
 Russellmailto:[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]>

Help! Cocoon 2: Problem with connection to remote Oracle DB

[Skladov, Victor]

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:



  
  oracle:jdbc:thin:@server.his.de:1521:mydb
  admin
  pass

  

in web.xml:

  
  load-class
  
  

oracle.jdbc.driver.OracleDriver

  


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:

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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Re: AW: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Berin Loritsch]

"Skladov, Victor" wrote:
> 
> Thanks Berin!
> 
> But why does it run with Java-Application?
> If there had been something wrong with the username,password, port etc,
> it would not have run with Java too or am I wrong? Do I have to install
> the Oracle-Client on the Server?

The Java Application is a test to make sure your connection properties are
correct.  Depending on the driver type (like the non-thin driver), you may
have to make more entries to map database names with the server.  For instance,
in my installation, even though the default name for the Oracle database is
ORADB, on the server it's name was BORG.  That required a change in the
connection string.

> 
> Regards,
> Viktor
> 
> -Ursprungliche Nachricht-
> Von: Berin Loritsch [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 22. Oktober 2001 18:23
> An: [EMAIL PROTECTED]
> Betreff: Re: Help! Cocoon 2: Problem with connection to remote Oracle DB
> 
> "Skladov, Victor" wrote:
> >
> > 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!
> 
> When I originally wrote the connection pooling code, I tested against a
> remote JDBC connection.  There is probably something wrong in the setup.
> Please verify all your settings, and test a simple connection to the
> server until you find what is wrong.  Everything looks ok in your config
> files, and the fact that it runs when the server is on the same machine
> points to a larger error.
> 
> Ensure that the username/password exists on the remote server, that the
> DSN entry for the machine is correct (i.e. host.company.com), that the
> connection port is correct, etc.
> 
> -
> 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]>

-
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]>

Re: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Russell Castagnaro]

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> 
SV> 
SV>   
SV>   oracle:jdbc:thin:@server.his.de:1521:mydb
SV>   admin
SV>   pass
SV> 
SV>   

SV> in web.xml:

SV>   
SV>   load-class
SV>   
  
SV> 
SV> oracle.jdbc.driver.OracleDriver

SV>   
SV> 

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. 

SV> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
SV> For additional commands, e-mail: <[EMAIL PROTECTED]>



-- 
Best regards,
 Russellmailto:[EMAIL PROTECTED]


-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

AW: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Skladov, Victor]

Thanks Berin!

But why does it run with Java-Application?
If there had been something wrong with the username,password, port etc,
it would not have run with Java too or am I wrong? Do I have to install
the Oracle-Client on the Server?

Regards,
Viktor

-Ursprungliche Nachricht-
Von: Berin Loritsch [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 22. Oktober 2001 18:23
An: [EMAIL PROTECTED]
Betreff: Re: Help! Cocoon 2: Problem with connection to remote Oracle DB


"Skladov, Victor" wrote:
> 
> 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!

When I originally wrote the connection pooling code, I tested against a
remote JDBC connection.  There is probably something wrong in the setup.
Please verify all your settings, and test a simple connection to the
server until you find what is wrong.  Everything looks ok in your config
files, and the fact that it runs when the server is on the same machine
points to a larger error.

Ensure that the username/password exists on the remote server, that the
DSN entry for the machine is correct (i.e. host.company.com), that the
connection port is correct, etc.

-
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]>

RE: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Luca Morandini]

Viktor,

it may be silly, but... Since, your DBURL is:

oracle:jdbc:thin:@server.his.de:1521:mydb

I wonder whther mydb is the correct name of the Oracle instance you want to
use.

Best regards,

-
   Luca Morandini
   GIS Consultant
  [EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
-


> -Original Message-
> From: Skladov, Victor [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 6:38 PM
> To: [EMAIL PROTECTED]
> Subject: AW: Help! Cocoon 2: Problem with connection to remote Oracle DB
>
>
> Hello Gary!
>
> The problem seems to be not with loading of the driver itself - it has
> been loaded. The problem. I think, is with DB URL - Cocoon seems not to
> like my URL - or with something else. Any idea?
>
> Thanks,
> Viktor
>
> -Ursprüngliche Nachricht-
> Von: Gapinski, Gary (GEL, MSX) [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 22. Oktober 2001 18:14
> An: '[EMAIL PROTECTED]'
> Betreff: RE: Help! Cocoon 2: Problem with connection to remote Oracle DB
>
>
> While I have not tried locating the renamed classes12 file in
> WEB-INF/lib
> directory, I have used it successfully when it is placed in the
> CATALINA_HOME/common/lib directory.
>
> -
> 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]>
>


-
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]>

RE: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Gapinski, Gary (GEL, MSX)]

The errors you mention in your original message seem to indicate that the
Oracle JDBC driver is not being found. I have only had success (in the
Tomcat environment) when I renamed classes12.zip to classes12.jar and placed
the renamed file in the CATALINE_HOME/common/lib directory (as I have other
non-Cocoon web apps that also use Oracle JDBC). While I have not tried in a
while, I recall having problems when the classes12.jar file was located
subordinate to a WEB-INF directory.

The Cocoon log files (under WEB-INF/logs) should have some error messages
regarding the failed creation of the database connection pool.

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

AW: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Skladov, Victor]

Hello Gary!

The problem seems to be not with loading of the driver itself - it has
been loaded. The problem. I think, is with DB URL - Cocoon seems not to
like my URL - or with something else. Any idea?

Thanks,
Viktor

-Ursprüngliche Nachricht-
Von: Gapinski, Gary (GEL, MSX) [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 22. Oktober 2001 18:14
An: '[EMAIL PROTECTED]'
Betreff: RE: Help! Cocoon 2: Problem with connection to remote Oracle DB


While I have not tried locating the renamed classes12 file in
WEB-INF/lib
directory, I have used it successfully when it is placed in the
CATALINA_HOME/common/lib directory.

-
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]>

Re: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Berin Loritsch]

"Skladov, Victor" wrote:
> 
> 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!

When I originally wrote the connection pooling code, I tested against a
remote JDBC connection.  There is probably something wrong in the setup.
Please verify all your settings, and test a simple connection to the
server until you find what is wrong.  Everything looks ok in your config
files, and the fact that it runs when the server is on the same machine
points to a larger error.

Ensure that the username/password exists on the remote server, that the
DSN entry for the machine is correct (i.e. host.company.com), that the
connection port is correct, etc.

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

RE: Help! Cocoon 2: Problem with connection to remote Oracle DB

[Gapinski, Gary (GEL, MSX)]

While I have not tried locating the renamed classes12 file in WEB-INF/lib
directory, I have used it successfully when it is placed in the
CATALINA_HOME/common/lib directory.

-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Help! Cocoon 2: Problem with connection to remote Oracle DB

[Skladov, Victor]

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:



  
  oracle:jdbc:thin:@server.his.de:1521:mydb
  admin
  pass

  

in web.xml:

  
  load-class
  
  

oracle.jdbc.driver.OracleDriver

  


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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>