Link to home
Start Free TrialLog in
Avatar of Jay Roy
Jay RoyFlag for United States of America

asked on

The conversion from UNKNOWN to UNKNOWN is unsupported

hi experts

I am using sql server 2008, when i run this sql in sql server studio it works fine .
INSERT INTO [CUSTOMER_ACCOUNT] ([VERSION] ,[QUESTID] ,[JANCE_ID] 
			 ,[DATE],[CREATED_DT],[CURRENCY],[ITEMID],[STATUS],[ACTION_DATE],[ENTITY],[ACTIONTYPE],[ID]
			,[REJECTION_REASON_ID],[OPERATION],[OPERATION_ACTION_DATE],[PROCESSID],[NSTANCEID],[PRODUCT],[PRODUCTCONTROL],[PRODUCTCONTROL_DATE]
			,[PRODUCT_OWNER],[PRODUCTSUP_ACTION_DATE],[RISK],[RISK_ACTION_DATE],[SPPUP_GID],[LINE],[CTIONTYPE],[JAMOOLID],[PLLIST],[PLTATUS]
			,[LOTUS_ACTION_DATE],[ISOOH_PERM],[ISOP_PERM],[UPWORKFLOW_ACTION_DATE],[UPWORKFLOW_STATUS]) 
			VALUES 
			(0,'test',''
			,GETDATE(),'2014-09-29',(select cmap.MAPID from CurrencyGroupMap cmap, CurrencyGroup cg
			where cmap.CURRENCYGROUPID = cg.CURRENCYGROUPID and 
			cg.NAME = ?),0,'','',(select lmap.LERMAPID from LegalEntityGroupMap lmap, TM.LegalEntityGroup lg
			where lmap.LEGALENTITYGROUPID = lg.LEGALENTITYGROUPID and 
			lg.NAME = ?),?,?
			,0,'','',0,?,(select pmap.PRODUCTGROUPMAPID from ProductGroupMap pmap, ProductGroup pg
			where pmap.PRODUCTGROUPID = pg.PRODUCTGROUPID and 
			pg.NAME = ?),'',''
			,'','','','','',(select JAMOOLID from JAMOOL where YEAR = ? and MONTH = ? and DAY = ?),'','','',''
			,'','','','','')

Open in new window

but when it is invoked from my java codeit gives errror
 

 SQL state [null]; error code [0]; The conversion from UNKNOWN to UNKNOWN is unsupported.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818)
      at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)


any clue where the problem is?
thanks
ASKER CERTIFIED SOLUTION
Avatar of mccarl
mccarl
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial