Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

problem with Connection object in a servlet  RSS feed

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I need to retrieve data from oracle table. So i have established the conection in a class(pck1.dbcon)
Connection dbcon = DriverManager.getConnection("jdbc racle ci:@orcl", "scott", "tiger");

When i try to retrieve data from a servlet which imports this package, it gives error saying dbcon cannot be resolved.

Please Explain ?

Thanks
Geetu
 
Ranch Hand
Posts: 489
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


So i have established the conection in a class(pck1.dbcon)
Connection dbcon = DriverManager.getConnection("jdbc racle ci:@orcl", "scott", "tiger");



you should have done this in a public (and static) method of the class.



ram.
 
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not a servlet question.

Edited:
Its a crosspost. Same thread.
[ April 14, 2005: Message edited by: Adeel Ansari ]
 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I didnt used OCI for connecting Oracle databse,but the probelom may comes lots of conditions...(userid,driver probelom,etc..,)

But i might suggest one possiblity of accessing Oracle databse,by using oracle thin driver(this is pure type-4 driver).

Try this option

cheers
vasu
 
Geetu Bahl
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks everyone, specially ram
 
Ranch Hand
Posts: 225
IBM DB2 Eclipse IDE Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by ramprasad madathil:


ram.


Hi Ram..
Do u think that after Class.forName(".....");
DriverManager,gerConcetion(".....");


Will work fine ...then y to do all these gossip in esply in public staic mtd..

Let me know if it is not OK for u.. or if u have any comments...

Thx and Regards
G R Ganesh Gowtham
grgowtham_cse@yahoo.com
Capricornsys inc, Hyderabad
 
Forget this weirdo. You guys wanna see something really neat? I just have to take off my shoe .... (hint: it's a tiny ad)
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!