JDBC
Executing a Stored Procedure using Java
Submitted by Duke on Wed, 08/15/2007 - 13:34
You can execute a stored procedure using Java using a CallableStatement
Connection connection = null; try { // Instantiate the appropriate JDBC driver final String driverName = "oracle.jdbc.driver.OracleDriver"; Class.forName(driverName); // Connection parameters final String databaseHost = "databaseHost"; final String portNumber = "1527"; //Port Number final String sid = "dbname"; final String url = "jdbc:oracle:thin:@" + databaseHost + ":"
Connecting to Oracle Database using JDBC
Submitted by Duke on Wed, 08/15/2007 - 11:49Connection connection = null; try { // Instantiate the appropirateJDBC driver final String driverName = "oracle.jdbc.driver.OracleDriver"; Class.forName(driverName); // Connection parameters final String databaseHost = "hotsname"; final String portNumber = "1521"; //Port on which oracle database is running final String sid = "dbname"; final String url = "jdbc:oracle:thin:@" + databaseHost + ":" + portNumber + ":" + sid; final String username = "username"; final String password = "password"; connection = DriverManager.g
Recent comments
44 weeks 6 days ago
1 year 17 weeks ago
1 year 23 weeks ago
1 year 29 weeks ago
2 years 27 weeks ago
2 years 27 weeks ago
2 years 41 weeks ago
2 years 41 weeks ago
2 years 42 weeks ago