程序迁移至虚拟机后,程序无法连接数据的问题。

系统架构:mysql5.5.62+finereport10(未注册)+tomcat8.5.38

具体问题描述如下:

(一)我开发用的笔记本电脑上系统运行正常。

在我笔记本电脑上,系统能正常跑起来,效果如下图所示:

开发用笔记本电脑上正常.jpg

(二)在虚拟机上部署,跑不起来。

将mysql数据库、tomcat、以及Finereport10文件夹中的webroot项目文件拷贝安装到vmware workstation虚拟机中后,数据库连接显示正常,如下图:

连接成功.jpg

但是前台页面显示不出数据库中的数据(效果如下图):

虚拟机上无法链接数据库.jpg

同时tomcat中报错,tomcat日志信息显示如下:

 at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)

 at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)

 at com.fr.web.controller.BaseRequestService.preview(Unknown Source)

 at com.fr.web.controller.ReportRequestService.preview(Unknown Source)

 at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

.java:43)

 at java.lang.reflect.Method.invoke(Method.java:498)

 at com.fr.third.springframework.web.method.support.InvocableHandlerMetho

oke(InvocableHandlerMethod.java:221)

 at com.fr.third.springframework.web.method.support.InvocableHandlerMetho

eForRequest(InvocableHandlerMethod.java:137)

 at com.fr.third.springframework.web.servlet.mvc.method.annotation.Servle

bleHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

 at com.fr.third.springframework.web.servlet.mvc.method.annotation.Reques

gHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)


 at com.fr.third.springframework.web.servlet.mvc.method.annotation.Reques

gHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)

 at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMe

pter.handle(AbstractHandlerMethodAdapter.java:85)

 at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch

cherServlet.java:938)

 at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(

herServlet.java:870)

 at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequ

meworkServlet.java:961)

 at com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(Fram

rvlet.java:863)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)

 at com.fr.third.springframework.web.servlet.FrameworkServlet.service(Fra

ervlet.java:837)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:231)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52


 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:193)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFil

rnal(CharacterEncodingFilter.java:88)

 at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter

rRequestFilter.java:107)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:193)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at com.fr.decision.base.DecisionServletInitializer$4.doFilter(Unknown So


 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:193)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

va:199)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

va:96)

 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica

.java:493)

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j


 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAcce

lve.java:650)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

:87)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav


 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java


 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig

:66)

 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract

l.java:806)

 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo

a:1498)

 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas

49)

 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

49)

 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

24)

 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh

va:61)

 at java.lang.Thread.run(Thread.java:748)

by: java.util.concurrent.ExecutionException: java.sql.SQLException: Can't

ile: '.\zhengxin\@003f@003f@003f.frm' (errno: 22)

 at java.util.concurrent.FutureTask.report(FutureTask.java:122)

 at java.util.concurrent.FutureTask.get(FutureTask.java:206)

 ... 71 more

by: java.sql.SQLException: Can't find file: '.\zhengxin\@003f@003f@003f.f

rno: 22)

 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)

 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)

 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)

 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)

 at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)

 at com.fr.third.alibaba.druid.pool.DruidPooledStatement.executeQuery(Dru

dStatement.java:140)

 at com.fr.data.core.db.dialect.base.key.create.executequery.DialectExecu

Key.execute(Unknown Source)

 at com.fr.data.core.db.dialect.base.key.create.executequery.DialectExecu

Key.execute(Unknown Source)

 at com.fr.data.core.db.dialect.AbstractDialect.execute(Unknown Source)

 at com.fr.data.core.db.dialect.DefaultDialect.executeQuery(Unknown Sourc


 at com.fr.data.impl.AbstractDBDataModel$1.call(Unknown Source)

 at com.fr.data.impl.AbstractDBDataModel$1.call(Unknown Source)

 at java.util.concurrent.FutureTask.run(FutureTask.java:266)

 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

49)

 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

24)

 ... 1 more

0 http-nio-8080-exec-6 ERROR [standard] 错误代码:11300001 数据集配置错误


il.concurrent.ExecutionException: java.sql.SQLException: Can't find file:

ngxin\@003f@003f@003f.frm' (errno: 22)

.general.data.TableDataException: 错误代码:11300001 数据集配置错误


il.concurrent.ExecutionException: java.sql.SQLException: Can't find file:

ngxin\@003f@003f@003f.frm' (errno: 22)

 at com.fr.data.impl.AbstractCacheDBDataModel.hasRow(Unknown Source)

 at com.fr.data.impl.MemCachedDBDataModel.getRowCount(Unknown Source)

 at com.fr.data.index.AbstractIndexDataModel.getRowCount(Unknown Source)

 at com.fr.data.impl.FormulaDisplayDictionary.createKVS(Unknown Source)

 at com.fr.data.impl.FormulaDisplayDictionary.entrys(Unknown Source)

 at com.fr.form.ui.ComboBoxDataFilter.filterAndPutData(Unknown Source)

 at com.fr.form.ui.ComboBox.filterAndPutData(Unknown Source)

 at com.fr.form.ui.ComboBox.createJSONData(Unknown Source)

 at com.fr.web.core.B.u.B(Unknown Source)

 at com.fr.web.core.B.m.actionCMD(Unknown Source)

 at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)


 at com.fr.web.core.B.CB.process(Unknown Source)

 at com.fr.stable.fun.impl.NoOPService.process(Unknown Source)

 at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)

 at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)

 at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)

 at com.fr.web.controller.BaseRequestService.preview(Unknown Source)

 at com.fr.web.controller.ReportRequestService.preview(Unknown Source)

 at sun.reflect.GeneratedMethodAccessor86.invoke(Unknown Source)

 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

