Hi!
I try to generate a XML schema for a Sybase database. The problem is
that the task runs without an error but the generated schema.xml is
empty. I think, I forgot a property but I don't know which one. Here are
my torque properties and the generated output:
#
torque.database.type = sybase
torque.database.user = sa
torque.database.password = <password>
torque.database.driver =
com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource
torque.database.url = jdbc:sybase:Tds:dbtest:2510/cadooz
torque.database.validationQuery = SELECT 1
#
torque.database.default = intershop
torque.database.schema = intershop
torque.database.intershop.adapter = sybase
torque.dsfactory.intershop.factory =
org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.intershop.pool.maxIdle = 8
torque.dsfactory.intershop.pool.maxActive = 10
torque.dsfactory.intershop.pool.maxWait = 10000
torque.dsfactory.intershop.pool.timeBetweenEvictionRunsMillis = 300000
torque.dsfactory.intershop.pool.minEvictableIdleTimeMillis = 3600000
torque.dsfactory.intershop.pool.testOnBorrow = true
torque.dsfactory.intershop.pool.validationQuery = SELECT 1
torque.dsfactory.intershop.connection.driver =
com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource
torque.dsfactory.intershop.connection.url =
jdbc:sybase:Tds:dbtest:2510/cadooz
torque.dsfactory.intershop.connection.user = sa
torque.dsfactory.intershop.connection.password = <password>
torque.manager.useCache = true
#
torque.home = .
torque.project = intershop
torque.database = sybase
torque.targetPackage =
com.cadooz.framework.intershop.database
torque.subpackage.map = map
torque.subpackage.manager = manager
torque.runOnlyOnSchemaChange = false
torque.output.dir = .
torque.schema.dir =
${torque.home}/resources/schema/intershop
torque.templatePath =
${torque.home}/resources/torque
torque.doc.dir = ${torque.home}/doc
torque.java.dir = ${torque.home}/src
torque.ojb.dir =
${torque.home}/resources/torque
torque.sql.dir =
${torque.home}/resources/schema/intershop
torque.database.createUrl =
jdbc:sybase:Tds:dbtest:2510/cadooz
torque.database.buildUrl =
jdbc:sybase:Tds:dbtest:2510/cadooz
torque.database.url =
jdbc:sybase:Tds:dbtest:2510/cadooz
torque.database.host = dbtest
torque.useManagers = false
The console output is (I'm using ant)
jdbc:
[echo] +-----------------------------------------------+
[echo] | |
[echo] | Generating XML from JDBC connection ! |
[echo] | |
[echo] +-----------------------------------------------+
[torque-jdbc-transform] Torque - JDBCToXMLSchema starting
[torque-jdbc-transform] Your DB settings are:
[torque-jdbc-transform] driver :
com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource
[torque-jdbc-transform] URL :
jdbc:sybase:Tds:dbtest.cadooz-ag.intern:2510/cadooz
[torque-jdbc-transform] user : sa
[torque-jdbc-transform] schema : intershop
[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] ./resources/schema/intershop/schema.xml
[torque-jdbc-transform] Torque - JDBCToXMLSchema finished
[echo] ...done.
BUILD SUCCESSFUL
Total time: 7 seconds
This generates a XML file with the following content.
<?xml version="1.0"?>
<!DOCTYPE database SYSTEM
"http://db.apache.org/torque/dtd/database_3_2.dtd";>
<!-- Autogenerated by JDBCToXMLSchema! -->
<database name="sa"/>
Of course, there are more than 0 tables in this database.
It's strange, that it sets the database name to the database user name
"sa"..... In org.apache.torque.task.TorqueJDBCTransformTask#generateXML
line 196 is a bug:
195: databaseNode = doc.createElement("database");
196: databaseNode.setAttribute("name", dbUser);
I think this should be something like:
196: databaseNode.setAttribute("name", dbName);
Where dbName is the name of the database (I'll make a bug report). But
that doesn't solve my problem.
bye
Thoralf
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
