db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: Is SQL Server 2005 supported in Torque?
Date Fri, 19 Jan 2007 23:20:49 GMT
What Thomas meant by extensions is that there has been a 
lot of changes to Torque relating to MS SQL over the last
year or so.  

The newest version has been tested against MS SQL 2000 (and
MS SQL V7) but not specifically against MS SQL 2005.  Mainly
because none of the developers has easy access to it. (I.e.,
I didn't DL the developer edition and install it somewhere.
;) )

But AFAIK, there are no major changes in MS SQL that would 
prevent Torque from working with it. Unless it's because MS 
has done a major split with the SQL standards, we'll try to 
fix any problems reported.

So the answer to the "Is it supported?" question is a 
qualified yes.

That said, here's some thoughts:

Unless you REALLY need to use MS's JDBC driver, I'd suggest 
using the jTDS JDBC driver (http://jtds.sourceforge.net/).
This is what we test with and it is known to be fully 
JDBC 4.0 compliant and well used in lots of production 
situations (we use it here).  See the MS SQL Database HOW 
TO for syntax, etc.

If you're updating from a Torque from before 3.1, there 
have been a lot of changes in the Torque property settings, 
both for the generation and runtime.  You will probably 
need to look closely at your old properties file to make 
sure you are using the same settings.

Good luck and feel free to ask questions here.

> -----Original Message-----
> From: Bill Tomlinson [mailto:wstomlin@gmail.com] 
> Sent: Friday, January 19, 2007 4:40 PM
> To: Apache Torque Users List
> Subject: Re: Is SQL Server 2005 supported in Torque?
> On 1/19/07, Thomas Vandahl <tv@apache.org> wrote:
> > >> But it does sound like SQL server 2005 is not an officially 
> > >> supported DB for the project.
> >
> > Well, you did not even say which Torque version you use. 
> 3.3 contains 
> > some MS specific extensions...
> >
> I apologize for being obtuse, but I don't understand what 
> "contains some MS specific extensions..." exactly means?
> Is SQL server 2005 supported in the latest release (3.3) or 
> not? If someone involved in the project says "yes" then I'll 
> dig in there and do whatever work I need to do to make it work.
> I'm just asking because a) 2005 is not mentioned explicitly 
> on any Torque page I could find (and 2000 is) and b) the hard 
> coding of driver names in DBFactory suggests that some 
> drivers are supported and some aren't.
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

Duke CE Privacy Statement
Please be advised that this e-mail and any files transmitted with it are confidential communication
or may otherwise be privileged or confidential and are intended solely for the individual
or entity to whom they are addressed.  If you are not the intended recipient you may not rely
on the contents of this email or any attachments, and we ask that you  please not read, copy
or retransmit this communication, but reply to the sender and destroy the email, its contents,
and all copies thereof immediately.  Any unauthorized dissemination, distribution or copying
of this communication is strictly prohibited.

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

View raw message