Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle noob

 
Ken Reigle
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm running Personal Oracle 8.1.6 on Win98 and am unable to obtain a connection to the database using the thin JDBC client.
Is it possible to establish a connection to the same machine on which you're developing? It seems likely, but my lack of Oracle smarts is hurting me here.
I believe the problem lies in the fact that I can't even get tnsping to return a response from a listener. Does anyone have the correct settings for setting up a listener which will work on a stand-alone client?
btw, I can connect to the database using SQL*Plus, so at least I know it's mounted.
 
prabhat kumar
Ranch Hand
Posts: 114
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
if u have created any user and used the default name then connection string is like this
Class.forName("oracle.jdbc.driver.OracleDriver");
dbCon = DriverManager.getConnection("jdbc racle:thin:@localhost:1521:localhost", "scott","tiger");
hope it will help.
if u can't connect then post the error message too
 
Ken Reigle
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the response. Between the time I posted and now, I completely removed Oracle from my system and reinstalled it. This cleared up whatever the underlying problem was, and all is well with JDBC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic