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