ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ehsan" <eabuleb...@asaltech.com>
Subject Problem connecting with iBatis
Date Sun, 27 Jul 2008 06:45:25 GMT
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

 


Mime
View raw message