我连接到我的数据库,测试了连接,当我使用输入表转换运行一个简单查询时,它工作正常,我得到这个错误:
37:11 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unexpected error
2022/12/13 11:37:11 - Table input.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2022/12/13 11:37:11 - Table input.0 - An error occurred executing SQL:
2022/12/13 11:37:11 - Table input.0 - SELECT * from patient limit 10;
2022/12/13 11:37:11 - Table input.0 -
2022/12/13 11:37:11 - Table input.0 - (conn=49) invalid fetch size
2022/12/13 11:37:11 - Table input.0 -
2022/12/13 11:37:11 - Table input.0 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1776)
2022/12/13 11:37:11 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:242)
2022/12/13 11:37:11 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
2022/12/13 11:37:11 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2022/12/13 11:37:11 - Table input.0 - at java.lang.Thread.run(Thread.java:750)
2022/12/13 11:37:11 - Table input.0 - Caused by: java.sql.SQLSyntaxErrorException: (conn=49) invalid fetch size
2022/12/13 11:37:11 - Table input.0 - at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:282)
2022/12/13 11:37:11 - Table input.0 - at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:336)
2022/12/13 11:37:11 - Table input.0 - at org.mariadb.jdbc.Statement.setFetchSize(Statement.java:587)
2022/12/13 11:37:11 - Table input.0 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1754)
2022/12/13 11:37:11 - Table input.0 - ... 4 more
2022/12/13 11:37:11 - Table input.0 - Finished reading query, closing connection
2022/12/13 11:37:11 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
1条答案
按热度按时间ckx4rj1h1#
可能运行查询时不使用“;“到最后?