db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: MSSQL JDBC reverse ?
Date Wed, 17 Dec 2003 15:03:55 GMT
Hello Bogdan,

 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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message