Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
From: Sven Boden <list123@pandora.be>
To: user-java@ibatis.apache.org
Subject: Re: invalid column type
Date: Mon, 27 Jun 2005 17:36:09 +0200
Message-ID: <j570c1lbk1ng9ppdp4edmg1vs5r8sib0tu@4ax.com>
References: <20050627141406.BEC0610FB2E9@asf.osuosl.org>
In-Reply-To: <20050627141406.BEC0610FB2E9@asf.osuosl.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable


Can you post a describe of table EDB_USER?

Sven


On Mon, 27 Jun 2005 09:13:05 -0500, you 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