Hi Santiago, > I'm a little confused about [OPTIONAL]s in the API. I was using the ODBC > driver with a PostgreSQL database. The call to createDataDescriptor > doesn't fail, but seems to return nothing.
In general, if an OPTIONAL interface is present, it should do what is defined. If it cannot fulfill the contract of the interface, it should not implement it. > My intention was to create a basic database migration wizard, at the > higher possible level of abstraction (sdb or sdbcx), without messing > with sdbc drivers directly. > > I believed that I could copy a table structure between databases just > using this call to createDataDescriptor, but then realized that there > are 'incompatible' properties to be aware of. exchanging data descriptors between different databases will most probably not work, I fear you need to explicitly code this. The most interesting part here is probably the migration of data types, as those have the highest chance to not match between different databases. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
