Jeff, Russell, Thanks for the helpful answers. Anyway, shouldn't be the insert-sql a main target?
Regards, tele > create-db will not work for as400 as you cannot create a database > through SQL/JDBC. You must create the database yourself - which > you may have already done? > > The more important steps are the sql and insert-sql targets which > create the ddl sql, and insert the tables into the db. > > Russell > > > -----Original Message----- > > From: teletype [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, October 10, 2002 1:24 AM > > To: [EMAIL PROTECTED] > > Subject: AS400 > > > > > > Hello, > > > > I've tried to make Torque 3.0-b4 work without success. My > > main target platform is as400. > > I've done this: > > > > 1. copy bookstore-schema.xml to torque.home/schema > > 2. edit torque.home/build.properties: > > > > torque.database = db2400 > > torque.targetPackage = my.company.bookstore > > torque.database.createUrl = jdbc:as400://as400-host > > torque.database.buildUrl = jdbc:as400://as400-host > > torque.database.url = jdbc:as400://as400-host > > torque.database.driver = > > com.ibm.as400.access.AS400JDBCDriver > > torque.database.user = myaccount > > torque.database.password = mypassword > > torque.database.host = as400-host > > > > 3. copy jt400.jar to torque.home/lib > > 4. ant -f build-torque.xml create-db > > > > Buildfile: build-torque.xml > > > > create-db-check: > > > > create-db: > > [torque-data-model] Generating to file E:\torque-3.0-b4 > > \src\sql\create-db.sql > > [torque-data-model] Resolver: used database.dtd from > > org.apache.torque.engine.da > > tabase.transform package > > [torque-data-model] Resolver: used database.dtd from > > org.apache.torque.engine.da > > tabase.transform package > > [torque-data-model] Resolver: used database.dtd from > > org.apache.torque.engine.da > > tabase.transform package > > [torque-data-model] Resolver: used database.dtd from > > org.apache.torque.engine.da > > tabase.transform package > > [echo] > > [echo] Executing the create-db.sql script ... > > [echo] > > [sql] Executing file: E:\torque-3.0-b4 \src\sql\create- > > db.sql > > [sql] 0 of 0 SQL statements executed successfully > > > > BUILD SUCCESSFUL > > Total time: 10 seconds > > > > In fact the torque.home/src/sql/create-db.sql file contains > > 5 bytes only: 0D0A0D0A0A > > > > Can someone help me how can I make it work? > > > > Another question: > > As I know on as400 SQL a reference to a table is valid only > > if library name come before the table name like > > MYLIB.MYTABLE. The macros does not take account library > > names as I see. Have anyone been tried Torque with AS400? > > > > Regards, > > tele > > > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:turbine-torque-user- [EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > -- > To unsubscribe, e-mail: <mailto:turbine-torque-user- [EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:turbine-torque- [EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
