使用java中的SSL cwallet.so的Oracle数据库连接

Question

我正在尝试使用Java程序连接oracle数据库。需要数据库才能连接到SSL cwallet.so文件。当我尝试连接时，它从类中弹出，没有发现异常。此外，我不确定我的代码是否正确。

代码：

package com.erplogic.lms.dabasehelper;

导入com.erlogic.lms.putilities。*；

import java.security.Security;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Properties;
public class DatabaseConnection {
// ORACLE DATABASE Connection
private Connection con;
private final String oracleDriver;
private final String connectionString;
private final String userName;
private final String password;
public DatabaseConnection() {
oracleDriver = PropertyFileHandler.PROPERTY_OBJECT.getProperty("ORACLE_DATABASE_DRIVER");
connectionString = PropertyFileHandler.PROPERTY_OBJECT.getProperty("DATABASE_CONNECTION_STRING");
userName = PropertyFileHandler.PROPERTY_OBJECT.getProperty("DATABASE_USER_NAME");
password = PropertyFileHandler.PROPERTY_OBJECT.getProperty("DATABASE_USER_PASSWORD");
}
public Connection connectOracleDatabase() {
try {

log4jHandler.infoLogger("Connecting To Database ::", PropertyFileHandler.class);
//step1 load the driver class
System.out.println(oracleDriver);
//Class.forName(oracleDriver);
//properties
Properties props = new Properties();
props.setProperty("user", userName);
props.setProperty("password", password);
props.setProperty("javax.net.ssl.trustStore", "D:\sapUAT\ssl_wallet\cwallet.sso");
props.setProperty("javax.net.ssl.trustStoreType","SSO");
props.setProperty("javax.net.ssl.keyStore","D:\sapUAT\ssl_wallet\cwallet.sso");
props.setProperty("javax.net.ssl.keyStoreType","SSO");
props.setProperty("oracle.net.authentication_services","(TCPS)");
Security.addProvider(new oracle.security.pki.OraclePKIProvider());
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

//step2 create  the connection object
con = DriverManager.getConnection(connectionString,props);
System.out.println(con);
log4jHandler.infoLogger("Database Connection Success ::", PropertyFileHandler.class);
} catch (SQLException e) {
log4jHandler.errorLogger("Database Connection Issue :: " + e.getMessage(), PropertyFileHandler.class);
Email emailTrigger = new Email();
//emailTrigger.triggerEmailWithoutAttachment("Database Connection Issue","Please check VPN is Connected Or Not n"+e.getMessage());

emailTrigger.triggerEmailWithOutAttachmentRohaGroup("Finnone SAP Interface : Database Connection Issue : " +DateFunction.getTheCurrentSystemDate(),EmailTemplates.messageBodyForDatabaseDown());
System.exit(0);
}
return con;
}
}

错误：线程出现异常"主"；java.lang.NoClassDefFoundError:oracle/security/crypto/core/AuthenticationException

Answer 1

确保类路径中有oraclepki.jar、osdt_core.jar和osdt_cert.jar以及ojdbc jar。这些jar可以从OTN/maven下载。