Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 18360 invoked from network); 21 Jun 2006 12:49:22 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Jun 2006 12:49:22 -0000 Received: (qmail 44390 invoked by uid 500); 21 Jun 2006 12:49:19 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 44374 invoked by uid 500); 21 Jun 2006 12:49:18 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 44363 invoked by uid 99); 21 Jun 2006 12:49:18 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Jun 2006 05:49:18 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [195.6.195.202] (HELO smtp1.girce.net) (195.6.195.202) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Jun 2006 05:49:17 -0700 Received: from unknown (HELO srvexch.epro.dom) ([192.168.200.206]) by smtp1.girce.net with ESMTP; 21 Jun 2006 14:48:55 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C69531.6D71D2B0" Subject: "invalid column type' Date: Wed, 21 Jun 2006 14:51:34 +0200 Message-ID: <14A339358E3BE14C94A52240E3FD0A3A06E1F4A1@srvexch.epro.dom> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: "invalid column type' Thread-Index: AcaVMZmPoTqcQFs/RgqKSZZ2qEGvKg== From: "jeremy jardin" To: X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C69531.6D71D2B0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello, =20 I'm trying to insert user in my oracle database using ibatis framework. I generated sql-map file using Abator plugin. =20 My table look like that : =20 UID CHAR(36 Bytes) =20 MOBILE CHAR(12 Bytes) ORIGINE_UUID CHAR(36 Bytes) ETAT CHAR(10 Bytes) LOGIN CHAR(20 Bytes) ETAT_MODIFIE CHAR(1 Bytes)=20 TSTMPINSR TIMESTAMP(6) =20 TSTMPUPDT TIMESTAMP(6)=20 =20 I can see that Timestamp columns have been set as 'Object' in my javabean.. It should have been a "Date" type ! =20 =20 So, when I try to store my user, I have that exception : =20 --- Check the parameter mapping for the 'TSTMPUPDT' property. =20 --- Cause: java.sql.SQLException: Type de colonne non valide Caused by: java.sql.SQLException: Type de colonne non valide =20 What should I do ?? =20 =20 Thx =20 =20 =20 ------_=_NextPart_001_01C69531.6D71D2B0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

 

I’m trying to = insert user in my oracle database using ibatis = framework.

I generated sql-map file using Abator plugin.

 

My table look like = that :

 

UID       CHAR(36 Bytes)           =

MOBILE           = CHAR(12 = Bytes)

 ORIGINE_UUID        = ;    CHAR(36 Bytes)

 ETAT   CHAR(10 Bytes)

LOGIN  CHAR(20 = Bytes)

 ETAT_MODIFIE        = ;   CHAR(1 Bytes) =

TSTMPINSR     TIMESTAMP(6)         = ;            = ;   

TSTMPUPDT    TIMESTAMP(6)

 

I can see that = Timestamp columns have been set as ‘Object’ in my javabean..

It should have been a = “Date” type !

 

 

So, when I try to = store my user, I have that exception = :

 

--- Check the parameter mapping for the = 'TSTMPUPDT' property.  =

--- Cause: = java.sql.SQLException: Type de = colonne non valide

Caused by: java.sql.SQLException: Type de = colonne non valide

 

What should I = do ??

 

 

Thx

      =

 

 

=00 ------_=_NextPart_001_01C69531.6D71D2B0--