ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yee, Richard K, CTR,, DMDCWEST" <Richard.Yee....@osd.pentagon.mil>
Subject RE: SQL Error while executing ibatis with websphere 5.2 and db2 w ith jdbcconfig
Date Tue, 29 Mar 2005 18:01:43 GMT
To fix this problem:
 log4j:WARN No appenders could be found for logger
(com.ibatis.common.jdbc.SimpleDataSource). 
log4j:WARN Please initialize the log4j system properly. 
you need to call     org.apache.log4j.PropertyConfigurator.configure(...);
with the path to the log4j property file.
 
Once you do that, you might get better logging information.
 
-Richard
 -----Original Message-----
From: Suvasis.Mukherjee@kp.org [mailto:Suvasis.Mukherjee@kp.org] 
Sent: Monday, March 28, 2005 5:39 PM
To: ibatis-user-java@incubator.apache.org
Subject: SQL Error while executing ibatis with websphere 5.2 and db2 with
jdbcconfig




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.executeQueryWith
Callback(GeneralStatement.java:180) 
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForL
ist(GeneralStatement.java:118) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:626) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:598) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionIm
pl.java:107) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl
.java:76) 
        at
org.kp.ai.ear.browse.dal.dataobject.persistance.ibatis.IbatisService.getResu
ltList(IbatisService.java:156) 
        at
org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAI
EarDAOImpl.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(RemoteTestRu
nner.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(PreparedStat
ementLogProxy.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.executeQueryWith
Callback(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(PreparedStat
ementLogProxy.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.executeQueryWith
Callback(GeneralStatement.java:168) 
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForL
ist(GeneralStatement.java:118) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:626) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:598) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionIm
pl.java:107) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl
.java:76) 
        at
org.kp.ai.ear.browse.dal.dataobject.persistance.ibatis.IbatisService.getResu
ltList(IbatisService.java:156) 
        at
org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAI
EarDAOImpl.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(RemoteTestRu
nner.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(PreparedStat
ementLogProxy.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.executeQueryWith
Callback(GeneralStatement.java:168) 
        at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForL
ist(GeneralStatement.java:118) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:626) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:598) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionIm
pl.java:107) 
        at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl
.java:76) 
        at
org.kp.ai.ear.browse.dal.dataobject.persistance.ibatis.IbatisService.getResu
ltList(IbatisService.java:156) 
        at
org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAI
EarDAOImpl.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(RemoteTestRu
nner.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.getResu
ltList(IbatisService.java:161) 
        at
org.kp.ai.ear.browse.dal.dao.impl.IbatisAIEarDAOImpl.getAllHostsVOs(IbatisAI
EarDAOImpl.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(RemoteTestRu
nner.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(IbatisAI
EarDAOImpl.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(RemoteTestRu
nner.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




Mime
View raw message