Exception when using H2 and DataFX

[Dominik]

Hi,

I am using DataFX (org.javafxdata:datafx-datareader:8.0b52) to populate a TableView, really similar to your example. 

But I am using H2 (com.h2database:h2:1.3.1712).

The table is populated witht the data but I am getting an ongoing number of exceptions.

Where do I miss something?

Excerpt of our/my code:

59            JdbcConverter<Person> converter = new JdbcConverter<Person>() {

60                public Person convertOneRow (ResultSet personResultSet){

61

62                    try {

63                        System.out.println("gerade in convertOneRow "+ personResultSet.getRow());

64                        Person pk = new Person();

65                        pk.setId(personResultSet.getInt("Id"));

66                        pk.setVorname(personResultSet.getString("Vorname"));

67                        pk.setName(personResultSet.getString("Nachname"));

68                        return pk;

69                    } catch (SQLException ex) {

70                        Logger.getLogger(verknuepfenTab.class.getName()).log(Level.SEVERE, null, ex);

71                    }

72                    return null;

73                }

74            };

Excerpt of exceptions:

gerade in convertOneRow 0

gerade in convertOneRow 0

gerade in convertOneRow 0

Jul 22, 2014 3:09:22 PM com.kA.com.view.verknuepfenTab$1 convertOneRow

SCHWERWIEGEND: null

org.h2.jdbc.JdbcSQLException: Keine Daten verfügbar

No data is available [2000-171]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)

at org.h2.message.DbException.get(DbException.java:169)

at org.h2.message.DbException.get(DbException.java:146)

at org.h2.message.DbException.get(DbException.java:135)

at org.h2.jdbc.JdbcResultSet.checkOnValidRow(JdbcResultSet.java:2956)

at org.h2.jdbc.JdbcResultSet.get(JdbcResultSet.java:2962)

at org.h2.jdbc.JdbcResultSet.get(JdbcResultSet.java:2979)

at org.h2.jdbc.JdbcResultSet.getInt(JdbcResultSet.java:322)

at com.kA.com.view.verknuepfenTab$1.convertOneRow(verknuepfenTab.java:65)

at com.kA.com.view.verknuepfenTab$1.convertOneRow(verknuepfenTab.java:59)

at org.datafx.reader.converter.JdbcConverter.get(JdbcConverter.java:61)

at org.datafx.reader.JdbcSource.get(JdbcSource.java:141)

at org.datafx.provider.ListDataProvider$2.callTask(ListDataProvider.java:246)

at org.datafx.concurrent.PublishingTask.call(PublishingTask.java:57)

at org.datafx.concurrent.PublishingTask.call(PublishingTask.java:40)

at javafx.concurrent.Task$TaskCallable.call(Task.java:1426)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at javafx.concurrent.Service$7$1.run(Service.java:744)

at javafx.concurrent.Service$7$1.run(Service.java:742)

at java.security.AccessController.doPrivileged(Native Method)

at javafx.concurrent.Service$7.run(Service.java:742)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

Jul 22, 2014 3:09:22 PM com.kA.com.view.verknuepfenTab$1 convertOneRow

SCHWERWIEGEND: null

org.h2.jdbc.JdbcSQLException: Keine Daten verfügbar

No data is available [2000-171]

...

And so on.

[Dominik]

Well, and of course thank you for your help. :)

Dominik

[Hendrik Ebbers]

Hi Dominik,

it looks like your SQL select doesn't return a row. Can you check this by calling your SQL command directly?

[Dominik]

Hi Hendrik,

thank you for your quick answer.

Well actually there are several rows.

And they are also shown in the TableView, but it seems to me that it is some how stuck in a loop and does not finish.

There are also several empty lines added to the TableView, I suspect null is returned, but it does not finish.

Here is the SQL select statement:

personDataReader = new JdbcSource<>(dbURL, "Select * from PKTABLETEST;", personJdbcConverter);

[Dominik]

Hi,

I will try to give more information on what I am trying to do.

There are two tableViews on one tab. 

The first one is created and populated as expected.

The user should then be able to select an item and populate with this information the second tableView.

However I am experiencing then this ongoing exception behaviour.

Should I paste the whole file here?

[Dominik]

Hi,

did anyone experience something similar?

When I was using a previous version of DataFX with a MariaDB the same code was working fine.

Cheers

Dominik

[Hendrik Ebbers]

Hi,

What Version of DataFX are you using? 

--
You received this message because you are subscribed to the Google Groups "DataFX" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datafx-dev+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Dominik]

Hi,

Currently I am using org.javafxdata:datafx-datareader: 8.0b52

[Hendrik Ebbers]

And what old version is working?

[Dominik]

I just switched to the version: org.javafxdata:datafx-datareader:8.0b2

It seems to work for me.

In the output a "regularquery" remark appears, but no exception at all.

[Hendrik Ebbers]

Hi,

can you send us a simple demo. The. WE can fix it in one of the next builds.

--

[Dominik]

Hi,

did you receive the code?