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>