You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "CG Monroe (JIRA)" <ji...@apache.org> on 2006/07/19 00:44:13 UTC
[jira] Created: (TORQUE-46) MSSQL Version 7.0 DB Adaptor support
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: Generator, Runtime, 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
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
[jira] Commented: (TORQUE-46) MSSQL Version 7.0 DB Adaptor support
Posted by "CG Monroe (JIRA)" <ji...@apache.org>.
[ 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
[jira] Resolved: (TORQUE-46) MSSQL Version 7.0 DB Adaptor support
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-46?page=all ]
Thomas Fischer resolved TORQUE-46.
----------------------------------
Resolution: Won't Fix
Assignee: Thomas Fischer
Added a note in the MSSQL Howto to point to this issue for mssql7.
Did not commit the test profile because it would have used a non-existing database name and Adaptor, which may have caused confusion.
Closed for now, reopen if there are better ways to support user-specific setting sin the generator.
> 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
> Assigned To: Thomas Fischer
> 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
[jira] Commented: (TORQUE-46) MSSQL Version 7.0 DB Adaptor support
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-46?page=comments#action_12426026 ]
Thomas Fischer commented on TORQUE-46:
--------------------------------------
Do we really want to add an adapter for every old version which is out there ?
I'd suggest the following
- add the test profile (it does not hurt if that does not get maintained)
- find a way to change sql type mappings more easily than in the current version
- document the changes needed for mssql7 in the mssql howto page
> 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
[jira] Updated: (TORQUE-46) MSSQL Version 7.0 DB Adaptor support
Posted by "CG Monroe (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-46?page=all ]
CG Monroe updated TORQUE-46:
----------------------------
Attachment: MSSQL7 Adaptor.zip
MS SQL V7.0 Adaptor support to correctly support BigInt and SQL creation.
> 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
[jira] Closed: (TORQUE-46) MSSQL Version 7.0 DB Adaptor support
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-46?page=all ]
Thomas Vandahl closed TORQUE-46.
--------------------------------
> 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.3
> Environment: Windows XP, Java 1.5, MS SQL V7.0, Maven 1.02
> Reporter: CG Monroe
> Assigned To: Thomas Fischer
> Priority: Minor
> Fix For: 3.3
>
> 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