This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection error

 
priya Anand
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Please help me resolve the following error:

[#|2009-01-19T18:40:58.454-0300|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=32;_ThreadName=httpSSLWorkerThread-8080-41;_RequestID=82b30543-b1b4-4347-886d-62d205190cb3;|
RAR7093 : Error while cleaning up ManagedConnection
javax.resource.ResourceException: This Managed Connection is not valid as the phyiscal connection is not usable
at com.sun.gjc.spi.ManagedConnection.checkIfValid(ManagedConnection.java:627)
at com.sun.gjc.spi.ManagedConnection.cleanup(ManagedConnection.java:233)

My configuration is as follows :

<jdbc-connection-pool connection-validation-method="table" datasource-classname="oracle.jdbc.pool.OracleConnectionPoolDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="true" is-isolation-level-guaranteed="false" max-pool-size="32" max-wait-time-in-millis="60000" name="ddamd" pool-resize-quantity="2" res-type="javax.sql.ConnectionPoolDataSource" steady-pool-size="8" validation-table-name="HOST">
<property name="URL" value="jdbcracle:thin:@server:1521/thingy" />
<property name="Password" value="password" />
<property name="User" value="user" />
</jdbc-connection-pool>

Thanks and Regards,
Priya Anand

[edit to remove connection details]
 
ujjwal soni
Ranch Hand
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Could you try setting the fail-all-connections flag to true? This might be needed in case of a database restart.

 
John Kimball
Ranch Hand
Posts: 96
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Even if it's a development box, it's REALLY bad idea to:
- Include the URL.
- Include the password.
- Include the username.
 
Moojid Hamid
Ranch Hand
Posts: 120
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
double check your URL
 
krishna kanaga
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you included the Oracle JDBC Jar in your build path? Given the "package oracle.jdbc does not exist" error, it seems you don't have the Oracle Jar in your path.

The link below is one that I use for simple Java examples. If you search for "jdbc" on that, it redirects to the ExampleDepot site link I included below.
Source(s):
Java Almanac
 
Davie Lin
Ranch Hand
Posts: 294
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
<property name="URL" value="jdbcracle:thin:@server:1521/thingy" />


missing "o" between "c" and "r"
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic