connection with Oracle 10g

[Somitesh Chakraborty]

I've a problem while connecting java throw jdbc: oracle!:confused:
While I've written
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
in my program.....I'm having a compilation error........

TryingJDBC.java:2: package oracle.jdbc.pool does not exist
import oracle.jdbc.pool.OracleDataSource;

What should I do now?

please help me out.

[emceenugget]

Seems that you don't have your classpath set up correctly if it's not finding what you're trying to import. Hope someone else here can be of more help.

[Somitesh Chakraborty]

thanx for your reply...
no sir I've that yet i've this as a problem.........
please help me out.....

[Somitesh Chakraborty]

Can anyone tell me how to set the classpath so that I can connect java with oracle..........
I want to verify my classpath is correct or not........
plz help me..........

[DevzAbhi]

plz have ojdbc14.jar

put it in some folder


and when you are compiling your prog on command prompt

write
set classpath=.;c:\youfolder\ojdbc14.jar

and than javac your.java file

[Somitesh Chakraborty]

Thank you DevzAbhi!!!!!!!!
I'm very happy now......
what you told me that really works......
thanx a lot!!!!