从Java连接到Oracle ...异常 [英] Connecting to Oracle from Java ...Exception
问题描述
我想连接远程Oracle DB,但是出现异常.请帮帮我.我该怎么办?
I want to connect Remote Oracle DB but I have Exception. Help me please. What can I do?
我尝试了这个,但是不起作用:
I tried this but it doesn't work:
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)
推荐答案
您的连接URL格式错误.您正在混合 SID
和 service
格式.
Your connect URL is wrong formatted. You are mixing the SID
and service
format.
任何一个
DriverManager.getConnection(
"jdbc:oracle:thin:<user>/<password>@<host>:<port>:<sid>");
或
DriverManager.getConnection(
"jdbc:oracle:thin:@<host>:<port>:<sid>", "<user>", "<password>");
或者如果您连接到服务而不是SID
or in case you connect to a service instead of a SID
DriverManager.getConnection(
"jdbc:oracle:thin:<user>/<password>@//<host>:<port>/<service");
For an example using a Properties
object have a look into the javadoc of oracle.jdbc.OracleDriver
编辑在此处找到精简样式的服务名称语法
编辑2 启用驱动程序日志记录,以查看是否会有一些有用的消息.
edit 2 Enable driver logging to see if there would be some helpful message there.
OracleLog.setTrace(true);
DriverManager.setLogWriter(new PrintWriter(System.out));
编辑3 这是一种通过反射查找服务器和驱动程序报告哪个字符集的方法.
edit 3 Here a way to find via reflection which charset is reported by the server and driver.
出于许可的原因,软件包声明很重要.
For permission reason the package declaration is important.
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
.
Most probably the driver charset is -1
in your case.
检查您是否正在使用最新的驱动程序版本.
Check that you are using an up-to-date driver version.
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
设置
Check the locale
setting on your Linux box
locale
可能的输出(取决于您的语言设置,但是所有值通常应该相同)
possible output (depends on your language setting, but all values should be normally the same)
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"
这篇关于从Java连接到Oracle ...异常的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!