gmane.comp.java.ibatisdb.user

Re: Transaction Rollback not working with iBatis + Spring

Bruno Issenmann — 2010-07-22T15:18:31


My SqlMapConfig.xml wasn't ok, i was using an EXTERNAL transaction manager
instead of a JDBC... (sorry for that)
Next time i'll post on the new list.

Larry and Vinaya Thanks for your help !

Bruno

Re: Transaction Rollback not working with iBatis + Spring

Larry Meadors — 2010-07-22T14:47:01

Wait - I'm REALLY confused. Can you post a stack trace?

Doh, I just noticed - this conversation should be on the new list.
Maybe it's time to start this as a new thread and give us the stack
trace and the relevant code anew. :)

The ibatis project has moved and been renamed.

It is no longer being maintained as an Apache project, but has moved
(along with the development team) here:

http://www.mybatis.org/

Please join us at the new location by joining the mailing list here:

http://groups.google.com/group/mybatis-user

Larry

Re: Transaction Rollback not working with iBatis + Spring

Bruno Issenmann — 2010-07-22T09:11:42

Both tables are linked by constraints on primary keys, so i can't make only one
insert.

I must have missed something with the ibatis config or the doa manager.

Thanks for your time.

Bruno

RE: Transaction Rollback not working with iBatis + Spring

Vinaya Tirikkovalluru — 2010-07-21T18:07:51

Does just the insert work on the table which is giving the issue without
the insert into the history?

-----Original Message-----
From: Bruno Issenmann [mailto:b.issenmann< at >labsoft.fr] 
Sent: Wednesday, July 21, 2010 2:03 PM
To: user-java< at >ibatis.apache.org
Subject: Re: Transaction Rollback not working with iBatis + Spring

Vinaya Tirikkovalluru <vinaya.tirikkovalluru <at> converge.com> writes:

runtime

I have a runtime exception, transaction is rolled back. When i run the
SQL
manually on oracle it's ok.
But with the dao i got a constraint integrity violation. It's like the
inserts
go in the wrong order (complains about the first table id missing).
Or i'm wrong with the dao.

Here is my code

public class LotTest extends DAOManagerTest {

