prrvchr / jdbcdriverooo Goto Github PK

Hello again.

I have another issue, but when installing your extension to OpenOffice on Windows.

OpenOffice 4.1.14, Windows 7 SP1 64bit, JRE Adoptium 11.0.21.9 32bit

When I try to install jdbcDriverOOo package in LibreOffice I see "no module named "packaging"" error.

Running this command has no effect:

user@pc:~$ pip3 install packaging
Requirement already satisfied: packaging in /usr/lib/python3/dist-packages (20.3)

LibreOffice version: 6.4.7.2
OS: Linux Mint 20.3 Una (based on Ubuntu 20.04 focal)
Java: openjdk 11.0.20.1 2023-08-24

Hi there!

First, thanks for your work on this, it is very much appreciated.

I am trying to connect my Office365 email account, so installed the extensions as described on your repository: https://prrvchr.github.io/smtpServerOOo/#installation

For the HsqlDBDriverOOo, I get the following message:

(com.sun.star.uno.RuntimeException) { { Message = "<class 'ImportError'>: No module named 'six' (or 'six.binary_type' is unknown), traceback follows\X000a  File \"C:\\Program Files\\LibreOffice\\program\\pythonloader.py\", line 146, in writeRegistryInfo\X000a    mod = self.getModuleFromUrl( locationUrl )\X000a  File \"C:\\Program Files\\LibreOffice\\program\\pythonloader.py\", line 101, in getModuleFromUrl\X000a    exec(codeobject, mod.__dict__)\X000a  File \"C:\\Users\\uqsguill\\AppData\\Roaming\\LibreOffice\\4\\user\\uno_packages\\cache\\uno_packages\\lu1100821cme.tmp_\\HsqlDBDriverOOo.oxt\\OptionsDialog.py\", line 43, in <module>\X000a    from hsqldbdriver import createService\X000a  File \"C:\\Program Files\\LibreOffice\\program\\uno.py\", line 346, in _uno_import\X000a    return _builtin_import(name, *optargs, **kwargs)\X000a  File \"C:\\Users\\uqsguill\\AppData\\Roaming\\LibreOffice\\4\\user\\uno_packages\\cache\\uno_packages\\lu1100821cme.tmp_\\HsqlDBDriverOOo.oxt\\pythonpath\\hsqldbdriver\\__init__.py\", line 38, in <module>\X000a    from .unotool import createService\X000a  File \"C:\\Program Files\\LibreOffice\\program\\uno.py\", line 346, in _uno_import\X000a    return _builtin_import(name, *optargs, **kwargs)\X000a  File \"C:\\Users\\uqsguill\\AppData\\Roaming\\LibreOffice\\4\\user\\uno_packages\\cache\\uno_packages\\lu1100821cme.tmp_\\HsqlDBDriverOOo.oxt\\pythonpath\\hsqldbdriver\\unotool\\__init__.py\", line 30, in <module>\X000a    from .unotool import createMessageBox\X000a  File \"C:\\Program Files\\LibreOffice\\program\\uno.py\", line 346, in _uno_import\X000a    return _builtin_import(name, *optargs, **kwargs)\X000a  File \"C:\\Users\\uqsguill\\AppData\\Roaming\\LibreOffice\\4\\user\\uno_packages\\cache\\uno_packages\\lu1100821cme.tmp_\\HsqlDBDriverOOo.oxt\\pythonpath\\hsqldbdriver\\unotool\\unotool.py\", line 41, in <module>\X000a    from six import binary_type, string_types\X000a  File \"C:\\Program Files\\LibreOffice\\program\\uno.py\", line 423, in _uno_import\X000a    raise uno_import_exc\X000a  File \"C:\\Program Files\\LibreOffice\\program\\uno.py\", line 346, in _uno_import\X000a    return _builtin_import(name, *optargs, **kwargs)\X000a\X000a", Context = (com.sun.star.uno.XInterface) @0 } }

Do you know why that might be?

Installed the extension,
updated the JDBC driver to something (HSQLDB 2.7.2? or was it there before?) via the new Options menu entry,
restarted my database with xdbc... instead of jdbc...
shutdown compact'ed the database
restarted Libreoffice Base

and could not see ANY progress in speed or something else. The new Administration menu entries are not working. I had sudden crashes of my database documents (Base forms) without any message or comment before.

So I tried to rebuild my old installation, uninstalled that extension, reconnected with jdbc... again, and had to see that the database had somewhat changed so I could not re-establish a connection with the old driver.

So at this moment I can only warn: do not install that crap in this state (version 1.1.1). And cheers to my backups.

Hi,
It is impossible to ,install this extension : the message error is :
(com.sun.star.uno.RuntimeException) { { Message = "[jni_uno bridge error] UNO calling Java method writeRegistryInfo: non-UNO exception occurred: java.lang.UnsupportedClassVersionError: io/github/prrvchr/jdbcdriver/RegistrationHandler has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0\X000ajava stack trace:\X000ajava.lang.UnsupportedClassVersionError: io/github/prrvchr/jdbcdriver/RegistrationHandler has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0\X000d\X000a\X0009at java.lang.ClassLoader.defineClass1(Native Method)\X000d\X000a\X0009at java.lang.ClassLoader.defineClass(Unknown Source)\X000d\X000a\X0009at java.security.SecureClassLoader.defineClass(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader.defineClass(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader.access$100(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader$1.run(Unknown Source)\X000d\X000a\X0009at java.net.URLClassLoader$1.run(Unknown Source)\X000d\X000a\X0009at java.security.AccessController.doPrivileged(Native Method)\X000d\X000a\X0009at java.net.URLClassLoader.findClass(Unknown Source)\X000d\X000a\X0009at java.lang.ClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at java.lang.ClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at java.net.FactoryURLClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at java.lang.ClassLoader.loadClass(Unknown Source)\X000d\X000a\X0009at com.sun.star.comp.loader.RegistrationClassFinder.find(RegistrationClassFinder.java:53)\X000d\X000a\X0009at com.sun.star.comp.loader.JavaLoader.writeRegistryInfo(JavaLoader.java:376)\X000d\X000a", Context = (com.sun.star.uno.XInterface) @0 } }
I'm using LO 7.2.7 (x64) on windows 10.
Java 1.8.0_333 (x64)
Thank you !
Christophe

When I try to insert a new record in a table (setting values only for the required fields -4-) using LO Base's GUI (Windows 10 Version: 7.4.6.2 (x64)) selecting Tables and then opening the table, connected to a database managed by an HSQLDB Server (version 2.7.2 same OS) the following error is displayed:

SQL State 24515 error code -3606 incorrect cursor state all columns must be set before calling INSERT

However, when I perform the same operation just changing LO Base's file connection type to JDBC (driver version 2.7.2) the record is added successfully.

So apparently changing LO's Base connection type to JDBC is causing non required fields to be set null values before the INSERT operation takes place.