<value>test<value/>
should be:
<value>test</value>
It is always a good idea to use an XML editor to make sure your file is well-formed.
Note that you can also give a try to the OCI driver which, like SQL*Plus, uses Oracle's native Net8 to connect. The URL will look like this:
jdbc:oracle:oci:@splus
I hope this helps,
-Erik
Tony Tay wrote:
> 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 ------
_______________________________________________ oxf-users mailing list [EMAIL PROTECTED] http://mail.orbeon.com/mailman/listinfo/oxf-users
