You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by ehsan <ea...@asaltech.com> on 2008/07/27 08:45:25 UTC
Problem connecting with iBatis
Hi all;
I have a test application which I have been running using
PrimeBase Database and iBatis as a data access layer. All works fine with no
errors.
However, when I try to run it on another PC I get an error (stack trace
below). Does anyone have any ideas?
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation;
uncategorized SQLException for SQL []; SQL state []; error code [-100
20];
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive; nested
exception is com.iba
tis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive
Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:185)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForO
bject(GeneralStatement.java:104)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapEx
ecutorDelegate.java:566)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapEx
ecutorDelegate.java:541)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSession
Impl.java:106)
at
org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMa
pClientTemplate.java:243)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemp
late.java:193)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapCli
entTemplate.java:241)
at
com.asaltech.tool.dal.SqlMapAccountDao.getUser(SqlMapAccountDao.java:51)
at
com.asaltech.tool.bl.SynchronizationManager$1.doInTransactionWithoutResult(S
ynchronizationManager.java:76)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doI
nTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(Transact
ionTemplate.java:127)
at
com.asaltech.tool.bl.SynchronizationManager.synchGoDB(SynchronizationManager
.java:64)
at
com.asaltech.tool.controller.viewLDAPSettingsController.onSubmit(viewLDAPSet
tingsController.java:72)
at
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmissi
on(SimpleFormController.java:267)
at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInte
rnal(AbstractFormController.java:250)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(Abstrac
tController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(Si
mpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServl
et.java:857)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServle
t.java:792)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSer
vlet.java:475)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.jav
a:440)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler
.java:1093)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:292)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:106)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:79)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:143)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:246)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:156)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120
)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler
.java:1084)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:292)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:116)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:79)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:143)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:246)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:220)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120
)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler
.java:1084)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:
844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:4
42)
Caused by: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive
at
com.primebase.jdbc.jDALSession.getDALException(jDALSession.java:238)
at com.primebase.jdbc.jDALSession.getItem(jDALSession.java:1094)
at
com.primebase.jdbc.jDALFieldItem.initFromSession(jDALFieldItem.java:377)
at
com.primebase.jdbc.jDALFieldItem.newjDALFieldItem(jDALFieldItem.java:547)
at com.primebase.jdbc.jDALCmd.getNextPage(jDALCmd.java:179)
at com.primebase.jdbc.jDALCmd.processItems(jDALCmd.java:200)
at com.primebase.jdbc.jDALCmd.executeQueryCmd(jDALCmd.java:237)
at com.primebase.jdbc.jDALResultSet.<init>(jDALResultSet.java:432)
at com.primebase.jdbc.jDALStatement.execute(jDALStatement.java:109)
at
com.primebase.jdbc.jDALPreparedStatement.execute(jDALPreparedStatement.java:
168)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPrepar
edStatement.java:169)
at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java
:186)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
GeneralStatement.java:205)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:173)
... 65 more
2008-07-17 17:24:58,296 ERROR [com.asaltech.tool.bl.SynchronizationManager]
- <synchGoDB>
org.springframework.dao.InvalidDataAccessResourceUsageException:
synchPersons; nested exception is
org.springframework.jdbc.UncategorizedSQLExcep
tion: SqlMapClient operation; uncategorized SQLException for SQL []; SQL
state []; error code [-10020];
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive; nested
exception is com.iba
tis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive
Caused by:
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation;
uncategorized SQLException for SQL []; SQL state []; error code [-100
20];
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive; nested
exception is com.iba
tis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive
Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/asaltech/tool/dal/GoDB.xml.
--- The error occurred while applying a parameter map.
--- Check the getUser-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:185)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForO
bject(GeneralStatement.java:104)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapEx
ecutorDelegate.java:566)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapEx
ecutorDelegate.java:541)
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSession
Impl.java:106)
at
org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMa
pClientTemplate.java:243)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemp
late.java:193)
at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapCli
entTemplate.java:241)
at
com.asaltech.tool.dal.SqlMapAccountDao.getUser(SqlMapAccountDao.java:51)
at
com.asaltech.tool.bl.SynchronizationManager$1.doInTransactionWithoutResult(S
ynchronizationManager.java:76)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doI
nTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(Transact
ionTemplate.java:127)
at
com.asaltech.tool.bl.SynchronizationManager.synchGoDB(SynchronizationManager
.java:64)
at
com.asaltech.tool.controller.viewLDAPSettingsController.onSubmit(viewLDAPSet
tingsController.java:72)
at
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmissi
on(SimpleFormController.java:267)
at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInte
rnal(AbstractFormController.java:250)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(Abstrac
tController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(Si
mpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServl
et.java:857)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServle
t.java:792)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSer
vlet.java:475)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.jav
a:440)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler
.java:1093)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:292)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:106)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:79)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:143)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:246)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:156)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120
)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler
.java:1084)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:292)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:116)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:79)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:143)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:246)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:220)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:303)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:173)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:120
)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler
.java:1084)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712)
at
org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:
844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:4
42)
Caused by: com.primebase.jdbc.jDALException: "printctl
1,2,3,4,5,6,7,8,9,1..."@client line 59: Cursor '' is inactive
at
com.primebase.jdbc.jDALSession.getDALException(jDALSession.java:238)
at com.primebase.jdbc.jDALSession.getItem(jDALSession.java:1094)
at
com.primebase.jdbc.jDALFieldItem.initFromSession(jDALFieldItem.java:377)
at
com.primebase.jdbc.jDALFieldItem.newjDALFieldItem(jDALFieldItem.java:547)
at com.primebase.jdbc.jDALCmd.getNextPage(jDALCmd.java:179)
at com.primebase.jdbc.jDALCmd.processItems(jDALCmd.java:200)
at com.primebase.jdbc.jDALCmd.executeQueryCmd(jDALCmd.java:237)
at com.primebase.jdbc.jDALResultSet.<init>(jDALResultSet.java:432)
at com.primebase.jdbc.jDALStatement.execute(jDALStatement.java:109)
at
com.primebase.jdbc.jDALPreparedStatement.execute(jDALPreparedStatement.java:
168)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPrepar
edStatement.java:169)
at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java
:186)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
GeneralStatement.java:205)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:173)
... 65 more