File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Connecting to oracle through glassfish Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connecting to oracle through glassfish" Watch "Connecting to oracle through glassfish" New topic

Connecting to oracle through glassfish

Bushra Binte
Ranch Hand

Joined: Nov 07, 2006
Posts: 60
Hi,while trying to create a connection pool for oracle in glassfish version 2,m getting the below error"Class name is wrong or classpath is not set for : oracle.jdbc.xa.client.OracleXADataSource ".Please suggest as how to resolve.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32320

Is classes12.jar in y our classpath?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Bushra Binte
Ranch Hand

Joined: Nov 07, 2006
Posts: 60
yep.I have added classes12.jar at the following location:
domains/<domainname>/lib/ext.Now am able to connect and able to ping from admin console of glassfish server.But when i use the connection pool in the ejb application,i get this error:
java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870336)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=abcd)(PORT=1000))'))(ERROR=(CODE=305)(EMFI=1))))
Don't get me started about those stupid light bulbs.
subject: Connecting to oracle through glassfish
It's not a secret anymore!