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
|