看看这个错误是游戏数据错误怎么回事事
点击联系发帖人
时间：2017-10-02 08:10
查看: 7333|回复: 5
[已解决]请高手看看这个1004的错误，即“类RANG的COPY方法无效是什么原因（EXCEL用的是2003版
具体的代码如下：
Dim r As Range, fs As FileSearch
Dim x, y As Excel.Worksheet
Dim z As Integer
& & Set myexcel = Excel.Application
& & Set fs = Application.FileSearch
& & Set x = ThisWorkbook.Sheets(&sheet1&)
& & Set y = ThisWorkbook.Sheets(&sheet2&)
& & With fs
& && &&&.LookIn = ThisWorkbook.Path & &\运行文件夹&
& && &&&.Filename = &*.xls&
& && &&&If .Execute & 0 Then
& && && && &Application.ScreenUpdating = False
& && && && &For i = 1 To .FoundFiles.Count
& && && && && & Workbooks.Open .FoundFiles(i)
& && && && && & Rows(&1:1&).Select
& && && && && & myexcel.Selection.AutoFilter
& && && && && & myexcel.Selection.AutoFilter Field:=2, Criteria1:=&=&
& && && && && & Set r = ActiveSheet.AutoFilter.Range.SpecialCells(12)
& && && && && & r.Select
& && && && && & myexcel.Selection.Copy y.Cells(1, 1)
& && && && && & z = y.Range(&a65536&).End(xlUp).Row
& && && && && & x.Cells(i, 1).Value = z - 2
& && && && && & y.Cells.Clear
& && && && && & ActiveWorkbook.Close False
& && && && &Next i
& && && && &MsgBox &There were & & .FoundFiles.Count & & file(s) found.&
& && &&&Else
& && && && &MsgBox &There were no files found.&
& && &&&End If
& & End With
逐条运行后，在这句”myexcel.Selection.Copy y.Cells(1, 1)“上出了问题，系统报错：1004，类”RANG“的COPY方法无效”，但我看了一下代码表格中的SHEET2已经被COPY过去了具体的内容，到底是什么原因导致了代码运行不下去了，我查了一下宝典，解释了1004的错误是一种全捕获的错误，是EXCEL本身及相关对象的定义错误，但具体情况却未再做详细解释，到底是什么原因，请各位高手予以解答，万分感谢，悬赏分不多，仅是什么意思，还望各位海涵！！！另附件已上传
15:02 上传
点击文件名下载附件
23.53 KB, 下载次数: 22
Sub Macro4()
' Macro4 Macro
' 宏由 User 录制，时间:
Dim iAreas As Long, iRow As Long
Dim myexcel As Excel.Application
Dim r As Range, fs As FileSearch
Dim x, y As Excel.Worksheet
Dim z As Integer
Set myexcel = Excel.Application
Set fs = Application.FileSearch
Set x = ThisWorkbook.Sheets("sheet1")
Set y = ThisWorkbook.Sheets("sheet ...
吕布发布于
Sub Macro4()
' Macro4 Macro
' 宏由 User 录制，时间:
& & Dim iAreas As Long, iRow As Long
& & Dim myexcel As Excel.Application
& & Dim r As Range, fs As FileSearch
& & Dim x, y As Excel.Worksheet
& & Dim z As Integer
& & Set myexcel = Excel.Application
& & Set fs = Application.FileSearch
& & Set x = ThisWorkbook.Sheets(&sheet1&)
& & Set y = ThisWorkbook.Sheets(&sheet2&)
& & With fs
& && &&&.LookIn = ThisWorkbook.Path & &\运行文件夹&
& && &&&.Filename = &*.xls&
& && &&&If .Execute & 0 Then
& && && && &Application.ScreenUpdating = False
& && && && &For i = 1 To .FoundFiles.Count
& && && && && & Workbooks.Open .FoundFiles(i)
& && && && && & Rows(&1:1&).Select
& && && && && & myexcel.Selection.AutoFilter
& && && && && & myexcel.Selection.AutoFilter Field:=2, Criteria1:=&=&
& && && && && & Set r = ActiveSheet.AutoFilter.Range.SpecialCells(12)
& && && && && & 'r.Select
& && && && && & 'myexcel.Selection.Copy y.Cells(1, 1)
& && && && && &
& && && && && & ' 因为筛选后复制的区域不连续，粘贴时是粘贴不上的。要一个一个的粘贴
& && && && && & iRow = 1
& && && && && & For iAreas = 1 To r.Areas.Count
& && && && && && &&&r.Areas(iAreas).Copy y.Cells(iRow, 1)
& && && && && && &&&iRow = iRow + r.Areas(iAreas).Rows.Count
& && && && && & Next iAreas
& && && && && &
& && && && && & z = y.Range(&a65536&).End(xlUp).Row
& && && && && & x.Cells(i, 1).Value = z - 2
& && && && && & y.Cells.Clear
& && && && && & ActiveWorkbook.Close False
& && && && &Next i
& && && && &MsgBox &There were & & .FoundFiles.Count & & file(s) found.&
& && &&&Else
& && && && &MsgBox &There were no files found.&
& && &&&End If
& & End With
&&&本楼为最佳答案&&&
Sub Macro4()
' Macro4 Macro
' 宏由 User 录制，时间:
& & Dim iAreas As Long, iRow As Long
& & Dim myexcel As Excel.Application
& & Dim r As Range, fs As FileSearch
& & Dim x, y As Excel.Worksheet
& & Dim z As Integer
& & Set myexcel = Excel.Application
& & Set fs = Application.FileSearch
& & Set x = ThisWorkbook.Sheets(&sheet1&)
& & Set y = ThisWorkbook.Sheets(&sheet2&)
& & With fs
& && &&&.LookIn = ThisWorkbook.Path & &\运行文件夹&
& && &&&.Filename = &*.xls&
& && &&&If .Execute & 0 Then
& && && && &Application.ScreenUpdating = False
& && && && &For i = 1 To .FoundFiles.Count
& && && && && & Workbooks.Open .FoundFiles(i)
& && && && && & Rows(&1:1&).Select
& && && && && & myexcel.Selection.AutoFilter
& && && && && & myexcel.Selection.AutoFilter Field:=2, Criteria1:=&=&
& && && && && & Set r = ActiveSheet.AutoFilter.Range.SpecialCells(12)
& && && && && & 'r.Select
& && && && && & 'myexcel.Selection.Copy y.Cells(1, 1)
& && && && && &
& && && && && & ' 因为筛选后复制的区域不连续，粘贴时是粘贴不上的。要一个一个的粘贴
& && && && && & iRow = 1
& && && && && & For iAreas = 1 To r.Areas.Count
& && && && && && &&&r.Areas(iAreas).Copy y.Cells(iRow, 1)
& && && && && && &&&iRow = iRow + r.Areas(iAreas).Rows.Count
& && && && && & Next iAreas
& && && && && &
& && && && && & z = y.Range(&a65536&).End(xlUp).Row
& && && && && & x.Cells(i, 1).Value = z - 2
& && && && && & y.Cells.Clear
& && && && && & ActiveWorkbook.Close False
& && && && &Next i
& && && && &MsgBox &There were & & .FoundFiles.Count & & file(s) found.&
& && &&&Else
& && && && &MsgBox &There were no files found.&
& && &&&End If
& & End With
帮顶的人& && &
本帖最后由 adders 于
04:48 编辑
It might be caused by the whole row selection line: Rows(&1:1&).Select
instead, you may want to change above to:
range(cells(1,1),cells(1,cells(1,columns.count).end(xltoLeft).column)).select
Microsoft Refrence: /kb/905164
看了楼上的回复，我好象有点明白了，这是EXCEL本身自带的一个错误，只能采用别的方式，但问题是我想得到筛选的结果，即正常我们进行了自动筛选后，EXCEL会告诉我选出了多少条纪录，我现在就是想得出这个多少条的信息，既然COPY的方法无效，那么该用哪一种方法，我知道要以用分类汇总的方式，但问题是我带的表已经是分类汇总的形式了，请高手们能够予以赐教，万分感激！！！！！！！！！！！！！！！！
果然是高手，受益非浅
Powered by关注微信公众号
扫一扫，访问微社区
查看: 1333|回复: 3
大家帮看下这是什么原因
Minor Error
CCT-7609#sh module
Mod Ports Card Type& && && && && && && && && && &Model& && && && &&&Serial No.
--- ----- -------------------------------------- ------------------ -----------
&&1& &24&&CEF720 24 port 1000mb SFP& && && && &&&WS-X6724-SFP& && & SAL11392E89
&&2& &24&&CEF720 24 port 1000mb SFP& && && && &&&WS-X6724-SFP& && & SAL11391JNV
&&5& & 2&&Supervisor Engine 720 (Active)& && && &WS-SUP720-3B& && & SAL1204EBG7
&&6& & 2&&Supervisor Engine 720 (Hot)& && && && &WS-SUP720-3B& && & SAL1022PLFV
Mod MAC addresses& && && && && && && &&&Hw& & Fw& && && &&&Sw& && && &&&Status
--- ---------------------------------- ------ ------------ ------------ -------
&&1&&0013.7fbc.03a0 to 0013.7fbc.03b7& &2.1& &12.2(14r)S5&&12.2(33)SRA7 Ok
&&2&&0013.7fbc.03a0 to 0013.7fbc.03b7& &2.1& &12.2(14r)S5&&12.2(33)SRA7 Ok
&&5&&.9048 to .904b& &5.4& &8.4(2)& && & 12.2(33)SRA7 Ok
&&6&&.52cc to .52cf& &5.2& &8.4(2)& && & 12.2(33)SRA7 Ok
Mod&&Sub-Module& && && && && && &Model& && && && &&&Serial& && & Hw& &&&Status
---- --------------------------- ------------------ ----------- ------- -------
&&1&&Distributed Forwarding Card WS-F6700-DFC3B& &&&SAL1213KEM2&&4.6& & Ok
&&2&&Centralized Forwarding Card WS-F6700-CFC& && & SAL11402ZAS&&2.0& & Ok
&&5&&Policy Feature Card 3& && & WS-F6K-PFC3B& && & SAL1129UTS4&&2.3& & Ok
&&5&&MSFC3 Daughterboard& && && &WS-SUP720& && && & SAL1115L3WY&&2.6& & Ok
&&6&&Policy Feature Card 3& && & WS-F6K-PFC3B& && & SAL.3& & Ok
&&6&&MSFC3 Daughterboard& && && &WS-SUP720& && && & SAL1020N6PJ&&2.5& & Ok
Mod&&Online Diag Status
---- -------------------
&&1&&Minor Error
----------------------------------------------------------------------------------------------------
CCT-7609#sh diagnostic events
Diagnostic events (storage for 500 events, 9 events recorded)
Event Type (ET): I - Info, W - Warning, E - Error
Time Stamp& && && &ET [Card] Event Message
------------------ -- --------------------------------------------------------
09/16 22:09:18.259 I&&[5] Diagnostics Passed
09/16 22:09:52.211 I&&[2] Diagnostics Passed
09/16 22:11:50.495 E&&[1] TestLoopback Failed
09/16 22:11:55.119 E&&[1] Minor Error Detected
09/16 22:11:56.995 I&&[6] Diagnostics Passed
08/08 12:33:11.207 I&&[3] Diagnostics Passed
08/08 12:57:17.407 E&&[3] TestSynchedFabChannel Failed
09/04 06:21:24.720 I&&[6] Diagnostics Passed
09/04 06:40:01.656 I&&[6] Diagnostics Passed
-------------------------------------------------------------------------------------------------------------------
真心不知道这是什么错误，求教，但是现在业务正常运行
平均得分0 (0 评价)
其实Minor Error都是一些小的错误，有的时候重新插拔一下线卡就不会报错了。
但是如果你想知道细节的东西，还是推荐开case解决。。你可以先看下syslog其他log有没有什么重要的报警。
平均得分0 (0 评价)
本帖最后由 shwlzcco1 于
14:43 编辑
show diagnostic result module 1
看一下输出
平均得分0 (0 评价)
插拔下~~ 实在不行就修了
平均得分0 (0 评价)
京ICP备号-187
版权所有 :copyright: 思科系统 & |2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
匿名用户不能发表回复！|
每天回帖即可获得10分可用分！小技巧：
你还可以输入10000个字符
(Ctrl+Enter)
请遵守CSDN，不得违反国家法律法规。
转载文章请注明出自“CSDN（www.csdn.net）”。如是商业用途请联系原作者。大家帮我看看这个错误该怎么解决 - ITeye问答
log4j:WARN Please initialize the log4j system properly.
15:00:41 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class or
g.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassIndexBuilder' defined in ServletContext resource [/WEB-INF/applic
ationContext-compass.xml]: Cannot resolve reference to bean 'compassGps' while s
etting bean property 'compassGps'; nested exception is org.springframework.beans
.factory.BeanCreationException: Error creating bean with name 'compassGps' defin
ed in ServletContext resource [/WEB-INF/applicationContext-compass.xml]: Invocat
ion o nested exception is java.lang.ClassCastException: $Pr
oxy8 cannot be cast to org.hibernate.impl.SessionFactoryImpl
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'compassGps' defined in ServletContext resource [/WEB-INF/appl
icationContext-compass.xml]: Invocation o nested exception
is java.lang.ClassCastException: $Proxy8 cannot be cast to org.hibernate.impl.Se
ssionFactoryImpl
Caused by: java.lang.ClassCastException: $Proxy8 cannot be cast to org.hibernate
.impl.SessionFactoryImpl
pass.gps.device.hibernate.lifecycle.DefaultHibernateEntityLifecycleIn
jector.injectLifecycle(DefaultHibernateEntityLifecycleInjector.java:95)
pass.gps.device.hibernate.HibernateGpsDevice.doStart(HibernateGpsDevi
ce.java:149)
pass.gps.device.AbstractGpsDevice.start(AbstractGpsDevice.java:125)
pass.gps.device.support.parallel.AbstractParallelGpsDevice.start(Abst
ractParallelGpsDevice.java:73)
pass.gps.device.AbstractGpsDeviceWrapper.start(AbstractGpsDeviceWrapp
er.java:65)
pass.gps.impl.AbstractCompassGps.start(AbstractCompassGps.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1237)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:427)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.populateBean(AbstractAutowireCapableBeanFactory.java:857)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:291)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:352)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:245)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:188)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1116)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1214)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:117)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Cont
ainerBase.java:1590)
at java.lang.Thread.run(Thread.java:619)
15:00:41 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
15:00:41 org.apache.catalina.core.StandardContext start
严重: Context [/datashare] startup failed due to previous errors问题补充：我本来的配置都没有问题，但是今天整合了compass之后，tomcat启动就出错了！问题补充：WEB-INF/applicationContext-compass.xml 内容如下：
&beans xmlns="http://www.springframework.org/schema/beans" &br=""& xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=" http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" default-lazy-init="true"&
&bean id="annotationConfiguration" &br=""&
class="pass.passAnnotationsConfiguration"&
&bean id="compass" class="pass.spring.LocalCompassBean"&
&property name="resourceDirectoryLocations"&
&value&classpath:com/datashare&/value&
&/property&
&property name="connection"&
&value&/lucene/indexes&/value&
&/property&
&property name="classMappings"&
&value&com.datashare.model.Book&/value&
&/property&
&property name="compassConfiguration" &br=""&
ref="annotationConfiguration" /&
&property name="compassSettings"&
&prop key="compass.transaction.factory"&
pass.spring.transaction.SpringSyncTransactionFactory
&prop key="compass.engine.analyzer.MMAnalyzer.CustomAnalyzer"&net.paoding.analysis.analyzer.PaodingAnalyzer &/prop&
&/property&
&property name="transactionManager" ref="transactionManager"&
&bean id="hibernateGpsDevice" &br=""&
class="pass.gps.device.hibernate.HibernateGpsDevice"&
&property name="name"&
&value&hibernateDevice&/value&
&/property&
&property name="sessionFactory" ref="sessionFactory"&
&property name="mirrorDataChanges"&
&value&true&/value&
&/property&
&bean id="compassGps" class="pass.gps.impl.SingleCompassGps" &br=""&
init-method="start" destroy-method="stop"&
&property name="compass" ref="compass"&
&property name="gpsDevices"&
&bean &br=""&
class="pass.spring.device.SpringSyncTransactionGpsDeviceWrapper"&
&property name="gpsDevice" ref="hibernateGpsDevice"&
&/property&
&bean id="compassTemplate" &br=""&
class="passTemplate"&
&property name="compass" ref="compass"&
&bean id="compassIndexBuilder" &br=""&
class="com.datashare.passIndexBuilder"
lazy-init="false"&
&property name="compassGps" ref="compassGps"&
&property name="buildIndex" value="true"&
&property name="lazyTime" value="10"&
&/beans&问题补充：我用log4j捕捉的到的错误信息：
信息: Initializing Spring root WebApplicationContext
12:08:26,578
INFO Environment:479 - Hibernate 3.1.3
12:08:26,609
INFO Environment:509 - hibernate.properties not found
12:08:26,609
INFO Environment:525 - using CGLIB reflection optimizer
12:08:26,625
INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
12:08:27,187
INFO HbmBinder:309 - Mapping class: com.datashare.model.BookCatego
ry -& bookcategory
12:08:27,265
INFO HbmBinder:309 - Mapping class: com.datashare.model.BookMetada
ta -& bookmetadata
12:08:27,453
INFO HbmBinder:309 - Mapping class: com.datashare.model.BookCatalo
g -& bookcatalog
12:08:27,468
INFO HbmBinder:309 - Mapping class: com.datashare.model.Book -& bo
12:08:27,484
INFO HbmBinder:309 - Mapping class: com.datashare.model.CourseWare
Category -& coursewarecategory
12:08:27,500
INFO HbmBinder:309 - Mapping class: com.datashare.model.CourseWare
-& courseware
12:08:27,515
INFO HbmBinder:309 - Mapping class: com.datashare.model.News -& Qm
12:08:27,531
INFO HbmBinder:309 - Mapping class: com.datashare.model.Admin -& a
12:08:27,562
INFO ConnectionProviderFactory:72 - Initializing connection provid
er: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
12:08:28,015
INFO SettingsFactory:77 - RDBMS: Microsoft SQL Server, version: Mi
crosoft SQL Server
2000 - 8.00.760 (Intel X86)
Dec 17 :05
Copyright (c)
Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
12:08:28,015
INFO SettingsFactory:78 - JDBC driver: SQLServer, version: 2.2.004
12:08:28,203
INFO Dialect:103 - Using dialect: org.hibernate.dialect.SQLServerD
12:08:28,218
INFO TransactionFactoryFactory:31 - Using default transaction stra
tegy (direct JDBC transactions)
12:08:28,234
INFO TransactionManagerLookupFactory:33 - No TransactionManagerLoo
kup configured (in JTA environment, use of read-write or transactional second-le
vel cache is not recommended)
12:08:28,234
INFO SettingsFactory:125 - Automatic flush during beforeCompletion
(): disabled
12:08:28,234
INFO SettingsFactory:129 - Automatic session close at end of trans
action: disabled
12:08:28,234
INFO SettingsFactory:144 - Scrollable result sets: enabled
12:08:28,250
INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
12:08:28,250
INFO SettingsFactory:160 - Connection release mode: on_close
12:08:28,250
INFO SettingsFactory:187 - Default batch fetch size: 1
12:08:28,250
INFO SettingsFactory:191 - Generate SQL with comments: disabled
12:08:28,250
INFO SettingsFactory:195 - Order SQL updates by primary key: disab
12:08:28,250
INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast
.ASTQueryTranslatorFactory
12:08:28,265
INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactor
12:08:28,265
INFO SettingsFactory:203 - Query language substitutions: {}
12:08:28,265
INFO SettingsFactory:209 - Second-level cache: enabled
12:08:28,265
INFO SettingsFactory:213 - Query cache: enabled
12:08:28,265
INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.EhC
acheProvider
12:08:28,281
INFO SettingsFactory:228 - Optimize cache for minimal puts: disabl
12:08:28,281
INFO SettingsFactory:237 - Structured second-level cache entries:
12:08:28,281
INFO SettingsFactory:312 - Query cache factory: org.hibernate.cach
e.StandardQueryCacheFactory
12:08:28,312
INFO SettingsFactory:257 - Echoing all SQL to stdout
12:08:28,312
INFO SettingsFactory:264 - Statistics: disabled
12:08:28,312
INFO SettingsFactory:268 - Deleted entity synthetic identifier rol
lback: disabled
12:08:28,312
INFO SettingsFactory:283 - Default entity-mode: pojo
12:08:28,421
INFO SessionFactoryImpl:154 - building session factory
12:08:29,484
INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI,
no JNDI name configured
12:08:29,484
INFO UpdateTimestampsCache:43 - starting update timestamps cache a
t region: org.hibernate.cache.UpdateTimestampsCache
12:08:29,500
WARN EhCacheProvider:103 - Could not find configuration [org.hiber
nate.cache.UpdateTimestampsCache]; using defaults.
12:08:29,500
INFO StandardQueryCache:51 - starting query cache at region: org.h
ibernate.cache.StandardQueryCache
12:08:29,515
WARN EhCacheProvider:103 - Could not find configuration [org.hiber
nate.cache.StandardQueryCache]; using defaults.
12:08:31,453
INFO SessionFactoryImpl:729 - closing
12:08:31,468 ERROR ContextLoader:204 - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassIndexBuilder' defined in ServletContext resource [/WEB-INF/applic
ationContext-compass.xml]: Cannot resolve reference to bean 'compassGps' while s
etting bean property 'compassGps'; nested exception is org.springframework.beans
.factory.BeanCreationException: Error creating bean with name 'compassGps' defin
ed in ServletContext resource [/WEB-INF/applicationContext-compass.xml]: Invocat
ion o nested exception is java.lang.ClassCastException: $Pr
oxy0 cannot be cast to org.hibernate.impl.SessionFactoryImpl
Caused by:
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassGps' defined in ServletContext resource [/WEB-INF/applicationCont
ext-compass.xml]: Invocation o nested exception is java.lan
g.ClassCastException: $Proxy0 cannot be cast to org.hibernate.impl.SessionFactor
Caused by:
java.lang.ClassCastException: $Proxy0 cannot be cast to org.hibernate.impl.Sessi
onFactoryImpl
pass.gps.device.hibernate.lifecycle.DefaultHibernateEntityLifecycleIn
jector.injectLifecycle(DefaultHibernateEntityLifecycleInjector.java:95)
pass.gps.device.hibernate.HibernateGpsDevice.doStart(HibernateGpsDevi
ce.java:149)
pass.gps.device.AbstractGpsDevice.start(AbstractGpsDevice.java:125)
pass.gps.device.support.parallel.AbstractParallelGpsDevice.start(Abst
ractParallelGpsDevice.java:73)
pass.gps.device.AbstractGpsDeviceWrapper.start(AbstractGpsDeviceWrapp
er.java:65)
pass.gps.impl.AbstractCompassGps.start(AbstractCompassGps.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1237)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:427)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.populateBean(AbstractAutowireCapableBeanFactory.java:857)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:291)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:352)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:245)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:188)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
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
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)
12:08:31 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class or
g.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassIndexBuilder' defined in ServletContext resource [/WEB-INF/applic
ationContext-compass.xml]: Cannot resolve reference to bean 'compassGps' while s
etting bean property 'compassGps'; nested exception is org.springframework.beans
.factory.BeanCreationException: Error creating bean with name 'compassGps' defin
ed in ServletContext resource [/WEB-INF/applicationContext-compass.xml]: Invocat
ion o nested exception is java.lang.ClassCastException: $Pr
oxy0 cannot be cast to org.hibernate.impl.SessionFactoryImpl
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'compassGps' defined in ServletContext resource [/WEB-INF/appl
icationContext-compass.xml]: Invocation o nested exception
is java.lang.ClassCastException: $Proxy0 cannot be cast to org.hibernate.impl.Se
ssionFactoryImpl
Caused by: java.lang.ClassCastException: $Proxy0 cannot be cast to org.hibernate
.impl.SessionFactoryImpl
pass.gps.device.hibernate.lifecycle.DefaultHibernateEntityLifecycleIn
jector.injectLifecycle(DefaultHibernateEntityLifecycleInjector.java:95)
pass.gps.device.hibernate.HibernateGpsDevice.doStart(HibernateGpsDevi
ce.java:149)
pass.gps.device.AbstractGpsDevice.start(AbstractGpsDevice.java:125)
pass.gps.device.support.parallel.AbstractParallelGpsDevice.start(Abst
ractParallelGpsDevice.java:73)
pass.gps.device.AbstractGpsDeviceWrapper.start(AbstractGpsDeviceWrapp
er.java:65)
pass.gps.impl.AbstractCompassGps.start(AbstractCompassGps.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1237)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:427)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.populateBean(AbstractAutowireCapableBeanFactory.java:857)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:291)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:352)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:245)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:188)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
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
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)
意思是说你的spring的配置文件没有找到，这种情况你可能将spring的配置文件放在了src下面。为了防止这种情况的发生，你以后可以将spring的配置文件放在web-inf下面。这里的解决方案是,把加载applicationContext.xml的路径改成：
web-inf/classes/applicationContext.xml。
如果你用了框架的整合，那就在web.xml中这样子写就可以了
&context-param&
&& ¶m-name&contextConfigLocation&/param-name&
&& ¶m-value&
&&&&&&&& /WEB-INF/classes/applicationContext.xml
&& &/param-value&
&/context-param&
请提供类 SingleCompassGps 的代码
主要是 init-method="start" 也就是方法 start() 的内容
compassIndexBuilder
这个Bean配置有问题 检查一下
log说compassIndexBuilder的属性compassGps引用的Bean compassGps(也叫compassGps? 未定义, 找不到) 这个错误是由下面原因造成的
创建Bean compassGps时出错 Invocation of init method failed, java.lang.ClassCastException
$Proxy8 cannot be cast to org.hibernate.impl.SessionFactoryImpl
把你的配置文件贴出来看看, 就是这个文件 /WEB-INF/applicationContext-compass.xml
看看spring中这个compassGps的配置
$Proxy8 cannot be cast to org.hibernate.impl.SessionFactoryImpl
这句是关键!
仔细检查下SessionFactoryImpl这个bean
spring的配置文件有问题
已解决问题
未解决问题}
[已解决]请高手看看这个1004的错误，即“类RANG的COPY方法无效是什么原因（EXCEL用的是2003版
具体的代码如下：
Dim r As Range, fs As FileSearch
Dim x, y As Excel.Worksheet
Dim z As Integer
& & Set myexcel = Excel.Application
& & Set fs = Application.FileSearch
& & Set x = ThisWorkbook.Sheets(&sheet1&)
& & Set y = ThisWorkbook.Sheets(&sheet2&)
& & With fs
& && &&&.LookIn = ThisWorkbook.Path & &\运行文件夹&
& && &&&.Filename = &*.xls&
& && &&&If .Execute & 0 Then
& && && && &Application.ScreenUpdating = False
& && && && &For i = 1 To .FoundFiles.Count
& && && && && & Workbooks.Open .FoundFiles(i)
& && && && && & Rows(&1:1&).Select
& && && && && & myexcel.Selection.AutoFilter
& && && && && & myexcel.Selection.AutoFilter Field:=2, Criteria1:=&=&
& && && && && & Set r = ActiveSheet.AutoFilter.Range.SpecialCells(12)
& && && && && & r.Select
& && && && && & myexcel.Selection.Copy y.Cells(1, 1)
& && && && && & z = y.Range(&a65536&).End(xlUp).Row
& && && && && & x.Cells(i, 1).Value = z - 2
& && && && && & y.Cells.Clear
& && && && && & ActiveWorkbook.Close False
& && && && &Next i
& && && && &MsgBox &There were & & .FoundFiles.Count & & file(s) found.&
& && &&&Else
& && && && &MsgBox &There were no files found.&
& && &&&End If
& & End With
逐条运行后，在这句”myexcel.Selection.Copy y.Cells(1, 1)“上出了问题，系统报错：1004，类”RANG“的COPY方法无效”，但我看了一下代码表格中的SHEET2已经被COPY过去了具体的内容，到底是什么原因导致了代码运行不下去了，我查了一下宝典，解释了1004的错误是一种全捕获的错误，是EXCEL本身及相关对象的定义错误，但具体情况却未再做详细解释，到底是什么原因，请各位高手予以解答，万分感谢，悬赏分不多，仅是什么意思，还望各位海涵！！！另附件已上传
15:02 上传
点击文件名下载附件
23.53 KB, 下载次数: 22
Sub Macro4()
' Macro4 Macro
' 宏由 User 录制，时间:
Dim iAreas As Long, iRow As Long
Dim myexcel As Excel.Application
Dim r As Range, fs As FileSearch
Dim x, y As Excel.Worksheet
Dim z As Integer
Set myexcel = Excel.Application
Set fs = Application.FileSearch
Set x = ThisWorkbook.Sheets("sheet1")
Set y = ThisWorkbook.Sheets("sheet ...
吕布发布于
Sub Macro4()
' Macro4 Macro
' 宏由 User 录制，时间:
& & Dim iAreas As Long, iRow As Long
& & Dim myexcel As Excel.Application
& & Dim r As Range, fs As FileSearch
& & Dim x, y As Excel.Worksheet
& & Dim z As Integer
& & Set myexcel = Excel.Application
& & Set fs = Application.FileSearch
& & Set x = ThisWorkbook.Sheets(&sheet1&)
& & Set y = ThisWorkbook.Sheets(&sheet2&)
& & With fs
& && &&&.LookIn = ThisWorkbook.Path & &\运行文件夹&
& && &&&.Filename = &*.xls&
& && &&&If .Execute & 0 Then
& && && && &Application.ScreenUpdating = False
& && && && &For i = 1 To .FoundFiles.Count
& && && && && & Workbooks.Open .FoundFiles(i)
& && && && && & Rows(&1:1&).Select
& && && && && & myexcel.Selection.AutoFilter
& && && && && & myexcel.Selection.AutoFilter Field:=2, Criteria1:=&=&
& && && && && & Set r = ActiveSheet.AutoFilter.Range.SpecialCells(12)
& && && && && & 'r.Select
& && && && && & 'myexcel.Selection.Copy y.Cells(1, 1)
& && && && && &
& && && && && & ' 因为筛选后复制的区域不连续，粘贴时是粘贴不上的。要一个一个的粘贴
& && && && && & iRow = 1
& && && && && & For iAreas = 1 To r.Areas.Count
& && && && && && &&&r.Areas(iAreas).Copy y.Cells(iRow, 1)
& && && && && && &&&iRow = iRow + r.Areas(iAreas).Rows.Count
& && && && && & Next iAreas
& && && && && &
& && && && && & z = y.Range(&a65536&).End(xlUp).Row
& && && && && & x.Cells(i, 1).Value = z - 2
& && && && && & y.Cells.Clear
& && && && && & ActiveWorkbook.Close False
& && && && &Next i
& && && && &MsgBox &There were & & .FoundFiles.Count & & file(s) found.&
& && &&&Else
& && && && &MsgBox &There were no files found.&
& && &&&End If
& & End With
&&&本楼为最佳答案&&&
Sub Macro4()
' Macro4 Macro
' 宏由 User 录制，时间:
& & Dim iAreas As Long, iRow As Long
& & Dim myexcel As Excel.Application
& & Dim r As Range, fs As FileSearch
& & Dim x, y As Excel.Worksheet
& & Dim z As Integer
& & Set myexcel = Excel.Application
& & Set fs = Application.FileSearch
& & Set x = ThisWorkbook.Sheets(&sheet1&)
& & Set y = ThisWorkbook.Sheets(&sheet2&)
& & With fs
& && &&&.LookIn = ThisWorkbook.Path & &\运行文件夹&
& && &&&.Filename = &*.xls&
& && &&&If .Execute & 0 Then
& && && && &Application.ScreenUpdating = False
& && && && &For i = 1 To .FoundFiles.Count
& && && && && & Workbooks.Open .FoundFiles(i)
& && && && && & Rows(&1:1&).Select
& && && && && & myexcel.Selection.AutoFilter
& && && && && & myexcel.Selection.AutoFilter Field:=2, Criteria1:=&=&
& && && && && & Set r = ActiveSheet.AutoFilter.Range.SpecialCells(12)
& && && && && & 'r.Select
& && && && && & 'myexcel.Selection.Copy y.Cells(1, 1)
& && && && && &
& && && && && & ' 因为筛选后复制的区域不连续，粘贴时是粘贴不上的。要一个一个的粘贴
& && && && && & iRow = 1
& && && && && & For iAreas = 1 To r.Areas.Count
& && && && && && &&&r.Areas(iAreas).Copy y.Cells(iRow, 1)
& && && && && && &&&iRow = iRow + r.Areas(iAreas).Rows.Count
& && && && && & Next iAreas
& && && && && &
& && && && && & z = y.Range(&a65536&).End(xlUp).Row
& && && && && & x.Cells(i, 1).Value = z - 2
& && && && && & y.Cells.Clear
& && && && && & ActiveWorkbook.Close False
& && && && &Next i
& && && && &MsgBox &There were & & .FoundFiles.Count & & file(s) found.&
& && &&&Else
& && && && &MsgBox &There were no files found.&
& && &&&End If
& & End With
帮顶的人& && &
本帖最后由 adders 于
04:48 编辑
It might be caused by the whole row selection line: Rows(&1:1&).Select
instead, you may want to change above to:
range(cells(1,1),cells(1,cells(1,columns.count).end(xltoLeft).column)).select
Microsoft Refrence: /kb/905164
看了楼上的回复，我好象有点明白了，这是EXCEL本身自带的一个错误，只能采用别的方式，但问题是我想得到筛选的结果，即正常我们进行了自动筛选后，EXCEL会告诉我选出了多少条纪录，我现在就是想得出这个多少条的信息，既然COPY的方法无效，那么该用哪一种方法，我知道要以用分类汇总的方式，但问题是我带的表已经是分类汇总的形式了，请高手们能够予以赐教，万分感激！！！！！！！！！！！！！！！！
果然是高手，受益非浅
Powered by关注微信公众号
扫一扫，访问微社区
查看: 1333|回复: 3
大家帮看下这是什么原因
Minor Error
CCT-7609#sh module
Mod Ports Card Type& && && && && && && && && && &Model& && && && &&&Serial No.
--- ----- -------------------------------------- ------------------ -----------
&&1& &24&&CEF720 24 port 1000mb SFP& && && && &&&WS-X6724-SFP& && & SAL11392E89
&&2& &24&&CEF720 24 port 1000mb SFP& && && && &&&WS-X6724-SFP& && & SAL11391JNV
&&5& & 2&&Supervisor Engine 720 (Active)& && && &WS-SUP720-3B& && & SAL1204EBG7
&&6& & 2&&Supervisor Engine 720 (Hot)& && && && &WS-SUP720-3B& && & SAL1022PLFV
Mod MAC addresses& && && && && && && &&&Hw& & Fw& && && &&&Sw& && && &&&Status
--- ---------------------------------- ------ ------------ ------------ -------
&&1&&0013.7fbc.03a0 to 0013.7fbc.03b7& &2.1& &12.2(14r)S5&&12.2(33)SRA7 Ok
&&2&&0013.7fbc.03a0 to 0013.7fbc.03b7& &2.1& &12.2(14r)S5&&12.2(33)SRA7 Ok
&&5&&.9048 to .904b& &5.4& &8.4(2)& && & 12.2(33)SRA7 Ok
&&6&&.52cc to .52cf& &5.2& &8.4(2)& && & 12.2(33)SRA7 Ok
Mod&&Sub-Module& && && && && && &Model& && && && &&&Serial& && & Hw& &&&Status
---- --------------------------- ------------------ ----------- ------- -------
&&1&&Distributed Forwarding Card WS-F6700-DFC3B& &&&SAL1213KEM2&&4.6& & Ok
&&2&&Centralized Forwarding Card WS-F6700-CFC& && & SAL11402ZAS&&2.0& & Ok
&&5&&Policy Feature Card 3& && & WS-F6K-PFC3B& && & SAL1129UTS4&&2.3& & Ok
&&5&&MSFC3 Daughterboard& && && &WS-SUP720& && && & SAL1115L3WY&&2.6& & Ok
&&6&&Policy Feature Card 3& && & WS-F6K-PFC3B& && & SAL.3& & Ok
&&6&&MSFC3 Daughterboard& && && &WS-SUP720& && && & SAL1020N6PJ&&2.5& & Ok
Mod&&Online Diag Status
---- -------------------
&&1&&Minor Error
----------------------------------------------------------------------------------------------------
CCT-7609#sh diagnostic events
Diagnostic events (storage for 500 events, 9 events recorded)
Event Type (ET): I - Info, W - Warning, E - Error
Time Stamp& && && &ET [Card] Event Message
------------------ -- --------------------------------------------------------
09/16 22:09:18.259 I&&[5] Diagnostics Passed
09/16 22:09:52.211 I&&[2] Diagnostics Passed
09/16 22:11:50.495 E&&[1] TestLoopback Failed
09/16 22:11:55.119 E&&[1] Minor Error Detected
09/16 22:11:56.995 I&&[6] Diagnostics Passed
08/08 12:33:11.207 I&&[3] Diagnostics Passed
08/08 12:57:17.407 E&&[3] TestSynchedFabChannel Failed
09/04 06:21:24.720 I&&[6] Diagnostics Passed
09/04 06:40:01.656 I&&[6] Diagnostics Passed
-------------------------------------------------------------------------------------------------------------------
真心不知道这是什么错误，求教，但是现在业务正常运行
平均得分0 (0 评价)
其实Minor Error都是一些小的错误，有的时候重新插拔一下线卡就不会报错了。
但是如果你想知道细节的东西，还是推荐开case解决。。你可以先看下syslog其他log有没有什么重要的报警。
平均得分0 (0 评价)
本帖最后由 shwlzcco1 于
14:43 编辑
show diagnostic result module 1
看一下输出
平均得分0 (0 评价)
插拔下~~ 实在不行就修了
平均得分0 (0 评价)
京ICP备号-187
版权所有 :copyright: 思科系统 & |2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
2015年8月 移动开发大版内专家分月排行榜第三2014年9月 移动开发大版内专家分月排行榜第三2014年7月 移动开发大版内专家分月排行榜第三
匿名用户不能发表回复！|
每天回帖即可获得10分可用分！小技巧：
你还可以输入10000个字符
(Ctrl+Enter)
请遵守CSDN，不得违反国家法律法规。
转载文章请注明出自“CSDN（www.csdn.net）”。如是商业用途请联系原作者。大家帮我看看这个错误该怎么解决 - ITeye问答
log4j:WARN Please initialize the log4j system properly.
15:00:41 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class or
g.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassIndexBuilder' defined in ServletContext resource [/WEB-INF/applic
ationContext-compass.xml]: Cannot resolve reference to bean 'compassGps' while s
etting bean property 'compassGps'; nested exception is org.springframework.beans
.factory.BeanCreationException: Error creating bean with name 'compassGps' defin
ed in ServletContext resource [/WEB-INF/applicationContext-compass.xml]: Invocat
ion o nested exception is java.lang.ClassCastException: $Pr
oxy8 cannot be cast to org.hibernate.impl.SessionFactoryImpl
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'compassGps' defined in ServletContext resource [/WEB-INF/appl
icationContext-compass.xml]: Invocation o nested exception
is java.lang.ClassCastException: $Proxy8 cannot be cast to org.hibernate.impl.Se
ssionFactoryImpl
Caused by: java.lang.ClassCastException: $Proxy8 cannot be cast to org.hibernate
.impl.SessionFactoryImpl
pass.gps.device.hibernate.lifecycle.DefaultHibernateEntityLifecycleIn
jector.injectLifecycle(DefaultHibernateEntityLifecycleInjector.java:95)
pass.gps.device.hibernate.HibernateGpsDevice.doStart(HibernateGpsDevi
ce.java:149)
pass.gps.device.AbstractGpsDevice.start(AbstractGpsDevice.java:125)
pass.gps.device.support.parallel.AbstractParallelGpsDevice.start(Abst
ractParallelGpsDevice.java:73)
pass.gps.device.AbstractGpsDeviceWrapper.start(AbstractGpsDeviceWrapp
er.java:65)
pass.gps.impl.AbstractCompassGps.start(AbstractCompassGps.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1237)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:427)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.populateBean(AbstractAutowireCapableBeanFactory.java:857)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:291)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:352)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:245)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:188)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.startup.HostConfig.checkResources(HostConfig.java:1116)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1214)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:293)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:117)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processC
hildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(Cont
ainerBase.java:1590)
at java.lang.Thread.run(Thread.java:619)
15:00:41 org.apache.catalina.core.StandardContext start
严重: Error listenerStart
15:00:41 org.apache.catalina.core.StandardContext start
严重: Context [/datashare] startup failed due to previous errors问题补充：我本来的配置都没有问题，但是今天整合了compass之后，tomcat启动就出错了！问题补充：WEB-INF/applicationContext-compass.xml 内容如下：
&beans xmlns="http://www.springframework.org/schema/beans" &br=""& xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=" http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.0.xsd" default-lazy-init="true"&
&bean id="annotationConfiguration" &br=""&
class="pass.passAnnotationsConfiguration"&
&bean id="compass" class="pass.spring.LocalCompassBean"&
&property name="resourceDirectoryLocations"&
&value&classpath:com/datashare&/value&
&/property&
&property name="connection"&
&value&/lucene/indexes&/value&
&/property&
&property name="classMappings"&
&value&com.datashare.model.Book&/value&
&/property&
&property name="compassConfiguration" &br=""&
ref="annotationConfiguration" /&
&property name="compassSettings"&
&prop key="compass.transaction.factory"&
pass.spring.transaction.SpringSyncTransactionFactory
&prop key="compass.engine.analyzer.MMAnalyzer.CustomAnalyzer"&net.paoding.analysis.analyzer.PaodingAnalyzer &/prop&
&/property&
&property name="transactionManager" ref="transactionManager"&
&bean id="hibernateGpsDevice" &br=""&
class="pass.gps.device.hibernate.HibernateGpsDevice"&
&property name="name"&
&value&hibernateDevice&/value&
&/property&
&property name="sessionFactory" ref="sessionFactory"&
&property name="mirrorDataChanges"&
&value&true&/value&
&/property&
&bean id="compassGps" class="pass.gps.impl.SingleCompassGps" &br=""&
init-method="start" destroy-method="stop"&
&property name="compass" ref="compass"&
&property name="gpsDevices"&
&bean &br=""&
class="pass.spring.device.SpringSyncTransactionGpsDeviceWrapper"&
&property name="gpsDevice" ref="hibernateGpsDevice"&
&/property&
&bean id="compassTemplate" &br=""&
class="passTemplate"&
&property name="compass" ref="compass"&
&bean id="compassIndexBuilder" &br=""&
class="com.datashare.passIndexBuilder"
lazy-init="false"&
&property name="compassGps" ref="compassGps"&
&property name="buildIndex" value="true"&
&property name="lazyTime" value="10"&
&/beans&问题补充：我用log4j捕捉的到的错误信息：
信息: Initializing Spring root WebApplicationContext
12:08:26,578
INFO Environment:479 - Hibernate 3.1.3
12:08:26,609
INFO Environment:509 - hibernate.properties not found
12:08:26,609
INFO Environment:525 - using CGLIB reflection optimizer
12:08:26,625
INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
12:08:27,187
INFO HbmBinder:309 - Mapping class: com.datashare.model.BookCatego
ry -& bookcategory
12:08:27,265
INFO HbmBinder:309 - Mapping class: com.datashare.model.BookMetada
ta -& bookmetadata
12:08:27,453
INFO HbmBinder:309 - Mapping class: com.datashare.model.BookCatalo
g -& bookcatalog
12:08:27,468
INFO HbmBinder:309 - Mapping class: com.datashare.model.Book -& bo
12:08:27,484
INFO HbmBinder:309 - Mapping class: com.datashare.model.CourseWare
Category -& coursewarecategory
12:08:27,500
INFO HbmBinder:309 - Mapping class: com.datashare.model.CourseWare
-& courseware
12:08:27,515
INFO HbmBinder:309 - Mapping class: com.datashare.model.News -& Qm
12:08:27,531
INFO HbmBinder:309 - Mapping class: com.datashare.model.Admin -& a
12:08:27,562
INFO ConnectionProviderFactory:72 - Initializing connection provid
er: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
12:08:28,015
INFO SettingsFactory:77 - RDBMS: Microsoft SQL Server, version: Mi
crosoft SQL Server
2000 - 8.00.760 (Intel X86)
Dec 17 :05
Copyright (c)
Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
12:08:28,015
INFO SettingsFactory:78 - JDBC driver: SQLServer, version: 2.2.004
12:08:28,203
INFO Dialect:103 - Using dialect: org.hibernate.dialect.SQLServerD
12:08:28,218
INFO TransactionFactoryFactory:31 - Using default transaction stra
tegy (direct JDBC transactions)
12:08:28,234
INFO TransactionManagerLookupFactory:33 - No TransactionManagerLoo
kup configured (in JTA environment, use of read-write or transactional second-le
vel cache is not recommended)
12:08:28,234
INFO SettingsFactory:125 - Automatic flush during beforeCompletion
(): disabled
12:08:28,234
INFO SettingsFactory:129 - Automatic session close at end of trans
action: disabled
12:08:28,234
INFO SettingsFactory:144 - Scrollable result sets: enabled
12:08:28,250
INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
12:08:28,250
INFO SettingsFactory:160 - Connection release mode: on_close
12:08:28,250
INFO SettingsFactory:187 - Default batch fetch size: 1
12:08:28,250
INFO SettingsFactory:191 - Generate SQL with comments: disabled
12:08:28,250
INFO SettingsFactory:195 - Order SQL updates by primary key: disab
12:08:28,250
INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast
.ASTQueryTranslatorFactory
12:08:28,265
INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactor
12:08:28,265
INFO SettingsFactory:203 - Query language substitutions: {}
12:08:28,265
INFO SettingsFactory:209 - Second-level cache: enabled
12:08:28,265
INFO SettingsFactory:213 - Query cache: enabled
12:08:28,265
INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.EhC
acheProvider
12:08:28,281
INFO SettingsFactory:228 - Optimize cache for minimal puts: disabl
12:08:28,281
INFO SettingsFactory:237 - Structured second-level cache entries:
12:08:28,281
INFO SettingsFactory:312 - Query cache factory: org.hibernate.cach
e.StandardQueryCacheFactory
12:08:28,312
INFO SettingsFactory:257 - Echoing all SQL to stdout
12:08:28,312
INFO SettingsFactory:264 - Statistics: disabled
12:08:28,312
INFO SettingsFactory:268 - Deleted entity synthetic identifier rol
lback: disabled
12:08:28,312
INFO SettingsFactory:283 - Default entity-mode: pojo
12:08:28,421
INFO SessionFactoryImpl:154 - building session factory
12:08:29,484
INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI,
no JNDI name configured
12:08:29,484
INFO UpdateTimestampsCache:43 - starting update timestamps cache a
t region: org.hibernate.cache.UpdateTimestampsCache
12:08:29,500
WARN EhCacheProvider:103 - Could not find configuration [org.hiber
nate.cache.UpdateTimestampsCache]; using defaults.
12:08:29,500
INFO StandardQueryCache:51 - starting query cache at region: org.h
ibernate.cache.StandardQueryCache
12:08:29,515
WARN EhCacheProvider:103 - Could not find configuration [org.hiber
nate.cache.StandardQueryCache]; using defaults.
12:08:31,453
INFO SessionFactoryImpl:729 - closing
12:08:31,468 ERROR ContextLoader:204 - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassIndexBuilder' defined in ServletContext resource [/WEB-INF/applic
ationContext-compass.xml]: Cannot resolve reference to bean 'compassGps' while s
etting bean property 'compassGps'; nested exception is org.springframework.beans
.factory.BeanCreationException: Error creating bean with name 'compassGps' defin
ed in ServletContext resource [/WEB-INF/applicationContext-compass.xml]: Invocat
ion o nested exception is java.lang.ClassCastException: $Pr
oxy0 cannot be cast to org.hibernate.impl.SessionFactoryImpl
Caused by:
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassGps' defined in ServletContext resource [/WEB-INF/applicationCont
ext-compass.xml]: Invocation o nested exception is java.lan
g.ClassCastException: $Proxy0 cannot be cast to org.hibernate.impl.SessionFactor
Caused by:
java.lang.ClassCastException: $Proxy0 cannot be cast to org.hibernate.impl.Sessi
onFactoryImpl
pass.gps.device.hibernate.lifecycle.DefaultHibernateEntityLifecycleIn
jector.injectLifecycle(DefaultHibernateEntityLifecycleInjector.java:95)
pass.gps.device.hibernate.HibernateGpsDevice.doStart(HibernateGpsDevi
ce.java:149)
pass.gps.device.AbstractGpsDevice.start(AbstractGpsDevice.java:125)
pass.gps.device.support.parallel.AbstractParallelGpsDevice.start(Abst
ractParallelGpsDevice.java:73)
pass.gps.device.AbstractGpsDeviceWrapper.start(AbstractGpsDeviceWrapp
er.java:65)
pass.gps.impl.AbstractCompassGps.start(AbstractCompassGps.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1237)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:427)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.populateBean(AbstractAutowireCapableBeanFactory.java:857)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:291)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:352)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:245)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:188)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
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
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)
12:08:31 org.apache.catalina.core.StandardContext listenerStart
严重: Exception sending context initialized event to listener instance of class or
g.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean wit
h name 'compassIndexBuilder' defined in ServletContext resource [/WEB-INF/applic
ationContext-compass.xml]: Cannot resolve reference to bean 'compassGps' while s
etting bean property 'compassGps'; nested exception is org.springframework.beans
.factory.BeanCreationException: Error creating bean with name 'compassGps' defin
ed in ServletContext resource [/WEB-INF/applicationContext-compass.xml]: Invocat
ion o nested exception is java.lang.ClassCastException: $Pr
oxy0 cannot be cast to org.hibernate.impl.SessionFactoryImpl
Caused by: org.springframework.beans.factory.BeanCreationException: Error creati
ng bean with name 'compassGps' defined in ServletContext resource [/WEB-INF/appl
icationContext-compass.xml]: Invocation o nested exception
is java.lang.ClassCastException: $Proxy0 cannot be cast to org.hibernate.impl.Se
ssionFactoryImpl
Caused by: java.lang.ClassCastException: $Proxy0 cannot be cast to org.hibernate
.impl.SessionFactoryImpl
pass.gps.device.hibernate.lifecycle.DefaultHibernateEntityLifecycleIn
jector.injectLifecycle(DefaultHibernateEntityLifecycleInjector.java:95)
pass.gps.device.hibernate.HibernateGpsDevice.doStart(HibernateGpsDevi
ce.java:149)
pass.gps.device.AbstractGpsDevice.start(AbstractGpsDevice.java:125)
pass.gps.device.support.parallel.AbstractParallelGpsDevice.start(Abst
ractParallelGpsDevice.java:73)
pass.gps.device.AbstractGpsDeviceWrapper.start(AbstractGpsDeviceWrapp
er.java:65)
pass.gps.impl.AbstractCompassGps.start(AbstractCompassGps.java:166)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1237)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1203)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.initializeBean(AbstractAutowireCapableBeanFactory.java:1167)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:427)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eReference(BeanDefinitionValueResolver.java:267)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolv
eValueIfNecessary(BeanDefinitionValueResolver.java:110)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1095)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.populateBean(AbstractAutowireCapableBeanFactory.java:857)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
.createBean(AbstractAutowireCapableBeanFactory.java:423)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(Ab
stractBeanFactory.java:249)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSi
ngleton(DefaultSingletonBeanRegistry.java:155)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:246)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstra
ctBeanFactory.java:160)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInst
antiateSingletons(DefaultListableBeanFactory.java:291)
at org.springframework.context.support.AbstractApplicationContext.refresh(Abstr
actApplicationContext.java:352)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(Co
ntextLoader.java:245)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(Cont
extLoader.java:188)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(Con
textLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:7
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSuppor
t.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
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
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)
意思是说你的spring的配置文件没有找到，这种情况你可能将spring的配置文件放在了src下面。为了防止这种情况的发生，你以后可以将spring的配置文件放在web-inf下面。这里的解决方案是,把加载applicationContext.xml的路径改成：
web-inf/classes/applicationContext.xml。
如果你用了框架的整合，那就在web.xml中这样子写就可以了
&context-param&
&& ¶m-name&contextConfigLocation&/param-name&
&& ¶m-value&
&&&&&&&& /WEB-INF/classes/applicationContext.xml
&& &/param-value&
&/context-param&
请提供类 SingleCompassGps 的代码
主要是 init-method="start" 也就是方法 start() 的内容
compassIndexBuilder
这个Bean配置有问题 检查一下
log说compassIndexBuilder的属性compassGps引用的Bean compassGps(也叫compassGps? 未定义, 找不到) 这个错误是由下面原因造成的
创建Bean compassGps时出错 Invocation of init method failed, java.lang.ClassCastException
$Proxy8 cannot be cast to org.hibernate.impl.SessionFactoryImpl
把你的配置文件贴出来看看, 就是这个文件 /WEB-INF/applicationContext-compass.xml
看看spring中这个compassGps的配置
$Proxy8 cannot be cast to org.hibernate.impl.SessionFactoryImpl
这句是关键!
仔细检查下SessionFactoryImpl这个bean
spring的配置文件有问题
已解决问题
未解决问题}
我要回帖
更多关于 qq下载错误是怎么回事 的文章
更多推荐
- ·一个手机号注册2个微信可以直接登录吗？
- ·本田XR-V好还是启辰大V好1.8L手动和启辰T70 2.0L自动哪个车值得拥有？
- ·怎么用酷狗怎么在酷狗音乐下载mp3的音乐音乐
- ·自助小火锅加盟店10大品牌火锅培训地址？
- ·一拳超人视频在线观看免费第一季谁帮我截个图搜不到？
- ·有办法用 linux版visual studioo 写 linux 程序么
- ·如何初中化学观课评课报告课
- ·微信钱包提现没到账管家里面的微信钱包提现没到账金融十月一提现什么时候到账
- ·这幅尹延新的牡丹大约一元硬币牡丹值多少钱钱，请专业认识帮忙回答
- ·厕所阴角线多少钱一米米
- ·敦刻尔克中文百度云百度云高清
- ·js怎么生成重复js字符串去重复
- ·成长守护平台绑定自己被恶意绑定
- ·mac 终端 怎么mac打开终端快捷键特定应用 简书
- ·开发工作是怎样一番深入体验php项目开发
- ·2018华为优招offer2018校招有收到offer的吗
- ·如何设置myeclipse字符文件的存储字符编码
- ·苹果5s能更新ios11吗 ios11更新后的问题
- ·知道身一个人手机号码怎么查看其他手机号码
- ·迅游加速器充值共享
- ·看看这个错误是游戏数据错误怎么回事事
- ·韩剧爱你的时间韩剧百度云百度资源
- ·怎么登录交通360网站
- ·求电视剧《欢喜密探百度网盘资源》百度云资源，
- ·win10如何添加此电脑如何
- ·和iPhone 7有什么区别看完就知道了
- ·跪求，英伦对决国语百度网盘，百度网盘地址，求大神帮助
- ·如何评价intel虚拟技术开不开GPU技术
- ·http://http llpan.baidu.comm/mbox/homepage?short=eR7Zwdk
- ·新手求助western westernblot转膜时间间问题
- ·如何使用u盘安u盘重装win10系统步骤
- ·oncreateview没有调用holder什么时候调用
- ·玩手机的危害英语作文利弊英语作文
- ·怎么在虚拟机安装sql server中安装windows server 2008
- ·如何用Powerdesigner的PDM生成数据库文档生成工具及逆向生成
