Jay Roy
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 .
SQL state [null]; error code [0]; The conversion from UNKNOWN to UNKNOWN is unsupported.; nested exception is com.microsoft.sqlserver.jd bc.SQLServ erExceptio n: The conversion from UNKNOWN to UNKNOWN is unsupported.
at org.springframework.jdbc.s upport.Abs tractFallb ackSQLExce ptionTrans lator.tran slate(Abst ractFallba ckSQLExcep tionTransl ator.java: 83)
at org.springframework.jdbc.s upport.Abs tractFallb ackSQLExce ptionTrans lator.tran slate(Abst ractFallba ckSQLExcep tionTransl ator.java: 80)
at org.springframework.jdbc.s upport.Abs tractFallb ackSQLExce ptionTrans lator.tran slate(Abst ractFallba ckSQLExcep tionTransl ator.java: 80)
at org.springframework.jdbc.c ore.JdbcTe mplate.exe cute(JdbcT emplate.ja va:605)
at org.springframework.jdbc.c ore.JdbcTe mplate.upd ate(JdbcTe mplate.jav a:818)
at org.springframework.jdbc.c ore.JdbcTe mplate.upd ate(JdbcTe mplate.jav a:874)
any clue where the problem is?
thanks
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 = ?),'','','',''
,'','','','','')
but when it is invoked from my java codeit gives errrorSQL state [null]; error code [0]; The conversion from UNKNOWN to UNKNOWN is unsupported.; nested exception is com.microsoft.sqlserver.jd
at org.springframework.jdbc.s
at org.springframework.jdbc.s
at org.springframework.jdbc.s
at org.springframework.jdbc.c
at org.springframework.jdbc.c
at org.springframework.jdbc.c
any clue where the problem is?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.