hi Erik,
> Message: 3
> Date: Tue, 23 Mar 2004 16:18:00 -0800
> From: Erik Bruchez <[EMAIL PROTECTED]>
> Subject: Re: Setting up Oracle as a datasource
> To: OXF Users <[EMAIL PROTECTED]>
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> What is the error you are seeing?
>
1. I restarted oxf (from start menu in winXP) and it crashed. No log was
available. I attached the full server.xml file below:
2. Also, i am not sure how to fill in for the "URL" parameter as my access
to oracle is native sqlplus format, ie., sqlplus test/[EMAIL PROTECTED] I wonder
if the jdbc values are correct. Please advise. thanks.
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.10.147:1521:splus</value>
</parameter>
The oracle database sits on another machine: 192.168.10.147
------- start of server.xml -----------------------
<Server port="8005" shutdown="SHUTDOWN" debug="0">
<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
debug="0"/>
<Listener
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
debug="0"/>
<GlobalNamingResources>
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved">
</Resource>
<ResourceParams name="UserDatabase">
<parameter>
<name>factory</name>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
</parameter>
<parameter>
<name>pathname</name>
<value>conf/tomcat-users.xml</value>
</parameter>
</ResourceParams>
</GlobalNamingResources>
<Service name="Tomcat-Standalone">
<Connector className="org.apache.coyote.tomcat4.CoyoteConnector"
port="8080" minProcessors="5" maxProcessors="75"
enableLookups="true" redirectPort="8443"
acceptCount="100" debug="0" connectionTimeout="20000"
useURIValidationHack="false" disableUploadTimeout="true" />
<Engine name="Standalone" defaultHost="localhost" debug="0">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="catalina_log." suffix=".txt"
timestamp="true"/>
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
debug="0" resourceName="UserDatabase"/>
<Host name="localhost" debug="0" appBase="webapps"
unpackWARs="true" autoDeploy="true">
<Logger className="org.apache.catalina.logger.FileLogger"
directory="logs" prefix="localhost_log." suffix=".txt"
timestamp="true"/>
<Context path="/oxf" docBase="../../oxf-2.2" debug="10"
reloadable="true" checkInterval="1">
<Resource name="jdbc/db" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/db">
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@192.168.10.147:1521:splus</value>
</parameter>
<parameter>
<name>username</name>
<value>test</value>
</parameter>
<parameter>
<name>password</name>
<value>test<value/>
</parameter>
</ResourceParams>
</Context>
</Host>
</Engine>
</Service>
</Server>
----- end of conf/server.xml ------
> Your change must be made within the context set for OXF, e.g. you
> would have something like this in your server.xml:
>
> <Context path="/oxf"
> docBase="C:/oxf-war/"
> reloadable="false" override="true">
> <Resource name="jdbc/db" auth="Container" type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/db">
> <parameter>
> <name>username</name>
> <value>scott</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>tiger</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>oracle.jdbc.driver.OracleDriver</value>
> </parameter>
> <parameter>
> <name>url</name>
> <value>jdbc:oracle:oci:@rosaura</value>
> </parameter>
> </ResourceParams>
> </Context>
>
> -Erik
>
> Tony Tay wrote:
> > hi
> >
> > I must be doing something wrong. I restarted after making changes to
> > tomcat1-4.27/config/server.xml file. Thanks for helping. Am new to
this
> > bit.
> >
> > This is what i did:
> >
> > I used server.xml in tomcat-4.1.27/conf/ directory and made the
following
> > changes:
> >
> > </ResourceParams>
> > <parameter>
> > <name>driverClassName</name>
> >
<value>oracle.jdbc.driver.OracleDriver</value>
> > </parameter>
> > <parameter>
> > <name>url</name>
> >
<value>jdbc:oracle:oci:@192.168.10.1</value>
> > </parameter>
> > <parameter>
> > <name>username</name>
> > <value>test</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value>test<value/>
> > </parameter>
> > </ResourceParams>
> >
> >
> > I overwrote the original (show below with the above):
> >
> > <ResourceParams name="jdbc/db">
> > <parameter>
> > <name>factory</name>
> >
> > <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> > </parameter>
> > <parameter>
> > <name>driverClassName</name>
> > <value>org.hsqldb.jdbcDriver</value>
> > </parameter>
> > <parameter>
> > <name>url</name>
> >
> > <value>jdbc:hsqldb:http://localhost:8080/oxf/db</value>
> > </parameter>
> > <parameter>
> > <name>username</name>
> > <value>sa</value>
> > </parameter>
> > <parameter>
> > <name>password</name>
> > <value/>
> > </parameter>
> > </ResourceParams>
> >
_______________________________________________
oxf-users mailing list
[EMAIL PROTECTED]
http://mail.orbeon.com/mailman/listinfo/oxf-users
