db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bogdan Vatkov" <bvat...@globaltech-bg.com>
Subject Re: MSSQL JDBC reverse ?
Date Wed, 17 Dec 2003 15:36:55 GMT
Thanx Andras, that works for me too :)

----- Original Message -----
From: "Andras Balogh" <andras@reea.net>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Sent: Wednesday, December 17, 2003 17:03
Subject: Re: MSSQL JDBC reverse ?


> 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
>


---------------------------------------------------------------------
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