1)DB_INPUT_TABLE and DB_OUT_TABLE do not support the MS-ACCESS database, to verify the following.
----------------------------------------------
connection.setHoldability(ResultSet.CLOSE_CURSORS_AT_COMMIT);
--------------------------------------------------------
org.jetel.connection.jdbc.SQLDataParser.java
public void close() {}
This method output warning
DefaultConnection.java
createStatement(){}
This method output warning
-------------------------------------------------------
2)Please provide the incrementalKey DELIMITED_DATA_READER attribute the use of samples.
----------------------------------------------
connection.setHoldability(ResultSet.CLOSE_CURSORS_AT_COMMIT);
--------------------------------------------------------
org.jetel.connection.jdbc.SQLDataParser.java
public void close() {}
This method output warning
DefaultConnection.java
createStatement(){}
This method output warning
-------------------------------------------------------
2)Please provide the incrementalKey DELIMITED_DATA_READER attribute the use of samples.
-
Hello,
I I've open the issue (http://bug.cloveretl.org/view.php?id=926) for the above problem. -
v2.5.3 has yet to be resolved No data found the problem, the problem only
DB_INPUT_TABLE incremental read MS-ACCESS database records, we do not want to support such a database it?
=======================================
INFO [main] - Checking graph configuration...
INFO [main] - Graph configuration is valid.
INFO [main] - Graph initialization (testaccess)
INFO [main] - Initializing connection:
INFO [main] - DBConnection driver[org.jetel.connection.jdbc.driver.JdbcDriver@e5ace9]:jndi[null]:url[jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/test/db1.mdb]:user[] ... OK
INFO [WatchDog] - [Clover] Initializing phase: 0
DEBUG [WatchDog] - initializing edges:
DEBUG [WatchDog] - all edges initialized successfully...
DEBUG [WatchDog] - initializing nodes:
DEBUG [WatchDog] - DB_OUTPUT_TABLE_0 ...OK
DEBUG [WatchDog] - DB_INPUT_TABLE_0 ...OK
INFO [WatchDog] - [Clover] phase: 0 initialized successfully.
INFO [WatchDog] - Starting up all nodes in phase [0]
DEBUG [WatchDog] - DB_OUTPUT_TABLE_0 ... started
DEBUG [WatchDog] - DB_INPUT_TABLE_0 ... started
INFO [WatchDog] - Sucessfully started all nodes in phase!
DEBUG [DB_INPUT_TABLE_0] - DB_INPUT_TABLE_0: Sending query "select * from test_1 where c1>2"
DEBUG [DB_INPUT_TABLE_0] - DB_INPUT_TABLE_0: Query execution time: 00:00:00.016
WARN [DB_INPUT_TABLE_0] - Can't set fetch size to 1000
INFO [DB_INPUT_TABLE_0] - Using default value of fetch size
ERROR [WatchDog] - Graph execution finished with error
ERROR [WatchDog] - Node DB_INPUT_TABLE_0 finished with status: ERROR caused by: Problem when updating incremental position caused by: java.sql.SQLException: No data found
DEBUG [WatchDog] - Node DB_INPUT_TABLE_0 error details:
org.jetel.exception.JetelException: Problem when updating incremental position caused by: java.sql.SQLException: No data found
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:215)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:137)
at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:181)
at org.jetel.component.DBInputTable.execute(DBInputTable.java:242)
at org.jetel.graph.Node.run(Node.java:379)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7139)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(JdbcOdbc.java:3812)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(JdbcOdbcResultSet.java:5639)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(JdbcOdbcResultSet.java:582)
at org.jetel.connection.jdbc.CopySQLData$CopyInteger.setJetel(CopySQLData.java:746)
at org.jetel.connection.jdbc.SQLIncremental.updatePosition(SQLIncremental.java:209)
at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:211)
... 5 more
ERROR [WatchDog] - !!! Phase finished with error - stopping graph run !!!
Please sign in to leave a comment.
Comments 2