Announcement

Collapse
No announcement yet.

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