When creating a query in sbase the following exceptions are thrown ======================================================= === Note: An Exception was thrown which should have === === caused a crash. I caught it. Please report this === === to openoffice.org === ======================================================= java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:96) at com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:89) at com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:49) at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy55.execute(Unknown Source) at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:742) at com.sun.star.wizards.query.QueryWizard.startQueryWizard(QueryWizard.java:204) at com.sun.star.wizards.query.CallQueryWizard$QueryWizardImplementation.trigger(CallQueryWizard.java:111) Caused by: com.sun.star.uno.RuntimeException: exception type not found: _STL.out_of_range at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method) at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:175) at $Proxy11.loadComponent(Unknown Source) at com.sun.star.wizards.db.DatabaseObjectWizard.loadSubComponent(DatabaseObjectWizard.java:61) at com.sun.star.wizards.query.QueryWizard.finishWizard(QueryWizard.java:348) at com.sun.star.wizards.ui.WizardDialog.finishWizard_1(WizardDialog.java:696) ... 13 more terminate called after throwing an instance of '_STL::out_of_range' what(): vector This results in an immediate crash when executing the query. It doesn't make any difference whether the query is created in Design View, with Wizard or in SQL view. The problem occures with LibO 3.4.0rc2, 3.3.3rc1 (installed with dpkg from deb package from website (not ubuntu repository)) and libreoffice-java (and its dependencies) (installed from ubuntu repositories). I also tried some OpenOffice versions (debs from website, but don't recall the exception and versions, but the problem appears to be exactly the same. Please fix this because it makes LibO completely useless for me!
Hi, Which Java version are you using ? What is the query you are trying to process ? What kind of database ? (builtin HSQL or some connection to external dbms) Without this information and a sample database or at least a table and query to try, we won't be able to get very far confirming this issue. For all we know, it could be specifically linked to any of the above. Alex
Hi, thank you for your answer. I figured out a few things. First of all, I should have mentioned that the crash only happens with an address data source! I connected my Thunderbird addressbook (version 3.1.10) and can use the addresses without problems when creating a form letter. The problem only occures with LIKE as criterion, but in all columns! The Exception thrown is always the same. The error doesn't occur with a table I created myself with sbase, not even with LIKE. I made these tests with LibO 3.3.3rc1. I can't send you any tables I used because it's my private addressbook, but the error shouldn't be difficult to reproduce (I had it on three pcs with linux x86 and solaris x86). I'm running OpenJDK 6b22-1.10.2-0ubuntu1~11.04.1 (installed from Ubuntu repo). Greetings
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
needinfo keyword redundant by needinfo status.
Hi, The problem with LO 3.3.4, 3.4.4 and also 3.5.0beta2, that I can't setup my Thunderbird addressbook as data source in LO any more. The error message is: "A connection for the following URL was requested "sdbc:address:evolution:local" which is the normal error message if you install LO from package repo in Ubnutu (because it only accepts Evolution as addressbook data source), but I did it from LO version installed manually from downloaded .deb. This means that I can't test whether the problem persists in 3.5.0beta2, because also the existing odb-files from address data sources show the same error message when I open them. Why is it so complicated to add data sources if LO has been installed from repo? Why not just offer the five or six most popular email clients as data sources out of the box without any difficult manual installation? Greetings
Driver has been updated 1 or 2 years ago. Any better with recent LO version (given the last one is 4.2.4)?
I have tested it with LO 4.2.7.2 and OpenSUSE 12.3 64bit rpm Linux. Connected to Thunderbird addressbook and started SELECT * FROM "CollectedAddressBook" WHERE "Nachname" LIKE '%kopf%' as query (German translated Addressbook). Works as expected, without any problems. Same with LO 4.0.5.2 Couldn't start the connection with LO 3.3.4 - connection could not be established.
Following last comment, let's put this one to WFM. Krichter: if you can reproduce this with a recent LO version (last stable one is 4.3.3), don't hesitate to reopen this tracker.