https://bugs.documentfoundation.org/show_bug.cgi?id=156512
--- Comment #3 from [email protected] --- After further investigation, it appears that the driver must provide a connection offering at least the UNO service com.sun.star.sdbcx.Connection or com.sun.star.sdb.Connection and must support the updatable resultset to be able to reproduce. Obviously the same is true for all the services provided by the connection (Statement, PreparedStatement, CallableStatement and ResultSet) they must be of the same level (com.sun.star.sdbcx or com.sun.star.sdb respectively) jdbcDriverOOo offers the big advantage of being polymorphic and of being able to provide the levels of UNO services which are requested from it in: Tools -> Options -> Base drivers -> JDBC Driver -> UNO drivers settings On the other hand, this issue is indeed the only one where I am not sure that the problem comes from LibreOffice and not from my extension, since I have this problem regardless of the version of LibreOffice. But if I look at how Base uses an updatable resultset I still don't understand why the first thing it does is to switch to insert mode (with moveToInsertRow()) when it is just supposed to display the contents of the table... Normally, at least with JDBC, when you switch to insert mode you can no longer move in the resultset until you exit insert mode. That's not what Base does.... This forces me to manage this very special case in my driver and do not really know if it is really a Base problem or incompatibility between UNO SDBC and JDBC. -- You are receiving this mail because: You are the assignee for the bug.
