cancel
Showing results for 
Search instead for 
Did you mean: 

DSL/DDL Error for h2 database grid gain queries in Ready API

Highlighted
Occasional Contributor

DSL/DDL Error for h2 database grid gain queries in Ready API

I am getting the below error when I am running Apache ignite queries via Ready API latest Version à Using Datasource(JDBC) where it working as expected if I directly call the JDBC connection with the same connection and same query.

 

One of the reasons I think it is trying to process the query as transaction and gridgain/ignite are not supporting à so the question here is there any setting in ready API that helps in solving this issue (or) How is DatasourceJDBC triggering the query is different from the normal JDBC connection in Ready API?Grid Gain Query Error in Ready API .jpg

 

 

 

ERROR: java.sql.SQLException: Unsupported DDL/DML operation: org.h2.command.dml.TransactionCommand

   java.sql.SQLException: Unsupported DDL/DML operation: org.h2.command.dml.TransactionCommand

               at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:750)

               at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:212)

               at org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:475)

               at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.doCommit(JdbcThinConnection.java:369)

               at org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.setAutoCommit(JdbcThinConnection.java:328)

               at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.internalLoad(DBDataSource.java:129)

               at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.load(DBDataSource.java:102)

               at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.c(WsdlDataSourceTestStep.java:603)

               at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.b(WsdlDataSourceTestStep.java:597)

               at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.a(WsdlDataSourceTestStep.java:787)

               at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.next(WsdlDataSourceTestStep.java:797)

               at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(DataSourceDesktopPanel.java:406)

               at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(DataSourceDesktopPanel.java:1)

               at com.eviware.soapui.impl.wsdl.actions.iface.AbstractSwingAction.actionPerformed(AbstractSwingAction.java:62)

               at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

               at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

               at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

               at javax.swing.DefaultButtonModel.setPressed(Unknown Source)

               at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

               at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)

               at java.awt.Component.processMouseEvent(Unknown Source)

               at javax.swing.JComponent.processMouseEvent(Unknown Source)

               at java.awt.Component.processEvent(Unknown Source)

               at java.awt.Container.processEvent(Unknown Source)

               at java.awt.Component.dispatchEventImpl(Unknown Source)

               at java.awt.Container.dispatchEventImpl(Unknown Source)

               at java.awt.Component.dispatchEvent(Unknown Source)

               at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

               at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

               at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

               at java.awt.Container.dispatchEventImpl(Unknown Source)

               at java.awt.Window.dispatchEventImpl(Unknown Source)

               at java.awt.Component.dispatchEvent(Unknown Source)

               at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

               at java.awt.EventQueue.access$500(Unknown Source)

               at java.awt.EventQueue$3.run(Unknown Source)

               at java.awt.EventQueue$3.run(Unknown Source)

               at java.security.AccessController.doPrivileged(Native Method)

               at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

               at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

               at java.awt.EventQueue$4.run(Unknown Source)

               at java.awt.EventQueue$4.run(Unknown Source)

               at java.security.AccessController.doPrivileged(Native Method)

               at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

               at java.awt.EventQueue.dispatchEvent(Unknown Source)

               at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

               at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

               at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

               at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

               at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

               at java.awt.EventDispatchThread.run(Unknown Source)

 

 @DBarnes 

10 REPLIES 10
Highlighted
Community Manager

Hi @BandhaviN,

 

I see that you are actively working with Lakshmi from the Support Team to resolve the issue. Please let us know the solution you will find out.

---------
Tanya Gorbunova
SmartBear Community Manager

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
New Here?
Join us and watch the welcome video:
Announcements
TechCorner Leaderboard
Want a fun and easy way to learn ReadyAPI and show off your skills? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Get a full Raw JMS request

Participate!

Compare an expected JSON value and actual response in Events

Participate!

Fetch value/data from JSON response using Groovy Script

See replies!

Get data from Petstore and add it to Excel sheets

Participate!