无法使用Pentaho从MariaDB读取数据

osh3o9ms  于 2022-12-18  发布在  其他
关注(0)|答案(1)|浏览(186)

我连接到我的数据库,测试了连接,当我使用输入表转换运行一个简单查询时,它工作正常,我得到这个错误:

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)
ckx4rj1h

ckx4rj1h1#

可能运行查询时不使用“;“到最后?

相关问题