Not sure about all of the various settings etc.. I think the MS Sql Server Howto has gotton out of date, any patches would be welcome. Here is how my Torque is set up:
# ------------------------------------------------------------------- # # T O R Q U E P R O P E R T I E S # # ------------------------------------------------------------------- # These are your database settings. Look in the # org.apache.torque.pool.* packages for more information. # # The parameters to connect to the default database. You MUST # configure these properly. # ------------------------------------------------------------------- torque.database.default.adapter=mssql #torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSour ceFactory #torque.dsfactory.default.pool.defaultMaxConnections=10 #torque.dsfactory.default.pool.maxExpiryTime=3600 #torque.dsfactory.default.pool.connectionWaitTimeout=10 #torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver #torque.dsfactory.default.connection.url = jdbc:microsoft:sqlserver://hqdbtest01:1433;DatabaseName=fortius;SelectMethod =cursor #torque.dsfactory.default.connection.user = SilverUserLogin #torque.dsfactory.default.connection.password = MYPassword torque.dsfactory.default.factory= org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory torque.dsfactory.default.pool.defaultMaxActive=30 torque.dsfactory.default.pool.testOnBorrow=true torque.dsfactory.default.pool.validationQuery=SELECT 1 torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.default.connection.url = jdbc:microsoft:sqlserver://hqdbtest01:1433;DatabaseName=fortius;SelectMethod =cursor torque.dsfactory.default.connection.user = SilverUserLogin torque.dsfactory.default.connection.password = MYPassword Eric pugh -----Original Message----- From: Stuart Townhill [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 5:24 AM To: [EMAIL PROTECTED] Subject: TDK How To - ant init - Microsoft SQL Server Looking forward to using TDK looks interesting. Successfully installed and configured Ant. Successfully used ant to build Turbine application (TDK Howto steps 1-3) I am trying to use Microsoft SQL Server (have been using Microsoft SQL Server Howto located in Torque area of website): Configured build.properties - database, databaseUrl, databaseDriver, databaseUser, databasePassword (Did not configure targetPlatform & targetPlatformExt as could not find but from reading archives I believe these are now configured automatically correct?) The Microst SQL Server Howto states: In the ..\WEB-INF\conf\TurbineResources.properties file, set; services.DatabaseService.database.adaptor=DBMSSQL services.DatabaseService.database.adaptor.DBMSSQL=[JDBC Driver] I think I have located these in the TurbineResources.properties file: database.adaptor=@DATABASE_ADAPTOR@ database.adaptor.@DATABASE_ADAPTOR@=@DATABASE_DRIVER@ But these look like they are automatically configuring themselves, is this correct? (therefore I left alone) Not sure exactly where I found it but a help file stated I had to create the database in Enterprise Manager with a user with SQL Server authentication and db_owner role. And when I set all the parameters listed above it is to this database, user and passwords that I have used. Basically when I run "Ant init" it doesn't work. (Error is printed below) Apologies if this has already been covered. I bet you here that a lot but I have scoured the website and archives for a good few hours but to no success. Many thanks for looking at this and if you can offer any advice. Regards, Stuart Townhill (Final Year Computing Student) C:\Program Files\Apache Group\Jakarta\tdk\webapps\app01\WEB-INF\build>ant init Buildfile: build.xml init: init-tasks: set-os: set-windows2000: set-windowsNT: set-windows98: set-unix: unix-ext: windows-ext: ext: [echo] Platform = unix [echo] Extension = sh create-database: init-tasks: turbine-sql: [echo] +------------------------------------------+ [echo] | | [echo] | Generating SQL for Turbine base system! | [echo] | | [echo] +------------------------------------------+ [torque-sql] C:\Program Files\Apache Group\Jakarta\tdk\webapps\app01\WEB-INF\src \sql\turbine-schema.sql BUILD FAILED java.lang.VerifyError: (class: org/apache/turbine/torque/engine/database/transfo rm/XmlToAppData, method: parseFile signature: (Ljava/lang/String;)Lorg/apache/tu rbine/torque/engine/database/model/AppData;) Incompatible object argument for fu nction call at org.apache.turbine.torque.TorqueSQLTask.initControlContext(TorqueSQLT ask.java:153) at org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:166) at org.apache.tools.ant.Task.perform(Task.java:319) at org.apache.tools.ant.Target.execute(Target.java:309) at org.apache.tools.ant.Target.performTasks(Target.java:336) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:371) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143) at org.apache.tools.ant.Task.perform(Task.java:319) at org.apache.tools.ant.Target.execute(Target.java:309) at org.apache.tools.ant.Target.performTasks(Target.java:336) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.Project.executeTargets(Project.java:1250) at org.apache.tools.ant.Main.runBuild(Main.java:610) at org.apache.tools.ant.Main.start(Main.java:196) at org.apache.tools.ant.Main.main(Main.java:235) Total time: 2 seconds java.lang.VerifyError: (class: org/apache/turbine/torque/engine/database/transfo rm/XmlToAppData, method: parseFile signature: (Ljava/lang/String;)Lorg/apache/tu rbine/torque/engine/database/model/AppData;) Incompatible object argument for fu nction call at org.apache.turbine.torque.TorqueSQLTask.initControlContext(TorqueSQLT ask.java:153) at org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:166) at org.apache.tools.ant.Task.perform(Task.java:319) at org.apache.tools.ant.Target.execute(Target.java:309) at org.apache.tools.ant.Target.performTasks(Target.java:336) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:371) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143) at org.apache.tools.ant.Task.perform(Task.java:319) at org.apache.tools.ant.Target.execute(Target.java:309) at org.apache.tools.ant.Target.performTasks(Target.java:336) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.Project.executeTargets(Project.java:1250) at org.apache.tools.ant.Main.runBuild(Main.java:610) at org.apache.tools.ant.Main.start(Main.java:196) at org.apache.tools.ant.Main.main(Main.java:235) (class: org/apache/turbine/torque/engine/database/transform/XmlToAppData, method : parseFile signature: (Ljava/lang/String;)Lorg/apache/turbine/torque/engine/dat abase/model/AppData;) Incompatible object argument for function call
