[TORQUE-46] MSSQL Version 7.0 DB Adaptor support

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 3.3
• Fix Version/s: 3.3
• Component/s: Generator, Runtime, Test Project
• Environment: Windows XP, Java 1.5, MS SQL V7.0, Maven 1.02
• Assignee: Thomas Fox
• Reporter: CG Monroe
• Created: 18/Jul/06 22:43
• Updated: 26/Nov/06 18:23
• Resolved: 12/Aug/06 08:43

Description

Thomas V. inspired me to finally get the Torque test-project to run clean with MS SQL V7.0 (I know ancient stuff but we got a deal on a lot of licenses here...)

Attached is a source zip file that adds an mssql7 adaptor type to Torque. This is the same as the mssql adaptor except for the following items:

PlatformMssql7Imp.java:

BIGINT type is mapped to Decimal(19,0) since V7.0 did not support this.

sql template files:

Comments now done with SQL92 '--' standard rather than /* .... */
Foreign key "ON" support has been removed since V7.0 did not support this.

DBMSSQL7.java

Just a stub that extends DMBSSQL since runtime works fine with V7.0

DBFactory.java

Adds mssql7 as an adaptor type.

Test

Adds an mssql7 profile.