Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

The conversion from UNKNOWN to UNKNOWN is unsupported

Posted on 2014-11-03
2
Medium Priority
?
1,649 Views
Last Modified: 2014-12-03
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
0
Comment
Question by:royjayd
1 Comment
 
LVL 36

Accepted Solution

by:
mccarl earned 2000 total points
ID: 40420599
but when it is invoked from my java codeit gives errror
any clue where the problem is?
Probably in the Java code (that you haven't posted)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question