You can specify the schema (library) in the URL. Check out example 2 at: http://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/rzaha/conjdbex.htm
Also, there are some interesting properties you can set in the URL (such as prompt=false to eliminate the login prompt), try: http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/rzaha/conpr op.htm ----- Original Message ----- From: "teletype" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 1:23 AM 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]>
