correct way to connect to oracle 8i DB ?

[jamesa]

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 ??

[jamesa]

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 ?