Hi
I'm using torque-3.0-b3. I am trying to generate an xml schema from a
postgres db (my own - not the tutorial),
but I get the following output:
<output>
Buildfile: build-MyDAL.xml
jdbc:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating XML from JDBC connection ! |
[echo] | Woo hoo! |
[echo] | |
[echo] +-----------------------------------------------+
[echo] taking build.properties from: MyDAL.build.properties
[torque-jdbc-transform] Torque - JDBCToXMLSchema starting
[torque-jdbc-transform]
[torque-jdbc-transform] Your DB settings are:
[torque-jdbc-transform] driver : org.postgresql.Driver
[torque-jdbc-transform] URL :
jdbc:postgresql://127.0.0.1:5432/MyDatabaseName
[torque-jdbc-transform] user : myusername
[torque-jdbc-transform] password : mypassword
[torque-jdbc-transform] schema : ${databaseSchema}
[torque-jdbc-transform] DB driver sucessfuly instantiated
[torque-jdbc-transform] DB connection established
[torque-jdbc-transform] Getting table list...
[torque-jdbc-transform] Building column/table map...
[torque-jdbc-transform] java.sql.SQLException: ERROR: No such attribute
or function 'oid'
[torque-jdbc-transform]
[torque-jdbc-transform] java.sql.SQLException: ERROR: No such attribute
or function 'oid'
[torque-jdbc-transform]
[torque-jdbc-transform] at
org.postgresql.Connection.ExecSQL(Connection.java:533)
[torque-jdbc-transform] at
org.postgresql.Connection.ExecSQL(Connection.java:400)
[torque-jdbc-transform] at
org.postgresql.jdbc1.DatabaseMetaData.getColumns(DatabaseMetaData.java:1894)
[torque-jdbc-transform] at
org.apache.torque.task.TorqueJDBCTransformTask.getColumns(TorqueJDBCTransformTask.java:436)
[torque-jdbc-transform] at
org.apache.torque.task.TorqueJDBCTransformTask.generateXML(TorqueJDBCTransformTask.java:240)
[torque-jdbc-transform] at
org.apache.torque.task.TorqueJDBCTransformTask.execute(TorqueJDBCTransformTask.java:191)
[torque-jdbc-transform] at org.apache.tools.ant.Task.perform(Task.java:217)
[torque-jdbc-transform] at
org.apache.tools.ant.Target.execute(Target.java:184)
[torque-jdbc-transform] at
org.apache.tools.ant.Target.performTasks(Target.java:202)
[torque-jdbc-transform] at
org.apache.tools.ant.Project.executeTarget(Project.java:601)
[torque-jdbc-transform] at
org.apache.tools.ant.Project.executeTargets(Project.java:560)
[torque-jdbc-transform] at org.apache.tools.ant.Main.runBuild(Main.java:454)
[torque-jdbc-transform] at org.apache.tools.ant.Main.start(Main.java:153)
[torque-jdbc-transform] at org.apache.tools.ant.Main.main(Main.java:176)
[torque-jdbc-transform]
[torque-jdbc-transform] Torque - JDBCToXMLSchema finished
BUILD SUCCESSFUL
Total time: 3 seconds
</output>
No schema file is generated.
Is this problem related to the "oid" issue mentioned in the postgres
howto ? I assumed not since I have the tutorial running OK.
Any idea how to fix this ?
Pete
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
