db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Hakim <dha...@webcodex.com>
Subject SOLVED: Problems with the jdbc task against SQLServer
Date Fri, 18 Apr 2003 21:22:33 GMT
	Actually this looks like just more weirdness with Microsoft's JDBC 
driver not returning database meta data the way it should (or at least 
the way I'd like it to). It seems that while torque's jdbc task will 
function somewhat (i.e. it will retrieve tables and columns) against 
sqlserver by including the extra property:

torque.database.schema = %

in your build.properties, it works much better (i.e. it actually pulls 
primary key meta-data) if the schema is set to dbo

torque.database.schema = dbo

Swarn: Sorry for the less than complete advice I posted on this issue 
earlier :)


On Friday, April 18, 2003, at 04:20  PM, David Hakim wrote:

> 	Are there extra properties I need to pass in torque's 
> build.properties file for the jdbc task to pull out which columns are 
> primary keys in a SQLServer schema (using Microsoft's JDBC driver) 
> when generating the XML schema? The jdbc task seems to be able to do 
> this just fine against MySQL schemas without any additional 
> configuration.
> -Dave
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

View raw message