connection problem

[subash]

Hi Friends this is my code to connect to database oracle10g but i am gettin error when java command the error is invalid oracle url specified can anybody solve this problem






import java.sql.*;
import java.lang.*;
import java.io.*;

public class condb
{
public static void main (String args[]) throws SQLException
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbcracle:thin@//localhost:1521:XE","SYSTEM","tiger");
System.out.println("connected");
}
catch(Exception e)
{
System.out.println(e);
}
}
}

[rico16135]

What is with people using the DriverManager?

JDBC is recommending that the DataSource interface should be used to create database connection objects instead of using the DriverManager class.

Implementations of the DataSource Interface

[javarishi]

The database params can be given as a url. The format of url is

jdbcracle:<drivertype>:@<hostname>:<port>:<datab ase_sid>

In your case just replace the values as
Connection con=DriverManager.getConnection("jdbcracle:thin@ localhost:1521:XE","SYSTEM","tiger");

Try It Out.

[Eranga]

javarishi, seems there is a space between @ sign and the word localhost in the URL.

[javarishi]

Yaah Eranga, The space need to be deleted. No Space between @ and

localhost. Thanks.

[Eranga]

Just want to let it know.