problem with Connection object in a servlet

[Geetu Bahl]

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

[ramprasad madathil]

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.

class ConnectionUtil
{
  public static Connection getConnection()
   {
         Connection conn = //get your connection object
         return conn;
   }
}
 
//later in some other class
 
Connection conn = ConnectionUtil.getConnection();
 

ram.

[Adeel Ansari]

Not a servlet question.

Edited:
Its a crosspost. Same thread.
[ April 14, 2005: Message edited by: Adeel Ansari ]

[vasu devan]

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]

thanks everyone, specially ram

[Ganesh Gowtham]

Originally posted by ramprasad madathil:

class ConnectionUtil
{
  public static Connection getConnection()
   {
         Connection conn = //get your connection object
         return conn;
   }
}
 
//later in some other class
 
Connection conn = ConnectionUtil.getConnection();
 

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
[e-mail]
Capricornsys inc, Hyderabad