Transaction is not supported by connector

[aelmeswari]

I have an integration test in grails that does a insert and I receive the following error:

Hibernate operation: could not insert:  [mil.disa.apex.dal.jopes.OplanComment]; uncategorized SQLException for  SQL [insert into DAL.MY_VL.SCHEMA.TABLE1 (COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5) values (?, ?, ?, ?,  ?)]; SQL state [38000]; error code [0]; Error occurred on connector  jopes_ddb88 Connector<3> - Transaction is not supported by the  connector.; nested exception is com.metamatrix.jdbc.MMSQLException:  Error occurred on connector jopes_ddb88 Connector<3> - Transaction  is not supported by the connector.

org.springframework.jdbc.UncategorizedSQLException: Hibernate  operation: could not insert: [mil.disa.apex.dal.jopes.OplanComment];  uncategorized SQLException for SQL [insert into  DAL.MY_VL.SCHEMA.TABLE1 (COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5) values (?, ?, ?, ?, ?)]; SQL state  [38000]; error code [0]; Error occurred on connector jopes_ddb88  Connector<3> - Transaction is not supported by the connector.;  nested exception is com.metamatrix.jdbc.MMSQLException: Error occurred  on connector jopes_ddb88 Connector<3> - Transaction is not  supported by the connector.
at  mil.disa.apex.dal.jopes.OplanCommentItTests.testSave(OplanCommentItTests.groovy:58)
at junit.framework.Test$run.call(Unknown Source)
Caused by:  com.metamatrix.jdbc.MMSQLException: Error occurred on connector  jopes_ddb88 Connector<3> - Transaction is not supported by the  connector.
at  com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:123)
at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71)
at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:423)
at  com.metamatrix.jdbc.MMPreparedStatement.executeUpdate(MMPreparedStatement.java:218)
at  org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at $Proxy44.saveOrUpdate(Unknown Source)
at  mil.disa.apex.dal.jopes.OplanCommentItTests.testSave(OplanCommentItTests.groovy:58)
at junit.framework.Test$run.call(Unknown Source)
at  _GrailsTest_groovy$_run_closure4.doCall(_GrailsTest_groovy:270)
at  _GrailsTest_groovy$_run_closure4.call(_GrailsTest_groovy)
at  _GrailsTest_groovy$_run_closure2.doCall(_GrailsTest_groovy:229)
at  _GrailsTest_groovy$_run_closure2.call(_GrailsTest_groovy)
at  _GrailsTest_groovy$_run_closure1_closure21_closure25.doCall(_GrailsTest_groovy:197)
at  _GrailsTest_groovy$_run_closure1_closure21.doCall(_GrailsTest_groovy:196)
at _GrailsTest_groovy$_run_closure1.doCall(_GrailsTest_groovy:171)
at TestApp$_run_closure1.doCall(TestApp.groovy:102)
at  gant.Gant$_dispatch_closure4.doCall(Gant.groovy:324)
at  gant.Gant$_dispatch_closure6.doCall(Gant.groovy:334)
at  gant.Gant$_dispatch_closure6.doCall(Gant.groovy)
at  gant.Gant.withBuildListeners(Gant.groovy:344)
at  gant.Gant.this$2$withBuildListeners(Gant.groovy)
at  gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
at  gant.Gant.dispatch(Gant.groovy:334)
at  gant.Gant.this$2$dispatch(Gant.groovy)
at  gant.Gant.invokeMethod(Gant.groovy)
at  gant.Gant.processTargets(Gant.groovy:495)
at  gant.Gant.processTargets(Gant.groovy:480)
Caused by:  [MetaMatrixComponentException]Error occurred on connector jopes_ddb88  Connector<3> - Transaction is not supported by the connector.
1  [ConnectorException]Error occurred on connector jopes_ddb88  Connector<3> - Transaction is not supported by the connector.
2  [ConnectorException]Transaction is not supported by the connector.
at  org.teiid.dqp.internal.process.DataTierTupleSource.switchBatch(DataTierTupleSource.java:128)
at  org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:89)
at  com.metamatrix.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:132)
at  com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:261)
at  com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:110)
at  com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:160)
at  com.metamatrix.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:445)
at  com.metamatrix.query.processor.proc.AbstractAssignmentInstruction.process(AbstractAssignmentInstruction.java:78)
at  com.metamatrix.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:285)
at  com.metamatrix.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:224)
at  com.metamatrix.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:110)
at  com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:261)
at  com.metamatrix.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:165)
at  com.metamatrix.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:261)
at  com.metamatrix.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:110)
at  com.metamatrix.query.processor.QueryProcessor.process(QueryProcessor.java:160)
at  org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:261)
at  org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:207)
at  org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at  com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:211)
at  java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by:  org.teiid.connector.api.ConnectorException: Error occurred on connector  jopes_ddb88 Connector<3> - Transaction is not supported by the  connector.
at  org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.handleError(ConnectorWorkItem.java:238)
at  org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.process(ConnectorWorkItem.java:174)
at  org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
at  org.teiid.dqp.internal.datamgr.impl.SynchConnectorWorkItem.run(SynchConnectorWorkItem.java:69)
Caused  by: org.teiid.connector.api.ConnectorException: Transaction is not  supported by the connector.
at  org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.createConnection(ConnectorWorkItem.java:137)
at  org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.createExecution(ConnectorWorkItem.java:291)
at  org.teiid.dqp.internal.datamgr.impl.SynchConnectorWorkItem.createExecution(SynchConnectorWorkItem.java:100)
at  org.teiid.dqp.internal.datamgr.impl.ConnectorWorkItem.process(ConnectorWorkItem.java:152)

