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:[EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
