Solved

The conversion from UNKNOWN to UNKNOWN is unsupported

Posted on 2014-11-03
2
1,258 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL - format decimal in a string 5 49
maven not picking latest jar instead picking old jar from .m2 12 42
Reformat SQL - so SSRS can read the columns 25 30
SQL- GROUP BY 4 21
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

685 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