UDN-企业互联网技术人气社区

板块导航

浏览  : 4761
回复  : 1

[集成平台] 那位帮我看看ESB监视数据库出错

[复制链接]
雨中渔的头像 楼主
发表于 2014-4-7 19:20:04 | 显示全部楼层 |阅读模式
本帖最后由 雨中渔 于 2014-4-7 19:21 编辑

服务启动成功!
+-------------------------------------------------------
| 组件名称:noticecomp
| 服务接口:esb.flew.demo.serv.NoticeDataServ
| 通讯协议:DBMonitor
| 服务操作:getNoticeData
| 监控模式:Table
| 数 据 源:tpn_orc
| 数 据 表:WMS_IN_NOTICES11
| 主键字段:ID
| 监控字段:write_time
+-------------------------------------------------------
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [AbstractAtomicComponentService          ] <INFO> - The service[esb.flew.demo.serv.NoticeDataServ(1.0.0)] provided by the component[ID: esb.flew.demo.comp.noticecomp.scomp, instance PATH: esb.flew.demo.comp.noticecomp.scomp] is started successfully!
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [EIPOsgiBundleApplicationContext         ] <INFO> - Refreshing EIPOsgiBundleApplicationContext(bundle=test.dbmonitor, config=classpath:dbm/DBMComp.scomp): startup date [Mon Apr 07 19:10:18 CST 2014]; root of context hierarchy
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [EIPOsgiBundleApplicationContext         ] <INFO> - Application Context service already unpublished
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [EIPOsgiBundleApplicationContext         ] <INFO> - Publishing application context as OSGi service with properties {org.springframework.context.service.name=test.dbmonitor, Bundle-SymbolicName=test.dbmonitor, Bundle-Version=1.0.0}
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [EIPStatic                               ] <WARN> - There is no configuration information for the component[dbm.DBMComp.scomp]! Nothing is updated!
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [AbstractComponent                       ] <WARN> - Couldn't find the conf info of the component[dbm.DBMComp.scomp] in system DB and the property won't be updated!
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [AbstractAtomicComponent                 ] <INFO> - Component [dbm.DBMComp.scomp] has no flow(s) to deploy!
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [AbstractAtomicComponentService          ] <INFO> - Begin to start the service[out.OutServ(1.0.0)] provided by the component[ID: dbm.DBMComp.scomp, component instance PATH: dbm.DBMComp.scomp]!
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [DbMonitorServiceBinding                 ] <INFO> - 启动服务--接口[out.OutServ];组件[DBMComp]……
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [DbMonitorServiceBinding                 ] <INFO> -
服务启动成功!
+-------------------------------------------------------
| 组件名称:DBMComp
| 服务接口:out.OutServ
| 通讯协议:DBMonitor
| 服务操作:outOpt
| 监控模式:Table
| 数 据 源:thirdDB
| 数 据 表:DBMTest01
| 主键字段:id
| 监控字段:ts
+-------------------------------------------------------
<2014-04-07 19:10:18> <EIP-ThreadPool-1                > [AbstractAtomicComponentService          ] <INFO> - The service[out.OutServ(1.0.0)] provided by the component[ID: dbm.DBMComp.scomp, instance PATH: dbm.DBMComp.scomp] is started successfully!
<2014-04-07 19:10:20> <af:scheduler#643af4_Worker-1    > [TableMonitorScanner                     ] <ERROR> - >>>>>>>>>>定时扫描数据库出错......
java.lang.NullPointerException
at com.ufida.eip.dbmonitor.service.table.TableMonitorScanner.scanOriginalData(TableMonitorScanner.java:131)
at com.ufida.eip.binding.asyn.abs.AbstractBindingDataScanner.scan(AbstractBindingDataScanner.java:65)
at com.ufida.eip.binding.asyn.impl.BindingDataTimerJob.execute(BindingDataTimerJob.java:39)
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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
<2014-04-07 19:10:20> <af:scheduler#643af4_Worker-1    > [AbstractBindingDataScanner              ] <INFO> - [0] BindingData needed to be retried, which includes the original, the retried and removed the repeated.
<2014-04-07 19:10:22> <JpaExtThread-2                  > [DependencyServiceManager                ] <INFO> - No unsatisfied OSGi service dependencies; completing initialization for ByteArrayOsgiBundleApplicationContext(bundle=com.ufida.eip.jpa, config=0)
<2014-04-07 19:10:22> <JpaExtThread-2                  > [ByteArrayOsgiBundleApplicationContext   ] <INFO> - Not publishing application context OSGi service for bundle Ufida Eip ESB :: Datasource (com.ufida.eip.datasource)
<2014-04-07 19:10:25> <af:scheduler#643af4_Worker-2    > [TableMonitorScanner                     ] <ERROR> - >>>>>>>>>>定时扫描数据库出错......
java.lang.NullPointerException
at com.ufida.eip.dbmonitor.service.table.TableMonitorScanner.scanOriginalData(TableMonitorScanner.java:131)
at com.ufida.eip.binding.asyn.abs.AbstractBindingDataScanner.scan(AbstractBindingDataScanner.java:65)
at com.ufida.eip.binding.asyn.impl.BindingDataTimerJob.execute(BindingDataTimerJob.java:39)
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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
<2014-04-07 19:10:25> <af:scheduler#643af4_Worker-2    > [AbstractBindingDataScanner              ] <INFO> - [0] BindingData needed to be retried, which includes the original, the retried and removed the repeated.
<2014-04-07 19:10:30> <af:scheduler#643af4_Worker-3    > [TableMonitorScanner                     ] <ERROR> - >>>>>>>>>>定时扫描数据库出错......
java.lang.NullPointerException
at com.ufida.eip.dbmonitor.service.table.TableMonitorScanner.scanOriginalData(TableMonitorScanner.java:131)
at com.ufida.eip.binding.asyn.abs.AbstractBindingDataScanner.scan(AbstractBindingDataScanner.java:65)
at com.ufida.eip.binding.asyn.impl.BindingDataTimerJob.execute(BindingDataTimerJob.java:39)
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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
<2014-04-07 19:10:30> <af:scheduler#643af4_Worker-3    > [AbstractBindingDataScanner              ] <INFO> - [0] BindingData needed to be retried, which includes the original, the retried and removed the repeated.
<2014-04-07 19:10:30> <af:scheduler#166d30b_Worker-1   > [TableMonitorScanner                     ] <ERROR> - >>>>>>>>>>定时扫描数据库出错......
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9
at org.hibernate.dialect.TypeNames.get(TypeNames.java:76)
at org.hibernate.dialect.TypeNames.get(TypeNames.java:99)
at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:592)
at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:696)
at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:600)
at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:616)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2048)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1837)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1816)
at org.hibernate.loader.Loader.doQuery(Loader.java:900)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)
at org.hibernate.loader.Loader.doList(Loader.java:2526)
at org.hibernate.loader.Loader.doList(Loader.java:2512)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2342)
at org.hibernate.loader.Loader.list(Loader.java:2337)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338)
at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1827)
at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:231)
at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.ufida.eip.jpa.dao.callback.support.NativeListMapQueryCallback.action(NativeListMapQueryCallback.java:109)
at com.ufida.eip.jpa.dao.callback.support.NativeListMapQueryCallback.action(NativeListMapQueryCallback.java:1)
at com.ufida.eip.jpa.dao.impl.BaseDaoImpl$1.doInTransaction(BaseDaoImpl.java:425)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:71)
at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:54)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy50.execute(Unknown Source)
at com.ufida.eip.jpa.dao.impl.BaseDaoImpl.executeInTransaction(BaseDaoImpl.java:422)
at com.ufida.eip.jpa.dao.impl.BaseDaoImpl.execute(BaseDaoImpl.java:255)
at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at $Proxy55.execute(Unknown Source)
at com.ufida.eip.dbmonitor.service.table.TableMonitorScanner.scanOriginalData(TableMonitorScanner.java:131)
at com.ufida.eip.binding.asyn.abs.AbstractBindingDataScanner.scan(AbstractBindingDataScanner.java:65)
at com.ufida.eip.binding.asyn.impl.BindingDataTimerJob.execute(BindingDataTimerJob.java:39)
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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
<2014-04-07 19:10:30> <af:scheduler#166d30b_Worker-1   > [AbstractBindingDataScanner              ] <INFO> - [0] BindingData needed to be retried, which includes the original, the retried and removed the repeated.
<2014-04-07 19:10:35> <af:scheduler#643af4_Worker-4    > [TableMonitorScanner                     ] <ERROR> - >>>>>>>>>>定时扫描数据库出错......
java.lang.NullPointerException
at com.ufida.eip.dbmonitor.service.table.TableMonitorScanner.scanOriginalData(TableMonitorScanner.java:131)
at com.ufida.eip.binding.asyn.abs.AbstractBindingDataScanner.scan(AbstractBindingDataScanner.java:65)
at com.ufida.eip.binding.asyn.impl.BindingDataTimerJob.execute(BindingDataTimerJob.java:39)
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.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:311)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)


test.dbmonitor.rar

19 KB, 下载次数: 0

工程文件

发表于 2014-4-25 14:26:19 | 显示全部楼层



数据库是啥,哪个版本?
使用道具 举报

回复

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关于我们
联系我们
  • 电话:010-86393388
  • 邮件:udn@yonyou.com
  • 地址:北京市海淀区北清路68号
移动客户端下载
关注我们
  • 微信公众号:yonyouudn
  • 扫描右侧二维码关注我们
  • 专注企业互联网的技术社区
版权所有:用友网络科技股份有限公司82041 京ICP备05007539号-11 京公网网备安1101080209224 Powered by Discuz!
快速回复 返回列表 返回顶部