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
