Solved

The conversion from UNKNOWN to UNKNOWN is unsupported

Posted on 2014-11-03
2
1,088 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
2 Comments
 
LVL 35

Accepted Solution

by:
mccarl earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now