October 6, 2008 at 8:54 PM
If u are using the oracle Database 9i(connect from servlet)
1)first u have to load the drivers.
2)Get the connection to the DataBase.
3)In this process first you have to set the classpath for oracle9i ie classes111.jar file in the classpath.
4)copy the abou said jar file in lib folder along with servlet-api.jar and jsp-api.jar files.
for example code like this if u are using the oracle type4(thin) driver:
5)to know the serviceid use type this command in oracle9i ie
select * from global_name;
the first word in this name is service id otherwise to search for tnsNames.ora file in oracle software after installation. I think it is in jdbc folder.