Joe,
Thanks! Uppercasing the schema worked immediately. Wow, I've been trying
to get that to work for over a day now.
-Greg
From: "Joe McGlynn" <[EMAIL PROTECTED]> on 10/24/2002 11:43 AM MST
Please respond to "Turbine Torque Users List"
<[EMAIL PROTECTED]>
To: "'Turbine Torque Users List'" <[EMAIL PROTECTED]>
cc:
Subject: RE: Unable to create project schema from Oracle JDBC
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>
--
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>
