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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
