Community
Participate
Working Groups
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.
Created attachment 209891 [details] Fix to modify JDBC ENUM Type value for NText in SQLSERVER 2005/2008
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.