[rareddy]

When you execute query in a transactional context and does not provide a corresponding XA Connector Binding the above exception is thrown by Teiid indicating that connector is not capable of supporting the transaction.

1) You can create a XA Connector binding for your source (you need XA datasource for your source). Designer can help you build the XA connector binding for your VDB.

2) You can set a property "immutable=true" on your connector binding. This is to be used *only* with read only sources. Looks like you are doing an insert. I would not advise this.

I think through Hibernate it always does JTA style txn, in which case Teiid requires XA connectors even you are using single source.

Teiid would also require all participating connectors to be XA connectors, if you are updating multiple sources in a single transaction. If you are not using Hibernate on top, and this is the only source that is doing an "insert" in Teiid, then it would have used local transaction fine with current driver defined for your source.

Hope this helps.

Ramesh..

[aelmeswari]

Hi Ramesh,

Option 1 seemed to work.  Thank you.

[aelmeswari]

Rameesh,

Although using the XA connector resolved that issue, I now run my functional tests and one of the tests fails with the following exception:

2010-03-11 17:37:59,703 [http-8080-6] ERROR errors.GrailsExceptionResolver  - Hibernate operation: could not update: [mil.dis
a.apex.dal.jopes.Pid#3209549]; uncategorized SQLException for SQL [update DAL.JOPES_VL.JOPES.OPLAN set OPLAN_EXERCISE_CD=?, O
PLAN_READ_ROLE_ID=?, OPLAN_C_DT=?, OPLAN_EXECUTION_ICD=?, OPLAN_UPD_ROLE_ID=?, OPLAN_ID=?, OPLAN_ACCESS_CD=?, OPLAN_UPD_DT=?,
SCTY_CLSN_CD=?, OPLAN_UPD_USER_ID=?, OPLAN_TITLE_TX=?, OPLAN_TUCHA_DT=?, OPLAN_CREATE_ROLE_ID=?, OPLAN_CREATE_DT=?, OPLAN_PO
C_NM=?, OPLAN_CREATE_USER_ID=? where OPLAN_SEQ_ID=?]; SQL state [38000]; error code [0]; Detected request "1.14" with multipl
e updates when using txnAutoWrap=OPTIMISTIC.  If you are using MetaMatrix Enterprise, you can set txnAutoWrap=OFF to avoid us
ing a transaction or txnAutoWrap=PESSIMISTIC to automatically create a transaction when needed. If you are not using MetaMatr
ix Enterprise, no transaction manager is provided and transactions are not supported.  In that case, you can set txnAutoWrap=
OFF to allow transaction methods to be called and ignored without actual transaction support. WARNING: Setting txnAutowrap=OF
F and using transaction methods is risky because transactions will not be executed atomically and rollback will not occur!; n
ested exception is com.metamatrix.jdbc.MMSQLException: Detected request "1.14" with multiple updates when using txnAutoWrap=O
PTIMISTIC.  If you are using MetaMatrix Enterprise, you can set txnAutoWrap=OFF to avoid using a transaction or txnAutoWrap=P
ESSIMISTIC to automatically create a transaction when needed. If you are not using MetaMatrix Enterprise, no transaction mana
ger is provided and transactions are not supported.  In that case, you can set txnAutoWrap=OFF to allow transaction methods t
o be called and ignored without actual transaction support. WARNING: Setting txnAutowrap=OFF and using transaction methods is
risky because transactions will not be executed atomically and rollback will not occur!
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [mil.disa.apex.dal.jopes.Pid#32095
49]; uncategorized SQLException for SQL [update DAL.JOPES_VL.JOPES.OPLAN set OPLAN_EXERCISE_CD=?, OPLAN_READ_ROLE_ID=?, OPLAN
_C_DT=?, OPLAN_EXECUTION_ICD=?, OPLAN_UPD_ROLE_ID=?, OPLAN_ID=?, OPLAN_ACCESS_CD=?, OPLAN_UPD_DT=?, SCTY_CLSN_CD=?, OPLAN_UPD
_USER_ID=?, OPLAN_TITLE_TX=?, OPLAN_TUCHA_DT=?, OPLAN_CREATE_ROLE_ID=?, OPLAN_CREATE_DT=?, OPLAN_POC_NM=?, OPLAN_CREATE_USER_
ID=? where OPLAN_SEQ_ID=?]; SQL state [38000]; error code [0]; Detected request "1.14" with multiple updates when using txnAu
toWrap=OPTIMISTIC.  If you are using MetaMatrix Enterprise, you can set txnAutoWrap=OFF to avoid using a transaction or txnAu
toWrap=PESSIMISTIC to automatically create a transaction when needed. If you are not using MetaMatrix Enterprise, no transact
ion manager is provided and transactions are not supported.  In that case, you can set txnAutoWrap=OFF to allow transaction m
ethods to be called and ignored without actual transaction support. WARNING: Setting txnAutowrap=OFF and using transaction me
thods is risky because transactions will not be executed atomically and rollback will not occur!; nested exception is com.met
amatrix.jdbc.MMSQLException: Detected request "1.14" with multiple updates when using txnAutoWrap=OPTIMISTIC.  If you are usi
ng MetaMatrix Enterprise, you can set txnAutoWrap=OFF to avoid using a transaction or txnAutoWrap=PESSIMISTIC to automaticall
y create a transaction when needed. If you are not using MetaMatrix Enterprise, no transaction manager is provided and transa
ctions are not supported.  In that case, you can set txnAutoWrap=OFF to allow transaction methods to be called and ignored wi
thout actual transaction support. WARNING: Setting txnAutowrap=OFF and using transaction methods is risky because transaction
s will not be executed atomically and rollback will not occur!
        at org.grails.jaxrs.web.JaxrsFilter.doFilterInternal(JaxrsFilter.java:46)
        at java.lang.Thread.run(Thread.java:619)
