# Not support the MS-ACCESS,DATA\_READER incrementalKey samples **URL:** \ **Category:** CloverDX Platform\ **Created:** [September 9, 2008, 12:00am UTC](https://forum.cloverdx.com/t/not-support-the-ms-access-data-reader-incrementalkey-samples/386 "2008-09-09T00:00:00Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\ **Post date:** [September 9, 2008, 12:00am UTC](https://forum.cloverdx.com/t/not-support-the-ms-access-data-reader-incrementalkey-samples/386/1 "2008-09-09T00:00:00Z")
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. ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [September 25, 2008, 6:54am UTC](https://forum.cloverdx.com/t/not-support-the-ms-access-data-reader-incrementalkey-samples/386/2 "2008-09-25T06:54:36Z")
Hello, I I’ve open the issue ([http://bug.cloveretl.org/view.php?id=926](http://bug.cloveretl.org/view.php?id=926)) for the above problem. ---
**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\ **Post date:** [October 24, 2008, 8:42am UTC](https://forum.cloverdx.com/t/not-support-the-ms-access-data-reader-incrementalkey-samples/386/3 "2008-10-24T08:42:52Z")
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 !!!