I'm using the ojdbc7.jar that is distributed from the Oracle site, and so far it has worked perfectly. Recently, however, we've decided to switch to using a maven structure for our webapp development so I've been converting our Java Web App to maven. Now I'm seeing this oracle.jdbc.driver.T4CConnection.isValid(I)Z error when making an Oracle DB connection even though I'm using the exact same driver file as I was in my non-maven build. I have the dependency declared like this:
我使用ojdbc7。jar來自Oracle站點,到目前為止,它工作得很好。然而,最近,我們決定在webapp開發中使用maven結構,因此我將Java Web應用程序轉換為maven。現在,我看到這個oracle.jdbc.driver. t4cconnect . isvalid (I)Z錯誤在建立Oracle DB連接時發生,盡管我使用的驅動程序文件與在非maven構建中使用的完全相同。我有這樣的聲明:
com.oracle
ojdbc
7
I have manually installed the driver using Netbeans, as the maven depository does not contain the ojdbc7 driver.
我已經使用Netbeans手動安裝了驅動程序,因為maven儲存庫不包含ojdbc7驅動程序。
Why am I seeing this error and what can I do about it? It's clearly a maven related problem seeing as this builds perfectly without maven managing it.
為什么我看到這個錯誤,我該怎么辦?很明顯,這是一個maven相關的問題,因為在沒有maven管理的情況下,這是一個完美的構建。
Stack Trace:
堆棧跟蹤:
org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:913)
org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:226)
org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:302)
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2208)
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2191)
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1945)
org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412)
com.networkfleet.sre.common.db.Resource.getDBConnectionDEV(Resource.java:75)
com.networkfleet.sre.app.checkreport.CheckReportSrv.doGet(CheckReportSrv.java:63)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:614)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2463)
org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2452)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:745)
1 个解决方案
#1
0
You need run maven install-file since maven can't download it.
您需要運行maven安裝文件,因為maven不能下載它。
https://stackoverflow.com/questions/1074869/find-oracle-jdbc-driver-in-maven-repository/1074971 1074971 e