2011-10-28 10:18:12,103 WARN  [com.thesearchagency.core.smb.service.contentrepository.ContentAdminService] (WorkerThread#0[127.0.0.1:34327]) Importing Merchant Attributes
2011-10-28 10:18:12,103 WARN  [com.thesearchagency.core.smb.dao.MerchantAttributeDAO] (WorkerThread#0[127.0.0.1:34327]) Getting Transaction Manager
2011-10-28 10:18:12,103 WARN  [com.thesearchagency.core.smb.dao.MerchantAttributeDAO] (WorkerThread#0[127.0.0.1:34327]) Got Transaction Manager
2011-10-28 10:18:12,103 WARN  [com.thesearchagency.core.smb.dao.MerchantAttributeDAO] (WorkerThread#0[127.0.0.1:34327]) Executing transaction
2011-10-28 10:18:12,104 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing SQL statement [DELETE FROM merchantAttributesTemp where id>0]
2011-10-28 10:18:12,106 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,106 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,107 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,107 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,107 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,108 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,108 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,108 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,109 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,109 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,109 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,110 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,110 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,110 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,111 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,111 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,111 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,112 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,112 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,112 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,113 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,113 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,113 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,114 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,114 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,114 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,115 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,115 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL update
2011-10-28 10:18:12,115 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) Executing prepared SQL statement [INSERT INTO merchantAttributesTemp       (id,type,parentID,attribute,status)     VALUES  (?,?,?,?,?)]
2011-10-28 10:18:12,116 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkerThread#0[127.0.0.1:34327]) SQL update affected 1 rows
2011-10-28 10:18:12,116 ERROR [com.thesearchagency.core.smb.dao.MerchantAttributeDAO] (WorkerThread#0[127.0.0.1:34327]) Exception during database transaction, rolling back.
java.lang.ArrayIndexOutOfBoundsException: 1
        at com.thesearchagency.core.smb.dao.MerchantAttributeDAO$1.doInTransaction(MerchantAttributeDAO.java:98)
        at com.thesearchagency.core.smb.dao.MerchantAttributeDAO$1.doInTransaction(MerchantAttributeDAO.java:85)
        at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
        at com.thesearchagency.core.smb.dao.MerchantAttributeDAO.updateMerchantAttributes(MerchantAttributeDAO.java:83)
        at com.thesearchagency.core.smb.service.contentrepository.ContentAdminService.importMerchantAttributeFile(ContentAdminService.java:561)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
        at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
        at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
        at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
        at sun.reflect.GeneratedMethodAccessor394.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
        at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1535826336.invoke(InvocationContextInterceptor_z_fillMethod_1535826336.java)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
        at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1535826336.invoke(InvocationContextInterceptor_z_setup_1535826336.java)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
        at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
        at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
        at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:421)
        at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:53)
        at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91)
        at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
        at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891)
        at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:744)
        at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:697)
        at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:524)
        at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:232)
^C