*
The moose likes JDBC and the fly likes JDBC Oracle connection error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Oracle connection error" Watch "JDBC Oracle connection error" New topic
Author

JDBC Oracle connection error

kris iyer
Greenhorn

Joined: Mar 27, 2002
Posts: 5
Hi all
I was trying to connect to my oracle database with Type 4 driver....also added classes111.zip in my class path then
ran the following java script to check my connection
it gave me the following error
Testing: jdbc:oracle:thin:somelogin/somepass@some.db.server.com:1521:jive
An exception occurred while connecting and performing our test query.
Refused:ROR=<CODE=12505><EMFI=4>>>>

I can't figure out the reason...can someone help me
Thanks
Kris Iyer
:roll: :roll:
[ Edited bt Dave to format code and fix smilies ]
[ March 27, 2002: Message edited by: David O'Meara ]
Mahesh Mamani
Ranch Hand

Joined: Jun 25, 2001
Posts: 110
Hi,
Here is the code for the connection part which may help u ,

Bye,

Mahesh
[ Edited by Dave to format code and fix smilies ]
[ March 27, 2002: Message edited by: David O'Meara ]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"kris_iyer",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
kris iyer
Greenhorn

Joined: Mar 27, 2002
Posts: 5
Hi Mahesh
Big thanks....:-)I made some changes in my script ...earlier i was reffering to SERVICE NAME from my tnsnames and also added classes12.zip to classpath and now it's working fine
thanks
kris
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Oracle connection error
 
Similar Threads
establishing connection to mssql2000
oracle database problems
DSN name not found error with TOMCAT5.5.7
database connection in init() of servlet
pls help me deal with jsp--oracle database connection