sql server 的 for xml path查询出错 5C

java web项目中
有代码如下

String sql = "select a.dStareDate from JXZX_EAT_RECORD a where a.iState=1 and a.cCardNickNo='AA0005' for xml path('a')";
        List ll = entityManager.createNativeQuery(sql).getResultList();

结果报出如下错误,在sql server 数据库中可以成功用这段sql查询。
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)
at sun.reflect.GeneratedMethodAccessor216.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:375)
at com.sun.proxy.$Proxy163.getResultList(Unknown Source)
at eiis.app.jxzx.servlet.JXZXCardManageService.getMainInfo(JXZXCardManageService.java:120)
at eiis.app.jxzx.servlet.JXZXCardManageService$$FastClassBySpringCGLIB$$ec286876.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:667)
at eiis.app.jxzx.servlet.JXZXCardManageService$$EnhancerBySpringCGLIB$$2f59bc87.getMainInfo()
at org.apache.jsp.app.jxzx.cardmanage.action_jsp$Action.getMain(action_jsp.java:306)
at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at eiis.util.Reflections.invokeMethod(Reflections.java:102)
... 104 more
Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:196)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:160)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1885)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
at org.hibernate.loader.Loader.doQuery(Loader.java:910)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
at org.hibernate.loader.Loader.doList(Loader.java:2554)
at org.hibernate.loader.Loader.doList(Loader.java:2540)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
at org.hibernate.loader.Loader.list(Loader.java:2365)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:353)
at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1909)
at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:311)
at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:141)
at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)
... 119 more
Caused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :' xml path('a')',expect IDENTIFIER, actual IDENTIFIER path : select a.dStareDate from JXZX_EAT_RECORD a where a.iState=1 and a.cCardNickNo='AA0005' for xml path('a')
at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:726)
at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:254)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928)
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928)
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:331)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:162)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186)
... 135 more
Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :' xml path('a')',expect IDENTIFIER, actual IDENTIFIER path
at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:232)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:407)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:145)
at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620)
at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574)
at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:713)
... 147 more

1个回答

没看出什么明显的问题,你原原本本复制sql到sql server management studio可以查询?
将'a'改一个名字呢?

xsb_20171227
今天是星期五 我就是在sql server management studio里面写好了,确认没问题了才复制到java这边的
7 个月之前 回复
xsb_20171227
今天是星期五 path('') 里面无论是空字符串还是什么都不得行,在sql server management studio里面无论怎样都没问题
7 个月之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
将xml转换为sql

<div class="post-text" itemprop="text"> <p>I need to convert an XML file (about 200 Mb in size) to SQL files and insert them into a MySQL table (one table - it looks like there are about 10 million rows, only a few columns).</p> <ul> <li>Unfortunately, I don't have access to shell / command line tools</li> <li>It looks like I would need to use PHPMyAdmin import tool where the import size is limited to 50mb per upload</li> <li>Or, PHP is enabled via web browsers only, so write a PHP script to execute from the browser. </li> </ul> <p>So, steps are (please let me know if there are better ways to go around):</p> <ul> <li>unpack the file into the server</li> <li>write a PHP script to convert and insert </li> </ul> <p>or </p> <ul> <li>do it locally and use phpadmin to upload them separately</li> </ul> <p>What would be a good way to get this done? any ideas / feedbacks / details are appreciated.</p> </div>

关于mybatis的sqlxml文件中mysql分页问题

当LIMIT #{startNumber},#{showNumber}这样写时会报错。 换成LIMIT 0,10 就不会报错了。什么原因?jdbc驱动jar也换了还是报错。求解。 ``` Database product name cached for DataSource [org.apache.commons.dbcp.BasicDataSource@142bec44]: name is 'MySQL' [org.springframework.jdbc.support.SQLErrorCodesFactory] - SQL error codes for 'MySQL' found [org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator] - Translating SQLException with SQL state '42000', error code '1064', message [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1','15'' at line 4]; SQL was [] for task [ ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1','15'' at line 4 ### The error may exist in file [D:\develop\java\tomcat\webapps\adream\WEB-INF\classes\com\dream\mapping\fixedassets\CommoditySQL.xml] ### The error may involve com.dream.fixedassets.dao.CommodityDao.commodityList-Inline ### The error occurred while setting parameters ### SQL: select * from l_commodity order BY p_number LIMIT ?,? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1','15'' at line 4 ] 六月 10, 2016 11:11:14 上午 org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet [SpringMVC] in context with path [/adream] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1','15'' at line 4 ### The error may exist in file [D:\develop\java\tomcat\webapps\adream\WEB-INF\classes\com\dream\mapping\fixedassets\CommoditySQL.xml] ### The error may involve com.dream.fixedassets.dao.CommodityDao.commodityList-Inline ### The error occurred while setting parameters ### SQL: select * from l_commodity order BY p_number LIMIT ?,? ```

安装SSMS2016报错 版本sql server2016developer

