Bug 111813 - Too much time for connecting / loading Oracle database
Summary: Too much time for connecting / loading Oracle database
Status: RESOLVED DUPLICATE of bug 63713
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.0 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2017-08-15 06:52 UTC by MichaelB
Modified: 2017-08-16 07:23 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description MichaelB 2017-08-15 06:52:01 UTC
Hi,

I have this problem from many years with LO. I need connect to Oracle Database 11g Release 2 with ojdbc6.jar. I retrieve my data directly in calc.

This working and i can run my database request.. BUT the delay for the connection time / and after entered the password and retrieve the data is very long (~10-30 seconds) - (no delay with mysql request for example)

If i use another tool like sqlplus, i do not have this delay and is very fast. My data appears directly.


Problem in:

- 4.x.x
- 5.0.x
- 5.1.x
- 5.2.x
- 5.3.x
- 5.4.x

Someone have a explanation for that?

Thanks in advance.
Comment 1 Alex Thurgood 2017-08-16 07:08:15 UTC
@MichaelB:

Please indicate :

- which OS(es) you are using;

- if you are using a Linux OS, which distribution and version number;

- if you are using a Linux OS, whether or not you are using the Linux distribution provided version of LibreOffice or the one provided by TDF from its download page;

- which version of the JRE, and/or JDK;

- which options, if any, you have entered on the JDBC driver configuration line, and which options are ticked in the ODB file under the Advanced Properties tab.


Setting to NEEDINFO.
Comment 2 Alex Thurgood 2017-08-16 07:20:51 UTC
Sounds like a duplicate of bug 63713
Comment 3 Alex Thurgood 2017-08-16 07:23:20 UTC

*** This bug has been marked as a duplicate of bug 63713 ***