url: jdbc:oracle:thin:@ecs040915:1524:csmc

[shifting_18]

Hi!
I used this url for an oracle dbase.It's version 8.1.6. Can the driver for Oracle 10g Release 2 support it??

I got the following error:

org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
at org.mule.providers.AbstractMessageReceiver.start(A bstractMessageReceiver.java:396)
at org.mule.providers.AbstractConnector.registerListe ner(AbstractConnector.java:518)
at org.mule.impl.model.AbstractModel.registerListener s(AbstractModel.java:221)
at org.mule.impl.model.AbstractModel.start(AbstractMo del.java:353)
at org.mule.MuleManager.start(MuleManager.java:730)
at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXmlConfigurationBuilder.java:207)
at org.mule.config.builders.MuleXmlConfigurationBuild er.configure(MuleXmlConfigurationBuilder.java:194)
at com.webreach.mirth.server.Mirth.startMule(Mirth.ja va:163)
at com.webreach.mirth.server.Mirth.restartMule(Mirth. java:145)
at com.webreach.mirth.server.Mirth.run(Mirth.java:101 )
Caused by: org.mule.providers.FatalConnectException: ReconnectStrategy "org.mule.providers.SingleAttemptConnectionStrateg y" failed to reconnect receiver on endpoint "jdbc://query"
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:34 )
at org.mule.providers.AbstractConnectionStrategy.conn ect(AbstractConnectionStrategy.java:67)
at org.mule.providers.AbstractMessageReceiver.connect (AbstractMessageReceiver.java:353)
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:32 )
... 11 more
Caused by: org.mule.providers.ConnectException: Initialisation Failure: Io exception: The Network Adapter could not establish the connection
at com.webreach.mirth.server.mule.providers.jdbc.Jdbc MessageReceiver.doConnect(JdbcMessageReceiver.java :91)
at org.mule.providers.AbstractMessageReceiver.connect (AbstractMessageReceiver.java:360)
at org.mule.providers.SingleAttemptConnectionStrategy .doConnect(SingleAttemptConnectionStrategy.java:32 )
... 14 more
Caused by: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnecti on.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(Physi calConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnect ion.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnectio n(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.webreach.mirth.server.mule.providers.jdbc.Jdbc Connector.getConnection(JdbcConnector.java:452)
at com.webreach.mirth.server.mule.providers.jdbc.Jdbc MessageReceiver.doConnect(JdbcMessageReceiver.java :89)
... 16 more

{}

[shifting_18]

Re:url: jdbcracle:thin:@ecs040915:1524:csmc

I have successfully started my channel. HOwever, a simple query doesn't seem to work.

SELECT lastname from doctorlist where doctorcode = '107';

I really am bothered why can't Mirth read the values on the database. Does anybody know the problem?
Thanks !!!!