![图片说明](https://img-ask.csdn.net/upload/201607/26/1469519391_623667.jpg) [1F58:22E0][2016-07-26T15:28:10]i001: Burn v3.8.1128.0, Windows v6.3 (Build 9600: Service Pack 0), path: D:\SSMS-Setup-CHS.exe, cmdline: '' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'ProductVersionVar' to value '13.0.15600.2' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'HeaderText' to value '八月 2016' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SubHeaderText' to value 'Microsoft SQL Server Management Studio' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'LicenseTermsUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x804' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'PreviewStatementUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=398120' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SystemLocaleMismatch' to value '安装程序检测到安装程序语言和操作系统语言不匹配。请使用英语语言版本的安装程序,或安装语言包,并通过控制面板中的区域设置更改格式和系统区域设置。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'LcidMismatchWarning' to value '检测到操作系统语言不匹配。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing numeric variable 'InstallerLcid' to value '2052' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'CancelText' to value '取消' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'CloseText' to value '关闭' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'ContinuePastWarningText' to value '要继续吗?' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'InstallText' to value '安装' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'LicenseTermsText' to value '许可条款' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'LoadingPackagesText' to value '正在加载程序包。请稍候...' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'OverallProgressText' to value '总体进度' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'PackageProgressText' to value '程序包进度' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'PrivacyStatementText' to value '隐私声明' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'RepairText' to value '修复' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'RestartText' to value '重启' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupBlockedDescriptionText' to value '出了点问题,导致安装程序无法继续。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupBlockedText' to value '已阻止安装程序' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupCanceledDescriptionText' to value '已取消安装操作。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupCanceledText' to value '已取消安装程序' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupCompletedText' to value '已完成安装程序' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupFailedDescriptionText' to value '安装过程中出错了。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupFailedText' to value '安装失败' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupHelpDescriptionText' to value '/install | /repair | /uninstall | /layout - 在目录中安装、修复、卸载或创建捆绑包的完整本地副本。安装为默认操作。 /passive | /quiet - 在无提示的情况下显示最小 UI 或不显示 UI 和提示。默认显示 UI 和所有提示。 /norestart - 取消任何重启尝试。默认情况下,UI 会在重启前显示提示。 /log log.txt - 在特定文件中生成日志。默认在 %TEMP% 中创建日志文件。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupHelpText' to value '安装程序帮助' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupInstalledText' to value '已成功安装所有指定的组件。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupLayoutText' to value '已完成布局操作。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupLogText' to value '单击此处查看日志文件。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupProgressText' to value '安装进度' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupRepairedText' to value '已成功修复所有指定的组件。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupRestartDescriptionText' to value '需要先重启计算机,然后安装程序才能继续。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupRestartText' to value '需要重启才能完成安装程序。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupUninstalledText' to value '已成功卸载所有指定的组件。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupWarningDescriptionText' to value '以下问题可能会影响已安装的应用程序。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'SetupWarningText' to value '安装警告' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'TermsAndConditionText' to value '单击“安装”按钮,即表示本人接受以下条款:' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'UninstallText' to value '卸载' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'WelcomeInstallText' to value '欢迎使用。单击“安装”,立即开始体验吧。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'YesText' to value '是' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'RestartAlreadyPending' to value '挂起的重启正在阻止完成安装过程。请重启计算机并再次运行安装程序。' [1F58:22E0][2016-07-26T15:28:10]i000: Initializing string variable 'AnotherInstallRunning' to value '由于当前正在运行另一个安装,安装程序被阻止。请先完成另一个安装,然后在必要时重启计算机。' [1F58:22E0][2016-07-26T15:28:11]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\len\AppData\Local\Temp\SsmsSetup\SSMS-Setup-CHS_20160726152811.log' [1F58:22E0][2016-07-26T15:28:11]i000: Setting string variable 'WixBundleOriginalSource' to value 'D:\SSMS-Setup-CHS.exe' [1F58:22E0][2016-07-26T15:28:11]i000: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Management Studio - 八月 2016' [1F58:22E0][2016-07-26T15:28:11]i000: Loading managed bootstrapper application. [1F58:22E0][2016-07-26T15:28:11]i000: Creating BA thread to run asynchronously. [1F58:14B8][2016-07-26T15:28:11]i000: ManagedBootstrapperApp.Run: Launcing the managed bootstrapper application. [1F58:14B8][2016-07-26T15:28:11]i000: BootstrapperMetadataModel.Initialize: Start loading the bootstrapper app data xml file [1F58:14B8][2016-07-26T15:28:11]i000: BootstrapperMetadataModel.Initialize: Completed loading the bootstrapper app data xml file content: <BootstrapperApplicationData xmlns="http://schemas.microsoft.com/wix/2010/BootstrapperApplicationData"> <WarningCondition Condition="(WixBundleInstalled OR NOT(SqlEngineCoreExists_x86) OR NOT(DatabaseEngineVersion_x86 &lt;&lt; &quot;13&quot;) OR DatabaseEngineVersion_x86 &gt;= &quot;13.0.1601.5&quot;)" Message="SSMS 安装程序在此计算机上检测到共享组件。如果继续安装,那么 SQL Server 等应用程序可能会受到共享组件更新的影响。" /> <WarningCondition Condition="(WixBundleInstalled OR NOT(SqlEngineCoreExists_x64) OR NOT(DatabaseEngineVersion_x64 &lt;&lt; &quot;13&quot;) OR DatabaseEngineVersion_x64 &gt;= &quot;13.0.1601.5&quot;)" Message="SSMS 安装程序在此计算机上检测到共享组件。如果继续安装,那么 SQL Server 等应用程序可能会受到共享组件更新的影响。" /> <WixBalCondition Condition="RebootPending = 0" Message="安装程序检测到有一个挂起的计算机重启操作。请重启计算机,然后再次运行安装程序" /> <WixBalCondition Condition="(VersionNT = v6.1 AND ServicePackLevel = 1) OR VersionNT &gt; v6.1" Message="不支持当前操作系统。此应用程序至少需要 Windows 7 SP1 或 Windows Server 2008 R2 SP1 才能运行。" />

请教一下,到底我的mapper.xml哪里出错了,弄不明白为什么找不到我写的log类

## update一下经大佬提点后如何解决的 可能因为我曾用粗暴的方法改动过Log.java的类名,导致Log类编译出问题了,编译后类文件夹内根本没有Log.class文件。于是我又粗暴地delete了Log类重写了一次,果然没问题了。 顺便百度了一下如何修改类名 https://zhidao.baidu.com/question/340215163.html ## 原问题如下 小白入门程序媛,这个是一个mybatis的关于银行转账的小练习 在写log部分之前,我写的account部分测试过是没有问题的,转账的业务也成功了的。现在是想增加一个记录日志的操作,在数据库log表格添加转账记录,并且利用log4j在硬盘生成log file中记录转账信息。 可是按照同样的套路写了了log实体类后再写logmapper.xml,却出现了以下的错误,后来干脆连mybatis中的别名的部分都去掉了,直接在mapper.xml中使用完整的类名,还是说找不到我写的log类。实在搞不懂是namespace出错了还是怎么滴。。。。 ## 错误信息如下: ``` 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Server version: Apache Tomcat/8.5.42 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Server built: Jun 4 2019 20:29:04 UTC 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Server number: 8.5.42.0 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: OS Name: Windows 10 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: OS Version: 10.0 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Architecture: amd64 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Java Home: C:\Program Files\Java\jdk1.8.0_201\jre 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: JVM Version: 1.8.0_201-b09 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: JVM Vendor: Oracle Corporation 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: CATALINA_BASE: D:\eclipse-workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: CATALINA_HOME: D:\apache-tomcat-8.5.42 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dcatalina.base=D:\eclipse-workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dcatalina.home=D:\apache-tomcat-8.5.42 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dwtp.deploy=D:\eclipse-workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Djava.endorsed.dirs=D:\apache-tomcat-8.5.42\endorsed 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dfile.encoding=UTF-8 七月 13, 2019 8:47:00 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent 信息: Loaded APR based Apache Tomcat Native library [1.2.21] using APR version [1.6.5]. 七月 13, 2019 8:47:00 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent 信息: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true]. 七月 13, 2019 8:47:00 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent 信息: APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true] 七月 13, 2019 8:47:00 下午 org.apache.catalina.core.AprLifecycleListener initializeSSL 信息: OpenSSL successfully initialized [OpenSSL 1.1.1a 20 Nov 2018] 七月 13, 2019 8:47:00 下午 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["http-nio-8080"] 七月 13, 2019 8:47:00 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector 信息: Using a shared selector for servlet write/read 七月 13, 2019 8:47:00 下午 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["ajp-nio-8009"] 七月 13, 2019 8:47:00 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector 信息: Using a shared selector for servlet write/read 七月 13, 2019 8:47:00 下午 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 828 ms 七月 13, 2019 8:47:00 下午 org.apache.catalina.core.StandardService startInternal 信息: Starting service [Catalina] 七月 13, 2019 8:47:00 下午 org.apache.catalina.core.StandardEngine startInternal 信息: Starting Servlet Engine: Apache Tomcat/8.5.42 七月 13, 2019 8:47:01 下午 org.apache.jasper.servlet.TldScanner scanJars 信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time. 七月 13, 2019 8:47:02 下午 org.apache.coyote.AbstractProtocol start 信息: Starting ProtocolHandler ["http-nio-8080"] 七月 13, 2019 8:47:02 下午 org.apache.coyote.AbstractProtocol start 信息: Starting ProtocolHandler ["ajp-nio-8009"] 七月 13, 2019 8:47:02 下午 org.apache.catalina.startup.Catalina start 信息: Server startup in 1377 ms 七月 13, 2019 8:47:32 下午 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet [yan.ibbie.servlet.TransferServlet] in context with path [/bank] threw exception org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ### The error may exist in yan/ibbie/mapper/logmapper.xml ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'yan/ibbie/mapper/logmapper.xml'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'yan.ibbie.pojo.Log'. Cause: java.lang.ClassNotFoundException: Cannot find class: yan.ibbie.pojo.Log at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:80) at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64) at yan.ibbie.service.Impl.AccountServiceImpl.transfer(AccountServiceImpl.java:23) at yan.ibbie.servlet.TransferServlet.service(TransferServlet.java:36) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'yan/ibbie/mapper/logmapper.xml'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'yan.ibbie.pojo.Log'. Cause: java.lang.ClassNotFoundException: Cannot find class: yan.ibbie.pojo.Log at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:121) at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:99) at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:78) ... 26 more Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'yan/ibbie/mapper/logmapper.xml'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'yan.ibbie.pojo.Log'. Cause: java.lang.ClassNotFoundException: Cannot find class: yan.ibbie.pojo.Log at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:120) at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:92) at org.apache.ibatis.builder.xml.XMLConfigBuilder.mapperElement(XMLConfigBuilder.java:373) at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:119) ... 28 more Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias 'yan.ibbie.pojo.Log'. Cause: java.lang.ClassNotFoundException: Cannot find class: yan.ibbie.pojo.Log at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:118) at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:68) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:135) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128) at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118) ... 31 more Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'yan.ibbie.pojo.Log'. Cause: java.lang.ClassNotFoundException: Cannot find class: yan.ibbie.pojo.Log at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:120) at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:149) at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:116) ... 35 more Caused by: java.lang.ClassNotFoundException: Cannot find class: yan.ibbie.pojo.Log at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:200) at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89) at org.apache.ibatis.io.Resources.classForName(Resources.java:261) at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:116) ... 37 more ``` ## mybatis.xml如下: ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> <setting name="logImpl" value="LOG4J"/> </settings> <!-- default填默认使用的environment的id --> <environments default="default"> <!-- environment标签声明一个环境 --> <environment id="default"> <!-- type="JDBC"表示使用原生JDBC事务 --> <transactionManager type="JDBC"></transactionManager> <dataSource type="POOLED"> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/ssm?serverTimezone=GMT%2B8"/> <property name="username" value="root"/> <property name="password" value="1233210"/> </dataSource> </environment> </environments> <mappers> <mapper resource="yan/ibbie/mapper/accountmapper.xml"/> <mapper resource="yan/ibbie/mapper/logmapper.xml"/> </mappers> </configuration> ``` ## accountmapper.xml如下: ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="yan.ibbie.mapper.accountmapper"> <!-- 根据账号和密码查询账户信息 --> <select id="selByAccnoPassword" resultType="yan.ibbie.pojo.Account" parameterType="yan.ibbie.pojo.Account"> select * from account where accno=#{accNo} and password=#{password} </select> <!-- 根据账号和姓名查询账户信息 --> <select id="selByAccnoName" resultType="yan.ibbie.pojo.Account" parameterType="yan.ibbie.pojo.Account"> select * from account where accno=#{accNo} and name=#{name} </select> <!-- 根据账号修改账户余额 --> <update id="updBalanceByAccno" parameterType="yan.ibbie.pojo.Account"> update account set balance=balance+#{balance} where accno=#{accNo} </update> </mapper> ``` ## logmapper.xml如下: ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="yan.ibbie.mapper.logmapper"> <insert id="insLog" parameterType="yan.ibbie.pojo.Log"> insert into log values(default,#{accOut},#{accIn},#{money}) </insert> </mapper> ``` ## yan.ibbie.pojo.log如下 ``` package yan.ibbie.pojo; public class Log { private int id; private String accOut; private String accIn; private double money; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getAccOut() { return accOut; } public void setAccOut(String accOut) { this.accOut = accOut; } public String getAccIn() { return accIn; } public void setAccIn(String accIn) { this.accIn = accIn; } public double getMoney() { return money; } public void setMoney(double money) { this.money = money; } } ``` ## AccountServiceImpl如下: ``` package yan.ibbie.service.Impl; import java.io.IOException; import java.io.InputStream; import java.util.Date; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import com.sun.istack.internal.logging.Logger; import yan.ibbie.pojo.Account; import yan.ibbie.pojo.Log; import yan.ibbie.service.AccountService; public class AccountServiceImpl implements AccountService { @Override public int transfer(Account accIn, Account accOut) throws IOException { InputStream is = Resources.getResourceAsStream("mybatis.xml"); SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is); SqlSession session = factory.openSession(); Account accOutSelect = session.selectOne("yan.ibbie.mapper.accountmapper.selByAccnoPassword",accOut); if (accOutSelect!=null) { if(accOutSelect.getBalance()>=accOut.getBalance()) { Account accInSelect = session.selectOne("yan.ibbie.mapper.accountmapper.selByAccnoName",accIn); if (accInSelect!=null) { accIn.setBalance(accOut.getBalance()); accOut.setBalance(-accOut.getBalance()); int index=session.update("yan.ibbie.mapper.accountmapper.updBalanceByAccno", accOut); index += session.update("yan.ibbie.mapper.accountmapper.updBalanceByAccno",accIn); if (index==2) { Log log = new Log(); log.setAccOut(accOut.getAccNo()); log.setAccIn(accIn.getAccNo()); log.setMoney(accIn.getBalance()); session.update("yan.ibbie.mapper.logmapper.insLog", log); Logger logger = Logger.getLogger(AccountServiceImpl.class); logger.info(log.getAccOut()+"给"+log.getAccIn()+ "在"+new Date().toLocaleString()+"转了"+log.getMoney()); session.commit(); session.close(); return SUCCESS; }else { session.rollback(); session.close(); return ERROR; } }else { return ACCOUNT_NAME_NOT_MATCH; } }else { return ACCOUNT_BALANCE_NOT_ENOUGHT; } }else { return ACCOUNT_PASSWORD_NOT_MATCH; } } } ```

ssm pageheleper 模糊查询语句出错

@RequestMapping("mohu") public String mohuchaxun(@RequestParam(value="pn",defaultValue="1")Integer pn,Model model,books bk){ //从第一条开始 每页查询五条数据 PageHelper.startPage(pn, 3); List<books> users = userService.mohu(bk); System.out.println("测试集合有没有获取到数据"+bk.getBookuser()); System.out.println("大小"+users.size()); //将用户信息放入PageInfo对象里 PageInfo page1 = new PageInfo(users,7); model.addAttribute("pageInfo2", page1); return "mohu"; } -----------------------------------------------------------------controller <select id="mohu" parameterType="books" resultType="books"> select * from books where bookuser LIKE '%' #{bookuser} '%' </select> -------------------------------------------------------------------dao.xml <c:forEach items="${pageInfo2.list }" var="user"> <tr> <td>${user.bid}</td> <td>${user.bookuser }</td> <td>${user.booktype }</td> <td><img src="${user.bookimg}" width="200" height="100" ></td> <!-- <td><img src="${user.bookimg}" width="200" height="300" ></td> --> <!-- <td><a class="edit">编辑</a> <a class="delete">删除</a></td> --> </tr> </c:forEach> </table> </div> </div> <hr style="height:1px;border:none;border-top:1px solid #ccc;" /> <!-- 分页导航栏 --> <!-- 分页信息 --> <div class="row"> <!-- 分页文字信息,其中分页信息都封装在pageInfo中 --> <div class="col-md-6"> 当前第:${pageInfo2.pageNum}页,总共:${pageInfo2.pages}页,总共:${pageInfo2.total}条记录 </div> <!-- 分页条 --> <div class="col-md-6"> <nav aria-label="Page navigation"> <ul class="hvtulli" style="list-style-type:none"> <li><a href="${path}/user/mohu?pn=1">首页</a></li> <c:if test="${pageInfo2.hasPreviousPage }"> <li> <a href="${path}/user/mohu?pn=${pageInfo2.pageNum-1}" aria-label="Previous"> <span aria-hidden="true">上一页</span> </a> </li> </c:if> <c:forEach items="${pageInfo2.navigatepageNums }" var="page_Num"> <c:if test="${page_Num == pageInfo2.pageNum }"> <li class="active"><a href="#">${ page_Num}</a></li> </c:if> <c:if test="${page_Num != pageInfo2.pageNum }"> <li><a href="${path}/user/mohu?pn=${ page_Num}">${ page_Num}</a></li> </c:if> </c:forEach> <c:if test="${pageInfo2.hasNextPage }"><a href="${path}/user/mohu?pn=${pageInfo2.pageNum+1}" aria-label="Next">下一页 </a> </c:if> <a href="${path}/user/mohu?pn=${pageInfo2.pages}">末页</a> -----------------------------------------------------------jsp 普通的查询这样都可以做到。 但是这个模糊查询,点击首页或者末页就会报错, Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null '%') tmp_count' at line 2 ### The error may exist in com/ssm/dao/Userdao.xml ### The error may involve com.ssm.dao.Userdao.mohu-Inline ### The error occurred while setting parameters ### SQL: select count(0) from (select * from books where bookuser LIKE '%' ? '%') tmp_count 知道是sql的错误, 请大神帮我看看怎么办。 我是初学者。

碰到no suitable driver found for jdbc:mysql//localhost:3306/qzhao 错误

我在家里的电脑上用eclipse建了一个简单的hibernate工程. 运行的时候碰到no suitable driver found for jdbc:mysql//localhost:3306/qzhao 异常。 我在网上搜了很多答案,比如把jar放在jre/lib/ext下面,都不行。 奇怪的是在我单位工作电脑上,同样的项目就能work。也没有把jar包放在jre下面。我家里用的是win7,jdk装在C:\pogram files下面。连接配置都是好的。还有家里mysql是和eclipse装在同一台电脑上。工作单位是在服务器上。 请高手解释?昨晚折腾了一夜。最后网速暴慢就睡觉了。 [b]问题补充:[/b] 我的不是一个web程序,就是一个普通的eclipse java project。我已经把jar加到eclipse project里面了。而且用这个jar包用一般的java code可以连接啊 [b]问题补充:[/b] 谢谢各位的答案 出现这样的情况,一般有四种原因: 一:连接URL格式出现了问题(Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX") [qzhao]:我的配置如下: <!-- Database connection settings --> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://10.111.3.244:3306/qzhao_opbook</property> <property name="connection.username">qzhao</property> <property name="connection.password">qzhao</property> <!-- JDBC connection pool (use the built-in) --> <property name="connection.pool_size">1</property> <!-- SQL dialect --> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <!-- Enable Hibernate's automatic session context management --> <property name="current_session_context_class">thread</property> <!-- Disable the second-level cache --> <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <!-- Echo all executed SQL to stdout --> <property name="show_sql">true</property> <!-- Drop and re-create the database schema on startup --> <property name="hbm2ddl.auto">update</property> <mapping resource="org/hibernate/tutorial/domain/Event.hbm.xml" /> 而且在我单位电脑能work 二:驱动字符串出错(com.mysql.jdbc.Driver) 三:Classpath中没有加入合适的mysql_jdbc驱动(驱动要和你的数据库版本一致) 这个我用的是mysql-connector-java-5.0.4-bin.jar,数据库是5.0 四:驱动jar包放的位置不对 我把它加到eclipse project build path里面的。同样在单位电脑上可以工作的。所以我很疑惑,难道是因为家里的电脑jdk路径下面有空格或者是win7的原因?? [b]问题补充:[/b] 问题找到了,是url错了。 分就给walsh吧

eclipse tomcat启动出错 求教 困扰整整一天了,跪求大神解答

最开始我是安装了两个eclipse的,但是只有eclipse neon部署了tomcat服务器,开始是好使的,也能用,然后不知怎么的出现下面这个错误了。我找了很久也没解决,最后用另一个eclipse mars部署了就可以,然后我还是想用回neon,又试了试,发现刚部署后没添加项目的时候能启动server,但是添加了项目后就不可以了,而且eclipse mars也不行了,卸载neon也不,重装tomcat都不行。求解答。很困扰。。。。 ![图片说明](https://img-ask.csdn.net/upload/201610/27/1477553304_256699.png) 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Server version: Apache Tomcat/8.0.37 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Server built: Sep 1 2016 10:01:52 UTC 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Server number: 8.0.37.0 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: OS Name: Windows 10 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: OS Version: 10.0 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Architecture: amd64 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Java Home: D:\JAVA\JDK1.8\jre 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: JVM Version: 1.8.0_71-b15 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: JVM Vendor: Oracle Corporation 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: CATALINA_BASE: D:\Eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: CATALINA_HOME: D:\tomcat\apache-tomcat-8.0.37-windows-x64 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dcatalina.base=D:\Eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dcatalina.home=D:\tomcat\apache-tomcat-8.0.37-windows-x64 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dwtp.deploy=D:\Eclipse\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\webapps 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Djava.endorsed.dirs=D:\tomcat\apache-tomcat-8.0.37-windows-x64\endorsed 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Dfile.encoding=GBK 十月 27, 2016 3:25:10 下午 org.apache.catalina.startup.VersionLoggerListener log 信息: Command line argument: -Xbootclasspath:D:\JAVA\JRE\lib\resources.jar;D:\JAVA\JRE\lib\rt.jar;D:\JAVA\JRE\lib\jsse.jar;D:\JAVA\JRE\lib\jce.jar;D:\JAVA\JRE\lib\charsets.jar;D:\JAVA\JRE\lib\jfr.jar;D:\JAVA\JRE\lib\ext\access-bridge-64.jar;D:\JAVA\JRE\lib\ext\cldrdata.jar;D:\JAVA\JRE\lib\ext\dnsns.jar;D:\JAVA\JRE\lib\ext\jaccess.jar;D:\JAVA\JRE\lib\ext\jfxrt.jar;D:\JAVA\JRE\lib\ext\localedata.jar;D:\JAVA\JRE\lib\ext\nashorn.jar;D:\JAVA\JRE\lib\ext\sunec.jar;D:\JAVA\JRE\lib\ext\sunjce_provider.jar;D:\JAVA\JRE\lib\ext\sunmscapi.jar;D:\JAVA\JRE\lib\ext\sunpkcs11.jar;D:\JAVA\JRE\lib\ext\zipfs.jar 十月 27, 2016 3:25:10 下午 org.apache.catalina.core.AprLifecycleListener lifecycleEvent 信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\JAVA\JDK1.8\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;D:\Java\jdk1.8\bin;D:\Java\jdk1.8\jre\bin;D:\Appserv\Apache24\bin;C:\winrun;D:\appcan\AppCanStudioPersonalV3.3\AppCan-IDE\jre\bin\;D:\appcan\AppCanStudioPersonalV3.3\HDK\emulator\mas\;;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;D:\Program Files\AMD\ATI.ACE\Core-Static;C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;D:\Appserv\MySQL\bin;C:\Users\zm\AppData\Local\Microsoft\WindowsApps;;. 十月 27, 2016 3:25:10 下午 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["http-nio-8080"] 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector 信息: Using a shared selector for servlet write/read 十月 27, 2016 3:25:11 下午 org.apache.coyote.AbstractProtocol init 信息: Initializing ProtocolHandler ["ajp-nio-8009"] 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.net.NioSelectorPool getSharedSelector 信息: Using a shared selector for servlet write/read 十月 27, 2016 3:25:11 下午 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 1814 ms 十月 27, 2016 3:25:11 下午 org.apache.catalina.core.StandardService startInternal 信息: Starting service Catalina 十月 27, 2016 3:25:11 下午 org.apache.catalina.core.StandardEngine startInternal 信息: Starting Servlet Engine: Apache Tomcat/8.0.37 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [web-jsptaglibrary_1_1.dtd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [web-jsptaglibrary_1_2.dtd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [web-jsptaglibrary_2_0.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [jsp_2_0.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [web-jsptaglibrary_2_1.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [jsp_2_1.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [jsp_2_2.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [web-app_3_1.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [web-fragment_3_1.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [web-common_3_1.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [javaee_7.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [jsp_2_3.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [javaee_web_services_1_4.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:11 下午 org.apache.tomcat.util.descriptor.DigesterFactory locationFor 警告: The XML schema [javaee_web_services_client_1_4.xsd] could not be found. This is very likely to break XML validation if XML validation is enabled. 十月 27, 2016 3:25:12 下午 org.apache.catalina.core.ContainerBase startInternal 严重: A child container failed during start

这个错误是出在哪里?是实体层有问题吗

Error creating bean with name 'basDictAction' defined in class path resource [applicationContext.xml]: Cannot resolve reference to bean 'basDictService' while setting bean property 'basDictService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'basDictService' defined in class path resource [applicationContext.xml]: Cannot resolve reference to bean 'basDictDao' while setting bean property 'basdictdao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'basDictDao' defined in class path resource [applicationContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [applicationContext.xml]: Invocation of init method failed; nested exception is org.hibernate.MappingException: Repeated column in mapping for entity: com.hr.entity.CstCustomer column: cust_level (should be mapped with insert="false" update="false")

maven 项目导入的问题

在导入 maven 项目时 pom.xml --> run as --> maven install 出现下面问题!对maven 不太了解,是个新手 [code="java"] [INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Building Herbalife Maven Webapp [INFO] [INFO] Id: com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT [INFO] task-segment: [install] [INFO] ------------------------------------------------------------------------ [INFO] [resources:resources] [INFO] Using default encoding to copy filtered resources. url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/opensymphony/xwork/2.0.4/xwork-2.0.4.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/dojo/dojo/0.0/dojo-0.0.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/fckeditor/fckeditor/2.3/fckeditor-2.3.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/sqlserver/msbase/1.0/msbase-1.0.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/sqlserver/mssqlserver/1.0/mssqlserver-1.0.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/sqlserver/msutil/1.0/msutil-1.0.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/opensymphony/jsonplugin/0[1].16-1.5/jsonplugin-0[1].16-1.5.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/unitils/unitils/1.0-rc-1/unitils-1.0-rc-1.pom url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/opensymphony/xwork/2.0.4/xwork-2.0.4.jar url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/dojo/dojo/0.0/dojo-0.0.jar url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/fckeditor/fckeditor/2.3/fckeditor-2.3.jar url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/sqlserver/msbase/1.0/msbase-1.0.jar url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/sqlserver/mssqlserver/1.0/mssqlserver-1.0.jar url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/sqlserver/msutil/1.0/msutil-1.0.jar url = http://repo1.maven.org/maven2 Downloading: http://repo1.maven.org/maven2/opensymphony/jsonplugin/0[1].16-1.5/jsonplugin-0[1].16-1.5.jar [ERROR] Transitive dependency resolution for scope: compile has failed for your project. Error message: Missing: ---------- 1) opensymphony:xwork:jar:2.0.4 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=opensymphony -DartifactId=xwork -Dversion=2.0.4 -Dpackaging=jar -Dfile=/path/to/file Alternatively, if you host your own repository you can deploy the file there: mvn deploy:deploy-file -DgroupId=opensymphony -DartifactId=xwork -Dversion=2.0.4 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] -DrepositoryId=[id] Path to dependency: 1) com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT 2) opensymphony:xwork:jar:2.0.4 2) dojo:dojo:jar:0.0 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=dojo -DartifactId=dojo -Dversion=0.0 -Dpackaging=jar -Dfile=/path/to/file Alternatively, if you host your own repository you can deploy the file there: mvn deploy:deploy-file -DgroupId=dojo -DartifactId=dojo -Dversion=0.0 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] -DrepositoryId=[id] Path to dependency: 1) com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT 2) dojo:dojo:jar:0.0 3) fckeditor:fckeditor:jar:2.3 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=fckeditor -DartifactId=fckeditor -Dversion=2.3 -Dpackaging=jar -Dfile=/path/to/file Alternatively, if you host your own repository you can deploy the file there: mvn deploy:deploy-file -DgroupId=fckeditor -DartifactId=fckeditor -Dversion=2.3 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] -DrepositoryId=[id] Path to dependency: 1) com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT 2) fckeditor:fckeditor:jar:2.3 4) sqlserver:msbase:jar:1.0 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=sqlserver -DartifactId=msbase -Dversion=1.0 -Dpackaging=jar -Dfile=/path/to/file Alternatively, if you host your own repository you can deploy the file there: mvn deploy:deploy-file -DgroupId=sqlserver -DartifactId=msbase -Dversion=1.0 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] -DrepositoryId=[id] Path to dependency: 1) com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT 2) sqlserver:msbase:jar:1.0 5) sqlserver:mssqlserver:jar:1.0 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=sqlserver -DartifactId=mssqlserver -Dversion=1.0 -Dpackaging=jar -Dfile=/path/to/file Alternatively, if you host your own repository you can deploy the file there: mvn deploy:deploy-file -DgroupId=sqlserver -DartifactId=mssqlserver -Dversion=1.0 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] -DrepositoryId=[id] Path to dependency: 1) com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT 2) sqlserver:mssqlserver:jar:1.0 6) sqlserver:msutil:jar:1.0 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=sqlserver -DartifactId=msutil -Dversion=1.0 -Dpackaging=jar -Dfile=/path/to/file Alternatively, if you host your own repository you can deploy the file there: mvn deploy:deploy-file -DgroupId=sqlserver -DartifactId=msutil -Dversion=1.0 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] -DrepositoryId=[id] Path to dependency: 1) com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT 2) sqlserver:msutil:jar:1.0 7) opensymphony:jsonplugin:jar:0[1].16-1.5 Try downloading the file manually from the project website. Then, install it using the command: mvn install:install-file -DgroupId=opensymphony -DartifactId=jsonplugin -Dversion=0[1].16-1.5 -Dpackaging=jar -Dfile=/path/to/file Alternatively, if you host your own repository you can deploy the file there: mvn deploy:deploy-file -DgroupId=opensymphony -DartifactId=jsonplugin -Dversion=0[1].16-1.5 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url] -DrepositoryId=[id] Path to dependency: 1) com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT 2) opensymphony:jsonplugin:jar:0[1].16-1.5 ---------- 7 required artifacts are missing. for artifact: com.herbalife.webapp:herbalife:war:1.0-SNAPSHOT from the specified remote repositories: central (http://repo1.maven.org/maven2) Group-Id: com.herbalife.webapp Artifact-Id: herbalife Version: 1.0-SNAPSHOT From file: D:\workspace\herbal-report\pom.xml [INFO] ------------------------------------------------------------------------ [INFO] For more information, run with the -e flag [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILED [INFO] ------------------------------------------------------------------------ [INFO] Total time: 13 seconds [INFO] Finished at: Fri Nov 20 13:49:19 CST 2009 [INFO] Final Memory: 2M/11M [INFO] ------------------------------------------------------------------------ [/code] [b]问题补充:[/b] D:\Downloads\xwork-2.0.4.jar 默认下载到什么地方了!这么多jar 包要一个一个导吗? 谢谢 [b]问题补充:[/b] 只剩下3 分了! :oops: 没有人知道吗??? [b]问题补充:[/b] 请问? cwx714 私服怎么建?? 我机子上的 repository 库算什么? 有没有参照的例子? 感激不尽! [img]http://dl.iteye.com/upload/attachment/171204/5b564360-105f-3cb7-96cb-4512a932b7e4.jpg[/img] [b]问题补充:[/b] 建私服太麻烦了,用 mvn 命令创建项目时为什么能自动下载对应jar 包,而导入项目时为什么就下载出错?

ssms安装失败是怎么回事啊

第一次安装时由于其他软件正在安装,导致安装失败。现在每次安装时都是这个样子 ![图片说明](https://img-ask.csdn.net/upload/201906/30/1561858582_371795.png) 日志: [2F6C:2804][2019-06-30T09:36:38]i001: Burn v3.8.1128.0, Windows v6.3 (Build 9600: Service Pack 0), path: C:\Users\鲁元博\Downloads\SSMS-Setup-CHS (1).exe, cmdline: '-burn.unelevated BurnPipe.{0A675724-EDF1-4111-B250-5037B43ED2B1} {A79C7EF2-219A-402E-866A-D7013734C967} 12992' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SSMSINSTALLROOT' to value '[ProgramFilesFolder]Microsoft SQL Server Management Studio 18' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SSMSInstallExists' to value '0' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SSMSInstalledLanguageMatch' to value 'false' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SSMS18PreReleaseDetected' to value 'false' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SSMS18InstalledVersion' to value '' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'ProductVersionVar' to value '15.0.18131.0' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'HeaderText' to value '版本 18.1' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SubHeaderText' to value 'Microsoft SQL Server Management Studio' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'LicenseTermsUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=620835&clcid=0x[System.Convert]::ToInt32(2052)' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'PreviewStatementUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=824140' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'TelemetryDocumentationUrl' to value 'https://go.microsoft.com/fwlink/?LinkID=869476' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing numeric variable 'InstallerLcid' to value '2052' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'CancelText' to value '取消' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'CloseText' to value '关闭(_C)' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'ContinuePastWarningText' to value '是否要继续?' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'InstallText' to value '安装(_I)' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'LicenseTermsText' to value '许可条款' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'LoadingPackagesText' to value '正在加载程序包。请稍候...' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'OverallProgressText' to value '总体进度' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'PackageProgressText' to value '程序包进度' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'PrivacyStatementText' to value '隐私声明' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'TelemetryDocumentationText' to value '文档' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'PrivacyDisclaimerText' to value '为了有助于改进产品,SQL Server Management Studio 会向 Microsoft 传输安装体验信息,以及其他使用情况和性能数据。若要详细了解数据处理和隐私控制,以及在安装后禁用收集此信息,请参阅 {documentation}。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'RepairText' to value '修复' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'RestartText' to value '重新启动' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupBlockedDescriptionText' to value '出了点问题,导致安装程序无法继续。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupBlockedText' to value '已阻止安装程序' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupCanceledDescriptionText' to value '已取消安装操作。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupCanceledText' to value '已取消安装程序' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupCompletedText' to value '已完成安装程序' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupFailedDescriptionText' to value '安装过程中出错了。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupFailedText' to value '安装失败' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupHelpDescriptionText' to value '/install | /repair | /uninstall - 安装、修复或卸载。安装为默认操作。 /passive | /quiet - 在无提示的情况下显示最小 UI 或不显示 UI 和提示。默认显示 UI 和所有提示。 /norestart - 取消任何重启尝试。默认情况下,UI 会在重启前显示提示。 /log <日志文件前缀> - SSMS 安装程序日志的前缀。默认在 %TEMP%\SSMSSetup 下创建日志文件。 SSMSInstallRoot=<SSMS 位置的路径>。 默认情况下为 {0}。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupHelpText' to value '安装程序帮助' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupInstalledText' to value '已成功安装所有指定的组件。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupLayoutText' to value '已完成布局操作。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupLogText' to value '单击此处查看日志文件。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupProgressText' to value '安装进度' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupRepairedText' to value '已成功修复所有指定的组件。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupRestartDescriptionText' to value '需要先重启计算机,然后安装程序才能继续。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupRestartText' to value '需要重启才能完成安装程序。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupUninstalledText' to value '已成功卸载所有指定的组件。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupWarningDescriptionText' to value '以下问题可能会影响已安装的应用程序。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SetupWarningText' to value '安装警告' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'TermsAndConditionText' to value '单击“安装”按钮即表明本人接受 {License Terms} 和 {Privacy Statement}。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'UninstallText' to value '卸载' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'WelcomeInstallText' to value '欢迎使用。单击“安装”,立即开始体验吧。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'YesText' to value '是' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'RestartAlreadyPending' to value '挂起的重启正在阻止完成安装过程。请重启计算机并再次运行安装程序。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'AnotherInstallRunning' to value '由于当前正在运行另一个安装,安装程序被阻止。请先完成另一个安装,然后在必要时重启计算机。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'SSMSCurrentlyRunning' to value 'SSMS 当前正在运行。请关闭 SSMS 所有已打开的实例并重新运行此安装程序。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'MinimizeButtonAccessibleName' to value '最小化' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'Win10OrWS2016NotSupported' to value '不支持此版本的 Windows 10 或 Windows Server 2016。请升级到版本 1607 或更高版本。' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'IsUpgradeScenario' to value 'false' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'ChangeText' to value '更改(_H)' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'LocationText' to value '位置(_L):' [2F6C:2804][2019-06-30T09:36:38]i000: Initializing string variable 'InvalidLocationText' to value '位置无效。请输入有效的位置以继续。' [2F6C:2804][2019-06-30T09:36:38]i000: Setting string variable 'WixBundleLog' to value 'C:\Users\鲁元博\AppData\Local\Temp\SsmsSetup\SSMS-Setup-CHS_20190630093638.log' [2F6C:2804][2019-06-30T09:36:38]i000: Setting string variable 'WixBundleOriginalSource' to value 'C:\Users\鲁元博\Downloads\SSMS-Setup-CHS (1).exe' [2F6C:2804][2019-06-30T09:36:38]i000: Setting string variable 'WixBundleName' to value 'Microsoft SQL Server Management Studio - 18.1' [2F6C:2804][2019-06-30T09:36:38]i000: Loading managed bootstrapper application. [2F6C:2804][2019-06-30T09:36:38]i000: Creating BA thread to run asynchronously. [2F6C:2E80][2019-06-30T09:36:39]i000: ManagedBootstrapperApp.Run: Launching the managed bootstrapper application. [2F6C:2E80][2019-06-30T09:36:39]i000: BootstrapperMetadataModel.Initialize: Start loading the bootstrapper app data xml file [2F6C:1078][2019-06-30T09:36:39]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Caption: Microsoft Windows 10 家庭中文版 [2F6C:1078][2019-06-30T09:36:39]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS Version: 10.0.16299 [2F6C:1078][2019-06-30T09:36:39]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: NetFx4 Version: 4.7.03062 [2F6C:1078][2019-06-30T09:36:39]i000: ManagedBootstrapperApp.LogUserEnvironmentInfoInBackground: OS UI Culture: Chinese (Simplified, China) (2052) [2F6C:2E80][2019-06-30T09:36:39]i000: BootstrapperMetadataModel.Initialize: Completed loading the bootstrapper app data xml file content: <BootstrapperApplicationData xmlns="http://schemas.microsoft.com/wix/2010/BootstrapperApplicationData"> <WixBalCondition Condition="SSMS18PreReleaseDetected = 0" Message="无法安装正式版(GA) SQL Server Management Studio (SSMS) v18.0,因为计算机上安装了预发布版 SSMS。请在控制面板的“添加/删除程序”中卸载预发布版 SSMS,并再次运行 SSMS 安装程序。" /> <WixBalCondition Condition="(SSMS18PreReleaseDetected = 1) OR (SSMSInstallExists = 0) OR SSMSInstalledLanguageMatch" Message="只能通过安装匹配语言包来升级 SSMS。请使用匹配版本的安装程序,或卸载当前版本的 SSMS 并再次运行 SSMS 安装程序。" /> <WixBalCondition Condition="NOT Msix64" Message="SSMS 只能安装在 64 位版本的 Windows 上。" /> <WixBalCondition Condition="RebootPending = 0" Message="安装程序检测到有一个挂起的计算机重启操作。请重启计算机,然后再次运行安装程序" /> <WixBalCondition Condition="(VersionNT = v6.1 AND ServicePackLevel = 1) OR VersionNT &gt; v6.1" Message="不支持当前操作系统。此应用程序至少需要 Windows 7 SP1 或 Windows Server 2008 R2 SP1 才能运行。" /> <WixBalCondition Condition="Installed OR (VersionNT &lt;&gt; v6.2) OR (InstallationType &lt;&gt; &quot;Client&quot;)" Message="不支持 Windows 8。请升级操作系统,然后再继续。" /> <WixBalCondition Condition="(VersionNT &lt;&gt; v6.3) OR (KB2919355_amd64_CurrentState = 112 OR KB2919355_x86_CurrentState = 112)" Message="The update corresponding to KB2919355 needs to be installed before you can install this product on Windows 8.1 or Windows Server 2012 R2. Please refer to https://support.microsoft.com/en-us/kb/2919355/ to obtain and install this update." /> <WixBundleProperties DisplayName="Microsoft SQL Server Management Studio - 18.1" LogPathVariable="WixBundleLog" Compressed="no" Id="{88251298-f74d-4665-aec9-1d88d509fc5b}" UpgradeCode="{C55E865B-F94F-42FC-A95A-00F24602F1C2}" PerMachine="yes" /> <WixMbaPrereqInformation PackageId="NetFx45Web" LicenseUrl="http://go.microsoft.com/fwlink/?LinkID=260867" /> <WixPackageProperties Package="VCRedistD12x86" Vital="no" DisplayName="Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.30501" Description="Microsoft Visual C++ 2013 Redistributable (x86) - 12.0.30501" DownloadSize="6503984" PackageSize="6503984" InstalledSize="6503984" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VCRedistD12x86" RollbackLogPathVariable="WixBundleRollbackLog_VCRedistD12x86" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="VCRedistD14x86" Vital="no" DisplayName="Microsoft Visual C++ 2017 Redistributable (x86) - 14.16.27029" Description="Microsoft Visual C++ 2017 Redistributable (x86) - 14.16.27029" DownloadSize="14673288" PackageSize="14673288" InstalledSize="14673288" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VCRedistD14x86" RollbackLogPathVariable="WixBundleRollbackLog_VCRedistD14x86" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="VCRedistD14x64" Vital="no" DisplayName="Microsoft Visual C++ 2017 Redistributable (x64) - 14.16.27029" Description="Microsoft Visual C++ 2017 Redistributable (x64) - 14.16.27029" DownloadSize="15354672" PackageSize="15354672" InstalledSize="15354672" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VCRedistD14x64" RollbackLogPathVariable="WixBundleRollbackLog_VCRedistD14x64" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="HelpViewer2_3" Vital="yes" DisplayName="Microsoft Help Viewer 2.3" DownloadSize="3149592" PackageSize="3149592" InstalledSize="13682786" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_HelpViewer2_3" RollbackLogPathVariable="WixBundleRollbackLog_HelpViewer2_3" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="HelpViewer2_3_LP" Vital="yes" DisplayName="Microsoft Help Viewer 2.3 语言包 - 简体中文" DownloadSize="556625" PackageSize="556625" InstalledSize="812913" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_HelpViewer2_3_LP" RollbackLogPathVariable="WixBundleRollbackLog_HelpViewer2_3_LP" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="DotNet47" Vital="yes" DisplayName="Microsoft .NET Framework 4.7.2" Description="Microsoft .NET Framework 4.7.2 Setup" DownloadSize="83943272" PackageSize="83943272" InstalledSize="83943272" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_DotNet47" RollbackLogPathVariable="WixBundleRollbackLog_DotNet47" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="NetFx45Web" Vital="yes" DisplayName="Microsoft .NET Framework 4.5" Description="Microsoft .NET Framework 4.5 Setup" DownloadSize="1005568" PackageSize="1005568" InstalledSize="1005568" PackageType="Exe" Permanent="yes" LogPathVariable="NetFx45FullWebLog" RollbackLogPathVariable="WixBundleRollbackLog_NetFx45Web" Compressed="no" DisplayInternalUI="no" /> <WixPackageProperties Package="sqlncli.msi" Vital="yes" DisplayName="Microsoft SQL Server 2012 Native Client " DownloadSize="5107712" PackageSize="5107712" InstalledSize="10813810" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sqlncli.msi" RollbackLogPathVariable="WixBundleRollbackLog_sqlncli.msi" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="msodbcsql.msi" Vital="yes" DisplayName="Microsoft ODBC Driver 17 for SQL Server" DownloadSize="3657728" PackageSize="3657728" InstalledSize="10917884" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_msodbcsql.msi" RollbackLogPathVariable="WixBundleRollbackLog_msodbcsql.msi" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="msoledbsql.msi" Vital="yes" DisplayName="Microsoft OLE DB Driver for SQL Server" DownloadSize="5390336" PackageSize="5390336" InstalledSize="12212300" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_msoledbsql.msi" RollbackLogPathVariable="WixBundleRollbackLog_msoledbsql.msi" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="adalsql_x64" Vital="yes" DisplayName="适用于 SQL Server 的 Active Directory 验证库" DownloadSize="2871296" PackageSize="2871296" InstalledSize="3357210" PackageType="Msi" Permanent="yes" LogPathVariable="WixBundleLog_adalsql_x64" RollbackLogPathVariable="WixBundleRollbackLog_adalsql_x64" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="sql_as_oledb_x64" Vital="yes" DisplayName="Microsoft Analysis Services OLE DB 提供程序" DownloadSize="74444800" PackageSize="74444800" InstalledSize="478359608" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_as_oledb_x64" RollbackLogPathVariable="WixBundleRollbackLog_sql_as_oledb_x64" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="sql_as_oledb_x86" Vital="yes" DisplayName="Microsoft Analysis Services OLE DB 提供程序" DownloadSize="36139008" PackageSize="36139008" InstalledSize="232289266" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_as_oledb_x86" RollbackLogPathVariable="WixBundleRollbackLog_sql_as_oledb_x86" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="VS2017IsoShellForSSMS" Vital="yes" DisplayName="Visual Studio 2017 Isolated Shell for SSMS" DownloadSize="142082048" PackageSize="142082048" InstalledSize="418962877" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_VS2017IsoShellForSSMS" RollbackLogPathVariable="WixBundleRollbackLog_VS2017IsoShellForSSMS" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="VS2017IsoShellForSSMS_LP" Vital="yes" DisplayName="用于 SSMS LangPack 的 Visual Studio 2017 Shell (独立) - 简体中文" DownloadSize="6905856" PackageSize="6905856" InstalledSize="31787409" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_VS2017IsoShellForSSMS_LP" RollbackLogPathVariable="WixBundleRollbackLog_VS2017IsoShellForSSMS_LP" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="VSTA2017" Vital="yes" DisplayName="Microsoft Visual Studio Tools for Applications 2017" Description="Microsoft Visual Studio Tools for Applications 2017" DownloadSize="13647984" PackageSize="13647984" InstalledSize="13647984" PackageType="Exe" Permanent="yes" LogPathVariable="WixBundleLog_VSTA2017" RollbackLogPathVariable="WixBundleRollbackLog_VSTA2017" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="sql_ssms_x64" Vital="yes" DisplayName="SQL Server Management Studio" DownloadSize="47964160" PackageSize="47964160" InstalledSize="208078967" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_ssms_x64" RollbackLogPathVariable="WixBundleRollbackLog_sql_ssms_x64" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="sql_ssms_loc_x64_Loc" Vital="yes" DisplayName="SQL Server Management Studio" DownloadSize="7376896" PackageSize="7376896" InstalledSize="32747110" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_sql_ssms_loc_x64_Loc" RollbackLogPathVariable="WixBundleRollbackLog_sql_ssms_loc_x64_Loc" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="ssms_rs_x64" Vital="yes" DisplayName="SQL Server Management Studio for Reporting Services" DownloadSize="8765440" PackageSize="8765440" InstalledSize="27019353" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_rs_x64" RollbackLogPathVariable="WixBundleRollbackLog_ssms_rs_x64" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="ssms_as_x64" Vital="yes" DisplayName="SQL Server Management Studio for Analysis Services" DownloadSize="73297920" PackageSize="73297920" InstalledSize="320197605" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_as_x64" RollbackLogPathVariable="WixBundleRollbackLog_ssms_as_x64" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="ssms_as_loc_x86" Vital="yes" DisplayName="SQL Server Management Studio for Analysis Services Localization" DownloadSize="3825664" PackageSize="3825664" InstalledSize="16651908" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_as_loc_x86" RollbackLogPathVariable="WixBundleRollbackLog_ssms_as_loc_x86" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="ssms_rs_loc_x86" Vital="yes" DisplayName="SQL Server Management Studio for Reporting Services Localization" DownloadSize="1548288" PackageSize="1548288" InstalledSize="4713000" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_rs_loc_x86" RollbackLogPathVariable="WixBundleRollbackLog_ssms_rs_loc_x86" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="ssms_is" Vital="yes" DisplayName="Integration Services" DownloadSize="32272384" PackageSize="32272384" InstalledSize="119146899" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_ssms_is" RollbackLogPathVariable="WixBundleRollbackLog_ssms_is" Compressed="yes" DisplayInternalUI="no" /> <WixPackageProperties Package="SsmsPostInstall_x64" Vital="yes" DisplayName="SSMS Post Install Tasks" DownloadSize="303104" PackageSize="303104" InstalledSize="0" PackageType="Msi" Permanent="no" LogPathVariable="WixBundleLog_SsmsPostInstall_x64" RollbackLogPathVariable="WixBundleRollbackLog_SsmsPostInstall_x64" Compressed="yes" DisplayInternalUI="no" /> <WixPayloadProperties Payload="VCRedistD12x86" Package="VCRedistD12x86" Container="WixAttachedContainer" Name="2013\vcredist_x86.exe" Size="6503984" DownloadUrl="https://aka.ms/vs/15/release/vc_redist.x86.exe" LayoutOnly="no" /> <WixPayloadProperties Payload="VCRedistD14x86" Package="VCRedistD14x86" Container="WixAttachedContainer" Name="2017\VC_redist.x86.exe" Size="14673288" DownloadUrl="https://aka.ms/vs/15/release/vc_redist.x86.exe" LayoutOnly="no" /> <WixPayloadProperties Payload="VCRedistD14x64" Package="VCRedistD14x64" Container="WixAttachedContainer" Name="2017\VC_redist.x64.exe" Size="15354672" DownloadUrl="https://aka.ms/vs/15/release/vc_redist.x64.exe" LayoutOnly="no" /> <WixPayloadProperties Payload="HelpViewer2_3" Package="HelpViewer2_3" Container="WixAttachedContainer" Name="redist\help3_vs_net.msi" Size="311296" LayoutOnly="no" /> <WixPayloadProperties Payload="cabE503715EC9048140D7380B4A179097EF" Package="HelpViewer2_3" Container="WixAttachedContainer" Name="redist\cab1.cab" Size="2838296" LayoutOnly="no" /> <WixPayloadProperties Payload="HelpViewer2_3_LP" Package="HelpViewer2_3_LP" Container="WixAttachedContainer" Name="redist\help3_LP_net.msi" Size="294912" LayoutOnly="no" /> <WixPayloadProperties Payload="cab96EEBCEEC415A2FC7E4C6265548D48E5" Package="HelpViewer2_3_LP" Container="WixAttachedContainer" Name="redist\cab1.cab" Size="261713" LayoutOnly="no" /> <WixPayloadProperties Payload="DotNet47" Package="DotNet47" Container="WixAttachedContainer" Name="redist\NDP472-KB4054530-x86-x64-AllOS-ENU.exe" Size="83943272" LayoutOnly="no" /> <WixPayloadProperties Payload="NetFx45Web" Package="NetFx45Web" Name="redist\dotNetFx45_Full_setup.exe" Size="1005568" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=225704" LayoutOnly="no" /> <WixPayloadProperties Payload="sqlncli.msi" Package="sqlncli.msi" Container="WixAttachedContainer" Name="x64\sqlncli.msi" Size="5107712" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718112" LayoutOnly="no" /> <WixPayloadProperties Payload="msodbcsql.msi" Package="msodbcsql.msi" Container="WixAttachedContainer" Name="x64\msodbcsql.msi" Size="3657728" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718071" LayoutOnly="no" /> <WixPayloadProperties Payload="msoledbsql.msi" Package="msoledbsql.msi" Container="WixAttachedContainer" Name="x64\msoledbsql.msi" Size="5390336" LayoutOnly="no" /> <WixPayloadProperties Payload="adalsql_x64" Package="adalsql_x64" Container="WixAttachedContainer" Name="x64\adalsql.msi" Size="2871296" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718064" LayoutOnly="no" /> <WixPayloadProperties Payload="sql_as_oledb_x64" Package="sql_as_oledb_x64" Container="WixAttachedContainer" Name="x64\sql_as_oledb.msi" Size="74444800" LayoutOnly="no" /> <WixPayloadProperties Payload="sql_as_oledb_x86" Package="sql_as_oledb_x86" Container="WixAttachedContainer" Name="x86\sql_as_oledb.msi" Size="36139008" LayoutOnly="no" /> <WixPayloadProperties Payload="VS2017IsoShellForSSMS" Package="VS2017IsoShellForSSMS" Container="WixAttachedContainer" Name="redist\vs2017_isoshell_for_ssms.msi" Size="142082048" LayoutOnly="no" /> <WixPayloadProperties Payload="VS2017IsoShellForSSMS_LP" Package="VS2017IsoShellForSSMS_LP" Container="WixAttachedContainer" Name="redist\vs2017_isoshell_for_ssms_lp.msi" Size="6905856" LayoutOnly="no" /> <WixPayloadProperties Payload="VSTA2017" Package="VSTA2017" Container="WixAttachedContainer" Name="redist\vsta_setup.exe" Size="13647984" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=799679" LayoutOnly="no" /> <WixPayloadProperties Payload="sql_ssms_x64" Package="sql_ssms_x64" Container="WixAttachedContainer" Name="x64\sql_ssms.msi" Size="47964160" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718090" LayoutOnly="no" /> <WixPayloadProperties Payload="sql_ssms_loc_x64_Loc" Package="sql_ssms_loc_x64_Loc" Container="WixAttachedContainer" Name="x64\sql_ssms_loc.msi" Size="7376896" DownloadUrl="http://go.microsoft.com/fwlink/?LinkId=718096" LayoutOnly="no" /> <WixPayloadProperties Payload="ssms_rs_x64" Package="ssms_rs_x64" Container="WixAttachedContainer" Name="x64\ssms_rs.msi" Size="8765440" LayoutOnly="no" /> <WixPayloadProperties Payload="ssms_as_x64" Package="ssms_as_x64" Container="WixAttachedContainer" Name="x64\ssms_as.msi" Size="73297920" LayoutOnly="no" /> <WixPayloadProperties Payload="ssms_as_loc_x86" Package="ssms_as_loc_x86" Container="WixAttachedContainer" Name="x86\ssms_as_loc.msi" Size="3825664" LayoutOnly="no" /> <WixPayloadProperties Payload="ssms_rs_loc_x86" Package="ssms_rs_loc_x86" Container="WixAttachedContainer" Name="x86\ssms_rs_loc.msi" Size="1548288" LayoutOnly="no" /> <WixPayloadProperties Payload="ssms_is" Package="ssms_is" Container="WixAttachedContainer" Name="x86\ssms_is.msi" Size="32272384" LayoutOnly="no" /> <WixPayloadProperties Payload="SsmsPostInstall_x64" Package="SsmsPostInstall_x64" Container="WixAttachedContainer" Name="x64\SsmsPostInstall.msi" Size="303104" LayoutOnly="no" /> <WixStdbaOverridableVariable Name="SSMSINSTALLROOT" /> </BootstrapperApplicationData> [2F6C:2E80][2019-06-30T09:36:40]i000: MainViewModel.CheckFailedConditions: Check whether OS is Windows 10 / Windows Server 2016 pre-RS1 (build <= 10586). OSVersion = 10.0.16299 [2F6C:2E80][2019-06-30T09:36:40]i000: ManagedBootstrapperApp.SetCommandLineProperties: Begin [2F6C:2E80][2019-06-30T09:36:40]i000: ManagedBootstrapperApp.SetCommandLineProperties: End [2F6C:2804][2019-06-30T09:36:41]i100: Detect begin, 24 packages [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'NETFRAMEWORK45' to value '461814' [2F6C:2804][2019-06-30T09:36:41]i000: Registry value not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18', Value = 'Version' [2F6C:2804][2019-06-30T09:36:41]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\SQL Server Management Studio\18' [2F6C:2804][2019-06-30T09:36:41]i000: Setting numeric variable 'SSMS18PreReleaseDetected' to value 0 [2F6C:2804][2019-06-30T09:36:41]i000: Setting numeric variable 'SSMSInstallExists' to value 1 [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'SSMSInstallExists' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'SSMSINSTALLROOT' to value 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\' [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'SSMSInstallExists' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i000: Registry value not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18', Value = 'Version' [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'SSMSInstallExists' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18\Language' [2F6C:2804][2019-06-30T09:36:41]i000: Setting numeric variable 'SSMSInstalledLanguageMatch' to value 0 [2F6C:2804][2019-06-30T09:36:41]i000: Setting numeric variable 'VCRedist_D12x86_KeyExists' to value 1 [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'VCRedist_D14x64_Bld' to value '27024' [2F6C:2804][2019-06-30T09:36:41]i000: Setting numeric variable 'VCRedist_D14x64_KeyExists' to value 1 [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'VCRedist_D14x64_Major' to value '14' [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'VCRedist_D14x64_Minor' to value '16' [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'VCRedist_D14x86_Bld' to value '27024' [2F6C:2804][2019-06-30T09:36:41]i000: Setting numeric variable 'VCRedist_D14x86_KeyExists' to value 1 [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'VCRedist_D14x86_Major' to value '14' [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'VCRedist_D14x86_Minor' to value '16' [2F6C:2804][2019-06-30T09:36:41]i000: Registry key not found. Key = 'HKLM\Software\Microsoft\DevDiv\vsta\Servicing\15.0\hosting' [2F6C:2804][2019-06-30T09:36:41]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Package_for_KB2919355~31bf3856ad364e35~amd64~~6.3.1.14' [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'Netfx4FullReleaseX64' to value '461814' [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'InstallationType' to value 'Client' [2F6C:2804][2019-06-30T09:36:41]i000: Setting string variable 'Netfx4ClientReleaseX64' to value '461814' [2F6C:2804][2019-06-30T09:36:41]i000: Registry key not found. Key = 'SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages\Package_for_KB2919355~31bf3856ad364e35~x86~~6.3.1.14' [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'VCRedist_D12x86_KeyExists' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'VCRedist_D14x86_KeyExists AND (VCRedist_D14x86_Major >= 14) AND (VCRedist_D14x86_Minor >= 10) AND (VCRedist_D14x86_Bld >= 25008)' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'VCRedist_D14x64_KeyExists AND (VCRedist_D14x64_Major >= 14) AND (VCRedist_D14x64_Minor >= 10) AND (VCRedist_D14x64_Bld >= 25008)' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition '(Netfx4FullReleaseX64 >= 461808) OR (NetFx4ClientReleaseX64 >= 461808)' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'NETFRAMEWORK45 >= 378389' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'VSTA2017Installed' evaluates to false. [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: VCRedistD12x86, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: VCRedistD14x86, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: VCRedistD14x64, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: HelpViewer2_3, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: HelpViewer2_3_LP, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: DotNet47, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: NetFx45Web, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: sqlncli.msi, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: msodbcsql.msi, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: msoledbsql.msi, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: adalsql_x64, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: sql_as_oledb_x64, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: sql_as_oledb_x86, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: VS2017IsoShellForSSMS, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: VS2017IsoShellForSSMS_LP, state: Present, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: VSTA2017, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: sql_ssms_x64, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: sql_ssms_loc_x64_Loc, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: ssms_rs_x64, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: ssms_as_x64, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: ssms_as_loc_x86, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: ssms_rs_loc_x86, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: ssms_is, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i101: Detected package: SsmsPostInstall_x64, state: Absent, cached: None [2F6C:2804][2019-06-30T09:36:41]i000: BootstrapperEngineDataModel.OnDetectComplete.: Entering... [2F6C:2804][2019-06-30T09:36:41]i000: MainViewModel: Trying to parse value '1' for property 'SSMSInstallExists'... [2F6C:2804][2019-06-30T09:36:41]i000: MainViewModel.CheckInstallPathIsValid: Successfully created and deleted installation folder - 'C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\' [2F6C:2804][2019-06-30T09:36:41]i000: MainViewModel.OnBootstrapperReady: IsUpgradeScenario=True [2F6C:2804][2019-06-30T09:36:41]i000: MainViewModel.OnBootstrapperReady: SSMSInstallRoot=C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\ [2F6C:2804][2019-06-30T09:36:41]e000: MainViewModel: SSMSInstallVersion not found. [2F6C:2804][2019-06-30T09:36:41]i000: MainViewModel.OnBootstrapperReady: SSMSInstallVersion= [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'RebootPending = 1' evaluates to false. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'SSMS18PreReleaseDetected = 0' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition '(SSMS18PreReleaseDetected = 1) OR (SSMSInstallExists = 0) OR SSMSInstalledLanguageMatch' evaluates to false. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'NOT Msix64' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'RebootPending = 0' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition '(VersionNT = v6.1 AND ServicePackLevel = 1) OR VersionNT > v6.1' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition 'Installed OR (VersionNT <> v6.2) OR (InstallationType <> "Client")' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i052: Condition '(VersionNT <> v6.3) OR (KB2919355_amd64_CurrentState = 112 OR KB2919355_x86_CurrentState = 112)' evaluates to true. [2F6C:2804][2019-06-30T09:36:41]i000: MainViewModel.AddFailedCondition: Error: 只能通过安装匹配语言包来升级 SSMS。请使用匹配版本的安装程序,或卸载当前版本的 SSMS 并再次运行 SSMS 安装程序。 [2F6C:2804][2019-06-30T09:36:41]i000: BootstrapperEngineDataModel.OnDetectComplete.: Exiting. [2F6C:2804][2019-06-30T09:36:41]i199: Detect complete, result: 0x0 [2F6C:2E80][2019-06-30T09:36:43]i000: MainViewModel.OpenUrl: Opening url: C:\Users\鲁元博\AppData\Local\Temp\SsmsSetup\SSMS-Setup-CHS_20190630093638.log

myeclipse与mysql连接运行servlet出问题

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "3306:myceshi" myceshi是数据库名

使用配置文件连接jdb连接池时出现问题

使用jndi实现数据库连接。 <%@page import="java.sql.Connection"%> <%@page import="javax.sql.DataSource"%> <%@page import="javax.naming.*"%> <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>测试jndi连接2</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <% //1.得到Context接口对象 Context ctx = new InitialContext(); //2.通过ctx到配置文件中查找指定的名称 DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/mysql"); //3.通过ds得到连接对象 Connection conn = ds.getConnection(); //4.对连接判断 if (conn != null) { out.println("数据库连接成功!"); } %> </body> </html> 1. 下载指定的数据库驱动jar包,放入容器tomcat lib中。 2. 开始配置tomcat配置文件: conf--->context.xml 3. 在context.xml中要配置一个资源的标签。 这三步没有问题 主要是通过ds得到连接对象老是出错 HTTP Status 500 - An exception occurred processing JSP page /jndi/testjndi2.jsp at line 39 type Exception report message An exception occurred processing JSP page /jndi/testjndi2.jsp at line 39 description The server encountered an internal error that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: An exception occurred processing JSP page /jndi/testjndi2.jsp at line 39 36: DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/mysql"); 37: 38: //3.閫氳繃ds寰楀埌杩炴帴瀵硅薄 39: Connection conn = ds.getConnection(); 40: 41: //4.瀵硅繛鎺ュ垽鏂� 42: if (conn != null) { Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:579) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:461) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) root cause javax.servlet.ServletException: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null' org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:909) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:838) org.apache.jsp.jndi.testjndi2_jsp._jspService(testjndi2_jsp.java:183) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) root cause java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null' org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2184) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2056) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1532) org.apache.jsp.jndi.testjndi2_jsp._jspService(testjndi2_jsp.java:159) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) root cause java.sql.SQLException: No suitable driver java.sql.DriverManager.getDriver(Unknown Source) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2168) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2056) org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1532) org.apache.jsp.jndi.testjndi2_jsp._jspService(testjndi2_jsp.java:159) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) note The full stack trace of the root cause is available in the Apache Tomcat/8.0.49 logs.

Struts2初次配置启动tomcat出错

开发环境: Eclipse Java EE IDE for Web Developers. Version: Helios Service Release 1 Build id: 20100917-0705 Tomcat 6.x log: [code="txt"] 2011-1-6 0:04:30 org.apache.tomcat.util.digester.SetPropertiesRule begin 警告: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:Struts2Demo' did not find a matching property. 2011-1-6 0:04:30 org.apache.catalina.core.AprLifecycleListener init 信息: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_02\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program Files/Java/jdk1.6.0_02/bin/../jre/bin/client;C:/Program Files/Java/jdk1.6.0_02/bin/../jre/bin;C:/Program Files/Java/jdk1.6.0_02/bin/../jre/lib/i386;C:\Program Files\PC Connectivity Solution\;C:\Program Files\Java\jdk1.6.0_02\bin;C:\Program Files\Java\jre1.6.0_02;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\EmEditor;C:\Program Files\TortoiseSVN\bin 2011-1-6 0:04:30 org.apache.coyote.http11.Http11Protocol init 信息: Initializing Coyote HTTP/1.1 on http-8080 2011-1-6 0:04:30 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 759 ms 2011-1-6 0:04:30 org.apache.catalina.core.StandardService start 信息: Starting service Catalina 2011-1-6 0:04:30 org.apache.catalina.core.StandardEngine start 信息: Starting Servlet Engine: Apache Tomcat/6.0.16 2011-1-6 0:04:30 org.apache.catalina.core.StandardContext filterStart 严重: Exception starting filter struts2 java.lang.ClassNotFoundException: org.apache.struts2.dispatcher.FilterDispatcher at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206) at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:249) at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:397) at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:108) at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3709) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4356) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:578) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) 2011-1-6 0:04:30 org.apache.catalina.core.StandardContext start 严重: Error filterStart 2011-1-6 0:04:30 org.apache.catalina.core.StandardContext start 严重: Context [/Struts2Demo] startup failed due to previous errors 2011-1-6 0:04:30 org.apache.coyote.http11.Http11Protocol start 信息: Starting Coyote HTTP/1.1 on http-8080 2011-1-6 0:04:30 org.apache.jk.common.ChannelSocket init 信息: JK: ajp13 listening on /0.0.0.0:8009 2011-1-6 0:04:30 org.apache.jk.server.JkMain start 信息: Jk running ID=0 time=0/31 config=null 2011-1-6 0:04:30 org.apache.catalina.startup.Catalina start 信息: Server startup in 622 ms [/code] web.xml如下: [code="java"] <?xml version="1.0" encoding="UTF-8"?> <web-app> <display-name>Struts2Demo</display-name> <filter> <filter-name>struts2</filter-name> <filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class> </filter> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app> [/code] 在xml中右键点击:org.apache.struts2.dispatcher.FilterDispatcher,可以进入FilterDispatcher类。 我在网上搜了下,提供的解决方案有: 1、导入commons-fileupload.jar和commons-io.jar包 2、将tomcat及jdk版本更新到struts2的需求,即5.5及1.5 3、添加struts2开发所需完整jar包 4、检查web.xml及struts.xml是否书写错误 5、将struts2相关包手动添加到classpath中 除了5我都试过,没有问题。 引入的jar包,见下图: [img]http://dl.iteye.com/upload/attachment/383348/cc12094e-5796-379c-b2f8-2facfb753bc6.jpg[/img] PS:我十分想将红圈里的那俩东西删掉,但是也不知道怎么搞。我是建立的Dynamic Web Project,建完之后就带着了,删不掉。

学习Java web的小菜鸟求问一个问题!web信息想传入数据库一直出错

按照网上的教程配置好了MySQL数据库连接池。 1.Tomcat的context.xml文件下加了 <Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver" username="root" password="123456" maxActive="100" maxIdle="30" maxWait="10000" url="jdbc:mysql://localhost:3306/blog "/> 2.在工程和Tomcat的lib文件夹下都加入了JAR包![图片说明](https://img-ask.csdn.net/upload/201712/01/1512125682_598232.png) 3.servlet源程序: package cn.com.seven.blog; import java.io.IOException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; import javax.sql.DataSource; import javax.naming.Context; import javax.naming.InitialContext; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class BlogServlet extends HttpServlet { private static final long serialVersionUID=1L; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String title=request.getParameter("title"); String content=request.getParameter("content"); String categoryId=request.getParameter("category"); //System.out.println(title); //System.out.println(content); //System.out.println(categoryId); DataSource ds = null; try { // 通过在context.xml文件,设定的数据源对象的名字,获取数据源对象 Context context = new InitialContext(); ds = (DataSource) context.lookup("java:/comp/env/jdbc/mysqlds"); } catch (Exception e) { System.out.println("获取数据源时出错"); } Connection conn; try { conn=ds.getConnection(); String sql = "insert into blog (title,content,category_id,createdtime) values (?,?,?,now())"; PreparedStatement pstmt =conn.prepareStatement(sql); pstmt.setString(1, title); pstmt.setString(2, content); pstmt.setInt(3,Integer.parseInt(categoryId)); int result=pstmt.executeUpdate(); System.out.println(result); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } 然后在界面中输入信息后报错: 获取数据源时出错 十二月 01, 2017 6:50:08 下午 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet [BlogServlet] in context with path [/blog] threw exception java.lang.NullPointerException at cn.com.seven.blog.BlogServlet.doPost(BlogServlet.java:49) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2516) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2505) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 【不知道什么原因,请大神帮帮我~~~】

ssm框架运维报错(数据库连接时出错)

今早发现了一个很奇怪的东西,服务器上前后测试了好几次的程序突然崩了,之前运行非常稳定,这是报错,目标是我数据库,大家有没有懂的 ``` 27-Mar-2018 07:34:41.680 严重 [https-jsse-nio2-443-exec-2] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.RecoverableDataAccessException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 32,986,781 milliseconds ago. The last packet sent successfully to the server was 32,986,781 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem. ### The error may exist in file [C:\Program Files\Apache Software Foundation\Tomcat 9.0_Tomcat9.0\webapps2\ShowHTML\WEB-INF\classes\mapper\student_infoMapper.xml] ### The error may involve com.cn.fenyu.dao.student_infoMapper.selectByExample-Inline ### The error occurred while setting parameters ### SQL: select studentID, studentpw, power, studentname from student WHERE ( studentID = ? ) ### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 32,986,781 milliseconds ago. The last packet sent successfully to the server was 32,986,781 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem. ; SQL []; The last packet successfully received from the server was 32,986,781 milliseconds ago. The last packet sent successfully to the server was 32,986,781 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 32,986,781 milliseconds ago. The last packet sent successfully to the server was 32,986,781 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.] with root cause java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111) at java.net.SocketOutputStream.write(SocketOutputStream.java:155) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3964) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2596) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1307) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:141) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy111.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) at com.sun.proxy.$Proxy45.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at com.sun.proxy.$Proxy46.selectByExample(Unknown Source) at com.cn.fenyu.servies.MainServies.finduser(MainServies.java:34) at com.cn.fenyu.controller.MainController.indexshow(MainController.java:149) at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ```

ssm+oracle项目,用了eclipse(oxygen)和tomcat9,tomcat启动出错

项目一开始可以运行,修改过几次后重新加到tomcat,tomcat启动就报错了 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.mybatis.spring.mapper.MapperScannerConfigurer#0' defined in URL [file:/D:/eclipse-workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MarketingCheckup/WEB-INF/classes/config/applicationContext.xml]: Cannot resolve reference to bean 'sqlSessionFactory' while setting bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in URL [file:/D:/eclipse-workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MarketingCheckup/WEB-INF/classes/config/applicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [config/mybatis-config.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class . Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ''. Cause: java.lang.ClassNotFoundException: Cannot find class: at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:336) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1456) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1197) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.context.support.PostProcessorRegistrationDelegate.invokeBeanFactoryPostProcessors(PostProcessorRegistrationDelegate.java:116) at org.springframework.context.support.AbstractApplicationContext.invokeBeanFactoryPostProcessors(AbstractApplicationContext.java:609) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4729) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5167) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in URL [file:/D:/eclipse-workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/MarketingCheckup/WEB-INF/classes/config/applicationContext.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [config/mybatis-config.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class . Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ''. Cause: java.lang.ClassNotFoundException: Cannot find class: at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1553) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) ... 24 more Caused by: org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [config/mybatis-config.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class . Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ''. Cause: java.lang.ClassNotFoundException: Cannot find class: at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:380) at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:295) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1612) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1549) ... 31 more Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class . Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ''. Cause: java.lang.ClassNotFoundException: Cannot find class: at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:105) at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:88) at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:374) ... 34 more Caused by: java.lang.RuntimeException: Error parsing Mapper XML. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class . Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ''. Cause: java.lang.ClassNotFoundException: Cannot find class: at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:113) at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:88) at org.apache.ibatis.builder.xml.XMLConfigBuilder.mapperElement(XMLConfigBuilder.java:311) at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:103) ... 36 more Caused by: org.apache.ibatis.builder.BuilderException: Error resolving class . Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ''. Cause: java.lang.ClassNotFoundException: Cannot find class: at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:94) at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:79) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128) at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:121) at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:111) ... 39 more Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias ''. Cause: java.lang.ClassNotFoundException: Cannot find class: at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:109) at org.apache.ibatis.builder.BaseBuilder.resolveAlias(BaseBuilder.java:115) at org.apache.ibatis.builder.BaseBuilder.resolveClass(BaseBuilder.java:92) ... 43 more Caused by: java.lang.ClassNotFoundException: Cannot find class: at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:188) at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:87) at org.apache.ibatis.io.Resources.classForName(Resources.java:250) at org.apache.ibatis.type.TypeAliasRegistry.resolveAlias(TypeAliasRegistry.java:105) ... 45 more

ssh中spring的配置加上事务配置后就出错,恳请大家帮忙

出错信息: 2011-3-27 20:15:08 org.apache.catalina.core.AprLifecycleListener lifecycleEvent 信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: D:\Program Files\java\bin;D:\Program Files\Tomcat 5.5\bin 2011-3-27 20:15:08 org.apache.coyote.http11.Http11BaseProtocol init 信息: Initializing Coyote HTTP/1.1 on http-1688 2011-3-27 20:15:08 org.apache.catalina.startup.Catalina load 信息: Initialization processed in 406 ms 2011-3-27 20:15:08 org.apache.catalina.core.StandardService start 信息: Starting service Catalina 2011-3-27 20:15:08 org.apache.catalina.core.StandardEngine start 信息: Starting Servlet Engine: Apache Tomcat/5.5.16 2011-3-27 20:15:08 org.apache.catalina.core.StandardHost start 信息: XML validation disabled 2011-03-27 20:15:09,062 INFO [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SSHExt]] - Initializing Spring root WebApplicationContext 2011-03-27 20:15:09,062 INFO [org.springframework.web.context.ContextLoader] - Root WebApplicationContext: initialization started 2011-03-27 20:15:09,203 INFO [org.springframework.web.context.support.XmlWebApplicationContext] - Refreshing Root WebApplicationContext: startup date [Sun Mar 27 20:15:09 CST 2011]; root of context hierarchy 2011-03-27 20:15:09,359 INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] - Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml] 2011-03-27 20:15:09,593 ERROR [org.springframework.web.context.ContextLoader] - Context initialization failed org.springframework.beans.factory.BeanDefinitionStoreException: Unexpected exception parsing XML document from ServletContext resource [/WEB-INF/applicationContext.xml]; nested exception is java.lang.NoClassDefFoundError: org/aopalliance/intercept/MethodInterceptor at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:412) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:178) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:149) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:124) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:93) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:467) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:397) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1112) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.lang.NoClassDefFoundError: org/aopalliance/intercept/MethodInterceptor at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:620) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1812) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:866) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1319) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at org.springframework.transaction.config.TxAdviceBeanDefinitionParser.getBeanClass(TxAdviceBeanDefinitionParser.java:69) at org.springframework.beans.factory.xml.AbstractSingleBeanDefinitionParser.parseInternal(AbstractSingleBeanDefinitionParser.java:66) at org.springframework.beans.factory.xml.AbstractBeanDefinitionParser.parse(AbstractBeanDefinitionParser.java:59) at org.springframework.beans.factory.xml.NamespaceHandlerSupport.parse(NamespaceHandlerSupport.java:73) at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1335) at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1325) at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:135) at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:93) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:493) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:390) ... 37 more 2011-03-27 20:15:09,593 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SSHExt]] - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanDefinitionStoreException: Unexpected exception parsing XML document from ServletContext resource [/WEB-INF/applicationContext.xml]; nested exception is java.lang.NoClassDefFoundError: org/aopalliance/intercept/MethodInterceptor at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:412) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:334) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:178) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:149) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:124) at org.springframework.web.context.support.XmlWebApplicationContext.loadBeanDefinitions(XmlWebApplicationContext.java:93) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:467) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:397) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4183) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524) at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904) at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1112) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021) at org.apache.catalina.core.StandardHost.start(StandardHost.java:718) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442) at org.apache.catalina.core.StandardService.start(StandardService.java:450) at org.apache.catalina.core.StandardServer.start(StandardServer.java:709) at org.apache.catalina.startup.Catalina.start(Catalina.java:551) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.lang.NoClassDefFoundError: org/aopalliance/intercept/MethodInterceptor at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:620) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124) at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1812) at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:866) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1319) at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at org.springframework.transaction.config.TxAdviceBeanDefinitionParser.getBeanClass(TxAdviceBeanDefinitionParser.java:69) at org.springframework.beans.factory.xml.AbstractSingleBeanDefinitionParser.parseInternal(AbstractSingleBeanDefinitionParser.java:66) at org.springframework.beans.factory.xml.AbstractBeanDefinitionParser.parse(AbstractBeanDefinitionParser.java:59) at org.springframework.beans.factory.xml.NamespaceHandlerSupport.parse(NamespaceHandlerSupport.java:73) at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1335) at org.springframework.beans.factory.xml.BeanDefinitionParserDelegate.parseCustomElement(BeanDefinitionParserDelegate.java:1325) at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.parseBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:135) at org.springframework.beans.factory.xml.DefaultBeanDefinitionDocumentReader.registerBeanDefinitions(DefaultBeanDefinitionDocumentReader.java:93) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.registerBeanDefinitions(XmlBeanDefinitionReader.java:493) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:390) ... 37 more 2011-3-27 20:15:09 org.apache.catalina.core.StandardContext start 严重: Error listenerStart 2011-3-27 20:15:09 org.apache.catalina.core.StandardContext start 严重: Context [/SSHExt] startup failed due to previous errors 2011-03-27 20:15:09,593 INFO [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SSHExt]] - Closing Spring root WebApplicationContext 2011-3-27 20:15:09 org.apache.coyote.http11.Http11BaseProtocol start 信息: Starting Coyote HTTP/1.1 on http-1688 2011-3-27 20:15:09 org.apache.jk.common.ChannelSocket init 信息: JK: ajp13 listening on /0.0.0.0:8009 2011-3-27 20:15:09 org.apache.jk.server.JkMain start 信息: Jk running ID=0 time=0/47 config=null 2011-3-27 20:15:09 org.apache.catalina.storeconfig.StoreLoader load 信息: Find registry server-registry.xml at classpath resource 2011-3-27 20:15:09 org.apache.catalina.startup.Catalina start 信息: Server startup in 1703 ms spring的配置信息如下: <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"> <!-- 配置数据库连接池 --> <!-- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"> <value>oracle.jdbc.OracleDriver</value> </property> <property name="url"> <value>jdbc:oracle:thin:@localhost:1521:orcl</value> </property> <property name="password"> <value>orcl</value> </property> <property name="username"> <value>yhj</value> </property> </bean> <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property> <property name="connection.url">jdbc:jtds:sqlserver://127.0.0.1:1433;DatabaseName=hibernate</property> --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName"> <value>net.sourceforge.jtds.jdbc.Driver</value> </property> <property name="url"> <value>jdbc:jtds:sqlserver://127.0.0.1:1433;databaseName=sshtest</value> </property> <property name="password"> <value>sa</value> </property> <property name="username"> <value>sa</value> </property> </bean> <!-- <property name="connection.url"> jdbc:sqlserver://127.0.0.1:1433;databaseName=HTSiteSrv </property> <property name="connection.username">sa</property> <property name="connection.password">sa</property> <property name="connection.driver_class"> com.microsoft.sqlserver.jdbc.SQLServerDriver </property> --> <!-- 配置sessionFactory --> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource"> <ref local="dataSource"/> </property> <property name="mappingResources"> <list> <value>UserTab.hbm.xml</value> </list> </property> <property name="hibernateProperties"> <props> <!-- <prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>--> <prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop> <prop key="hibernate.show_sql">true</prop> </props> </property> </bean> <!--AOP的事务管理 --> <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean> <!--传播特性 --> <tx:advice id="txAdvice" transaction-manager="txManager"> <tx:attributes> <tx:method name="add*" propagation="REQUIRED" /> <tx:method name="delete*" propagation="REQUIRED" /> <tx:method name="update*" propagation="REQUIRED" /> <tx:method name="get*" read-only="true" /> <tx:method name="search*" read-only="true" /> </tx:attributes> </tx:advice> <!--配置事务管理器应用的范围 --> <aop:config> <aop:pointcut id="userServiceMethods" expression="execution(*com.ssh.test.dao.*(..))" /> <aop:advisor advice-ref="txAdvice" pointcut-ref="userServiceMethods" /> </aop:config> <!-- dao配置 --> <bean id="userDao" class="com.ssh.test.dao.UserDao" scope="prototype"> <property name="sessionFactory"> <ref bean="sessionFactory" /> </property> </bean> <!-- 业务层配置 --> <bean id="userManageBusiness" class="com.ssh.test.business.UserManageBusiness" scope="prototype"> <property name="userDao"> <ref bean="userDao" /> </property> </bean> <!-- action配置 --> <bean id="loginAction" class="com.ssh.test.action.LoginAction" scope="prototype"> </bean> <bean id="userManageAction" class="com.ssh.test.action.UserManageAction" scope="prototype"> <property name="userManageBusiness"> <ref bean="userManageBusiness" /> </property> </bean> <bean id="deptManageAction" class="com.ssh.test.action.DeptManageAction" scope="prototype"> </bean> </beans> 去掉事务的配置就好,但是加上了就错,大家给力啊

