Schema is case-sensitive, this could be your problem. Try all CAPS for the value.
I had trouble making this work at first too, but is does work. -----Original Message----- From: Greg Mumm [mailto:mumm_greg@;yahoo.com] Sent: Thursday, October 24, 2002 11:40 AM To: [EMAIL PROTECTED] Subject: Unable to create project schema from Oracle JDBC Hello: I am trying to generate a 'schema.xml' file from an existing Oracle database. The issues are identical to those in Siegfried's recent posting, except I'm using Oracle and not MS-SQL. After successfully runing "ant jdbc" all I get is a empty schema file. - Database: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Driver: classes12.zip (and I've also tried a recent ojdbc14.jar). - Torque: 3.0-b4 I can provide version details on the JDBC drivers. Can anyone help determine why there's no significant output? I suspect that it's either an issue with the schema, or some interaction with Oracle. -Greg ([EMAIL PROTECTED]) --------- ant -f build-torque.xml jdbc: --------- Buildfile: build-torque.xml jdbc: [echo] +-----------------------------------------------+ [echo] | | [echo] | Generating XML from JDBC connection ! | [echo] | Woo hoo! | [echo] | | [echo] +-----------------------------------------------+ [torque-jdbc-transform] Torque - JDBCToXMLSchema starting [torque-jdbc-transform] Your DB settings are: [torque-jdbc-transform] driver : oracle.jdbc.driver.OracleDriver [torque-jdbc-transform] URL : jdbc:oracle:thin:@test_a:1521:devl [torque-jdbc-transform] user : user [torque-jdbc-transform] password : ****** [torque-jdbc-transform] schema : dev1 [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] ./schema/schema.xml [torque-jdbc-transform] [torque-jdbc-transform] Torque - JDBCToXMLSchema finished BUILD SUCCESSFUL Total time: 3 seconds ----------- schema.xml: ----------- <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";> <!-- Autogenerated by JDBCToXMLSchema! --> <database/> %%%%%%%%%%% build.properties: %%%%%%%%%%% torque.project = testproj torque.database = oracle torque.targetPackage = com.amex.testproj.torque torque.addGetByNameMethod = true torque.addIntakeRetrievable = false torque.addSaveMethod = true torque.addTimeStamp = true torque.basePrefix = Base torque.complexObjectModel = true torque.overloadKeySetters = true torque.useClasspath = false torque.useManagers = false torque.database.createUrl = jdbc:oracle:thin:@test_a:1521:devl torque.database.buildUrl = jdbc:oracle:thin:@test_a:1521:devl torque.database.url = jdbc:oracle:thin:@test_a:1521:devl torque.database.driver = oracle.jdbc.driver.OracleDriver torque.database.schema = dev1 torque.database.user = user torque.database.password = ****** torque.database.host = 127.0.0.1 torque.sameJavaName = false __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- To unsubscribe, e-mail: <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>
