Dremio, ARP new driver.... IsValid not supported

1

Hi,

I am trying to knock up a new datasource for Dremio, using the SQLite example as a template, and replacing various elements to suit.

I’ve made progress, but it fails. The underlying server.log for Dremio suggests that the native JDBC driver of my backend does NOT have the method isValid.

Is there a workaround for this, (assuming I cannot find the new driver)

Thanks.

2

Hi there,

At this time the Connection.isValid() method is used to determine the state of the connection. Unfortunately there is no work around with the ARP framework to avoid calling this method.

Best,
Ryan Nicholson

3

Ryan,

I suspected that was the likely answer. It’s a bit of a shame, a legacy system I’m using has bitten me again…once again.

Thanks for the feedback though!

4

@Ryan_Nicholson

I take that back, I’ve found an updated driver, so I’m fine through to the bring data back when I browse a table

So, I’m looking at the ARP configuration.

The statement submitted to the backend should be (This is Informix)

SELECT FIRST 2000 col1, col2, col3 FROM table

but it’s actually submitting

SELECT col1, col2, col3 FROM table FIRST 2000.

Maybe I’m missing something, but how do I get the SQL statement to be built correctly? I haven’t found anything obvious…

sort:
enable: true
order_by:
enable: true
default_nulls_ordering: high
fetch_offset:
offset_fetch:
enable: true
format: ‘FIRST {1} SKIP {0}’
offset_only:
enable: false
fetch_only:
enable: true
format: ‘FIRST {0}’

Would eb appreciative if you or someone else can point me in the right direction