Caused by: com.metamatrix.jdbc.MMSQLException: Detected request "1.14" with multiple updates when using txnAutoWrap=OPTIMISTI
C.  If you are using MetaMatrix Enterprise, you can set txnAutoWrap=OFF to avoid using a transaction or txnAutoWrap=PESSIMIST
IC to automatically create a transaction when needed. If you are not using MetaMatrix Enterprise, no transaction manager is p
rovided and transactions are not supported.  In that case, you can set txnAutoWrap=OFF to allow transaction methods to be cal
led and ignored without actual transaction support. WARNING: Setting txnAutowrap=OFF and using transaction methods is risky b
ecause transactions will not be executed atomically and rollback will not occur!
        at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:123)
        at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71)
        at com.metamatrix.jdbc.MMStatement.executeSql(MMStatement.java:423)
        at com.metamatrix.jdbc.MMPreparedStatement.executeUpdate(MMPreparedStatement.java:218)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        ... 2 more
Caused by: [MetaMatrixComponentException]Detected request "1.14" with multiple updates when using txnAutoWrap=OPTIMISTIC.  If
you are using MetaMatrix Enterprise, you can set txnAutoWrap=OFF to avoid using a transaction or txnAutoWrap=PESSIMISTIC to
automatically create a transaction when needed. If you are not using MetaMatrix Enterprise, no transaction manager is provide
d and transactions are not supported.  In that case, you can set txnAutoWrap=OFF to allow transaction methods to be called an
d ignored without actual transaction support. WARNING: Setting txnAutowrap=OFF and using transaction methods is risky because
transactions will not be executed atomically and rollback will not occur!
        at org.teiid.dqp.internal.process.Request.createProcessor(Request.java:386)
        at org.teiid.dqp.internal.process.Request.processRequest(Request.java:589)
        at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:365)
        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:200)
        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:44)
        at com.metamatrix.common.queue.WorkerPoolFactory$StatsCapturingSharedThreadPoolExecutor$1.run(WorkerPoolFactory.java:
211)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        ... 1 more