    < at >Test
    public void testInsert(){

    DAOFactory.daoMgr.startTransaction();
    try {
        LotDAO dao =
(LotDAO)DAOFactory.daoMgr.getDao(LotDAO.class);
        Lot lot = new Lot();
        lot.setIdlot("201000000008");
        //lot.setNumhistolot(new

Re: Transaction Rollback not working with iBatis + Spring

Bruno Issenmann — 2010-07-21T18:02:35


I have a runtime exception, transaction is rolled back. When i run the SQL
manually on oracle it's ok.
But with the dao i got a constraint integrity violation. It's like the inserts
go in the wrong order (complains about the first table id missing).
Or i'm wrong with the dao.

Here is my code

public class LotTest extends DAOManagerTest {

    < at >Test
    public void testInsert(){
    
    DAOFactory.daoMgr.startTransaction();
    try {
        LotDAO dao = (LotDAO)DAOFactory.daoMgr.getDao(LotDAO.class);
        Lot lot = new Lot();
        lot.setIdlot("201000000008");
        //lot.setNumhistolot(new Short("1"));
        lot.setIdlotamm("20char");
        dao.insert(lot);
        
        HistoLotDAO dao2 =
(HistoLotDAO)DAOFactory.daoMgr.getDao(HistoLotDAO.class);
        HistoLot histo = new HistoLot();
        histo.setIdlot("201000000008");
        histo.setNumhistolot(new Short("1"));
        histo.setIdetatlot("EC");
        histo.setDateetatlot(new Date());
        histo.setInfoetatl

RE: Transaction Rollback not working with iBatis + Spring

Vinaya Tirikkovalluru — 2010-07-21T17:24:29

Sorry!! I missed the thread.
Does it give you a runtime exception? Only if the code throws a runtime
exception the transaction will be rolled back

Vinaya


-----Original Message-----
From: Bruno Issenmann [mailto:b.issenmann< at >labsoft.fr] 
Sent: Wednesday, July 21, 2010 1:07 PM
To: user-java< at >ibatis.apache.org
Subject: Re: Transaction Rollback not working with iBatis + Spring

Thanks for ansering.

I do not use the batch.
I'm just doing two inserts then i commit. I still have an integrity
contraint
violation.



---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe< at >ibatis.apache.org
For additional commands, e-mail: user-java-help< at >ibatis.apache.org



This electronic message is intended only for the use of the individual(s) or entity(ies) named above and may contain information which is privileged and/or confidential.  If you are not the intended recipient, be aware that any disclosure, copying, distribution, dissemination or use of the contents of t

Re: Transaction Rollback not working with iBatis + Spring

Bruno Issenmann — 2010-07-21T17:07:28

Thanks for ansering.

I do not use the batch.
I'm just doing two inserts then i commit. I still have an integrity contraint
violation.

Re: Transaction Rollback not working with iBatis + Spring

Larry Meadors — 2010-07-21T16:43:56

You don't need the batch, and I'm pretty sure it won't ever work with
the batch because the inserts don't happen when you call them (they
happen when you call executeBatch()) so your ids don't get set when
you expect them to.

Remove the lines related to the batch, and I think it'll work.

Larry


On Wed, Jul 21, 2010 at 10:19 AM, Bruno Issenmann
<b.issenmann< at >labsoft.fr> wrote:

Re: Transaction Rollback not working with iBatis + Spring

Bruno Issenmann — 2010-07-21T16:19:51

Hi,

I'm facing the same problem. Did you solved it ?
Thanks

RE: Dynamic table names in DELETE

Poitras Christian — 2010-07-19T12:33:58

Ibatis project moved to Google. If I am not mistaking, the developers of iBATIS are not registered to this list anymore.
Please, post your questions to the new list at mybatis-user< at >googlegroups.com

Christian 

-----Original Message-----
From: droidin.net [mailto:droid< at >droidin.net] 
Sent: Sunday, July 18, 2010 11:07 PM
To: user-java< at >ibatis.apache.org
Subject: Dynamic table names in DELETE

iBatis 3 has wonderful ability in SELECT statements to provide dynamic substitution before statement is prepared. For example this will work

<select id="foo">SELECT * FROM $db$.MY_TABLE</select>

However I can't make it work when trying to empty table

XML code:

<delete id="del" parameterType="String">DELETE FROM $db$.MY_TABLE</delete>
<!-- and I also tried -->
<delete id="del" parameterType="String">DELETE FROM $0$.MY_TABLE</delete>

Java code:

// method defined as
del(String db);
// and executed as
mapper.del("MY_DB");

I get message complaining that Database '$db$' does not exist

Anyone can suggest the solution? I'

Dynamic table names in DELETE

droidin.net — 2010-07-19T03:06:45

iBatis 3 has wonderful ability in SELECT statements to provide dynamic
substitution before statement is prepared. For example this will work

<select id="foo">SELECT * FROM $db$.MY_TABLE</select>

However I can't make it work when trying to empty table

XML code:

<delete id="del" parameterType="String">DELETE FROM $db$.MY_TABLE</delete>
<!-- and I also tried -->
<delete id="del" parameterType="String">DELETE FROM $0$.MY_TABLE</delete>

Java code:

// method defined as
del(String db);
// and executed as
mapper.del("MY_DB");

I get message complaining that Database '$db$' does not exist

Anyone can suggest the solution? I'm on Teradata db and it is setup in the
way that I need provide db names in query or else I get Object not found

RE: Ibator 1.2.2

Poitras Christian — 2010-07-12T12:23:59

Ibatis project moved to Google. If I am not mistaking, the developers of iBATIS are not registered to this list anymore.
Please, post your questions to the new list at mybatis-user< at >googlegroups.com

Christian

-----Original Message-----
From: Panciz [mailto:dav.poletti< at >gmail.com] 
Sent: Saturday, July 10, 2010 2:25 AM
To: user-java< at >ibatis.apache.org
Subject: Ibator 1.2.2

Hi,

I built ibator 1.2.2 from sources downloaded from http://svn.apache.org/repos/asf/ibatis/java/ibator/trunk/core/
and create the JAR file.
The problem is that when I run the tool on a configuration file, which worked with the previous version, I get  

$ java -jar ibator-1.2.2.jar -configfile ../conf/ibatorConfig.xml java.net.MalformedURLException at java.net.URL.<init>(URL.java:601) at java.net.URL.<init>(URL.java:464) at java.net.URL.<init>(URL.java:413) at com.sun.org.apache.xerces.internal.impl.XMLEntityManager
  .setupCurrentEntity(XMLEntityManager.java:650)
at com.sun.org.apache.xerces.internal.impl
  .XMLEntityManager.startEntity

Ibator 1.2.2

Panciz — 2010-07-10T06:24:59

Hi,

I built ibator 1.2.2 from sources downloaded from 
http://svn.apache.org/repos/asf/ibatis/java/ibator/trunk/core/
and create the JAR file.
The problem is that when I run the tool on a configuration file,
which worked with the previous version, I get  

$ java -jar ibator-1.2.2.jar -configfile ../conf/ibatorConfig.xml 
java.net.MalformedURLException
at java.net.URL.<init>(URL.java:601)
at java.net.URL.<init>(URL.java:464)
at java.net.URL.<init>(URL.java:413)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager
  .setupCurrentEntity(XMLEntityManager.java:650)
at com.sun.org.apache.xerces.internal.impl
  .XMLEntityManager.startEntity(XMLEntityManager.java:1315)
at com.sun.org.apache.xerces.internal.impl
.XMLEntityManager.startDTDEntity(XMLEntityManager.java:1282)
at com.sun.org.apache.xerces.internal.impl
  .XMLDTDScannerImpl.setInputSource(XMLDTDScannerImpl.java:283)
at com.sun.org.apache.xerces.internal.impl
  .XMLDocumentScannerImpl$DTDDriver.dispatch(XMLDocumentScannerImpl.java:1193)
at com.sun.

RE: Ibatis 3 and null values

Poitras Christian — 2010-07-05T12:23:45

Ibatis project moved to Google. If I am not mistaking, the developers of iBATIS are not registered to this list anymore.
Please, post your questions to the new list at mybatis-user< at >googlegroups.com

Christian

-----Original Message-----
From: Laurent MANNS [mailto:laurent.manns< at >gmail.com] 
Sent: Monday, July 05, 2010 4:58 AM
To: user-java< at >ibatis.apache.org
Subject: Ibatis 3 and null values

Hello,

I'm facing a weird problem when resultType is a Map : 


<select id="test" resultType="java.util.LinkedHashMap">
  select 
    getDate() "Timestamp", 
    null      "Test"
</select>


List<LinkedHashMap<Object, Object>> lignes = session.selectList("test");
                
for (Iterator it = ((LinkedHashMap<Object, Object>)    
lignes.get(0)).keySet().iterator(); it.hasNext();) 
                  System.out.println(it.next());
                
                  
The result is : 

   TIMESTAMP
   Timestamp
   1

Why is first column duplicated when the alias is in lowercase ? And why can't i get the second column

Ibatis 3 and null values

Laurent MANNS — 2010-07-05T08:58:24

Hello,

I'm facing a weird problem when resultType is a Map : 


<select id="test" resultType="java.util.LinkedHashMap">
  select 
    getDate() "Timestamp", 
    null      "Test"
</select>


List<LinkedHashMap<Object, Object>> lignes = session.selectList("test");
                
for (Iterator it = ((LinkedHashMap<Object, Object>)    
lignes.get(0)).keySet().iterator(); it.hasNext();) 
                  System.out.println(it.next());
                
                  
The result is : 

   TIMESTAMP
   Timestamp
   1

Why is first column duplicated when the alias is in lowercase ? And why can't i
get the second column header when it contains null values ? 

Any help would be appreciated. 

Thx.

Re: ibatis 3 and calling stored procedure

Larry Meadors — 2010-06-28T17:19:45

The ibatis project has moved and been renamed.

It is no longer being maintained as an Apache project, but has moved
(along with the development team) here:

http://www.mybatis.org/

Please join us at the new location by joining the mailing list here:

http://groups.google.com/group/mybatis-user

Larry

ibatis 3 and calling stored procedure

Ashish Kulkarni — 2010-06-28T16:03:21

Hi
Is there any place where it has updated information about calling stored
procedure from ibatis 3.0, i checked google and could not find any,
I was reading user guide and it says parameterMap is not used,

I tried the code below and seems it is working, but i would like to do this
using some methods from ibatis 3.0

<parameterMap id="swapParameters" type="java.util.HashMap" >
    <parameter property="id" jdbcType="VARCHAR" javaType="java.lang.String"
mode="INOUT"/>
    <parameter property="message" jdbcType="VARCHAR"
javaType="java.lang.String" mode="INOUT"/>
 </parameterMap>

<select id="getValidPayment" statementType="CALLABLE"
resultType="java.lang.String" parameterMap="swapParameters">
call SCHEMA.PROCEDURE (?,?)
</select>

Re: Inheritanc

Nathan Maves — 2010-06-24T19:06:46

The ibatis project has moved and been renamed.

It is no longer being maintained as an Apache project, but has moved
(along with the development team) here:

http://www.mybatis.org/

Please join us at the new location by joining the mailing list here:

http://groups.google.com/group/mybatis-user

On Thu, Jun 24, 2010 at 1:05 PM, karthik085 <karthik085< at >gmail.com> wrote:

Inheritanc

karthik085 — 2010-06-24T19:05:17

Hi,
I am using iBatis 3.0 beta-9
How can inheritance or has-a relationship be specified for the following
case?

class A
   name: String

class B extends A
   id: Integer

 
Currently, I was trying to use "has-a" relationship - association to do it -
but, it is not working!
    <resultMap id="A" type="org.XXX.A">       
        <result property="name" column="name" />
        <association property="B" column="a_b_id" javaType="org.XXX.B"/>
    </resultMap>

     <association property="B" column="a_b_id" javaType="org.XXX.B">
        <id property="id" column="id" />
    </association>

Re: Passing Oracle Table Types (Is it possible?)

Larry Meadors — 2010-06-20T04:06:08

The ibatis project has moved and been renamed.

It is no longer being maintained as an Apache project, but has moved
(along with the development team) here:

http://www.mybatis.org/

Please join us at the new location by joining the mailing list here:

http://groups.google.com/group/mybatis-user

Passing Oracle Table Types (Is it possible?)

deepak123 — 2010-06-18T10:11:58

Hi, 
I have folloiwng types defines in Oracle:

create or replace type position_obj as object
(
POSITION_ID  NUMBER,
PROD_TYPE  VARCHAR2(50),
);

create or replace type position_tab as table of position_obj;
create or replace type error_logs_obj is object
( 
MODULE_NAME   VARCHAR2(30),
DATABASE_UNIT VARCHAR2(30),
TABLE_NAME    VARCHAR2(30),
ERROR_MESS    VARCHAR2(4000),
CREATE_TIME   DATE,
USER_NAME     VARCHAR2(30)
);
create or replace type error_logs_tab is table of error_logs_obj;

And my Oracle SP is:
  PROCEDURE insert_position(p_position_tab  position_tab
                           ,o_error_msg_tab OUT error_logs_tab)

How do i call above SP using iBatis 2.3.4 ? Please let me know if its
possible or not. 

Thanks & Regards,
Deepak