数据库连接问题:开始tomcat连接数据orcal数据库正常,但是安装SQL Server2000后,tomcat就连不上数据库了。
数据库连接问题:开始tomcat连接数据orcal数据库正常,但是安装SQL Server2000后,tomcat就连不上数据库了。orcal和SQL Server200都连接不上。已安装sqlsp3。程序应该没问题,单独安装orcal可以运行,单独安装sql server2000程序都可以正常运行。希望高人指点。
连orcal的异常如下:
AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@1ba4806
)
LogAbandoned: false
RemoveAbandoned: true
RemoveAbandonedTimeout: 60
22:00:02,609 WARN JDBCExceptionReporter:38 - SQL Error: 0, SQLState: null
22:00:02,609 ERROR JDBCExceptionReporter:46 - Cannot create PoolableConnectionFa
ctory
22:00:02,609 ERROR JDBCExceptionReporter:38 - Cannot open connection
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact
ory, cause:
java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:259)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:468) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(Driv
erConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(Poolable
ConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(Bas
icDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:518)
at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnectio
n(DatasourceConnectionProvider.java:59)
at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:286
)
at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3326)
at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3286)
at net.sf.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.ja
va:40)
at net.sf.hibernate.transaction.JDBCTransactionFactory.beginTransaction(
JDBCTransactionFactory.java:19)
at net.sf.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:2
-------------------------------------------
连接Sql Server 2000的异常:
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:203)
ava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
ing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou
ce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
urce)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.sql.ConnectionPool.<init>(ConnectionPool.java:28)
at com.prestige.servlet.command.connectiondb.<init>(connectiondb.java:29
at com.prestige.servlet.command.ContractHistorylistCommand.<init>(Contra
tHistorylistCommand.java:34)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)