连接0racle数据库出错
连接数据库的程序为:(连接本地)
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@:1521:ORCL","system","manager");
con.setAutoCommit(false);
jps中调用con总为null
<%
Connection con =null;
con=conbean.getTransactionConnection();
if(con!=null)
out.println("con success!!!");
else
out.println("con fail!!!");//总是执行此句
/////////////
classes12.zip也该成classes12.jar放在tomcat的WEB-INF\lib下,classpath中也设置了路径
错误提示:
java.lang.NullPointerException
at java.net.Socket.<init>(Socket.java:283)
at java.net.Socket.<init>(Socket.java:119)
at oracle.net.nt.TcpNTAdapter.connect(Unknown Source)
at oracle.net.nt.ConnOption.connect(Unknown Source)
at oracle.net.nt.ConnStrategy.execute(Unknown Source)
at oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source
at oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
at oracle.net.ns.NSProtocol.connect(Unknown Source)
at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1120)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:195)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:19
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.
va:251)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.jivesoftware.base.database.ConnectionManager.getTransactionConn
tion(ConnectionManager.java:89)
at org.apache.jsp.test_jsp._jspService(test_jsp.java:74)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapp
.java:204)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java
89)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ap
icationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio
ilterChain.java:193)
at com.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharac
rEncodingFilter.java:40)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Ap
icationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio
ilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrappe
alve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:99
at org.apache.catalina.core.StandardContextValve.invoke(StandardContex
alve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:99
at org.apache.catalina.core.StandardContext.invoke(StandardContext.jav
2396)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve
ava:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatc
rValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont
t.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve
ava:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont
t.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:99
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineV
ve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont
t.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j
a:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:99
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:
3)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.ja
:405)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.pro
ssConnection(Http11Protocol.java:380)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.ja
:508)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Threa
ool.java:533)
at java.lang.Thread.run(Thread.java:536)
%>
问题点数:100、回复次数:8Top
1 楼strawberryyeah(小叶)回复于 2003-01-10 11:34:24 得分 20
你的关于oracle的JDBC的在那里下载的阿Top
2 楼laoer(laoer.com)回复于 2003-01-10 11:35:28 得分 20
classes12.zip不用改为jar,放在tomcat/common/lib下就可以了!Top
3 楼akangcm(梅子)回复于 2003-01-10 12:10:52 得分 0
to: strawberryyeah(小叶)我没有下载JDBC我用的是oracle自带的(装上就有)
to: laoer(laoer) 我刚开始没有改,出上面的错,后来在论坛上有人说tomcat4.0以上要该成classes.jar,结果该了还不行,同样的错,请高手指点
还有可能是哪儿的问题?Top
4 楼yophoo(雅风)回复于 2003-01-10 12:19:48 得分 20
你将oracle的jdbc驱动的jar文件拷到Tomcat的lib中,然后重起Tomcat,再连接试试!!这可能是你的Tomcat启动时没有加载oracle的jdbc驱动造成的。Top
5 楼akangcm(梅子)回复于 2003-01-10 12:41:52 得分 0
我已试过不行,请问
at oracle.net.nt.TcpNTAdapter.connect(Unknown Source)
at oracle.net.nt.ConnOption.connect(Unknown Source)
at oracle.net.nt.ConnStrategy.execute(Unknown Source)
at oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source
at oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
at oracle.net.ns.NSProtocol.connect(Unknown Source)
Unknown Source 是什么意思???是不是oralce 需要配置什么?Top
6 楼zxhong(红透半边天)回复于 2003-01-14 14:02:00 得分 20
http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=439Top
7 楼akangcm(梅子)回复于 2003-01-14 14:10:57 得分 0
可我连接数据库的程序在别人机器上是可以的Top
8 楼dou1204(greenbird)回复于 2003-01-14 15:47:38 得分 20
conbean 放在哪里,建议你全贴出来Top




