db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Claas Eggert" <claa...@gmx.net>
Subject Connecting to Oracle 10 via DDLUtils throws Exceptions
Date Tue, 30 Jan 2007 08:31:23 GMT

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).

The most common error is an NullPointerException when using the DataSource in the createNewPlatformInstance
[
at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:82)
at org.apache.ddlutils.PlatformFactory.createNewPlatformInstance(PlatformFactory.java:120)
]

Using the function createNewPlatformInstance("oracle") instead of the DataSource works but
then the code line db = platform.readModelFromDatabase("benchmarking"); thows another NullPointerException
[
at org.apache.ddlutils.util.JdbcSupport.borrowConnection(JdbcSupport.java:134)
at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1713)
]

db = platform.readModelFromDatabase(DriverManager.getConnection(DBURL), "benchmarking");
throws
[
at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:572)
at org.apache.ddlutils.platform.oracle.Oracle8ModelReader.readTable(Oracle8ModelReader.java:94)
]

Any ideas, hints, clues?!

Many thanks.
Claas

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

Mime
View raw message