db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Claas Eggert" <claa...@gmx.de>
Subject JCP 225 XQJ and Re: Connecting to Oracle 10 via DDLUtils throws Exceptions
Date Sun, 25 Mar 2007 08:56:11 GMT
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" <tomdzk@gmail.com>
To: <ddlutils-user@db.apache.org>
Sent: Wednesday, January 31, 2007 6:46 AM
Subject: Re: Connecting to Oracle 10 via DDLUtils throws Exceptions


> On 1/30/07, Claas Eggert <claas01@gmx.net> 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 


Mime
View raw message