db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "CG Monroe (JIRA)" <j...@apache.org>
Subject [jira] Commented: (TORQUE-46) MSSQL Version 7.0 DB Adaptor support
Date Mon, 07 Aug 2006 15:01:15 GMT
    [ http://issues.apache.org/jira/browse/TORQUE-46?page=comments#action_12426243 ] 
CG Monroe commented on TORQUE-46:

I actually was on the fence about submitting this because it was for an old version.  But
I figured that here it would at least be available for reference if someone needed it.

Let's just put this on hold for now.  I think once some of the stuff in the pipeline gets
settled like the override support we're talking about and a place for contributions in the
web site, this would fit in there.  E.g., If you need MSSQL7 support, here's the generator
templates and jar to put in your override directory.  Here's the jar to add to your runtime.

I do agree it would be nice if some of the adaptor class matching was parametized (resource
bundle?) rather than hard coded.  E.g. DBFactory and PlatformFactory could load their lookup
tables from property files rather than hardcoding them.  But that's for another time/issue.

> MSSQL Version 7.0 DB Adaptor support
> ------------------------------------
>                 Key: TORQUE-46
>                 URL: http://issues.apache.org/jira/browse/TORQUE-46
>             Project: Torque
>          Issue Type: New Feature
>          Components: Runtime, Generator, Test Project
>    Affects Versions: 3.2.1
>         Environment: Windows XP, Java 1.5, MS SQL V7.0, Maven 1.02
>            Reporter: CG Monroe
>            Priority: Minor
>             Fix For: 3.2.1
>         Attachments: MSSQL7 Adaptor.zip
> 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.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


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

View raw message