异常详细信息: System.Exception: 从字符串转换日期和/或时间时,转换失败。

从朋友拿到的一个管理系统 在进行订单预定时出现了问题 请大佬指点指点 ![图片说明](https://img-ask.csdn.net/upload/202004/29/1588147955_776245.jpg) 这是准备预定时 ![图片说明](https://img-ask.csdn.net/upload/202004/29/1588147985_554177.jpg) 点击之后跳转至此 报错 ![图片说明](https://img-ask.csdn.net/upload/202004/29/1588148040_937129.jpg) 网页也变成这样 报错原因也说明 ![图片说明](https://img-ask.csdn.net/upload/202004/29/1588148080_618533.png)这是关于23行的代码 ![图片说明](https://img-ask.csdn.net/upload/202004/29/1588148104_884747.png)这是关于38行的代码 ``` int i = SqlHelper.ExecUpdateSql("delete T_ShopCar where BeginDate<convert(datetime,'" + DateTime.Now.ToShortDateString() + "') or EndDate<convert(datetime,'" + DateTime.Now.ToShortDateString() + "')"); //将所有的用户的预订时间和退房时间过期的数据都清除 ``` 不知道哪里出了问题 请大佬指点 万分感谢

druid + mybatis insert 第一次报错,第二次执行就没问题了

2016-05-31 19:16:14 -106908 [New I/O server worker #1-1] DEBUG - [DUBBO] Received heartbeat from remote channel /192.168.1.111:54696, cause: The channel has no data-transmission exceeds a heartbeat period: 60000ms, dubbo version: 2.5.3, current host: 192.168.1.111 2016-05-31 19:16:40 -132424 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - [DUBBO] Decode decodeable message com.alibaba.dubbo.rpc.protocol.dubbo.DecodeableRpcInvocation, dubbo version: 2.5.3, current host: 192.168.1.111 2016-05-31 19:16:40 -132425 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 执行服务,用户分配角色:addRurele 2016-05-31 19:16:40 -132426 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 分配的内容{USER_NAM=电饭锅, ROLE_IDS=admin,admin1, USER_ID=56古典风格} 2016-05-31 19:16:40 -132426 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 执行服务,用户角色表信息删除:deleteRurele 2016-05-31 19:16:40 -132426 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - 删除条件{USER_NAM=电饭锅, ROLE_IDS=admin,admin1, USER_ID=56古典风格} 2016-05-31 19:16:40 -132427 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Preparing: delete from LIMRURELE where USER_ID = ? 2016-05-31 19:16:40 -132428 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Parameters: 56古典风格(String) 2016-05-31 19:16:40 -132431 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - <== Updates: 2 [Ljava.lang.String;@41af159b ------admin 2016-05-31 19:16:40 -132432 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Preparing: insert into LIMRURELE (ROLE_ID,USER_ID) values (?,?) 2016-05-31 19:16:40 -132441 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - ==> Parameters: admin(String), 56古典风格(String) 2016-05-31 19:16:40 -132445 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - <== Updates: 1 2016-05-31 19:16:40 -132473 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 2016-05-31 19:16:40 -132517 [DubboServerHandler-192.168.1.111:20880-thread-11] INFO - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase] 2016-05-31 19:16:40 -132525 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - {conn-10004, pstmt-20008} enter cache 2016-05-31 19:16:40 -132526 [DubboServerHandler-192.168.1.111:20880-thread-11] DEBUG - {conn-10004, pstmt-20009} enter cache 2016-05-31 19:16:40 -132531 [DubboServerHandler-192.168.1.111:20880-thread-11] ERROR - [DUBBO] Got unchecked and undeclared exception which called by 192.168.1.111. service: com.um.facade.user.services.UserService, method: addRurele, exception: org.springframework.jdbc.UncategorizedSQLException: Error getting generated key or setting result to parameter object. Cause: java.sql.SQLException: Error ; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error, dubbo version: 2.5.3, current host: 192.168.1.111 org.springframework.jdbc.UncategorizedSQLException: Error getting generated key or setting result to parameter object. Cause: java.sql.SQLException: Error ; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371) at com.sun.proxy.$Proxy14.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240) at com.dao.DaoSupport.save(DaoSupport.java:27) at com.um.user.impl.UserServiceImple.addRurele(UserServiceImple.java:163) at com.um.user.impl.UserServiceImple$$FastClassByCGLIB$$367515af.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631) at com.um.user.impl.UserServiceImple$$EnhancerByCGLIB$$9cb2eeef.addRurele(<generated>) at com.alibaba.dubbo.common.bytecode.Wrapper5.invokeMethod(Wrapper5.java) at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46) at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72) at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53) at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38) at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108) at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84) at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170) at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52) at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)

大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了

大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...

在中国程序员是青春饭吗?

今年,我也32了 ,为了不给大家误导,咨询了猎头、圈内好友,以及年过35岁的几位老程序员……舍了老脸去揭人家伤疤……希望能给大家以帮助,记得帮我点赞哦。 目录: 你以为的人生 一次又一次的伤害 猎头界的真相 如何应对互联网行业的「中年危机」 一、你以为的人生 刚入行时,拿着傲人的工资,想着好好干,以为我们的人生是这样的: 等真到了那一天,你会发现,你的人生很可能是这样的: ...

程序员请照顾好自己,周末病魔差点一套带走我。

程序员在一个周末的时间,得了重病,差点当场去世,还好及时挽救回来了。

技术大佬:我去,你写的 switch 语句也太老土了吧

昨天早上通过远程的方式 review 了两名新来同事的代码,大部分代码都写得很漂亮,严谨的同时注释也很到位,这令我非常满意。但当我看到他们当中有一个人写的 switch 语句时,还是忍不住破口大骂:“我擦,小王,你丫写的 switch 语句也太老土了吧!” 来看看小王写的代码吧,看完不要骂我装逼啊。 private static String createPlayer(PlayerTypes p...

和黑客斗争的 6 天!

互联网公司工作,很难避免不和黑客们打交道,我呆过的两家互联网公司,几乎每月每天每分钟都有黑客在公司网站上扫描。有的是寻找 Sql 注入的缺口,有的是寻找线上服务器可能存在的漏洞,大部分都...

点沙成金:英特尔芯片制造全过程揭密

“亚马逊丛林里的蝴蝶扇动几下翅膀就可能引起两周后美国德州的一次飓风……” 这句人人皆知的话最初用来描述非线性系统中微小参数的变化所引起的系统极大变化。 而在更长的时间尺度内,我们所生活的这个世界就是这样一个异常复杂的非线性系统…… 水泥、穹顶、透视——关于时间与技艺的蝴蝶效应 公元前3000年,古埃及人将尼罗河中挖出的泥浆与纳特龙盐湖中的矿物盐混合,再掺入煅烧石灰石制成的石灰,由此得来了人...

讲一个程序员如何副业月赚三万的真实故事

loonggg读完需要3分钟速读仅需 1 分钟大家好,我是你们的校长。我之前讲过,这年头,只要肯动脑,肯行动,程序员凭借自己的技术,赚钱的方式还是有很多种的。仅仅靠在公司出卖自己的劳动时...

上班一个月,后悔当初着急入职的选择了

最近有个老铁,告诉我说,上班一个月,后悔当初着急入职现在公司了。他之前在美图做手机研发,今年美图那边今年也有一波组织优化调整,他是其中一个,在协商离职后,当时捉急找工作上班,因为有房贷供着,不能没有收入来源。所以匆忙选了一家公司,实际上是一个大型外包公司,主要派遣给其他手机厂商做外包项目。**当时承诺待遇还不错,所以就立马入职去上班了。但是后面入职后,发现薪酬待遇这块并不是HR所说那样,那个HR自...

女程序员,为什么比男程序员少???

昨天看到一档综艺节目,讨论了两个话题:(1)中国学生的数学成绩,平均下来看,会比国外好?为什么?(2)男生的数学成绩,平均下来看,会比女生好?为什么?同时,我又联想到了一个技术圈经常讨...

副业收入是我做程序媛的3倍,工作外的B面人生是怎样的?

提到“程序员”,多数人脑海里首先想到的大约是:为人木讷、薪水超高、工作枯燥…… 然而,当离开工作岗位,撕去层层标签,脱下“程序员”这身外套,有的人生动又有趣,马上展现出了完全不同的A/B面人生! 不论是简单的爱好,还是正经的副业,他们都干得同样出色。偶尔,还能和程序员的特质结合,产生奇妙的“化学反应”。 @Charlotte:平日素颜示人,周末美妆博主 大家都以为程序媛也个个不修边幅,但我们也许...

MySQL数据库面试题(2020最新版)

文章目录数据库基础知识为什么要使用数据库什么是SQL?什么是MySQL?数据库三大范式是什么mysql有关权限的表都有哪几个MySQL的binlog有有几种录入格式?分别有什么区别?数据类型mysql有哪些数据类型引擎MySQL存储引擎MyISAM与InnoDB区别MyISAM索引与InnoDB索引的区别?InnoDB引擎的4大特性存储引擎选择索引什么是索引?索引有哪些优缺点?索引使用场景(重点)...

如果你是老板,你会不会踢了这样的员工?

有个好朋友ZS,是技术总监,昨天问我:“有一个老下属,跟了我很多年,做事勤勤恳恳,主动性也很好。但随着公司的发展,他的进步速度,跟不上团队的步伐了,有点...

我入职阿里后,才知道原来简历这么写

私下里,有不少读者问我:“二哥,如何才能写出一份专业的技术简历呢?我总感觉自己写的简历太烂了,所以投了无数份,都石沉大海了。”说实话,我自己好多年没有写过简历了,但我认识的一个同行,他在阿里,给我说了一些他当年写简历的方法论,我感觉太牛逼了,实在是忍不住,就分享了出来,希望能够帮助到你。 01、简历的本质 作为简历的撰写者,你必须要搞清楚一点,简历的本质是什么,它就是为了来销售你的价值主张的。往深...

我说我不会算法,阿里把我挂了。

不说了,字节跳动也反手把我挂了。

优雅的替换if-else语句

场景 日常开发,if-else语句写的不少吧??当逻辑分支非常多的时候,if-else套了一层又一层,虽然业务功能倒是实现了,但是看起来是真的很不优雅,尤其是对于我这种有强迫症的程序"猿",看到这么多if-else,脑袋瓜子就嗡嗡的,总想着解锁新姿势:干掉过多的if-else!!!本文将介绍三板斧手段: 优先判断条件,条件不满足的,逻辑及时中断返回; 采用策略模式+工厂模式; 结合注解,锦...

离职半年了,老东家又发 offer,回不回?

有小伙伴问松哥这个问题,他在上海某公司,在离职了几个月后,前公司的领导联系到他,希望他能够返聘回去,他很纠结要不要回去? 俗话说好马不吃回头草,但是这个小伙伴既然感到纠结了,我觉得至少说明了两个问题:1.曾经的公司还不错;2.现在的日子也不是很如意。否则应该就不会纠结了。 老实说,松哥之前也有过类似的经历,今天就来和小伙伴们聊聊回头草到底吃不吃。 首先一个基本观点,就是离职了也没必要和老东家弄的苦...

为什么你不想学习?只想玩?人是如何一步一步废掉的

不知道是不是只有我这样子,还是你们也有过类似的经历。 上学的时候总有很多光辉历史,学年名列前茅,或者单科目大佬,但是虽然慢慢地长大了,你开始懈怠了,开始废掉了。。。 什么?你说不知道具体的情况是怎么样的? 我来告诉你: 你常常潜意识里或者心理觉得,自己真正的生活或者奋斗还没有开始。总是幻想着自己还拥有大把时间,还有无限的可能,自己还能逆风翻盘,只不是自己还没开始罢了,自己以后肯定会变得特别厉害...

男生更看重女生的身材脸蛋,还是思想?

往往,我们看不进去大段大段的逻辑。深刻的哲理,往往短而精悍,一阵见血。问:产品经理挺漂亮的,有点心动,但不知道合不合得来。男生更看重女生的身材脸蛋,还是...

为什么程序员做外包会被瞧不起?

二哥,有个事想询问下您的意见,您觉得应届生值得去外包吗?公司虽然挺大的,中xx,但待遇感觉挺低,马上要报到,挺纠结的。

当HR压你价,说你只值7K,你该怎么回答?

当HR压你价,说你只值7K时,你可以流畅地回答,记住,是流畅,不能犹豫。 礼貌地说:“7K是吗?了解了。嗯~其实我对贵司的面试官印象很好。只不过,现在我的手头上已经有一份11K的offer。来面试,主要也是自己对贵司挺有兴趣的,所以过来看看……”(未完) 这段话主要是陪HR互诈的同时,从公司兴趣,公司职员印象上,都给予对方正面的肯定,既能提升HR的好感度,又能让谈判气氛融洽,为后面的发挥留足空间。...

面试:第十六章:Java中级开发(16k)

HashMap底层实现原理,红黑树,B+树,B树的结构原理 Spring的AOP和IOC是什么?它们常见的使用场景有哪些?Spring事务,事务的属性,传播行为,数据库隔离级别 Spring和SpringMVC,MyBatis以及SpringBoot的注解分别有哪些?SpringMVC的工作原理,SpringBoot框架的优点,MyBatis框架的优点 SpringCould组件有哪些,他们...

面试阿里p7,被按在地上摩擦,鬼知道我经历了什么?

面试阿里p7被问到的问题(当时我只知道第一个):@Conditional是做什么的?@Conditional多个条件是什么逻辑关系?条件判断在什么时候执...

你打算用Java 8一辈子都不打算升级到Java 14,真香

我们程序员应该抱着尝鲜、猎奇的心态,否则就容易固步自封,技术停滞不前。

无代码时代来临,程序员如何保住饭碗?

编程语言层出不穷,从最初的机器语言到如今2500种以上的高级语言,程序员们大呼“学到头秃”。程序员一边面临编程语言不断推陈出新,一边面临由于许多代码已存在,程序员编写新应用程序时存在重复“搬砖”的现象。 无代码/低代码编程应运而生。无代码/低代码是一种创建应用的方法,它可以让开发者使用最少的编码知识来快速开发应用程序。开发者通过图形界面中,可视化建模来组装和配置应用程序。这样一来,开发者直...

面试了一个 31 岁程序员,让我有所触动,30岁以上的程序员该何去何从?

最近面试了一个31岁8年经验的程序猿,让我有点感慨,大龄程序猿该何去何从。

大三实习生,字节跳动面经分享,已拿Offer

说实话,自己的算法,我一个不会,太难了吧

程序员垃圾简历长什么样?

已经连续五年参加大厂校招、社招的技术面试工作,简历看的不下于万份 这篇文章会用实例告诉你,什么是差的程序员简历! 疫情快要结束了,各个公司也都开始春招了,作为即将红遍大江南北的新晋UP主,那当然要为小伙伴们做点事(手动狗头)。 就在公众号里公开征简历,义务帮大家看,并一一点评。《启舰:春招在即,义务帮大家看看简历吧》 一石激起千层浪,三天收到两百多封简历。 花光了两个星期的所有空闲时...

《经典算法案例》01-08:如何使用质数设计扫雷(Minesweeper)游戏

我们都玩过Windows操作系统中的经典游戏扫雷(Minesweeper),如果把质数当作一颗雷,那么,表格中红色的数字哪些是雷(质数)?您能找出多少个呢?文中用列表的方式罗列了10000以内的自然数、质数(素数),6的倍数等,方便大家观察质数的分布规律及特性,以便对算法求解有指导意义。另外,判断质数是初学算法,理解算法重要性的一个非常好的案例。

《Oracle Java SE编程自学与面试指南》最佳学习路线图(2020最新版)

正确选择比瞎努力更重要!

一文带你入门Java Stream流,太强了

两个星期以前,就有读者强烈要求我写一篇 Java Stream 流的文章,我说市面上不是已经有很多了吗,结果你猜他怎么说:“就想看你写的啊!”你看你看,多么苍白的喜欢啊。那就“勉为其难”写一篇吧,嘻嘻。 单从“Stream”这个单词上来看,它似乎和 java.io 包下的 InputStream 和 OutputStream 有些关系。实际上呢,没毛关系。Java 8 新增的 Stream 是为...

立即提问
相关内容推荐