.java:43)

 at java.lang.reflect.Method.invoke(Method.java:498)

 at com.fr.third.springframework.web.method.support.InvocableHandlerMetho

oke(InvocableHandlerMethod.java:221)

 at com.fr.third.springframework.web.method.support.InvocableHandlerMetho

eForRequest(InvocableHandlerMethod.java:137)

 at com.fr.third.springframework.web.servlet.mvc.method.annotation.Servle

bleHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

 at com.fr.third.springframework.web.servlet.mvc.method.annotation.Reques

gHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)


 at com.fr.third.springframework.web.servlet.mvc.method.annotation.Reques

gHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)

 at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMe

pter.handle(AbstractHandlerMethodAdapter.java:85)

 at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch

cherServlet.java:938)

 at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(

herServlet.java:870)

 at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequ

meworkServlet.java:961)

 at com.fr.third.springframework.web.servlet.FrameworkServlet.doPost(Fram

rvlet.java:863)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)

 at com.fr.third.springframework.web.servlet.FrameworkServlet.service(Fra

ervlet.java:837)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:231)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52


 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:193)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFil

rnal(CharacterEncodingFilter.java:88)

 at com.fr.third.springframework.web.filter.OncePerRequestFilter.doFilter

rRequestFilter.java:107)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:193)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at com.fr.decision.base.DecisionServletInitializer$4.doFilter(Unknown So


 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

FilterChain.java:193)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

ain.java:166)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

va:199)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

va:96)

 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica

.java:493)

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j


 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAcce

lve.java:650)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

:87)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav


 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java


 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLig

:66)

 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abstract

l.java:806)

 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpo

a:1498)

 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBas

49)

 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

49)

 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

24)

 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh

va:61)

 at java.lang.Thread.run(Thread.java:748)

by: com.fr.general.data.TableDataException: 错误代码:11300001 数据集配置



il.concurrent.ExecutionException: java.sql.SQLException: Can't find file:

ngxin\@003f@003f@003f.frm' (errno: 22)

 at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckI

s(Unknown Source)

 at com.fr.data.impl.AbstractDBDataModel.iterateResultSet$original$CCsCxJ

own Source)

 at com.fr.data.impl.AbstractDBDataModel.iterateResultSet$original$CCsCxJ

ssor$zBM71rmh(Unknown Source)

 at com.fr.data.impl.AbstractDBDataModel$auxiliary$bMOqApr7.call(Unknown


 at com.fr.intelli.metrics.DBMonitorInterceptor.intercept(Unknown Source)


 at com.fr.data.impl.AbstractDBDataModel.iterateResultSet(Unknown Source)


 at com.fr.data.impl.AbstractDBDataModel.iterateResultSet(Unknown Source)


 ... 63 more

by: java.lang.RuntimeException: java.util.concurrent.ExecutionException:

l.SQLException: Can't find file: '.\zhengxin\@003f@003f@003f.frm' (errno:


 at com.fr.data.impl.restriction.SQLTimeRestriction.check(Unknown Source)


 ... 70 more

by: java.util.concurrent.ExecutionException: java.sql.SQLException: Can't

ile: '.\zhengxin\@003f@003f@003f.frm' (errno: 22)

 at java.util.concurrent.FutureTask.report(FutureTask.java:122)

 at java.util.concurrent.FutureTask.get(FutureTask.java:206)

 ... 71 more

by: java.sql.SQLException: Can't find file: '.\zhengxin\@003f@003f@003f.f

rno: 22)

 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)

 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)

 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)

 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)

 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)

 at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)

 at com.fr.third.alibaba.druid.pool.DruidPooledStatement.executeQuery(Dru

dStatement.java:140)

 at com.fr.data.core.db.dialect.base.key.create.executequery.DialectExecu

Key.execute(Unknown Source)

 at com.fr.data.core.db.dialect.base.key.create.executequery.DialectExecu

Key.execute(Unknown Source)

 at com.fr.data.core.db.dialect.AbstractDialect.execute(Unknown Source)

 at com.fr.data.core.db.dialect.DefaultDialect.executeQuery(Unknown Sourc


 at com.fr.data.impl.AbstractDBDataModel$1.call(Unknown Source)

 at com.fr.data.impl.AbstractDBDataModel$1.call(Unknown Source)

 at java.util.concurrent.FutureTask.run(FutureTask.java:266)

 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.

49)

 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor

24)

 ... 1 more



以上就问题概况,求各位帮忙解答,谢谢!


FineReport liyang11011 发布于 2019-6-1 08:11
1min目标场景问卷 立即参与
回答问题
悬赏:4 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
liyang11011Lv0见习互助
发布于2019-6-2 07:10(编辑于 2019-6-2 07:11)

由于我的数据库表明全部使用的是汉字,所以在连接字符串时,应增加参数

'?useUnicode=true&characterEncoding=gb2312'


最佳回答
0
KevinGaoLv2初级互助
发布于2019-6-1 22:34

0 http-nio-8080-exec-6 ERROR [standard] 错误代码:11300001 数据集配置错误


il.concurrent.ExecutionException: java.sql.SQLException: Can't find file:

ngxin\@003f@003f@003f.frm' (errno: 22)

.general.data.TableDataException: 错误代码:11300001 数据集配置错误


il.concurrent.ExecutionException: java.sql.SQLException: Can't find file:

ngxin\@003f@003f@003f.frm' (errno: 22)


  • 1关注人数
  • 373浏览人数
  • 最后回答于:2019-6-2 07:11
    请选择关闭问题的原因
    确定 取消
    返回顶部