Announcement

Collapse
No announcement yet.

Oracle CLOB Support Not working - Help!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Oracle CLOB Support Not working - Help!

    We are trying to insertCLOB data into a very simple table and have tried many examples and non work. I am beginning to think this functionality will not work within this product.

    Here is our code:

    // Load the Oracle driver
    java.lang.Class.forName("oracle.jdbc.driver.Oracle Driver");
    var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('oracle.jdbc.OracleDriver','jdbcracle:thin:@localhost:1521:XE','AIMS','AIMS');

    var xmlData=messageObject.getTransformedData();

    // Create the statement
    var stmt = dbConn.prepareStatement("{ call CSP_INS_PATIENTDEMO(?,?,?) }");
    stmt.setInt(1,1);
    stmt.setString(2, $('MSH_MsgCtrlID'));
    stmt.setClob(1, xmlData);
    // Execute the statement
    stmt.executeUpdate();
    // Clean up
    stmt.close();
    dbConn.close();


    Now, when we run it we get the following error:

    ERROR-406: JDBC Connector error
    ERROR MESSAGE: Error writing to database:
    org.mozilla.javascript.EcmaError: TypeError: Cannot find function prepareStatement. (bc915dd1-6d6e-4870-b9d3-993968255b1e#18)
    at org.mozilla.javascript.ScriptRuntime.constructErro r(ScriptRuntime.java:3226)
    at org.mozilla.javascript.ScriptRuntime.constructErro r(ScriptRuntime.java:3216)
    at org.mozilla.javascript.ScriptRuntime.typeError(Scr iptRuntime.java:3232)
    at org.mozilla.javascript.ScriptRuntime.typeError1(Sc riptRuntime.java:3244)
    at org.mozilla.javascript.ScriptRuntime.notFunctionEr ror(ScriptRuntime.java:3304)
    at org.mozilla.javascript.ScriptRuntime.getPropFuncti onAndThis(ScriptRuntime.java:1988)
    at org.mozilla.javascript.gen.c50._c6(bc915dd1-6d6e-4870-b9d3-993968255b1e:18)
    at org.mozilla.javascript.gen.c50.call(bc915dd1-6d6e-4870-b9d3-993968255b1e)
    at org.mozilla.javascript.optimizer.OptRuntime.callNa me0(OptRuntime.java:106)
    at org.mozilla.javascript.gen.c50._c0(bc915dd1-6d6e-4870-b9d3-993968255b1e:29)
    at org.mozilla.javascript.gen.c50.call(bc915dd1-6d6e-4870-b9d3-993968255b1e)
    at org.mozilla.javascript.ContextFactory.doTopCall(Co ntextFactory.java:337)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(Scr iptRuntime.java:2755)
    at org.mozilla.javascript.gen.c50.call(bc915dd1-6d6e-4870-b9d3-993968255b1e)
    at org.mozilla.javascript.gen.c50.exec(bc915dd1-6d6e-4870-b9d3-993968255b1e)
    at com.webreach.mirth.connectors.jdbc.JdbcMessageDisp atcher.doDispatch(JdbcMessageDispatcher.java:97)
    at com.webreach.mirth.connectors.jdbc.JdbcMessageDisp atcher.doSend(JdbcMessageDispatcher.java:157)
    at org.mule.providers.AbstractMessageDispatcher.send( AbstractMessageDispatcher.java:166)
    at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:191)
    at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:130)
    at org.mule.routing.outbound.AbstractOutboundRouter.s end(AbstractOutboundRouter.java:85)
    at org.mule.routing.outbound.FilteringMulticastingRou ter.route(FilteringMulticastingRouter.java:99)
    at org.mule.routing.outbound.OutboundMessageRouter$1. doInTransaction(OutboundMessageRouter.java:78)
    at org.mule.transaction.TransactionTemplate.execute(T ransactionTemplate.java:48)
    at org.mule.routing.outbound.OutboundMessageRouter.ro ute(OutboundMessageRouter.java:82)
    at org.mule.impl.model.DefaultMuleProxy.onCall(Defaul tMuleProxy.java:247)
    at org.mule.impl.model.seda.SedaComponent.doSend(Seda Component.java:209)
    at org.mule.impl.model.AbstractComponent.sendEvent(Ab stractComponent.java:277)
    at org.mule.impl.MuleSession.sendEvent(MuleSession.ja va:201)
    at org.mule.routing.inbound.InboundMessageRouter.send (InboundMessageRouter.java:161)
    at org.mule.routing.inbound.InboundMessageRouter.rout e(InboundMessageRouter.java:128)
    at org.mule.providers.AbstractMessageReceiver$Default InternalMessageListener.onMessage(AbstractMessageR eceiver.java:493)
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:272)
    at org.mule.providers.AbstractMessageReceiver.routeMe ssage(AbstractMessageReceiver.java:244)
    at com.webreach.mirth.connectors.mllp.MllpMessageRece iver$TcpWorker.processHL7Data(MllpMessageReceiver. java:440)
    at com.webreach.mirth.connectors.mllp.MllpMessageRece iver$TcpWorker.processData(MllpMessageReceiver.jav a:419)
    at com.webreach.mirth.connectors.mllp.MllpMessageRece iver$TcpWorker.run(MllpMessageReceiver.java:340)
    at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
    at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
    at java.lang.Thread.run(Unknown Source)

    I have tried preparedStatement and gotten the same error (only with different reference due to change in name).
Working...
X