It's a problem with your SQL Statement. I don't know what... but i found this on google... http://www.openitx.com/archives/archives.asp?l=DB2-L&i=516451
Brandon On Mon, 28 Mar 2005 17:39:02 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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 > >
