Firebird does not support neither schemas nor catalogs. You should
try to set up Torque so that it passes nulls into
DatabaseMetaData.getTables(...) method.

Driver just reports that schemas are not supported.

Best regards,
Roman Rokytskyy

--- In Firebird-Java@yahoogroups.com, "paul <potnoddle@y...>"
<potnoddle@y...> wrote:

> hi
>
> i'm trying to uses torque will firebird, however when i get to the
> jdbc reengering part ie ant -buildfile build-torque.xml jdbc i geta
> SQL exception 'Schemas not supported' is this the case, if so will

is

> this on the cards, as will looks a wicked tool.
>
> also where can i get access to the latest CVS.
>
> thanks paul
> ----------------------torque error----------------------
>
> Torque - JDBCToXMLSchema starting
> Your DB settings are:
> driver : org.firebirdsql.jdbc.FBDriver
> URL : jdbc:firebirdsql://127.0.0.1:3050/c:\java\webblog.gdb
> user : sysdba
> schema : ${databaseSchema}
> DB driver sucessfuly instantiated
> DB connection established
> Getting table list...
> java.sql.SQLException: Schemas not supported
> java.sql.SQLException: Schemas not supported
> at
> org.firebirdsql.jdbc.FBDatabaseMetaData.checkCatalogAndSchema
> (FBDatabaseMetaData.java:5121)
> at org.firebirdsql.jdbc.FBDatabaseMetaData.getTables
> (FBDatabaseMetaData.java:2310)
> at
> org.apache.torque.task.TorqueJDBCTransformTask.getTableNames
> (TorqueJDBCTransformTask.java:392)
> at org.apache.torque.task.TorqueJDBCTransformTask.generateXML
> (TorqueJDBCTransformTask.java:231)
> at org.apache.torque.task.TorqueJDBCTransformTask.execute
> (TorqueJDBCTransformTask.java:194)
> at org.apache.tools.ant.Task.perform(Task.java:319)
> at org.apache.tools.ant.Target.execute(Target.java:309)
> at org.apache.tools.ant.Target.performTasks(Target.java:336)
> at org.apache.tools.ant.Project.executeTarget
> (Project.java:1306)
> at org.apache.tools.ant.Project.executeTargets
> (Project.java:1250)
> at org.apache.tools.ant.Main.runBuild(Main.java:610)
> at org.apache.tools.ant.Main.start(Main.java:196)
> at org.apache.tools.ant.Main.main(Main.java:235)
>
> Torque - JDBCToXMLSchema finished