Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 83305 invoked from network); 13 Dec 2007 05:27:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Dec 2007 05:27:39 -0000 Received: (qmail 71307 invoked by uid 500); 13 Dec 2007 05:27:22 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 71282 invoked by uid 500); 13 Dec 2007 05:27:22 -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 71271 invoked by uid 99); 13 Dec 2007 05:27:21 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Dec 2007 21:27:21 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [210.210.10.25] (HELO smtp.ceiindia.com) (210.210.10.25) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Dec 2007 05:27:21 +0000 Received: from shiva.CEIINDIA.COM ([192.100.0.153]) by smtp.ceiindia.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 13 Dec 2007 10:56:53 +0530 Received: from cei2022 ([192.100.0.148]) by shiva.CEIINDIA.COM with Microsoft SMTPSVC(5.0.2195.6713); Thu, 13 Dec 2007 10:59:02 +0530 Message-ID: <006f01c83d44$df401b10$940064c0@cei2022> Reply-To: "AVenkatesan" From: "AVenkatesan" To: Cc: "AVenkatesan" Subject: Mysql Database not showing the inserted record Date: Thu, 13 Dec 2007 10:28:59 +0530 Organization: CEI India P Ltd MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006C_01C83D72.F8E7B540" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 X-OriginalArrivalTime: 13 Dec 2007 05:29:02.0031 (UTC) FILETIME=[11C85DF0:01C83D49] X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_006C_01C83D72.F8E7B540 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable iam trying to run a simple ibatis insert statement as follows: I have code as following try{ SqlMapSession sqlMapSession=3D sqlMapClient.openSession(); sqlMapSession.startTransaction(); int i=3DsqlMapSession.update("insertCode",code); =20 sqlMapSession.commitTransaction(); sqlMapSession.close(); }catch{.....} but after excuting the program i see insert statement in logs but the = inserted records are not visible in database. Following is the Code.xml insert into CI_CODE (CODE_ID,CODE_DETAILS,CODE_DOMAIN,EMP_ID) = values=20 (#codeId#, #codeDetails#,#codeDomain#,#empId#) And resective sql-map-config.xml as=20 =20 =20 Anything wrong with the code? Venkatesan ------=_NextPart_000_006C_01C83D72.F8E7B540 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

iam trying to = run a simple=20 ibatis insert statement as follows:

I have code = as=20 following

try{
        = SqlMapSession=20 sqlMapSession=3D=20 sqlMapClient.openSession();
       = =20 sqlMapSession.startTransaction();
      = =20 int=20 i=3DsqlMapSession.update("insertCode",code);
    &= nbsp;  =20
       =20 sqlMapSession.commitTransaction();
      = ; =20 sqlMapSession.close();

}catch{.....}

but after = excuting the=20 program i see insert statement in logs but the inserted records are not = visible=20 in database.

Following is = the=20 Code.xml

<sqlMap=20 namespace=3D"Code">
<resultMap id=3D"result"=20 class=3D"transferobjects.com.Code">
     &= nbsp; =20 <result property=3D"codeId"=20 column=3D"CODE_ID"/>
        = <result=20 property=3D"codeDetails"=20 column=3D"CODE_DETAILS"/>
       = ;=20 <result property=3D"codeDomain"=20 column=3D"CODE_DOMAIN"/>
       = =20 <result property=3D"empId" = column=3D"EMP_ID"/>
   =20 </resultMap>

   =20 <insert = id=3D"insertCode">
       =20 insert into CI_CODE (CODE_ID,CODE_DETAILS,CODE_DOMAIN,EMP_ID) values=20
        (#codeId#,=20 #codeDetails#,#codeDomain#,#empId#)
   =20 </insert

</sqlMap>

And resective sql-map-config.xml as

<sqlMapConfig>

<sqlMap=20 resource=3D"com/codeinnovation/ibatis/Code.xml"/>
= ; =20

</sqlMapConfig>

Anything wrong with the code?

Venkatesan

------=_NextPart_000_006C_01C83D72.F8E7B540--