File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JBoss/WildFly and the fly likes Configuring <connection-url> in local-tx-datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Configuring <connection-url> in local-tx-datasource" Watch "Configuring <connection-url> in local-tx-datasource" New topic

Configuring <connection-url> in local-tx-datasource

karthik Suryanarayanan
Ranch Hand

Joined: Oct 07, 2009
Posts: 121

Dear All,
Nice to meet you after sometime.

I have a problem where i need to connect to a datasource through a dedicated server in JBOSS.

Below is my code in cib-ds.xml

I have tried different combinations like below.

But still , I get a org.jboss.resource.JBossResourceException always.

The JBOSS version i am using is 4.2.2 and oracle database version 10g.

Also , since I'm connecting to a single database , i think i need not go for XA if i'm right.

Any suggestions guys?.

"Learning is a Culture where your Eagerness & Curiosity plays a major Role".
Peter Johnson

Joined: May 14, 2008
Posts: 5852

I don't work with Oracle, but according to their docs, I think the URL should be:

So your next-to-last URL was the closest, but you should have dropped the "//"

JBoss In Action
karthik Suryanarayanan
Ranch Hand

Joined: Oct 07, 2009
Posts: 121

Hi Peter,
I just resolved it by adding the connection URL just like entry in tnsora file with service name.
Thanks for your reply .
I agree. Here's the link:
subject: Configuring <connection-url> in local-tx-datasource
It's not a secret anymore!