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

今天刚研究帆软这个软件，数据库链接测试成功的可是当用SQL 语句的时候就一直报错，搜了半天大家和我这个错还不一样，不知道怎么解决啊
警告:com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误
Query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Ïúá¿] where μØÇø='huadong'' at line 1
        at java.util.concurrent.FutureTask.report(Unknown Source)
        at java.util.concurrent.FutureTask.get(Unknown Source)
        at javax.swing.SwingWorker.get(Unknown Source)
        at com.fr.design.data.datapane.preview.PreviewTablePane$7.done(Unknown Source)
        at javax.swing.SwingWorker$5.run(Unknown Source)
        at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
        at sun.swing.AccumulativeRunnable.run(Unknown Source)
        at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
        at javax.swing.Timer.fireActionPerformed(Unknown Source)
        at javax.swing.Timer$DoPostEvent.run(Unknown Source)
        at java.awt.event.InvocationEvent.dispatch(Unknown Source)
        at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
        at java.awt.EventQueue.access$500(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.WaitDispatchSupport$2.run(Unknown Source)
        at java.awt.WaitDispatchSupport$4.run(Unknown Source)
        at java.awt.WaitDispatchSupport$4.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.WaitDispatchSupport.enter(Unknown Source)
        at java.awt.Dialog.show(Unknown Source)
        at java.awt.Component.show(Unknown Source)
        at java.awt.Component.setVisible(Unknown Source)
        at java.awt.Window.setVisible(Unknown Source)
        at java.awt.Dialog.setVisible(Unknown Source)
        at com.fr.design.data.datapane.preview.PreviewTablePane.previewTableData(Unknown Source)
        at com.fr.design.data.datapane.preview.PreviewTablePane.previewTableData(Unknown Source)
        at com.fr.design.data.tabledata.tabledatapane.DBTableDataPane$PreviewAction.actionPerformed(Unknown Source)
        at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
        at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
        at java.awt.EventQueue.access$500(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.WaitDispatchSupport$2.run(Unknown Source)
        at java.awt.WaitDispatchSupport$4.run(Unknown Source)
        at java.awt.WaitDispatchSupport$4.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.WaitDispatchSupport.enter(Unknown Source)
        at java.awt.Dialog.show(Unknown Source)
        at java.awt.Component.show(Unknown Source)
        at java.awt.Component.setVisible(Unknown Source)
        at java.awt.Window.setVisible(Unknown Source)
        at java.awt.Dialog.setVisible(Unknown Source)
        at com.fr.design.data.datapane.TableDataTreePane.dgEdit(Unknown Source)
        at com.fr.design.data.BasicTableDataTreePane$TDAction.actionPerformed(Unknown Source)
        at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
        at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
        at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
        at javax.swing.AbstractButton.doClick(Unknown Source)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
        at java.awt.Component.processMouseEvent(Unknown Source)
        at javax.swing.JComponent.processMouseEvent(Unknown Source)
        at java.awt.Component.processEvent(Unknown Source)
        at java.awt.Container.processEvent(Unknown Source)
        at java.awt.Component.dispatchEventImpl(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
        at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
        at java.awt.Container.dispatchEventImpl(Unknown Source)
        at java.awt.Window.dispatchEventImpl(Unknown Source)
        at java.awt.Component.dispatchEvent(Unknown Source)
        at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
        at java.awt.EventQueue.access$500(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.awt.EventQueue$3.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.awt.EventQueue$4.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)
FineReportyoli 发布于 2017-5-23 15:35
悬赏：2 F币 + 添加悬赏
举报
提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知
共11回答
最佳回答
0
Poseidon发布于2017-5-23 15:35（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • yoli yoli(提问者)

    啊！我用了自己的数据库==我自己数据库还没表，啊，2了~嘿嘿，用上FR数据库就好使了，谢谢大神
    回复
    2017-05-23 16:51 
最佳回答
0
Poseidon发布于2017-5-23 15:39（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • yoli yoli(提问者)

    大神，db后面是啥意思我还是不太明白呀
    回复
    2017-05-23 16:30 
最佳回答
0
yoli发布于2017-5-23 16:30（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • Poseidon Poseidon

    jdbc:mysql://ip/库名?useUnicode=true&characterEncoding=utf-8
    回复
    2017-05-23 16:39 
最佳回答
0
Poseidon发布于2017-5-23 16:39（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • yoli yoli(提问者)

    jdbc:mysql://localhost/yoyo?useUnicode=true&characterEncoding=utf-8数据库链接成功，但是还是报1301的错额
    回复
    2017-05-23 16:42 
最佳回答
0
yoli发布于2017-5-23 16:42（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • Poseidon Poseidon

    吧你sql贴出来，明显是字符乱码了
    回复
    2017-05-23 16:45 
最佳回答
0
Poseidon发布于2017-5-23 16:45（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • yoli yoli(提问者)

    就是那个帮助文档里面的
    SELECT * FROM [销量] where 地区=\'${地区}\'

    开始我自己敲了一下，后来不对我就复制粘贴了，还是不对额
    回复
    2017-05-23 16:47 
最佳回答
0
yoli发布于2017-5-23 16:47（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • Poseidon Poseidon

    如果是内置库的话应该是frdemo那个数据连接啊，不应该是你mysql的库啊；
    你库转移了？
    回复
    2017-05-23 15:35 
最佳回答
0
yoli发布于2017-5-23 16:51（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • Poseidon Poseidon

    客气
    {:9_240:}
    回复
    2017-05-23 16:52 
最佳回答
0
Poseidon发布于2017-5-23 16:52（编辑于 2023-9-6 09:34）
555
举报 收起评论(1)
  • yoli yoli(提问者)

    嘿嘿~菜鸟一个，傻乎乎的，我说呢，怎么搜半天没有和我问题一样的。。。
    回复
    2017-05-23 16:56 
最佳回答
0
yoli发布于2017-5-23 16:56（编辑于 2023-9-6 09:34）
555
  • 0关注人数
  • 3765浏览人数
    • 最后回答于：2018-8-28 13:16
    活动推荐 更多
    热门课程 更多
    隐私政策
    帆软用户服务协议
    联系管理员
    联系帆软
    Copyright© 帆软软件有限公司 版权所有
    苏ICP备18065767号
    返回顶部