sqle=java.sql.SQLException: No suitable driver found for proxool.net

问题描述

org.apache.tomcat.dbcp.dbcp.SQLNestedException:CannotcreatePoolableConnectionFactory(到主机的TCP/IP连接失败。java.net.ConnectException:Connectionrefused:connect)atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)atcom.wsy.Connsqlserver.getConnection(Connsqlserver.java:29)atcom.wsy.Connsqlserver.executeQuery(Connsqlserver.java:49)atcom.wsy.Selectsql.selectNews(Selectsql.java:138)atorg.apache.jsp.index_jsp._jspService(index_jsp.java:108)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.wsy.Filter.ModifyCode.doFilter(ModifyCode.java:23)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)atorg.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)atorg.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)atorg.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)atjava.lang.Thread.run(Thread.java:619)Causedby:com.microsoft.sqlserver.jdbc.SQLServerException:到主机的TCP/IP连接失败。java.net.ConnectException:Connectionrefused:connectatcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(UnknownSource)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(UnknownSource)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(UnknownSource)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(UnknownSource)atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(UnknownSource)atorg.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)atorg.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)atorg.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)...27morejava.lang.NullPointerExceptionatcom.wsy.Connsqlserver.executeQuery(Connsqlserver.java:51)atcom.wsy.Selectsql.selectNews(Selectsql.java:138)atorg.apache.jsp.index_jsp._jspService(index_jsp.java:108)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.wsy.Filter.ModifyCode.doFilter(ModifyCode.java:23)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)atorg.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)atorg.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)atorg.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)atjava.lang.Thread.run(Thread.java:619)org.apache.jasper.JasperException:AnexceptionoccurredprocessingJSPpage/index.jspatline4239:<tr>40:<tdcolspan="2"rowspan="2"width="405"height="20"><tablewidth="100%"border="0"background="images/17.gif"height="20">41:<%42:Collectiontemp2=sql.selectNews();43:Iteratorit2=temp2.iterator();44:while(it2.hasNext()){45:Newsnews=(News)it2.next();Stacktrace:atorg.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430)atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.wsy.Filter.ModifyCode.doFilter(ModifyCode.java:23)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)atorg.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)atorg.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)atorg.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)atjava.lang.Thread.run(Thread.java:619)Causedby:java.lang.NullPointerExceptionatcom.wsy.Connsqlserver.close(Connsqlserver.java:73)atcom.wsy.Selectsql.selectNews(Selectsql.java:154)atorg.apache.jsp.index_jsp._jspService(index_jsp.java:108)atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)atjavax.servlet.http.HttpServlet.service(HttpServlet.java:723)atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)...18more++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++怎么看Tcp/Ip的端口情况？使用ProxoolConnectionPool连接池。

解决方案

解决方案二：
Proxool.properties数据库sql2000jdbc-0.proxool.alias=netjdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriverjdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://127.0.0.1:7788;DatabaseName=db_netjdbc-0.user=sajdbc-0.password=jdbc-0.proxool.maximum-connection-count=10jdbc-0.proxool.prototype-count=4jdbc-0.proxool.house-keeping-test-sql=selectCURRENT_DATEjdbc-0.proxool.verbose=truejdbc-0.proxool.statistics=10s,1m,1djdbc-0.proxool.statistics-log-level=DEBUG++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++context.xml<?xmlversion='1.0'encoding='utf-8'?><Context><Resourcename="jdbc/ConnectionPool"type="javax.sql.DataSource"auth="Container"driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"url="jdbc:microsoft:sqlserver://127.0.0.1:7788;DatabaseName=db_net"username="sa"password=""maxActive="4"maxIdle="2"maxWait="6000"/></Context><?xmlversion='1.0'encoding='utf-8'?><Context><Resourcename="jdbc/ConnectionPool"type="javax.sql.DataSource"auth="Container"driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"url="jdbc:microsoft:sqlserver://127.0.0.1:7788;DatabaseName=db_net"username="sa"password=""maxActive="4"maxIdle="2"maxWait="6000"/></Context>
解决方案三：
CannotcreatePoolableConnectionFactory(到主机的TCP/IP连接失败。java.net.ConnectException:Connectionrefused:connect)

