Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 369352

Summary:

SQL SERVER 2005/2008 modification in JDBC Enum Type value for NText

Product:

[Tools] Data Tools

Reporter:

Rahul jain <rahul.jain>

Component:

Enablement

Assignee:

Brian Payton <bpayton>

Status:

RESOLVED FIXED

QA Contact:

Severity:

normal

Priority:

CC:

bpayton, hskolwal, proberts

Version:

unspecified

Target Milestone:

1.9.2

Hardware:

OS:

Windows XP

Whiteboard:

Attachments:

Description	Flags
Fix to modify JDBC ENUM Type value for NText in SQLSERVER 2005/2008	none

Description Rahul jain

2012-01-23 01:28:36 EST

Build Identifier:  M20110210-1200

This bug is created to modify the jdbc enum type value from "-10" to "-1".

Both the TEXT and NTEXT types map to the JDBC type LONGVARCHAR, which has a type code "-1".

Text sql type, JDBC enum type value is correctly set to "-1".

However it is set as "-10" for NText sql type.

Need to modify jdbcEnum type value from "-10" to "-1" for NText sql type in both 2005 and 2008 SQL SERVER support.

Few references that talks about the same are:

http://msdn.microsoft.com/en-us/library/ms378813.aspx 

http://msdn.microsoft.com/en-us/library/ms378715%28v=sql.90%29.aspx 

http://docs.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Types.ARRAY



Reproducible: Always

Steps to Reproduce:
Deployment fails if you have of the EJBs if you have NText part of your beans.

Error is:

UnKnown JDBC type for NText.

Comment 1 Rahul jain

2012-01-23 01:33:50 EST

Created attachment 209891 [details]
Fix to modify JDBC ENUM Type value for NText in SQLSERVER 2005/2008

Comment 2 Brian Payton

2012-01-23 16:31:28 EST

Here's the Git commit record for the 1.10 (master) branch: 
http://git.eclipse.org/c/datatools/org.eclipse.datatools.enablement.msft.git/commit/?h=DTP_1_9_2_Branch&id=55284880476a54a84c23558d3e04b2cd4ec8b50c

and for the 1.9.2 branch:
http://git.eclipse.org/c/datatools/org.eclipse.datatools.enablement.msft.git/commit/?id=8f405b1a4f9473fc49cd0093ac1aabe1d98ee86a

I updated the plugin version of the o.e.d.enablement.msft.sqlserver.dbdefinition in both branches from 1.0.0 to 1.0.1.