db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thoralf Rickert" <thoralf.rick...@cadooz.de>
Subject AW: Problem with SQL Task jdbc
Date Tue, 11 Jul 2006 14:07:00 GMT
Okay, the property torque.database.schema has to be null - otherwise the driver returns an
empty list of tables. But I cannot set it to null (comment out torque.database.schema results
in a String with the content "${torque.database.schema}").

I think this is a bug too - maybe sybase specific (it works with mysql).

bye
Thoralf

> -----Urspr√ľngliche Nachricht-----
> Von: Thoralf Rickert [mailto:thoralf.rickert@cadooz.de] 
> Gesendet: Dienstag, 11. Juli 2006 15:42
> An: Apache Torque Users List
> Betreff: Problem with SQL Task jdbc
> 
> 
> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message