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