[Datasource Configuration] - Re: Socket timeout or connection timeout exceptions

[Wolf-Dieter Fink]

Wolf-Dieter Fink [http://community.jboss.org/people/wdfink] created the discussion

"Re: Socket timeout or connection timeout exceptions"

To view the discussion, visit: http://community.jboss.org/message/568944#568944

--------------------------------------------------------------
Do you use the latest driver ojdbc6.jar?
Also you might set additional properties dependend to the DB driver.
e.g.:
<xa-datasource-property name="ConnectionProperties">oracle.jdbc.XATransLoose=true</xa-datasource-property>

Does the wiki help:
http://community.jboss.org/docs/DOC-9328 http://community.jboss.org/wiki/configdatasources
http://community.jboss.org/docs/DOC-12246 http://community.jboss.org/wiki/SetUpAOracleDatasource
Or you look into the docs/example/jca.
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/568944#568944]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

[Bhanu Pratap Padmanabhuni]

Bhanu Pratap Padmanabhuni [http://community.jboss.org/people/sun81] created the discussion

"Re: Socket timeout or connection timeout exceptions"

To view the discussion, visit: http://community.jboss.org/message/568991#568991

--------------------------------------------------------------
Hi, Thanks for the reply...I am looking for a similar kind of property for Non-XA datasource..
<xa-datasource-property name="ConnectionProperties">oracle.jdbc.XATransLoose=true</xa-datasource-property>
can you please let me know...
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/568991#568991]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

[Wolf-Dieter Fink]

Wolf-Dieter Fink [http://community.jboss.org/people/wdfink] created the discussion

"Re: Socket timeout or connection timeout exceptions"

To view the discussion, visit: http://community.jboss.org/message/569009#569009

--------------------------------------------------------------
Sorry,

XATransLoose is a property which I'm using. It is not for your problem, it was only an example.
You must search the Oracle knowlegebase for a property according to your problem.
The setting is done by JBoss connection manager with setter for the used connection class.
Also you should check that you use the latest ojdbc.jar.
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/569009#569009]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

[Bhanu Pratap Padmanabhuni]

Bhanu Pratap Padmanabhuni [http://community.jboss.org/people/sun81] created the discussion

"Re: Socket timeout or connection timeout exceptions"

To view the discussion, visit: http://community.jboss.org/message/569011#569011

--------------------------------------------------------------
I am using the latest ojdbc.jar file. Can I use the XATransLoose property in the oracle-xa-ds.xml in Jboss/deploy? I just wanted to give it a try?
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/569011#569011]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]