从Java ...Exception连接到Oracle
从Java ...Exception连接到Oracle
提问于 2016-03-01 08:53:45
我想连接远程Oracle DB，但我有异常。请帮帮我。我能做什么?
我试过了，但没有用：
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@*****:1521/******", "*********",
"********");
Statement st = con.createStatement();
con.close();
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}获取错误：
Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: -1
at oracle.sql.converter.CharacterSetMetaData$JdbcCharacterSetMetaData.isFixedWidth(CharacterSetMetaData.java:1292)
at oracle.sql.converter.CharacterSetMetaData.getRatio(CharacterSetMetaData.java:1230)
at oracle.jdbc.driver.DBConversion.init(DBConversion.java:159)
at oracle.jdbc.driver.DBConversion.<init>(DBConversion.java:112)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1075)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)Stack Overflow用户
发布于 2016-03-01 09:07:30
您的连接URL格式错误。您正在混合SID和service格式。
任一
DriverManager.getConnection(
"jdbc:oracle:thin:<user>/<password>@<host>:<port>:<sid>");或
DriverManager.getConnection(
"jdbc:oracle:thin:@<host>:<port>:<sid>", "<user>", "<password>");或者，如果您连接到服务，而不是SID
DriverManager.getConnection(
"jdbc:oracle:thin:<user>/<password>@//<host>:<port>/<service");对于使用Properties对象的示例，请查看oracle.jdbc.OracleDriver的javadoc
编辑在这里找到到瘦式服务名称语法的链接
编辑2启用驱动程序日志记录，以查看是否会有一些有用的消息。
OracleLog.setTrace(true);
DriverManager.setLogWriter(new PrintWriter(System.out));编辑3这里是通过反射查找哪个字符集是由服务器和驱动程序报告的。
出于权限原因，包声明很重要。
package oracle.jdbc.driver;
import java.lang.reflect.Field;
import java.sql.Connection;
import java.sql.DriverManager;
import oracle.sql.CharacterSet;
import sun.reflect.ReflectionFactory;
public class OJdbcInfo {
public static void main(String[] args) throws Exception {
OracleLog.setTrace(true);
DriverManager.setLogWriter(new PrintWriter(System.out));
System.out.printf("defaultCharset: %s%n", Charset.defaultCharset());
System.out.printf("file.encoding : %s%n",
System.getProperty("file.encoding"));
String connectUrl =
"jdbc:oracle:thin:<user>/<password>@<host>:<port>:<sid>";
try (Connection con = DriverManager.getConnection(connectUrl)) {
T4CConnection t4Conn = (T4CConnection) con;
T4C8TTIpro pro = t4Conn.pro;
short oVersion = pro.oVersion;
short svrCharSet = pro.svrCharSet;
short driverCharSet;
try {
driverCharSet = DBConversion.findDriverCharSet(
svrCharSet, oVersion);
} catch (ArrayIndexOutOfBoundsException e) {
System.err.printf("failed to get driver charset: %s%n",
e.getMessage());
driverCharSet = -1;
}
System.out.println("server charset: " + svrCharSet);
System.out.println("driver charset: " + driverCharSet);
Object instance = ReflectionFactory.getReflectionFactory()
.newConstructorForSerialization(
Class.forName("oracle.sql.CharacterSetFactoryThin"),
Object.class.getConstructor())
.newInstance();
for (Field fs : CharacterSet.class.getDeclaredFields()) {
if (fs.getType() == short.class) {
if (fs.getShort(instance) == driverCharSet) {
System.out.printf("charset name : %s%n", fs.getName());
}
}
}
}
}
}编译
mkdir bin
javac -cp ojdbc6_g.jar -d bin/ OJdbcInfo.java跑
java -cp ojdbc6_g.jar:bin/ oracle.jdbc.driver.OJdbcInfo可能输出
defaultCharset: UTF-8
file.encoding : UTF-8
server charset: 873
driver charset: 873
charset name : AL32UTF8_CHARSET在您的情况下，驱动字符集很可能是-1。
检查您使用的是最新的驱动程序版本。
java -jar ojdbc6.jar可能输出
Oracle 11.2.0.4.0 JDBC 4.0 compiled with JDK6 on Thu_Jul_03_18:17:32_PDT_2014检查Linux框上的locale设置。
locale可能的输出(取决于语言设置，但所有值通常应该相同)
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/35718346
复制相关文章
相似问题
腾讯云开发者
