Re: oracle database model dangerously broken

[Tim Dudgeon]

It's in JIRA.

Tim

Thomas Dudziak wrote:

On 1/31/06, Tim Dudgeon <[EMAIL PROTECTED]> 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