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: The DB created from XML has one more index for every table.
Date Tue, 21 Mar 2006 10:30:15 GMT
On 3/21/06, Jun Li <allanjunli@gmail.com> 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

Mime
View raw message