Forum Discussion

kiruthi_siv's avatar
15 years ago

HELP ME!!

Hi All,

Am trying to run multiple insert queries through Datasource JDBC connection[SOAP UI Pro 3.5.1 version]. Am connecting to Oracle server. The connection is fine but am not able to run multiple inserts because of the semicolon at the end of each query statement.Find the query I used :

INSERT INTO CUSTOMERS( MSISDN_SEQ_ID, MSISDN, STATUS_EFF_DATE, STATUS_ID )
VALUES (SEQ_MSISDN_SEQ_ID.NEXTVAL, '01234567890', SYSDATE, 1);


INSERT INTO PRODUCTS(PRODUCT_ID,PRODUCT_CODE,PRODUCT_CODE)
VALUES(SEQ_PRODUCT_ID.NEXTVAL,'TEST','TEST');

Error am getting is

Tue Aug 31 12:02:34 IST 2010:ERROR:java.sql.SQLException: ORA-00911: invalid character

java.sql.SQLException: ORA-00911: invalid character
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3076)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.load(SourceFile:120)
at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.next(SourceFile:503)
at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(SourceFile:366)
at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(SourceFile:320)
at com.eviware.soapui.impl.wsdl.actions.iface.AbstractSwingAction.actionPerformed(AbstractSwingAction.java:73)
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.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)

Please guide me in what to do for this case.

6 Replies

  • abhi1887's avatar
    abhi1887
    New Contributor
    The issue is becoz of semicolon.

    I'm still to figure out how can we run multiple queries. You can run one insert at a time, without semicolon.
  • shpits's avatar
    shpits
    New Contributor
    I'm using 4.5.1 Pro and I still get ORA-00911 when sending several queries to Oracle with ";" separation.
    Please help.

    Gadi
  • shpits wrote:
    I'm using 4.5.1 Pro and I still get ORA-00911 when sending several queries to Oracle with ";" separation.
    Please help.

    Gadi

    You can get support in the soapUI Pro forum. This is not the right place to get support.

    Regards

    Henrik
    SmartBear Software