RE: Problems accessing database,

2002-03-26 Thread Sozonnik Andrew

First you have to load Oracle driver in WEB-INF/web.xml

init-param
  param-nameload-class/param-name
  param-value
   
oracle.jdbc.driver.OracleDriver
  
  /param-value
/init-param



-Original Message-
From: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: TR: Problems accessing database,


Now I found an additional entry in the access log:

DEBUG   (2002-03-26) 10:48.43:410   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: parent-component-manager was not set -
defaulting to null.
DEBUG   (2002-03-26) 10:48.43:430   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
oracle.jdbc.driver.OracleDriver
WARN(2002-03-26) 10:48.43:440   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Could not force-load class:
oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)


Does anybody why Cocoon can't load the class while the same is working
in a Java program? 

-Message d'origine-
De: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]] 
Date: mardi, 26. mars 2002 10:16
À: [EMAIL PROTECTED]
Objet: Problems accessing database,


Cocoon 2.01, Tomcat 4.01, Oracle db

I can't access my Oracle db, no errors, just this entry in the core log:
WARN(2002-03-26) 09:11.01:401   [core]
(/cocoon/Kurt/testsxml/HD/base/query.xml)
HttpProcessor[8080][3]/LogKitLogger: Could not return Connection
java.lang.IllegalStateException: There are no connections in the pool,
check your settings.

I defined my connection in the sitemap:
map:transform type=sql 
 map:parameter name=use-connection value=aigle_oracle_pool / 
/map:transform


where the connection name points to the following datasource in
cocoon.xconf:

jdbc name=aigle_oracle_pool
  pool-controller min=5 max=10 oradb=true/
  auto-committrue/auto-commit
  dburljdbc:oracle:thin:@pallas6:1521:PAIG/dburl
  userverbalix/user
  passwordxml/password
/jdbc

If I try to execute a test query based on this entries, nothing happens,
but Cocoon seems to be working in the background (very high CPU usage by
java.exe), and I have to force Tomcat to shutdown. The settings in xconf
return data when used in a regular Java program.

Any ideas what's going wrong?


-
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: Problems accessing database,

2002-03-26 Thread Hahn Kurt (CHA)

Thanks,
I changed a number of configurations, including the Web.xml file, and now
it's working!


-Message d'origine-
De: Sozonnik Andrew [mailto:[EMAIL PROTECTED]]
Date: mardi, 26. mars 2002 11:22
À: [EMAIL PROTECTED]
Objet: RE: Problems accessing database,


First you have to load Oracle driver in WEB-INF/web.xml

init-param
  param-nameload-class/param-name
  param-value
   
oracle.jdbc.driver.OracleDriver
  
  /param-value
/init-param



-Original Message-
From: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: TR: Problems accessing database,


Now I found an additional entry in the access log:

DEBUG   (2002-03-26) 10:48.43:410   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: parent-component-manager was not set -
defaulting to null.
DEBUG   (2002-03-26) 10:48.43:430   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
oracle.jdbc.driver.OracleDriver
WARN(2002-03-26) 10:48.43:440   [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Could not force-load class:
oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)


Does anybody why Cocoon can't load the class while the same is working
in a Java program? 

-Message d'origine-
De: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]] 
Date: mardi, 26. mars 2002 10:16
À: [EMAIL PROTECTED]
Objet: Problems accessing database,


Cocoon 2.01, Tomcat 4.01, Oracle db

I can't access my Oracle db, no errors, just this entry in the core log:
WARN(2002-03-26) 09:11.01:401   [core]
(/cocoon/Kurt/testsxml/HD/base/query.xml)
HttpProcessor[8080][3]/LogKitLogger: Could not return Connection
java.lang.IllegalStateException: There are no connections in the pool,
check your settings.

I defined my connection in the sitemap:
map:transform type=sql 
 map:parameter name=use-connection value=aigle_oracle_pool / 
/map:transform


where the connection name points to the following datasource in
cocoon.xconf:

jdbc name=aigle_oracle_pool
  pool-controller min=5 max=10 oradb=true/
  auto-committrue/auto-commit
  dburljdbc:oracle:thin:@pallas6:1521:PAIG/dburl
  userverbalix/user
  passwordxml/password
/jdbc

If I try to execute a test query based on this entries, nothing happens,
but Cocoon seems to be working in the background (very high CPU usage by
java.exe), and I have to force Tomcat to shutdown. The settings in xconf
return data when used in a regular Java program.

Any ideas what's going wrong?


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

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