db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebastien.arbog...@free.fr
Subject Oracle 9 and timestamp datatype
Date Fri, 10 Mar 2006 09:57:09 GMT
I'm using DdlUtils to analyze an Oracle 9i database structure using the
following code :

public void analyzeDb(ReferenceDatabase refDb){
...
    OracleDataSource dataSource = new OracleDataSource();
    dataSource.setURL("jdbc:oracle:thin:@" +
                    refDb.getHostName() +
                    ":" + refDb.getPort() +
                    ":" + refDb.getSessionId());
    dataSource.setUser(refDb.getUsername());
    dataSource.setPassword(refDb.getPassword());
    log.info("Connecting to " + dataSource.getURL() + "...");
    Platform platform = PlatformFactory.createNewPlatformInstance("Oracle9");
    platform.setDataSource(dataSource);
    log.info("Building database model...");
    Database database = platform.readModelFromDatabase(null, null,
        refDb.getUsername(), null);
...
}

In the resulting Database object, Columns that have a TIMESTAMP datatype are
assigned the OTHER jdbc datatype, despite the fact that the platform is created
with platform name specification. Is it a known bug ?

Mime
View raw message