Hi Tom,
i'm still struggeling with the Oracle Datasource Problem :-(
But some other question.
I ran over the JCP 225 XQuery API for Java and i was wondering if there will
be an integration or some other way for querying xml in dbs? At the moment i
query the information by creating an xmltable or constructing an
pretty-formated sequence. Or are there already other ways to do that?
Thanks,
Claas
----- Original Message -----
From: "Thomas Dudziak" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, January 31, 2007 6:46 AM
Subject: Re: Connecting to Oracle 10 via DDLUtils throws Exceptions
On 1/30/07, Claas Eggert <[EMAIL PROTECTED]> wrote:
I'm trying to connect to Oracle 10g via ddlutils.
Since my code works fine with DB2 and postgres i'm wondering why i
couldn't get it to work with Oracle using there jdbc driver (ojdbc14.jar
or the special debugging version).
Here's what i tried so far.
The code for postgres:
Class.forName("org.postgresql.Driver").newInstance();
PGSimpleDataSource ds = new PGSimpleDataSource();
ds.setDatabaseName("benchmarking");
ds.setUser("user");
ds.setPassword("user");
platform = PlatformFactory.createNewPlatformInstance(ds);
db = platform.readModelFromDatabase("benchmarking");
For Oracle I already tried some additional options for the DataSource
like setting the DriverType, Port, the DB-URL in various forms (with user
and pw, port etc).
What data source class are you using ? You have to use one that
actually implements the DataSource interface
(http://java.sun.com/j2se/1.4.2/docs/api/javax/sql/DataSource.html).
DdlUtils comes with the commons-dbcp library which contains an
easy-to-use data source class called BasicDataSource
(http://jakarta.apache.org/commons/dbcp/apidocs/org/apache/commons/dbcp/BasicDataSource.html).
I think the Oracle JDBC driver provides
oracle.jdbc.pool.OracleDataSource also implements of this interface,
but I'm not sure.
Tom
