You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Bogdan Vatkov <bv...@globaltech-bg.com> on 2003/12/17 15:58:09 UTC
MSSQL JDBC reverse ?
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
Re: MSSQL JDBC reverse ?
Posted by Bogdan Vatkov <bv...@globaltech-bg.com>.
Thanx Andras, that works for me too :)
----- Original Message -----
From: "Andras Balogh" <an...@reea.net>
To: "Apache Torque Users List" <to...@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
Re: MSSQL JDBC reverse ?
Posted by Andras Balogh <an...@reea.net>.
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