Hi Christoph,
To get oracle working, you must first add a section to load the oracle
driver class in the web.xml file. Be certain that the Oracle driver Jar file
is in your servlet engine's classpath.
<web-app>
<servlet>
<servlet-name>Cocoon2</servlet-name>
<init-param>
<param-name>load-class</param-name>
<param-value>
oracle.jdbc.driver.OracleDriver
</param-value>
</init-param>
...
</servlet>
</web-app>
Then in the cocoon.xconf configuration file you must specify a datasource
such as:
<datasources>
<jdbc name="mydata">
<pool-controller min="5" max="10" oradb="true"/>
<dburl>jdbc:oracle:thin:@myserver.mydomain.com:1521:myInstance</dburl>
<user>scott</user>
<password>tiger</password>
</jdbc>
</datasources>
Finally, you can either use the connection in an XSP page or pass a Query in
XML to the SQL transformer as part of a pipeline in your sitemap:
<map:transform type="sql">
<map:parameter name="use-connection" value="fp"/>
<map:parameter name="show-nr-of-rows"
value="false"/>
</map:transform>
HTH,
Aaron
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 6:14 AM
To: [EMAIL PROTECTED]
Subject: Calling C2 from command line: problem with Oracle driver
Hello,
I'm working with Cocoon2.0-rc1a and Tomcat 3.2.3 on a Linux-Server.
With Tomcat everything is fine, but yesterday I tried to call Cocoon from
the
command line.
I did not find any documentation on command line parameters and options,
only
the definition of
COCOON_LIB and COCOON_WORK environment variables in run.sh.
After some hours my Cocoon command line environment nearly works, but there
is a
problem left:
I can not get the Oracle JDBC (thin) driver to work. I think it has do do
with
the missing initialization of the JDBC driver class.
When Cocoon is called from Tomcat, there is a configuration file called
web.xml
in the WEB-INF directory, where the initial parameters - like load-class -
are
defined.
What is the right way to specify these settings for command line execution?
Many thanks in advance
Christoph
PS: How can I specify directories, like the application directory, which is
assumed to be "./webapp" 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]>
