db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andras Balogh <and...@reea.net>
Subject Re: How to generate a schema.xml
Date Thu, 23 Oct 2003 14:38:08 GMT
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


Mime
View raw message