SQL Error while executing ibatis with websphere 5.2 and db2 with jdbcconfig

[Suvasis . Mukherjee]

hi,

I am encountering the follwing error:  Any clue!

log4j:WARN No appenders could be found for logger (com.ibatis.common.jdbc.SimpleDataSource).
log4j:WARN Please initialize the log4j system properly.
com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in org/kp/ai/ear/browse/dal/dataobject/persistance/ibatis/AiEarMetaData.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getAllHostsVOs-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: REDALERT.T_HOSTS
Caused by: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: REDALERT.T_HOSTS
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:180)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:118)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:626)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:598)
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:107)
        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:76)
        at org.kp.ai.ear.browse.dal.dataobject.persistance.ibatis.IbatisService.getResultList(IbatisService.java:156)
        at org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAIEarDAOImpl.java:306)
        at org.kp.ai.ear.browse.dal.unittest.TestDal.testGetAllHostsVOs(TestDal.java:63)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
Caused by: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: REDALERT.T_HOSTS
        at com.ibm.db2.jcc.a.co.e(co.java:1361)
        at com.ibm.db2.jcc.a.co.a(co.java:984)
        at com.ibm.db2.jcc.b.bd.g(bd.java:121)
        at com.ibm.db2.jcc.b.bd.a(bd.java:42)
        at com.ibm.db2.jcc.b.r.a(r.java:31)
        at com.ibm.db2.jcc.b.bp.g(bp.java:103)
        at com.ibm.db2.jcc.a.co.g(co.java:968)
        at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
        at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
        at com.ibm.db2.jcc.a.cp.K(cp.java:316)
        at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:54)
        at $Proxy1.executeQuery(Unknown Source)
        at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:200)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:168)
        ... 23 more

Caused by:
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: REDALERT.T_HOSTS
        at com.ibm.db2.jcc.a.co.e(co.java:1361)
        at com.ibm.db2.jcc.a.co.a(co.java:984)
        at com.ibm.db2.jcc.b.bd.g(bd.java:121)
        at com.ibm.db2.jcc.b.bd.a(bd.java:42)
        at com.ibm.db2.jcc.b.r.a(r.java:31)
        at com.ibm.db2.jcc.b.bp.g(bp.java:103)
        at com.ibm.db2.jcc.a.co.g(co.java:968)
        at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
        at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
        at com.ibm.db2.jcc.a.cp.K(cp.java:316)
        at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:54)
        at $Proxy1.executeQuery(Unknown Source)
        at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:200)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:168)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:118)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:626)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:598)
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:107)
        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:76)
        at org.kp.ai.ear.browse.dal.dataobject.persistance.ibatis.IbatisService.getResultList(IbatisService.java:156)
        at org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAIEarDAOImpl.java:306)
        at org.kp.ai.ear.browse.dal.unittest.TestDal.testGetAllHostsVOs(TestDal.java:63)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)

Caused by:
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: REDALERT.T_HOSTS
        at com.ibm.db2.jcc.a.co.e(co.java:1361)
        at com.ibm.db2.jcc.a.co.a(co.java:984)
        at com.ibm.db2.jcc.b.bd.g(bd.java:121)
        at com.ibm.db2.jcc.b.bd.a(bd.java:42)
        at com.ibm.db2.jcc.b.r.a(r.java:31)
        at com.ibm.db2.jcc.b.bp.g(bp.java:103)
        at com.ibm.db2.jcc.a.co.g(co.java:968)
        at com.ibm.db2.jcc.a.cp.T(cp.java:1378)
        at com.ibm.db2.jcc.a.cp.d(cp.java:1781)
        at com.ibm.db2.jcc.a.cp.K(cp.java:316)
        at com.ibm.db2.jcc.a.cp.executeQuery(cp.java:299)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:54)
        at $Proxy1.executeQuery(Unknown Source)
        at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:200)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:168)
        at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:118)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:626)
        at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:598)
        at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:107)
        at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:76)
        at org.kp.ai.ear.browse.dal.dataobject.persistance.ibatis.IbatisService.getResultList(IbatisService.java:156)
        at org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAIEarDAOImpl.java:306)
        at org.kp.ai.ear.browse.dal.unittest.TestDal.testGetAllHostsVOs(TestDal.java:63)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
org.kp.ai.ear.browse.dal.exception.DalException: IbatisService.getResultList : Exception while calling the getResultList method. :
 
--- The error occurred in org/kp/ai/ear/browse/dal/dataobject/persistance/ibatis/AiEarMetaData.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getAllHostsVOs-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: REDALERT.T_HOSTS
        at org.kp.ai.ear.browse.dal.dataobject.persistance.ibatis.IbatisService.getResultList(IbatisService.java:161)
        at org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAIEarDAOImpl.java:306)
        at org.kp.ai.ear.browse.dal.unittest.TestDal.testGetAllHostsVOs(TestDal.java:63)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
org.kp.ai.ear.browse.dal.exception.DalException: IbatisAIEarDAOImpl.getAllHostsVOs: Exception while query processing :
IbatisService.getResultList : Exception while calling the getResultList method. :
 
--- The error occurred in org/kp/ai/ear/browse/dal/dataobject/persistance/ibatis/AiEarMetaData.xml.  
--- The error occurred while applying a parameter map.  
--- Check the getAllHostsVOs-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: REDALERT.T_HOSTS
        at org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAIEarDAOImpl.java:324)
        at org.kp.ai.ear.browse.dal.unittest.TestDal.testGetAllHostsVOs(TestDal.java:63)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:41)
        at java.lang.reflect.Method.invoke(Method.java:386)
        at junit.framework.TestCase.runTest(TestCase.java:154)
        at junit.framework.TestCase.runBare(TestCase.java:127)
        at junit.framework.TestResult$1.protect(TestResult.java:106)
        at junit.framework.TestResult.runProtected(TestResult.java:124)
        at junit.framework.TestResult.run(TestResult.java:109)
        at junit.framework.TestCase.run(TestCase.java:118)
        at junit.framework.TestSuite.runTest(TestSuite.java:208)
        at junit.framework.TestSuite.run(TestSuite.java:203)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:392)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:276)
        at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:167)
Suvasis Mukherjee
KP-IT