I set the "Transaction AutoWrap" to Pessimistic but still get this failure.  It still thinks I am using txnAutoWrap=OPTIMISTIC.  The message also mentions the  if I am not using MetaMatrix Enterprise, no transcation manager is provided.  Although I have read on the internet that all Teiid install support transactions

[rareddy]

Teiid is an open source product came out of Metamatrix product, that has been around for a long time. Will still have messages and classes with metamatrix name. We are scrubbing them as we go.

OK, now to transactions, it really depends upon what style of transactions you are using. If the Hibernate layer is using JTA (like UserTransaction) then you need to use the "TeiidDataSource" and create an XA connection to your VDB.

If your Hibernate layer is using local transactions by setting "autocommit = false" on the JDBC driver, you can use TeiidDriver or TeiidDatasource. You can just create a regular JDBC connection on Teiid. However, in this scenario Hibernate layer *must* issue a commit.

If your Hibernate layer is using request level transactions (autocommit=true), then the burden is on Teiid to wrap the transaction around the multiple data sources involved inside Teiid. here we provide more options to the users as to how they would like to handle this. Please see explanation on "txnautoWrap" here.   You can see how to set this property here. You can supply this on the connection URL.

Please make sure you are using correct casing when defining this property. Pessimistic != PESSIMISTIC

[nandinitm]

This is in continuation of the previous post by Ahmed.

Now after setting txnAutoWrap=PESSIMISTIC (url = "jdbc:teiid:TEST@/opt/teiid-6.2.0/deploy.properties;txnAutoWrap=PESSIMISTIC;"), that error went away but getting the one below:

2010-03-16 13:41:39,793 [http-8080-8] ERROR application.WebApplicationImpl  - The RuntimeException could not be mapped to a response, re-throwing to the HTTP container
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.GLC_CD as GLC1_7_0_, this_.GLC_RPTG_UN_ID as GLC2_7_0
_, this_.GLC_THTR_CMD_ORG_CD as GLC3_7_0_, this_.CNTY_CD as CNTY4_7_0_, this_.INSTL_CD as INSTL5_7_0_, this_.ICAO_CD as ICAO6_7_0_, this_.LGR_RGN_CD as LGR7_7_0_, this_.MILSTAMP_ID as MILSTAMP8_7_0_,
this_.GLC_UPDATE_DT as GLC9_7_0_, this_.GLC_REC_STAT_CD as GLC10_7_0_, this_.GLC_NM as GLC11_7_0_, this_.GLC_LON_COORD as GLC12_7_0_, this_.GLC_LAT_COORD as GLC13_7_0_, this_.GLC_CREATE_DT as GLC14_7_
0_, this_.PRME_GLC_CD as PRME15_7_0_, this_.GLC_CNCLD_DT as GLC16_7_0_ from JOPES.GEOLOCATION this_]; SQL state [50000]; error code [0]; The request 1.88 has been closed.; nested exception is com.metamatrix.jdbc.MMSQLException: The request 1.88 has been closed.
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
        at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
        at org.springframework.orm.hibernate3.HibernateTemplate.loadAll(HibernateTemplate.java:584)
        at org.codehaus.groovy.grails.orm.hibernate.metaclass.FindAllPersistentMethod.doInvokeInternal(FindAllPersistentMethod.java:103)
        at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractStaticPersistentMethod.invoke(AbstractStaticPersistentMethod.java:64)
        at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractStaticPersistentMethod.invoke(AbstractStaticPersistentMethod.java:57)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSite.invoke(PojoMetaMethodSite.java:188)
        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
        at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
        at org.codehaus.groovy.grails.plugins.orm.hibernate.HibernatePluginSupport$_enhanceSessionFactory_closure10.doCall(HibernatePluginSupport.groovy:372)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:86)
        at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:234)
        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1049)
        at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:923)
        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:880)
        at groovy.lang.Closure.call(Closure.java:279)
        at org.codehaus.groovy.runtime.metaclass.ClosureStaticMetaMethod.invoke(ClosureStaticMetaMethod.java:59)
        at org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite$StaticMetaMethodSiteNoUnwrapNoCoerce.invoke(StaticMetaMethodSite.java:148)
        at org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:88)
        at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:121)
        at mil.disa.apex.dal.jopes.GeolocationCollectionResource.readAll(GeolocationCollectionResource.groovy:20)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:175)
        at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:67)
        at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:208)
        at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:75)
        at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:115)
        at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:67)
        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:775)
        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:740)
        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:731)
        at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:372)
        at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:452)
        at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:633)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.grails.jaxrs.web.JaxrsContext$JaxrsServiceImpl.process(JaxrsContext.java:150)
        at sun.reflect.GeneratedMethodAccessor394.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
        at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:129)
        at JaxrsController$_closure1.doCall(JaxrsController.groovy:36)
        at sun.reflect.GeneratedMethodAccessor392.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoCachedMethodSite.invoke(PogoMetaMethodSite.java:225)
        at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.callCurrent(PogoMetaMethodSite.java:51)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:151)
        at JaxrsController$_closure1.doCall(JaxrsController.groovy)
        at sun.reflect.GeneratedMethodAccessor391.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:86)
        at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:234)
        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1049)
        at groovy.lang.ExpandoMetaClass.invokeMethod(ExpandoMetaClass.java:923)
        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:880)
        at groovy.lang.Closure.call(Closure.java:279)
        at groovy.lang.Closure.call(Closure.java:274)
        at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleAction(SimpleGrailsControllerHelper.java:377)
        at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.executeAction(SimpleGrailsControllerHelper.java:244)
        at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:202)
        at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsControllerHelper.handleURI(SimpleGrailsControllerHelper.java:137)
        at org.codehaus.groovy.grails.web.servlet.mvc.SimpleGrailsController.handleRequest(SimpleGrailsController.java:88)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
        at org.codehaus.groovy.grails.web.servlet.GrailsDispatcherServlet.doDispatch(GrailsDispatcherServlet.java:255)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:70)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
        at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:302)
        at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:278)
        at org.codehaus.groovy.grails.web.util.WebUtils.forwardRequestForUrlMappingInfo(WebUtils.java:270)
        at org.codehaus.groovy.grails.web.mapping.filter.UrlMappingsFilter.doFilterInternal(UrlMappingsFilter.java:187)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.obtainContent(GrailsPageFilter.java:249)
        at org.codehaus.groovy.grails.web.sitemesh.GrailsPageFilter.doFilter(GrailsPageFilter.java:140)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.grails.jaxrs.web.JaxrsFilter.doFilterInternal(JaxrsFilter.java:46)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.codehaus.groovy.grails.web.servlet.mvc.GrailsWebRequestFilter.doFilterInternal(GrailsWebRequestFilter.java:65)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.codehaus.groovy.grails.web.filters.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:66)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
        at java.lang.Thread.run(Thread.java:619)
