起动tomcat时出先的
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:164) -
Database Url: jdbc:microsoft:sqlserver://192.168.1.3:1433;NETADDRESS=0000000000
00;HOSTPROCESS=0;SENDSTRINGPARAMETERSASUNICODE=true;LOGINTIMEOUT=0;DATABASENAME=
DianDianMiBbs;PROGRAMNAME=;SELECTMETHOD=direct;WSID=
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:165) -
Database Username: sa
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:166) -
JDBC Driver Name: SQLServer
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:167) -
JDBC Driver Version: 2.2.0040
2008-04-30 14:39:04,031 ERROR [main] jdbc.MemberDAOImplJDBC (MemberDAOImplJDBC.j
ava:1281) - Sql Execution Error!
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]列
名 'MemberPasswordExpireDate' 无效。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unkn
own Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType
(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown So
urce)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown So
urce)
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getMember(MemberDAOImplJDBC.ja
va:1221)
at com.mvnforum.service.impl.MvnForumLifeCycleServiceImplDefault.context
Initialized(MvnForumLifeCycleServiceImplDefault.java:120)
at com.mvnforum.MVNForumContextListener.contextInitialized(MVNForumConte
xtListener.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
343)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:80
7)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDep
loyer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:701)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
80)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:231
3)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
2008-04-30 14:39:04,078 INFO [main] impl.MvnForumLifeCycleServiceImplDefault (M
vnForumLifeCycleServiceImplDefault.java:125) - Error occured when get Guest
user.
net.myvietnam.mvncore.exception.DatabaseException: Error executing SQL in Member
DAOImplJDBC.getMember_forPublic(pk).
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getMember(MemberDAOImplJDBC.ja
va:1282)
at com.mvnforum.service.impl.MvnForumLifeCycleServiceImplDefault.context
Initialized(MvnForumLifeCycleServiceImplDefault.java:120)
at com.mvnforum.MVNForumContextListener.contextInitialized(MVNForumConte
xtListener.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
343)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:80
7)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDep
loyer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:701)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
80)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:231
3)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
配置文件是这样的
<driver_class_name>com.microsoft.jdbc.sqlserver.SQLServerDriver </driver_class_name>
<database_url>jdbc:microsoft:sqlserver://192.168.1.3:1433;DatabaseName=DianDianMiBbs </database_url>
<database_user>sa </database_user>
<database_password>666666 </database_password>
<max_connection>20 </max_connection>
<max_time_to_wait>2000 </max_time_to_wait>
<minutes_between_refresh>30 </minutes_between_refresh>
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:164) -
Database Url: jdbc:microsoft:sqlserver://192.168.1.3:1433;NETADDRESS=0000000000
00;HOSTPROCESS=0;SENDSTRINGPARAMETERSASUNICODE=true;LOGINTIMEOUT=0;DATABASENAME=
DianDianMiBbs;PROGRAMNAME=;SELECTMETHOD=direct;WSID=
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:165) -
Database Username: sa
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:166) -
JDBC Driver Name: SQLServer
2008-04-30 14:39:04,000 INFO [main] db.DBUtils ( DBUtils.java:167) -
JDBC Driver Version: 2.2.0040
2008-04-30 14:39:04,031 ERROR [main] jdbc.MemberDAOImplJDBC (MemberDAOImplJDBC.j
ava:1281) - Sql Execution Error!
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]列
名 'MemberPasswordExpireDate' 无效。
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unkn
own Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Sour
ce)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType
(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown
Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown So
urce)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown So
urce)
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getMember(MemberDAOImplJDBC.ja
va:1221)
at com.mvnforum.service.impl.MvnForumLifeCycleServiceImplDefault.context
Initialized(MvnForumLifeCycleServiceImplDefault.java:120)
at com.mvnforum.MVNForumContextListener.contextInitialized(MVNForumConte
xtListener.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
343)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:80
7)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDep
loyer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:701)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
80)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:231
3)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
2008-04-30 14:39:04,078 INFO [main] impl.MvnForumLifeCycleServiceImplDefault (M
vnForumLifeCycleServiceImplDefault.java:125) - Error occured when get Guest
user.
net.myvietnam.mvncore.exception.DatabaseException: Error executing SQL in Member
DAOImplJDBC.getMember_forPublic(pk).
at com.mvnforum.db.jdbc.MemberDAOImplJDBC.getMember(MemberDAOImplJDBC.ja
va:1282)
at com.mvnforum.service.impl.MvnForumLifeCycleServiceImplDefault.context
Initialized(MvnForumLifeCycleServiceImplDefault.java:120)
at com.mvnforum.MVNForumContextListener.contextInitialized(MVNForumConte
xtListener.java:83)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3827)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4
343)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:823)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:80
7)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) at org.apache.catalina.core.StandardHostDeployer.install(StandardHostDep
loyer.java:277)
at org.apache.catalina.core.StandardHost.install(StandardHost.java:832)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.j
ava:701)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:432
)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:983)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:349)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1091) at org.apache.catalina.core.StandardHost.start(StandardHost.java:789)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1083) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:478
)
at org.apache.catalina.core.StandardService.start(StandardService.java:4
80)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:231
3)
at org.apache.catalina.startup.Catalina.start(Catalina.java:556)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)
配置文件是这样的
<driver_class_name>com.microsoft.jdbc.sqlserver.SQLServerDriver </driver_class_name>
<database_url>jdbc:microsoft:sqlserver://192.168.1.3:1433;DatabaseName=DianDianMiBbs </database_url>
<database_user>sa </database_user>
<database_password>666666 </database_password>
<max_connection>20 </max_connection>
<max_time_to_wait>2000 </max_time_to_wait>
<minutes_between_refresh>30 </minutes_between_refresh>
名 'MemberPasswordExpireDate' 无效。
没有这个字段
Sql Execution Error!