From torque-user-return-3611-apmail-db-torque-user-archive=db.apache.org@db.apache.org Wed Dec 03 18:14:25 2003 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 39193 invoked from network); 3 Dec 2003 18:14:25 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 3 Dec 2003 18:14:25 -0000 Received: (qmail 6587 invoked by uid 500); 3 Dec 2003 18:14:02 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 6572 invoked by uid 500); 3 Dec 2003 18:14:02 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 6558 invoked from network); 3 Dec 2003 18:14:01 -0000 Received: from unknown (HELO infolog.it) (130.186.251.234) by daedalus.apache.org with SMTP; 3 Dec 2003 18:14:01 -0000 content-class: urn:content-classes:message Subject: R: Newbie - Torque with DB2/AS400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Wed, 3 Dec 2003 19:14:04 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Newbie - Torque with DB2/AS400 Thread-Index: AcO5xWjoJInr3kvrQXWMLHN3ZzSg3AAA0JwA From: "Giulio Vezzelli" To: "Apache Torque Users List" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I think you should consider the "library" corresponding to "database", = and "file" to "table". That's how IBM iSeries/Client Access works... Maybe it's your solution. The adapter should be "db2400", and the JDBC driver is = "com.ibm.as400.access.AS400JDBCDriver", supplied in the Java toolbox = which comes with OS/400. My personal opinion is that Torque is not ready yet to create = libraries/files on AS/400... Or maybe it's just my impression ;) Beware of case sensitivity issues when specifying databases (libraries), = tables and columns... AS/400 is quite nosy about it. Giulio Vezzelli Infolog S.r.l. Via Alfieri, 28 Modena - 41100 Telefono : +39-059-822446 Sito web : http://www.infolog.it E-mail : giulio.vezzelli@infolog.it =20 =20 > -----Messaggio originale----- > Da: Sonu Vijay [mailto:sonupv@yahoo.com]=20 > Inviato: mercoled=EC 3 dicembre 2003 18.46 > A: torque-user@db.apache.org > Oggetto: Newbie - Torque with DB2/AS400=20 >=20 > Hi, > Am trying to use Torque with DB2/AS400. So far am able to=20 > create tables and generate java classes. But I'm having some=20 > problems with using those java classes to enter data into the tables. >=20 > On DB2/AS400 everything is arranged in libraries and the=20 > conventional concept of a database (like in mysql > etc) doesn't exist. So the create-db target didn't do=20 > anything also. And in the database create and build URLs I=20 > only gave the URL to the library in which I needed the=20 > tables, that's the way it worked.=20 >=20 > Now I'm not sure how to configure the > Torque.properties I'm doing this: >=20 > Like for mysql and stuff I can write >=20 > torque.database.default=3Dbookstore > torque.database.bookstore.adapter=3DDBDB2App >=20 > So what needs to written in place of "bookstore" ? >=20 > The library name ?? >=20 > And also am I using the right adapter ? >=20 > And is there any DB2/AS400 specific tutorial available ? >=20 > Pls advice >=20 > Vijay >=20 >=20 > __________________________________ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now > http://companion.yahoo.com/ >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: torque-user-help@db.apache.org >=20 >=20 --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org