Win a copy of Succeeding with AI this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Junilu Lacar
Sheriffs:
  • Tim Cooke
  • Jeanne Boyarsky
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • fred rosenberger
  • Frits Walraven

Oracle noob

 
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.
 
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.
 
Politics is a circus designed to distract you from what is really going on. So is this tiny ad:
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic