From torque-user-return-6427-apmail-db-torque-user-archive=db.apache.org@db.apache.org Thu Sep 08 21:28:27 2005 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 73910 invoked from network); 8 Sep 2005 21:28:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 8 Sep 2005 21:28:26 -0000 Received: (qmail 84628 invoked by uid 500); 8 Sep 2005 21:28:25 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 84607 invoked by uid 500); 8 Sep 2005 21:28:25 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: 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 84590 invoked by uid 99); 8 Sep 2005 21:28:25 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Sep 2005 14:28:24 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [216.148.227.85] (HELO rwcrmhc12.comcast.net) (216.148.227.85) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Sep 2005 14:28:36 -0700 Received: from conanjb (c-24-4-27-10.hsd1.ca.comcast.net[24.4.27.10]) by comcast.net (rwcrmhc12) with SMTP id <2005090821282201400b0fobe>; Thu, 8 Sep 2005 21:28:22 +0000 From: "Gary Baranzini" To: "'Apache Torque Users List'" Subject: RE: HSQLDB not working with torque-gen Date: Thu, 8 Sep 2005 14:28:13 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <20050908135301.Q58997@minotaur.apache.org> Thread-Index: AcW0uGpHahU8Wc2OSpaQ7VmUZnuWggAA1cuA X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Checked: Checked by ClamAV on apache.org Message-Id: <20050908212837.A1E6F10FB2B8@asf.osuosl.org> X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, Below is the output from running Torque-gen. The SELECT statement didn't change when I changed torque.database.schema to INFORMATION_SCHEMA. jdbc: [echo] +-----------------------------------------------+ [echo] | | [echo] | Generating XML from JDBC connection ! | [echo] | | [echo] +-----------------------------------------------+ [torque-jdbc-transform] Torque - JDBCToXMLSchema starting [torque-jdbc-transform] Your DB settings are: [torque-jdbc-transform] driver : org.hsqldb.jdbcDriver [torque-jdbc-transform] URL : jdbc:hsqldb:hsql://localhost/pinyin [torque-jdbc-transform] user : sa [torque-jdbc-transform] schema : INFORMATION_SCHEMA [torque-jdbc-transform] DB driver sucessfuly instantiated [torque-jdbc-transform] DB connection established [torque-jdbc-transform] Getting table list... BUILD FAILED D:\JavaApps\torque-gen-3.2-rc1\build-torque.xml:339: java.sql.SQLException: Table not found in statement [SELECT * FROM SYSTEM_TABLES] Gary -----Original Message----- From: Thomas Fischer [mailto:tfischer@apache.org] Sent: Thursday, September 08, 2005 2:01 PM To: Apache Torque Users List Subject: Re: HSQLDB not working with torque-gen Hi, As far as I remember, torque-gen uses the metadata from a connection to find out the list of tables; it does not actually compose the statement. However, in my experience, the metadata is very picky about suppliying the right database schema. In oracle, it's even case sensitive. Try to set torque.database.schema to INFORMATION_SCHEMA in the generator options. Thomas On Thu, 8 Sep 2005, Gary Baranzini wrote: > Hi, > > I'm trying to run torque-gen 3.2 rc1 against HSQLDB 1.8. > > I can get the DB driver successfully instantiated and DB connection > established. > > But when torque-gen tries to get the table list it fails on the > [SELECT * FROM SYSTEM_TABLES] statement. > > HSQLDB 1.8 appears to require [SELECT * FROM > INFORMATION_SCHEMA.SYSTEM_TABLES] > > Any suggestion on how to get this to work? > > Thanks, > > gary > > > _____ > > > Gary W. Baranzini > conanjb@comcast.net > > > Cyber and Sons > Computer Solution Specialists > 925.998.4768 > > > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org