Hier ist die Quelle:
Code: Select all
import java.sql.*;
public class test {
public static void main (String[] args) {
try {
Connection connORA = DriverManager.getConnection("jdbc:oracle:thin:@myoracleserver:1521/myschema", "user", "password");
if (connORA != null) {
System.out.println("Connected to ORACLE");
}
Connection connPGS = DriverManager.getConnection("jdbc:postgresql://IP.of.my.server:5432/mydbname","user","password");
if (connPGS != null) {
System.out.println("Connected to POSTGRES");
}
Connection connSQS = DriverManager.getConnection("jdbc:sqlserver://IP.of.my.server;databaseName=mydbname" ,"user" ,"password");
if (connSQS != null) {
System.out.println("Connected to SQLSERVER");
}
}
catch (SQLException e) {
System.err.println(e.getMessage());
}
}
}
Code: Select all
javac -cp :$ORACLE_HOME/jdbc/lib/* test.java
Code: Select all
java -cp :$ORACLE_HOME/jdbc/lib/* test
Connected to ORACLE
Connected to POSTGRES
Connected to SQLSERVER
Code: Select all
loadjava -user myoracleuser/muoraclepassword@myoracleschema $ORACLE_HOME/jdbc/lib/postgresql-42.3.3.jar
loadjava -user myoracleuser/muoraclepassword@myoracleschema $ORACLE_HOME/jdbc/lib/sqljdbc4-2.0.jar
loadjava -user myoracleuser/muoraclepassword@myoracleschema test.java
Code: Select all
Connected to ORACLE
No suitable driver found for jdbc:postgresql://IP.of.my.server:5432/mydbname