This might be a basic information for some experts out there but I felt its worth mentioning it here
how will u differentiate between services and the SID to connect to Oracle using JDBC in the connection string
for SID: it goes like
jdbc:oracle:thin:@localhost:1521:XE
for Services you specify like
jdbc:oracle:thin:@localhost:1521/XE
Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(jdbc:oracle:thin:@localhost:1521/XE,system,tiger); Statement stmt = conn.createStatement(); ResultSet rset = stmt.executeQuery(query);