db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Dudziak <tom...@gmail.com>
Subject Re: oracle database model dangerously broken
Date Tue, 31 Jan 2006 14:21:51 GMT
On 1/31/06, Tim Dudgeon <tdudgeon@informaticsmatters.com> wrote:

<snip>

>     public void run() throws Exception {
>
>         OracleDataSource ods = new OracleDataSource();
>
>         ods.setURL("jdbc:oracle:thin:@localhost:1521:orcl");
>         ods.setUser("my_user");
>         ods.setPassword("my_password");
>
>         String sql = "CREATE TABLE MY_TABLE( " +
>                 "prop_name VARCHAR2(200) NOT NULL PRIMARY KEY, " +
>                 "prop_value VARCHAR2(200), prop_value_ext LONG RAW NULL)";
>
>         Connection conn = ods.getConnection();
>         Statement stmt = conn.createStatement();
>         stmt.execute(sql);
>         stmt.close();
>         conn.close();
>
>         String schema = "MY_SCHEMA";
>
>         Platform platform = PlatformFactory.createNewPlatformInstance(ods);
>         Database db = platform.readModelFromDatabase("test", null,
> schema, null);
>
>         dumpDb(db);
>
>         platform.alterTables(db, false, false, false);

This is the problem here: DdlUtils does not yet provide a mechanism
for specifying the catalog/schema to work in (. Could you create an
improvement in JIRA for this ?

Tom

Mime
View raw message