Checking DB Connection Using Java
Join the DZone community and get the full member experience.
Join For FreeFor the sake of completeness, here is a Java version of the Groovy post to test your Oracle Database connection.
package atest; import java.sql.*; /** * Run arguments sample: * jdbc:oracle:thin:@localhost:1521:XE system mypassword123 oracle.jdbc.driver.OracleDriver */ public class DbConn { public static void main(String[] args) throws Exception { String url = args[0]; String username = args[1]; String password = args[2]; String driver = args[3]; Class.forName(driver); Connection conn = DriverManager.getConnection(url, username, password); try { Statement statement = conn.createStatement(); ResultSet rs = statement.executeQuery("SELECT SYSDATE FROM DUAL"); while(rs.next()) { System.out.println(rs.getObject(1)); } } finally { conn.close(); } } }
Java (programming language)
Connection (dance)
Published at DZone with permission of Zemian Deng, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
Trending
-
Designing a New Framework for Ephemeral Resources
-
Building the World's Most Resilient To-Do List Application With Node.js, K8s, and Distributed SQL
-
Send Email Using Spring Boot (SMTP Integration)
-
What to Pay Attention to as Automation Upends the Developer Experience
Comments