Errors connecting to Oracle Cluster as DB store

[dave.stubbs]

We have been using Oracle in test with a single oracle instance, but on production we have a cluster. We have other applications already talking to the cluster so we know the JDBC connection string works, but for some reason Fuse MQ fails with an error.

Here is the connection string...

  element for property 'connection.url' must specify a ref or value

Offending resource: class path resource

Bean 'oracle-ds'

        -> Property 'connection.url'

        at org.springframework.beans.factory.parsing.FailFastProblemReporter.error(FailFastProblemReporter.java:68)

        at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:85)

        at org.springframework.beans.factory.parsing.ReaderContext.error(ReaderContext.java:80)

        at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.error(BeanDefinitionParserDelegate.java:281)

        at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parsePropertyValue(BeanDefinitionParserDelegate.java:896)

        at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parsePropertyElement(BeanDefinitionParserDelegate.java:785)

        at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parsePropertyElements(BeanDefinitionParserDelegate.java:661)

        at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseBeanDefinitionElement(BeanDefinitionParserDelegate.java:560)

        ... 35 more

Could it be an encoding issue with the XML? Or is this a problem with MQ not supporting clusters?

[dave.stubbs]

Forget that......just discovered they had copied in the url line from a Hibernate config file and the property was listed as conection.url instead of just url !

Obvious when you eventually spot it.

Edited by: dave.stubbs on Jul 19, 2010 8:49 AM

[dave.stubbs]

Unfortunately this has not resolved the issue for the customer. They tried to deploy again last week and MQ would not establish a connection to the database.

We've checked out the network routing, we can telnet to the cluster servers ports without a problem, but MQ just won't play ball.

[albertwilson]

Forget that......just discovered they had copied in the url line from a Hibernate con fig file and the property was listed as connection. url instead of just url !

Obvious when you eventually spot it.

Custom Term Papers