Java 简单连接OceanBase Oracle租户测试代码

为验证应用服务器连接数据库没有问题，

通过编写java代码建立数据库连接来验证

需要根据oceanbase版本和jdk版本选择ojdb驱动,

下面使用oceanbase-client-2.4.3.jar

import java.sql.*;
public class HelloWorld{
  public static void main(String[] args) throws SQLException{
    String url = "jdbc:oceanbase://12.12.12.12:2883/OTEST?useSSL=false&serverTimezone=UTC&autoReconnect=true";
    String username = "otest@Oracle_tenant#obcluster:10";
    String password = "";    
    Connection conn = null;
    try {
        Class.forName("com.oceanbase.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
        PreparedStatement ps = conn.prepareStatement("select to_char(sysdate,'yyyy-MM-dd HH24:mi:ss') from dual;");
        ResultSet rs = ps.executeQuery();
        rs.next();
        System.out.println("sysdate is:" + rs.getString(1));
        rs.close();
        ps.close();
    } catch (Throwable e) {
        e.printStackTrace();
    } finally {
        if (null != conn) {
            conn.close();
        }
    }
 }
}
复制

查看服务器jdk版本#java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
#javac -version
javac 1.8.0_171
复制

编译java程序

# javac -cp ./oceanbase-client-2.4.3.jar HelloWorld.java
复制

运行java程序

# java -cp .:/root/oceanbase-client-2.4.3.jar HelloWorld

2023-07-14 08:57:46
复制