这一段没什么问题,关键你Exception都能看错,明明是不能创建连接Exception org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Error preloading the connection pool你第一次调用肯定抛Exception,然后才开始创建连接,没等关闭呢,又调用,当然没问题了
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Error preloading the connection pool你第一次调用肯定抛Exception,然后才开始创建连接,没等关闭呢,又调用,当然没问题了
sqlnet.ora 里只有一句:
#SQLNET.AUTHENTICATION_SERVICES= (NTS)listener.log 有错误日志:
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipepl/sql developer 一直都能连上驱动使用oracle 安装目录下的 ojdbc14.jar 和 ojdbc14_g.jar 也不行
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
还是注释掉的...........NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tcp.validnode_checking=no
你把这两个加上试试
我把连接池换成c3p0了,看来c3p0真的比commons-dbcp好用