时间： 2024-11-03 13:59:01

sqle=java.sql.SQLException: No suitable driver found for proxool.net的相关文章

java.sql.SQLException: No suitable driver 问题解决

 最近在学习java,用到c3p0数据库连接池,遇到一个很奇怪的现象,用main方法测试是可以正常连接数据库的,但是使用jsp调用代码,就会报如下图的错误!   最下面的java.sql.SQLException: No suitable driver才是重点 解决办法是将mysql的驱动jar包,放到D:\Program Files\Java\jdk1.8.0_91\jre\lib\ext目录下(JAVA_HOME目录下的jre\lib\ext目录下)   然后就解决了这个问题

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 磁盘或网络错误。

问题描述 java.sql.SQLException:[Microsoft][ODBCMicrosoftAccessDriver]磁盘或网络错误. 解决方案 解决方案二:没有包解决方案三:1.给"系统盘:WindowsServiceProfilesNetworkServiceAppDataLocalTemp"目录添加一个"AuthenticatedUsers"的用户2.检查连接字符串"Provider=Microsoft.Jet.OLEDB.4.0;Dat

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] (未知)不是一个有效的路径

问题描述 ClassjdbcDriver=Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//这里加载驱动,数据库DriverManager.registerDriver((Driver)jdbcDriver.newInstance());Connectioncon=DriverManager.getConnection("jdbc:odbc:driver={MicrosoftAccessDriver(*.mdb,*.accdb)}

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户

问题描述 java.sql.SQLException:[Microsoft][SQLServer2000DriverforJDBC][SQLServer]用户'sa'登录失败.这是连接数据库的代码:packagedatabase;importjava.sql.*;publicclassConnectionDB{publicstaticConnectiongetConnection(){Connectionconn=null;Stringurl="jdbc:sqlserver://localhos

Caused by: java.sql.SQLException: ORA-01861: 文字与格式字符串不匹配

          项目中遇到这样一个问题:                 Caused by:java.sql.SQLException: ORA-01861: 文字与格式字符串不匹配 atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) atoracle.jdbc.

spring-Could not obtain connection metadata java.sql.SQLException: Io exception

问题描述 Could not obtain connection metadata java.sql.SQLException: Io exception 启动tomcat的时候就报下面的错.求大神指引....... 谢谢 [INFO] - Initializing connection provider: org.springframework.orm.hibernate3.TransactionAwareDataSourceConnectionProvider 2013-07-08 16:2

hibernate proxool java.sql.SQLException

问题描述 大家好,我现在在项目中使用了hibernate来连接数据库,使用到的连接池是proxool,但奇怪的是,在tomcat的日志中,每隔一定时间就会出现以下信息:09:02:35,768 DEBUG fm_oracleproxool:431 - 009441 (00/09/00) - #7920 removed because it has problems: java.sql.SQLException: ORA-00923: 未找到要求的 FROM 关键字09:02:36,407 DEB

java.sql.SQLException: 列名无效 [问题点数：25分，结帖人zshzyh] 收藏

问题描述 java.sql.SQLException:列名无效atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.

java.sql.SQLException: Io 异常: 连接超时

问题描述 帮我看看咋回事啊?我搞不懂.就是运行很久的一个项目,最近突然就动不动就登陆不了,然后连首页都显示不出来了.然后只能重启服务,就又没问题了.老师需要重启.帮我看看日志全是这个,是什么意思啊?ERROR 2013-12-06 13:12:20,831 org.logicalcobwebs.proxool.GAP-Pool #0041 encountered errors during destruction: java.sql.SQLException: Io 异常: 连接超时at ora