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:[EMAIL PROTECTED]
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
> [EMAIL PROTECTED]
>
>
> Cyber and Sons
> Computer Solution Specialists
> 925.998.4768
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
