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 "No.9" <no...@black.biglobe.ne.jp> on 2003/10/23 16:31:43 UTC
How to generate a schema.xml
Hi ,
Now I'm tryng to generate a project-schema.xml from MSSQLServer2k.
Although checked the past log , a schema file was empty.
After creating a table from the schema for tutorial created beforehand,
it attempted whether to be able to create a schema on ant jdbc.
Table creation and record insert are checked.
>ant jdbc
Buildfile: build.xml
[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://127.0.0.1:1433;user=boo
k;Password=store;DatabaseName=bookstore;SelectMethod=cursor
[torque-jdbc-transform] user : book
[torque-jdbc-transform] schema : bookstore
[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-jdbc-transform] Torque - JDBCToXMLSchema finished
BUILD SUCCESSFUL
Total time: 2 seconds
But schema.xml is empty like bellow.
<?xml version="1.0"?>
<!DOCTYPE database SYSTEM
"http://jakarta.apache.org/turbine/dtd/database.dtd">
<!-- Autogenerated by JDBCToXMLSchema! -->
<database/>
A setup of build.properties is this.
# -------------------------------------------------------------------
# T O R Q U E C O N F I G U R A T I O N F I L E
# -------------------------------------------------------------------
torque.project = bookstore
# -------------------------------------------------------------------
torque.database = mssql
# -------------------------------------------------------------------
torque.targetPackage = hoge
torque.addGetByNameMethod = true
torque.addIntakeRetrievable = false
torque.addSaveMethod = true
torque.addTimeStamp = true
torque.basePrefix = Base
torque.complexObjectModel = true
torque.useClasspath = false
torque.useManagers = false
# -------------------------------------------------------------------
databaseSchema = bookstore
torque.database.createUrl =
jdbc:microsoft:sqlserver://127.0.0.1:1433;user=book;Password=store;DatabaseN
ame=bookstore;SelectMethod=cursor
torque.database.buildUrl =
jdbc:microsoft:sqlserver://127.0.0.1:1433;user=book;Password=store;DatabaseN
ame=bookstore;SelectMethod=cursor
torque.database.url =
jdbc:microsoft:sqlserver://127.0.0.1:1433;user=book;Password=store;DatabaseN
ame=bookstore;SelectMethod=cursor
torque.database.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.database.user = book
torque.database.password = store
torque.database.host = 127.0.0.1
torque.database.shema = bookstore
torque.database.name = bookstore
torque.sameJavaName = false
I'm testing on
Windows2000pro(sp4) & torque3.0.jar & SQLServer2000(sp3a).
How can I resolve?
Thanks for any idea,
NO.9
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
Re: How to generate a schema.xml
Posted by Andras Balogh <an...@reea.net>.
Hello,
I'm not 100% sure but i think this line is wrong:
torque.database.shema = bookstore
This should be set to the owner of the tables with uppercase i.e. DBO
or what appears as owner of the tables in Enterprise Manager.
Best wishes,
Andras.
No.9 wrote:
>Hi ,
>
>Now I'm tryng to generate a project-schema.xml from MSSQLServer2k.
>Although checked the past log , a schema file was empty.
>After creating a table from the schema for tutorial created beforehand,
>it attempted whether to be able to create a schema on ant jdbc.
>Table creation and record insert are checked.
>
>
>
>>ant jdbc
>>
>>
>Buildfile: build.xml
>
>[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://127.0.0.1:1433;user=boo
>k;Password=store;DatabaseName=bookstore;SelectMethod=cursor
>[torque-jdbc-transform] user : book
>[torque-jdbc-transform] schema : bookstore
>[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-jdbc-transform] Torque - JDBCToXMLSchema finished
>
>BUILD SUCCESSFUL
>Total time: 2 seconds
>
>But schema.xml is empty like bellow.
>
><?xml version="1.0"?>
><!DOCTYPE database SYSTEM
>"http://jakarta.apache.org/turbine/dtd/database.dtd">
><!-- Autogenerated by JDBCToXMLSchema! -->
><database/>
>
>A setup of build.properties is this.
>
># -------------------------------------------------------------------
># T O R Q U E C O N F I G U R A T I O N F I L E
># -------------------------------------------------------------------
>torque.project = bookstore
># -------------------------------------------------------------------
>torque.database = mssql
># -------------------------------------------------------------------
>torque.targetPackage = hoge
>torque.addGetByNameMethod = true
>torque.addIntakeRetrievable = false
>torque.addSaveMethod = true
>torque.addTimeStamp = true
>torque.basePrefix = Base
>torque.complexObjectModel = true
>torque.useClasspath = false
>torque.useManagers = false
># -------------------------------------------------------------------
>databaseSchema = bookstore
>torque.database.createUrl =
>jdbc:microsoft:sqlserver://127.0.0.1:1433;user=book;Password=store;DatabaseN
>ame=bookstore;SelectMethod=cursor
>torque.database.buildUrl =
>jdbc:microsoft:sqlserver://127.0.0.1:1433;user=book;Password=store;DatabaseN
>ame=bookstore;SelectMethod=cursor
>torque.database.url =
>jdbc:microsoft:sqlserver://127.0.0.1:1433;user=book;Password=store;DatabaseN
>ame=bookstore;SelectMethod=cursor
>torque.database.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
>torque.database.user = book
>torque.database.password = store
>torque.database.host = 127.0.0.1
>torque.database.shema = bookstore
>torque.database.name = bookstore
>torque.sameJavaName = false
>
>
>I'm testing on
>Windows2000pro(sp4) & torque3.0.jar & SQLServer2000(sp3a).
>
>How can I resolve?
>Thanks for any idea,
>NO.9
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org