Hi,

         While I am calling the SqlMapClientBuilder.buildSqlMapClient(reader); 
I am getting multiple response. My Ibatis build is 2.1.5 I am using weblogic 
Server 8.1.

In the below method SqlMapClientBuilder.buildSqlMapClient(reader); give 2 
responses because of which my query is running two times and inserting same 
record 2 times. I feel the second trigger happns avfer I call my insert 
statement.

I am new to Ibatis. Kindly advise me if there is some error in my 
implementation.

Code:
I have a base implementation with a method to start transaction.

        /**
         * Start a transaction
         *
         * @throws Exception if business logic throws Exception
         */
        public void startTransaction() throws Exception {
            // open up the SQL Map for transaction
            isTxn = true;
            try {
                System.out.println("test1");
                String resource = ConfigMgr.config.get(SQLMAP);
                Reader reader = Resources.getResourceAsReader(resource);
                System.out.println("test3");
                txnSqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
                System.out.println("test4");
                reader.close();
                txnSqlMap.startTransaction();
                isTxn = true;
            } catch (Exception ex) {
                System.out.println("ex :: "+ex);
                logger.log(ERROR, ex);
            }
        }

And this is extended in my Data access Layer and called like:

startTransaction();
                intCountInserted=insert("mySqlId", myDTO);
                //

Regards,
Prasad



________________________________
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the 
intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE 
COMPANY INFORMATION. Any review or reliance by others or copying or 
distribution or forwarding of any or all of the contents in this message is 
STRICTLY PROHIBITED. If you are not the intended recipient, please contact the 
sender by email and delete all copies; your cooperation in this regard is 
appreciated.

Reply via email to