Pentaho启动报错，quartz：OPTION SQL_SELECT_LIMIT=5

最新推荐文章于 2021-09-05 20:45:02 发布
原创 最新推荐文章于 2021-09-05 20:45:02 发布 · 940 阅读 · 8 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#pentaho #mysql #quartz

本文解决Pentaho 8.0版本在迁移数据存储至MySQL时出现的SQL语法错误，通过升级MySQL驱动包成功修复问题。

Pentaho迁移存储到mysql启动报错信息

ERROR [ErrorLogger] An error occured while scanning for the next trigger to fire.
org.quartz.JobPersistenceException: Couldn’t acquire next trigger: 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 ‘OPTION SQL_SELECT_LIMIT=5’ at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=5’ at line 1]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2785)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2728)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2724)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=5’ at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1606)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2268)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2921)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2742)
… 4 more

笔者使用的pentaho版本为8.0，解决方法：
将低版本的mysql驱动包更换为高版本的即可。

JDBC方式连接KETTLE运行定时任务报错解决
纯真年代
01-04 2189
今天测试KETTLE定时任务时报错 D:\software\kettle7.1>Kitchen.bat -file="D:\software\kettle7.1\xuzhe_test_resault\多表同步（从EXCEL表中获取表名）.kjb" DEBUG: Using JAVA_HOME DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jdk1.8.0_131 DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\
quartz报错：OPTION SQL_SELECT_LIMIT=1
ym563099457的博客
11-30 3498
[2017-11-30 09:13:49.366][ERROR][ErrorLogger.schedulerError] An error occurred while scanning for the next triggers to fire. org.quartz.JobPersistenceException: Couldn't acquire next trigger: You hav
Quartz框架多个trigger任务执行出现漏执行的问题分析
岁月静好
05-27 4355
一、问题描述 使用Quartz配置定时任务，配置了超过10个定时任务，这些定时任务配置的触发时间都是5分钟执行一次，实际运行时，发现总有几个定时任务不能执行到。 二、示例程序 1、简单介绍 采用spring+quartz整合方案实现定时任务，Quartz的SchedulerFactoryBean配置参数中不注入taskExecutor属性，使用默认自带的线程池。准备了15个定时任务，全部设置为每隔10秒触发一次，定时任务的实现逻辑是使用休眠8秒的方式模拟执行定时任务的时间耗费。 2、配置文件信息如下（节
报错OPTION SQL_SELECT_LIMIT=
weixin_34032792的博客
02-18 587
org.quartz.JobPersistenceException: Couldn't acquire next trigger: 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...
windows安装Pentaho Server
直到世界的尽头
12-29 1万+
环境准备 安装JDK Pentaho Server的安装使用需要安装jdk，并配置相关环境变量。 windows版本的jdk安装可参考文章: http://blog.youkuaiyun.com/zzq900503/article/details/9770237 使用快捷键window+R输入cmd，输入java -version检查java环境如下: 下载Pentaho Server安装启动...
spoon 工具表输出 输入字段映射报错Unable to close prepared statement after determining SQL layout 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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
最新发布
11-11
错误信息明确指出问题出在 `OPTION SQL_SELECT_LIMIT=DEFAULT` 附近。 根据错误信息，这个SQL语句片段 `OPTION SQL_SELECT_LIMIT=DEFAULT` 是不被MySQL服务器接受的。我们需要考虑以下几点： 1. 这个语句可能是由...
pentaho-application-launcher.zip_pentaho_pentaho 启动
09-24
Pentaho Application Launcher是Pentaho数据集成（Kettle）或Business Intelligence Suite的一部分，它是一个用于启动和管理Pentaho应用程序的工具。这个压缩包包含了必要的组件和配置文件，帮助用户理解Pentaho如何...
DEBUG: Found JRE one folder up DEBUG: _PENTAHO_JAVA_HOME=D:\kettlePDI\..\jre DEBUG: _PENTAHO_JAVA=D:\kettlePDI\..\jre\bin\java.exe\
11-19
其中，引用中的内容表明找到了Java的安装路径，而引用中的内容则是在指定Java的一些参数后，启动了Pentaho应用程序启动器。但是，引用中的路径都是不完整的，因此无法确定完整的Java安装路径和Pentaho应用程序启动器...
上面的方案调整一下，kettle的jndi在src/main/resources/simple-jndi/jdbc.properties，编译后在target/classes/simple-jndi/jdbc.properties，希望修改里面的连接能重新加载kettle环境。 SampleData/type=javax.sql.DataSource SampleData/driver=org.h2.Driver SampleData/url=jdbc:h2:file:samples/db/sampledb;IFEXISTS=TRUE SampleData/user=PENTAHO_USER SampleData/password=PASSWORD Quartz/type=javax.sql.DataSource Quartz/driver=org.hsqldb.jdbcDriver Quartz/url=jdbc:hsqldb:hsql://localhost/quartz Quartz/user=pentaho_user Quartz/password=password Hibernate/type=javax.sql.DataSource Hibernate/driver=org.hsqldb.jdbcDriver Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate Hibernate/user=hibuser Hibernate/password=password Shark/type=javax.sql.DataSource Shark/driver=org.hsqldb.jdbcDriver Shark/url=jdbc:hsqldb:hsql://localhost/shark Shark/user=sa Shark/password= PDI_Operations_Mart/type=javax.sql.DataSource PDI_Operations_Mart/driver=org.postgresql.Driver PDI_Operations_Mart/url=jdbc:postgresql://localhost:5432/hibernate?searchpath=pentaho_operations_mart PDI_Operations_Mart/user=hibuser PDI_Operations_Mart/password=password live_logging_info/type=javax.sql.DataSource live_logging_info/driver=org.postgresql.Driver live_logging_info/url=jdbc:postgresql://localhost:5432/hibernate?searchpath=pentaho_dilogs live_logging_info/user=hibuser live_logging_info/password=password #01552 BASE_BIMS_01552/type=javax.sql.DataSource BASE_BIMS_01552/driver=com.mysql.jdbc.Driver BASE_BIMS_01552/url=jdbc:mysql://192.168.168.223:3306/plasma_test?useUnicode=true&characterEncoding=utf8&useSSL=false&useOldAliasMetadataBehavior=true BASE_BIMS_01552/user=plasma BASE_BIMS_01552/password=szrouting2004plasma #122 BASE_BIMS_122/type=javax.sql.DataSource BASE_BIMS_122/driver=com.mysql.jdbc.Driver BASE_BIMS_122/url=jdbc:mysql://192.168.168.223:3306/plasma_nyjl?useUnicode=true&characterEncoding=utf8&useSSL=false&useOldAliasMetadataBehavior=true BASE_BIMS_122/user=plasma BASE_BIMS_122/password=Szrouting2004P(@$ma #01255 BASE_BIMS_01255/type=javax.sql.DataSource BASE_BIMS_01255/driver=com.mysql.jdbc.Driver BASE_BIMS_01255/url=jdbc:mysql://192.168.168.223:3306/plasma?useUnicode=true&characterEncoding=utf8&useSSL=false&useOldAliasMetadataBehavior=true BASE_BIMS_01255/user=plasma BASE_BIMS_01255/password=szrouting2004plasma #etl BASE_ETL/type=javax.sql.DataSource BASE_ETL/driver=oracle.jdbc.driver.OracleDriver BASE_ETL/url=jdbc:oracle:thin:@192.168.168.218:1521:orcl BASE_ETL/user=BASE_ETL BASE_ETL/password=szrouting2015bip #bim BASE_BIM/type=javax.sql.DataSource BASE_BIM/driver=oracle.jdbc.driver.OracleDriver BASE_BIM/url=jdbc:oracle:thin:@192.168.168.218:1521:orcl BASE_BIM/user=BIM_NY BASE_BIM/password=szrouting2015bip #api ETL_POSITIVE/type=javax.sql.DataSource ETL_POSITIVE/driver=oracle.jdbc.driver.OracleDriver ETL_POSITIVE/url=jdbc:oracle:thin:@192.168.168.218:1521:orcl ETL_POSITIVE/user=BASE_ETL ETL_POSITIVE/password=szrouting2015bip #api BIM_POSITIVE/type=javax.sql.DataSource BIM_POSITIVE/driver=oracle.jdbc.driver.OracleDriver BIM_POSITIVE/url=jdbc:oracle:thin:@192.168.168.218:1521:orcl BIM_POSITIVE/user=BIM_NY BIM_POSITIVE/password=szrouting2015bip
09-17
#### 5. 更新作业执行代码 在运行作业时，将作业注册到`KettleJobManager`： ```java // 在执行作业之前注册 KettleJobManager.registerJob(kettleJob.getId().toString(), job); job.start(); ``` ### 注意事项 1....
（转）JAVA-WEB-错误之-'OPTION SQL_SELECT_LIMIT=DEFAULT'
jackyrongvip的专栏
08-28 165
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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1 原因： 项目中用的j...
kettle-error-OPTION SQL_SELECT_LIMIT=DEFAULT
紫天专栏
04-09 733
问题描述 kettle在抽取MySQL数据到SqlServer时，表输入mysql查询正常，表输出获取字段时报错： Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corres
quartz集群模式任务触发分析（二）
sharedCode源码交流
05-23 2216
前言 此处仅大致的将quartz的逻辑给理出来，有些具体的详细之处我也不是很清楚（苦笑） QuartzSchedulerThread quartzSchedulerThread是quartz的主线程，quartz完成任务的触发是完全依靠这个线程来做的。 QuartzSchedulerThread @Override public void run() {     ...
quartz mysql 常见_quartz定时任务使用MYSQL数据库，报SCHED_TIME没有默认值
weixin_33298352的博客
02-04 579
项目环境：spring4+mybatis2+quartz2.1.7+mysql5报错信息如下：Log4j:[2017-08-20 23:03:13] ERROR ErrorLogger:2361 - An error occurred while scanning for the next triggers to fire.org.quartz.JobPersistenceException: C...
quartz 2.2.1 mysql_quartz2.2.1bug
weixin_34737066的博客
01-19 198
quartz2.1.5 调用 scheduler.start()方法时报这样一个异常：严重: An error occurred while scanning for the next triggers to fire.org.quartz.JobPersistenceException: Couldn't acquire next trigger: You have an error in yo...
再谈quartz
鸣志工作室
03-17 4373
quartz集成到tomcat采用是使用 ServletContextListener方案，参见http://www.blogjava.net/Unmi/archive/2008/05/01/197657.html tomcat运行一段时间后，控制台报以下错误 2009-03-06 09:38:21 [org.quartz.core.ErrorLogger]-[ERROR] An error
Quartz的定时任务实现
热门推荐
不说话装高手
03-02 4万+
Quartz中管理定时任务的Scheduler对应一个QuartzScheduler，其中，负责管理定时任务的线程QuartzSchedulerThread也在其构造方法中被启动。 public QuartzScheduler(QuartzSchedulerResources resources, long idleWaitTime, @Deprecated long dbRetryInter...
Quartz使用问题记录
lonelymanontheway的博客
09-05 3426
新旧两个集群同时共存； job class； 本地测试Job；
解決org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: null
LWJdear的博客
07-05 1万+
解決org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: null org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigg
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值