What Torque does is it opens a connection to the db, goes for the metadata of the connection and makes the call
tableNames = dbMeta.getTables(null, dbSchema, "%", types); Maybe you can try to do this manually and play around to see what goes wrong ? It may also be that you have a permission problem and the orgasales user is not allowed to list all tables... Thomas Thoralf Rickert <[EMAIL PROTECTED]> schrieb am 10.04.2008 17:09:04: > Hi all, > > I try to extract a database schema from a SQL Server 2005. I tried both > drivers jTDS and the Microsoft JDBC Driver 1.2. In both versions I can access > the database, but the resulting XML schema for Torque is empty. > > When I run the JDBC task in build-torque.xml (fresh 3.3) I got this console response: > > 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.microsoft.sqlserver.jdbc.SQLServerDriver > [torque-jdbc-transform] URL : jdbc:sqlserver://srv-poseidon; > instanceName=orgasales;databaseName=OrgaSales;SelectMethod=cursor; > integratedSecurity=true > [torque-jdbc-transform] user : orgasales > [torque-jdbc-transform] schema : orgasales > [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/schema.xml > [torque-jdbc-transform] Torque - JDBCToXMLSchema finished > [echo] ...done. > BUILD SUCCESSFUL > Total time: 922 milliseconds > > That looks good for me. When I use the jTDS driver only the URL is different. > But the resulting XML file looks like this: > > <?xml version="1.0"?> > <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_3.dtd"> > <!-- Autogenerated by JDBCToXMLSchema! --> > <database name="orgasales"/> > Hmmm, that's not good. Actually the database has more then 100 tables, the > user 'orgasales' has admin rights and I can connect to the database via the > MSSQL console from my developer pc. The only thing that I didn't try is to > call the program directly on the machine. But this shouldn't be a problem, > because I can connect remotely. > > The config file looks like this: > > torque.database.host = srv-poseidon.cadooz-ag.intern > torque.database.type = mssql > torque.database.adaptor = mssql > torque.database.user = orgasales > torque.database.password = ... > torque.database.schema = orgasales > torque.database.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver > torque.database.url = jdbc:sqlserver://srv-poseidon;instanceName=orgasales; > databaseName=OrgaSales;SelectMethod=cursor;integratedSecurity=true > torque.database.buildUrl = ${torque.database.url} > torque.database.validationQuery = SELECT 1 > torque.database.default = orgasales > torque.database.cadooz.adapter = ${torque.database.type} > torque.dsfactory.cadooz.factory = org.apache.torque.dsfactory. > SharedPoolDataSourceFactory > torque.dsfactory.cadooz.pool.maxIdle = 8 > torque.dsfactory.cadooz.pool.maxActive = 10 > torque.dsfactory.cadooz.pool.maxWait = 10000 > torque.dsfactory.cadooz.pool.timeBetweenEvictionRunsMillis = 300000 > torque.dsfactory.cadooz.pool.minEvictableIdleTimeMillis = 3600000 > torque.dsfactory.cadooz.pool.testOnBorrow = true > torque.dsfactory.cadooz.pool.validationQuery = ${torque.database.validationQuery} > torque.dsfactory.cadooz.connection.driver = ${torque.database.driver} > torque.dsfactory.cadooz.connection.url = ${torque.database.url} > torque.dsfactory.cadooz.connection.user = ${torque.database.user} > torque.dsfactory.cadooz.connection.password = ${torque.database.password} > torque.manager.useCache = true > torque.home = . > torque.project = cadooz > torque.database = mssql > torque.targetPackage = com.cadooz.framework.orgasales > torque.subpackage.map = map > torque.subpackage.manager = manager > torque.runOnlyOnSchemaChange = false > torque.output.dir = . > torque.schema.dir = ${torque.home}/resources/schema > torque.java.dir = ${torque.home}/src > torque.sql.dir = ${torque.home}/resources/schema > torque.useManagers = false > In case of the jTDS driver the connection string looks like this: > > torque.database.driver = net.sourceforge.jtds.jdbc.Driver > torque.database.url = jdbc:jtds:sqlserver://srv-poseidon.cadooz-ag.intern: > 1433/OrgaSales;instance=OrgaSales > Has someone an idea what I can do to get a XML schema from this database? I > really don't like to edit the scheme file by hand this time ;-) > > Thanks, > Thoralf --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]