Hi Jyothi,

I'm CC'ing a response to the Torque-user list, as maybe others are
interested in an answer to your question as well.  (using non-supporting
drivers with Torque).

The latest version in CVS (CVS HEAD) has an adapter property allowing any
driver to be used, but the latest release (beta 3) *does not* have the
adapter property.  So, you have two choices.

(1) Use the latest version from CVS-HEAD.  This involves downloading the
source code, and building it.  I'm no expert (just a user) but did this a
while back.  If you're not familiar with all the tools (I wasn't at first)
it's a bit of a pain because the build tool (Maven) is also pre-release and
changes regularly.  You have to download and install ant, download and build
Maven, download the Torque CVS, and build.   Because Maven is under active
development, you have to use the latest (CVS HEAD) version of Maven.  Rumor
has it this will get easier once Maven stabilizes.

(2) Use an earlier version of Torque but hand-patch "DBFactory.java" to add
in your driver.  You still have to build Torque, but there's a non-Maven
build routine.  Advantage-- may be more stable than CVS head.
Disadvantage-- your changes will be lost when if you upgrade.  (and you
still have to build).

Hope this helps.

WILL

-----Original Message-----
From: Jyothi Gangadharan [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 17, 2002 3:20 PM
To: [EMAIL PROTECTED]
Subject: Quick Question on torque.


Hello Will,
I came across your posting on mailing list when i was searching for a
solution to my problem.
I am trying to use torque in Jetspeed with SqlServer database.

 I would like to use I-net Sprinta Driver that supports both sqlServer 7
and 2000
and is downloadable free of charge from
http://www.inetsoftware.de/English/produkte/JDBC2/Default.htm

Set the properties in Toque.properties to as shown below
database.adaptor=DBMSSQL
database.adaptor.DBMSSQL=com.inet.tds.TdsDriver
and  Driver url to
database.default.driver=com.inet.tds.TdsDriver
database.default.url=jdbc\:inetdae7\:127.0.0.1\:1433?database\=jetspeed

Added the Sprinta.jar to lib folder
Could you please let me know How I can add this to torque.jar

Thanks
Jyothi



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to