Caused by: com.metamatrix.jdbc.MMSQLException: The request 1.88 has been closed.
        at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:123)
        at com.metamatrix.jdbc.MMSQLException.create(MMSQLException.java:71)
        at com.metamatrix.jdbc.MMResultSet.requestBatch(MMResultSet.java:356)
        at com.metamatrix.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:205)
        at com.metamatrix.jdbc.BatchResults.requestNextBatch(BatchResults.java:118)
        at com.metamatrix.jdbc.BatchResults.hasNext(BatchResults.java:223)
        at com.metamatrix.jdbc.MMResultSet.hasNext(MMResultSet.java:374)
        at com.metamatrix.jdbc.MMResultSet.isAfterLast(MMResultSet.java:1227)
        at com.metamatrix.jdbc.MMResultSet.getObject(MMResultSet.java:218)
        at com.metamatrix.jdbc.MMResultSet.getString(MMResultSet.java:916)
        at com.metamatrix.jdbc.MMResultSet.getString(MMResultSet.java:930)
        at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:225)
        at org.hibernate.type.StringType.get(StringType.java:41)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
        at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
        at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:1121)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:588)
        at org.hibernate.loader.Loader.doQuery(Loader.java:724)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
        at org.hibernate.loader.Loader.doList(Loader.java:2228)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
        at org.hibernate.loader.Loader.list(Loader.java:2120)
        at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1596)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
        at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:590)
        at org.springframework.orm.hibernate3.HibernateTemplate$5.doInHibernate(HibernateTemplate.java:1)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
        ... 143 more
Caused by: [MetaMatrixProcessingException]The request 1.88 has been closed.
        at org.teiid.dqp.internal.process.DQPCore.getRequestWorkItem(DQPCore.java:369)
        at org.teiid.dqp.internal.process.DQPCore.processCursorRequest(DQPCore.java:282)
        at sun.reflect.GeneratedMethodAccessor404.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:111)
        at $Proxy39.processCursorRequest(Unknown Source)
        at com.metamatrix.jdbc.MMResultSet.requestBatch(MMResultSet.java:350)
        ... 168 more
2010-03-16 13:41:39,809 [http-8080-8] ERROR errors.GrailsExceptionResolver  - The request 1.88 has been closed.
[MetaMatrixProcessingException]The request 1.88 has been closed.
        at org.teiid.dqp.internal.process.DQPCore.getRequestWorkItem(DQPCore.java:369)
        at org.teiid.dqp.internal.process.DQPCore.processCursorRequest(DQPCore.java:282)
        at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:111)
        at $Proxy39.processCursorRequest(Unknown Source)
        at com.metamatrix.jdbc.MMResultSet.requestBatch(MMResultSet.java:350)
        at com.metamatrix.jdbc.BatchResults.requestBatchAndWait(BatchResults.java:205)
        at com.metamatrix.jdbc.BatchResults.requestNextBatch(BatchResults.java:118)
        at com.metamatrix.jdbc.BatchResults.hasNext(BatchResults.java:223)
        at com.metamatrix.jdbc.MMResultSet.hasNext(MMResultSet.java:374)
        at com.metamatrix.jdbc.MMResultSet.isAfterLast(MMResultSet.java:1227)
        at com.metamatrix.jdbc.MMResultSet.getObject(MMResultSet.java:218)
        at com.metamatrix.jdbc.MMResultSet.getString(MMResultSet.java:916)
        at com.metamatrix.jdbc.MMResultSet.getString(MMResultSet.java:930)
        at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:225)
        at mil.disa.apex.dal.jopes.GeolocationCollectionResource.readAll(GeolocationCollectionResource.groovy:20)
        at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:175)
        at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:67)
        at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:208)
        at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:75)
        at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:115)
        at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:67)
        at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:775)
        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:740)
        at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:731)
        at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:372)
        at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:452)
        at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:633)
        at org.grails.jaxrs.web.JaxrsContext$JaxrsServiceImpl.process(JaxrsContext.java:150)
        at JaxrsController$_closure1.doCall(JaxrsController.groovy:36)
        at JaxrsController$_closure1.doCall(JaxrsController.groovy)
        at org.grails.jaxrs.web.JaxrsFilter.doFilterInternal(JaxrsFilter.java:46)
        at java.lang.Thread.run(Thread.java:619)
