I think this line: torque.database.schema = dbo is missing from your build.properties file. Also i'm not sure exaclty what values should hae, dbo works for me.
Best wishes, Andras.
Bogdan Vatkov wrote:
Hi all,
I have tried to reverse xml schema from ms sql server via jdbc target.. and no tables reversed ..(they actually exist in the db server) the result is this : no error but no table in the result xml
H:\PROJECTS\java\OldFKSUOrganizer\torque-gen-3.1>ant jdbc Buildfile: build.xml
jdbc: [echo] +-----------------------------------------------+ [echo] | | [echo] | Generating XML from JDBC connection ! | [echo] | | [echo] +-----------------------------------------------+ [torque-jdbc-transform] Torque - JDBCToXMLSchema starting [torque-jdbc-transform] Your DB settings are: [torque-jdbc-transform] driver : com.microsoft.jdbc.sqlserver.SQLServerDriver [torque-jdbc-transform] URL : jdbc:microsoft:sqlserver://dm2:1433;DatabaseName=u m;User=um;Password=um [torque-jdbc-transform] user : um [torque-jdbc-transform] schema : ${databaseSchema} [torque-jdbc-transform] DB driver sucessfuly instantiated [torque-jdbc-transform] DB connection established [torque-jdbc-transform] Getting table list... [torque-jdbc-transform] Building column/table map... [torque-jdbc-transform] ./schema/schema.xml [torque-jdbc-transform] Torque - JDBCToXMLSchema finished
BUILD SUCCESSFUL Total time: 2 seconds
xml is:
<?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd";> <!-- Autogenerated by JDBCToXMLSchema! --> <database/>
any suggestions ?
with best regards, bogdan
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
