On 3/21/06, Jun Li <[EMAIL PROTECTED]> wrote: > Are you talking about > platform.readModelFromDatabase(String<http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html> > name, > String <http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html> > catalog, > String <http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html> schema, > String <http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html> > [] tableTypes) here? > > But for SQL Server, I have to set both catalog and schema to null to get the > right result. For Oracle, it's like you said, to set them in upppercase of > the database's name.
Yup, but I found that it is necessary to set both to their respective values instead of null (e.g. for the tests: http://svn.apache.org/viewcvs.cgi/db/ddlutils/trunk/src/test/jdbc.properties.sqlserver2000?view=markup), otherwise too much info was returned. Though all-uppercase is probably not required (as opposed to Oracle). Tom
