JSP and Oracle?

[Noura K]

Hello,
I'm writing jsp codes to connect mysql database with the web, and now I want to connect the web pages with the oracle database , I want to use the same jsp codes, But what should I change?

[vazhavandan]

change driver name
and connection url

[Sulabh Jain]

the driver has to changed and also there is a specific syntax for connecting to a oracle database as compard to a mysql database

[mallikj2â™]

Hi,
In order to work with the Oracle,

1) Change the Driver Class as per the Oracle DB.
ex: Class.forName("oracle.jdbc.driver.OracleDriver");

2) You need to Change the URL :
ex: DriverManager.getConnection("jdbcracle:thin:@hos tName:1521rcl", "scott", "tiger");


Thats it, The Remaining things will be the same