ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kris Jenkins <krisajenk...@yahoo.co.uk>
Subject Re: invalid column type
Date Mon, 27 Jun 2005 15:48:15 GMT
Tony,

Have you tried using the advice given in the page mentioned by Sven on 
the 'value' property?  I mean, have you tried:

    ...
    WHERE USER_ID = #value:VARCHAR#
    ...

?

Kris

Tony Chen wrote:

> I checked that, but it states that " With this error only your insert 
> and update statements will be of concern".  However, I am trying to 
> query a table w/o null value.  Thanks
>
> Tony
>
> -----Original Message-----
> From: Sven.Boden [mailto:list123@pandora.be]
> Sent: Monday, June 27, 2005 9:10 AM
> To: user-java@ibatis.apache.org
> Subject: Re: invalid column type
>
>
>
> It's explained in the FAQ, have a look at 
> http://opensource.atlassian.com/confluence/oss/display/IBATIS/What+causes+an+Invalid+column+type+error+with+Oracle%3F
>
> Regards,
> Sven Boden
>
> >I received an Invalid Column Type error when querying an Oracle 
> database.  This issue is explained for Insert and Update.  Does anyone 
> know what is the reason for insert?  The environment is 
> Windows2000+JDeveloper.  The message is like this
>
> >Cause:com.ibatis.common.jdbc.exception.NestedSQLException: --- The 
> error occurred in oraclemag/view/sql-map.xml. --- The error occurred 
> while applying a parameter map. --- Check the 
> getEntitlementProfile-InlineParameterMap. --- Check the parameter 
> mapping for the 'value' property. --- Cause: java.sql.SQLException: 
> Invalid column type Caused by: java.sql.SQLException: Invalid column type
>
>
>
>
> This transmission (and any information attached to it) may be 
> confidential and is intended solely for the use of the individual or 
> entity to which it is addressed. If you are not the intended recipient 
> or the person responsible for delivering the transmission to the 
> intended recipient, be advised that you have received this 
> transmission in error and that any use, dissemination, forwarding, 
> printing, or copying of this information is strictly prohibited. If 
> you have received this transmission in error, please immediately 
> notify LabOne at the following email address: 
> securityincidentreporting@labone.com
>


-- 
Kris Jenkins
Email:  kris@jenkster.com
Blog:   http://cafe.jenkster.com/
Wiki:   http://wiki.jenkster.com/


	
	
		
___________________________________________________________ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com

Mime
View raw message