Announcement

Collapse

NextGen Connect 3.10.1 Released!

NextGen (Mirth) Connect 3.10.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes. See the release notes for the list of fixes.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

correct way to connect to oracle 8i DB ?

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

  • correct way to connect to oracle 8i DB ?

    Hello All

    I am trying to connect to a Oracle 8i DB to select some data(inbound).
    here is my URL: jdbcracle:thin:@hostname.domain.local:1521:SIDname

    I am seeing "failed to register listner" in the channel logs:

    org.mule.umo.model.ModelException: Failed to register listener d5018d20-3eb1-4e2e-93ee-3f4a14edd298 on endpoint jdbc://query
    at org.mule.impl.model.AbstractModel.registerListener s(AbstractModel.java:225)
    at org.mule.impl.model.AbstractModel.startComponent(A bstractModel.java:429)
    at org.mule.management.mbeans.ModelService.startCompo nent(ModelService.java:50)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at com.sun.jmx.mbeanserver.StandardMetaDataImpl.invok e(Unknown Source)
    at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(Unknow n Source)
    at com.sun.jmx.interceptor.DefaultMBeanServerIntercep tor.invoke(Unknown Source)
    at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(Unkn own Source)
    at javax.management.remote.rmi.RMIConnectionImpl.doOp eration(Unknown Source)
    at javax.management.remote.rmi.RMIConnectionImpl.acce ss$100(Unknown Source)
    at javax.management.remote.rmi.RMIConnectionImpl$Priv ilegedOperation.run(Unknown Source)
    at javax.management.remote.rmi.RMIConnectionImpl.doPr ivilegedOperation(Unknown Source)
    at javax.management.remote.rmi.RMIConnectionImpl.invo ke(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
    at sun.rmi.transport.Transport$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.rmi.transport.Transport.serviceCall(Unknown Source)
    at sun.rmi.transport.tcp.TCPTransport.handleMessages( Unknown Source)
    at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.IllegalArgumentException: Read statement should be a select sql statement
    at com.webreach.mirth.server.mule.providers.jdbc.Jdbc Connector.getReadAndAckStatements(JdbcConnector.ja va:235)
    at com.webreach.mirth.server.mule.providers.jdbc.Jdbc Connector.createReceiver(JdbcConnector.java:150)
    at org.mule.providers.AbstractConnector.registerListe ner(AbstractConnector.java:514)
    at org.mule.impl.model.AbstractModel.registerListener s(AbstractModel.java:221)
    ... 26 more

    {}

    How to fix this ??

  • #2
    Re:correct way to connect to oracle 8i DB ?

    OK I looked a bit harder at the error message after a few days break and saw the problem was I was not performing a select query in my channel!


    now on to creating my query!

    URL was
    jdbcracle:thin:@your.server.comort:SID

    not 100% sure on the SID, might be database name ?

    Comment

    Working...
    X