2010-03-16 13:41:39,887 [http-8080-8] ERROR [Tomcat].[localhost]  - Exception Processing ErrorPage[errorCode=500, location=/grails-errorhandler]
java.lang.IllegalStateException: Cannot reset buffer after response has been committed
        at org.apache.catalina.connector.Response.resetBuffer(Response.java:691)
        at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:409)
        at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:343)
        at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:287)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

Appreciate your support!

--Nandini

[rareddy]

From the stack it seems like your app is trying to get the results from the resultset after the SQL statement is closed. Results must be accessed before the statement is closed. Can you double check?

[nandinitm]

Not really, this sql was called within a Groovy REST resource (mapped to Oracle database table) to get entire collection of the resource. So I took the SQL out of that and put in a simple test, but still getting the same error.  In my groovy test, if I comment out the code to print each row, test works fine. But if I leave it there, I'm getting the same error (error message attached).

void testGetMeSomething() {
       
        def url = 'jdbc:teiid:DAL@/opt/teiid-6.2.0/deploy.properties;txnAutoWrap=PESSIMISTIC;'    

          def sql = '''select this_.GLC_CD as GLC1_7_0_, this_.GLC_RPTG_UN_ID as GLC2_7_0_, this_.GLC_THTR_CMD_ORG_CD
         as GLC3_7_0_, this_.CNTY_CD as CNTY4_7_0_, this_.INSTL_CD as INSTL5_7_0_, this_.ICAO_CD as ICAO6_7_0_,  
         this_.LGR_RGN_CD as LGR7_7_0_, this_.MILSTAMP_ID as MILSTAMP8_7_0_, this_.GLC_UPDATE_DT as GLC9_7_0_,
         this_.GLC_REC_STAT_CD as GLC10_7_0_, this_.GLC_NM as GLC11_7_0_, this_.GLC_LON_COORD as GLC12_7_0_,
         this_.GLC_LAT_COORD as GLC13_7_0_, this_.GLC_CREATE_DT as GLC14_7_0_, this_.PRME_GLC_CD as PRME15_7_0_,
         this_.GLC_CNCLD_DT as GLC16_7_0_ from DAL.JOPES_VL.JOPES.GEOLOCATION this_ ''';

        def db = Sql.newInstance(url,'admin','teiid','org.teiid.jdbc.TeiidDriver')
        def i = 0
        db.eachRow(sql){row ->
            /*row.each{print it}
            println ''*/
            i++
        }
        println "total records:" + i
    }

[nandinitm]

BTW, size was 10,000. Not sure if that is the problem. Anything to configure in deploy.properties or configuration.xml?

[rareddy]

Good Info Nandini!

Yes, Teiid has a property called "MaxResultRows" on every connector that defaults to "10000" rows, after that many rows it closes connector underneath, thus you may be seeing the issue. You can set this value "0" for unlimited, or positive any value you like.  You can use Designer to set this value, or open the VDB and edit "ConfigurationInfo.def" file and add to the connector fragments.

Ramesh..

[nandinitm]

Good news, it worked:) Worked when I changed MaxResultRows to 0 or 100,000 in Configuration.def in the VDB file. Also had to change the MaxResultRows setting to 0 or 100,000 in configuration.xml in <teiid_home>/deploy directory.


FYI, actually the total rows returned are 60,000. Total size was showing 10,000 in the test when the setting was 10,000.

[rareddy]

Great! and thanks. We are looking into changing this property to unlimited by default in the next version of the Teiid. This will help to avoid issue next time around.

Returning the 10,000 when actual rows were 60,000 is expected behaviour when the "MaxResultRows" is set to 10,000.

Ramesh..