db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "No.9" <n...@black.biglobe.ne.jp>
Subject How to generate a schema.xml
Date Thu, 23 Oct 2003 14:31:43 GMT
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


Mime
View raw message