java连接oracle问题
package cn.jbit.jdbctest;import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.xml.soap.Text;
import org.apache.log4j.Logger;
public class Test {
private static Logger logger=Logger.getLogger(Text.class.getName());
public static void main(String[] args) {
Connection conn=null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception e)
{
logger.error(e);
}
try
{
conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.1:1521:ORCL","ORCL","199612");
System.out.println("建立连接成功!");
}
catch(Exception ex)
{
System.out.println("error");
logger.error(ex);
}
finally
{
try
{
if(null!=conn)
{
conn.close();
System.out.println("关闭连接成功!");
}
}
catch(SQLException e)
{
System.out.println("error");
logger.error(e);
}
}
}
}
帮我看看哪里错了?
报了个十一月 26, 2012 8:47:11 下午 oracle.jdbc.driver.OracleDriver registerMBeans
SEVERE: Error while registering Oracle JDBC Diagnosability MBean.
java.lang.NullPointerException
at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:340)
at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:193)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at cn.jbit.jdbctest.Test.main(Test.java:15)
error
log4j:WARN No appenders could be found for logger (javax.xml.soap.Text).
log4j:WARN Please initialize the log4j system properly.
异常 --------------------编程问答-------------------- 看看oracle的ojdbc14.jar是否未配置正确 --------------------编程问答-------------------- Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.1:1521:ORCL","ORCL","199612");
分别说明意思,详细点,我刚学Orcal --------------------编程问答-------------------- 报错提示你，oracle驱动注册失败，两个原因：
1> 你的驱动包不对，换一个试下；
2> 你的DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.1:1521:ORCL","ORCL","199612");参数不对。 --------------------编程问答--------------------
Class.forName("oracle.jdbc.driver.OracleDriver");就是去加载这个驱动；
DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.1:1521:ORCL","ORCL","199612");
就是从加载的驱动中获得一个Connection连接。 --------------------编程问答--------------------
conn = DriverManager
.getConnection("jdbc:oracle:thin:@localhost:1521:orcl",
"scott", "tiger");
我用这个连接自己的oracle数据库能连接，scott是用户名，tiger是密码，看一下你的驱动是否正确引入。 --------------------编程问答-------------------- 我老师今天帮我好了,,为什么装了myeclipse后不能调试?我装了后myeclipse后一调试就抛异常!1这是为什么? --------------------编程问答-------------------- 你的try catch finally用的太频繁了，可以在网上搜一个比较经典的链接数据库的代码。。这样会比较好一点。
补充：Java , Java相关
