You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2019/02/09 16:08:33 UTC

[Issue 128035] New: Can't use AOO with MariaDB and JDBC

https://bz.apache.org/ooo/show_bug.cgi?id=128035

          Issue ID: 128035
        Issue Type: DEFECT
           Summary: Can't use AOO with MariaDB and JDBC
           Product: Base
           Version: 4.2.0-dev
          Hardware: All
                OS: All
            Status: CONFIRMED
          Severity: Blocker
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: mechtilde@apache.org
  Target Milestone: ---

I use AOO as a client for several databases. Most of them were originally
created with MySQL. Now I use Mariadb on my Debian machines.

There is no MySQL JDBC Driver available. I get the message: "Can't load
com.mysql.jdbc.Driver"

For using Mariadb there is an own JDBC Driver. The name of the driver class is
org.mariadb.jdbc.Driver.

I found hardcoded entries: 

main/connectivity/qa/complex/connectivity/JdbcLongVarCharTest.java      
  67             prop[0] = new PropertyValue("JavaDriverClass", 0,
"com.mysql.jdbc.Driver", PropertyState.DIRECT_VALUE);

main/connectivity/source/drivers/mysql/YDriver.cxx      
 183                                                                        
,makeAny(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.mysql.jdbc.Driver")))

 234             ::rtl::OUString
sDriverClass(RTL_CONSTASCII_USTRINGPARAM("com.mysql.jdbc.Driver"));
 354                                        
,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.mysql.jdbc.Driver"))

main/connectivity/source/drivers/mysql/mysql.xcu        
  41             <value>com.mysql.jdbc.Driver</value>


I think it is necessary to be able to use both entries.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damjan@apache.org

--- Comment #1 from damjan@apache.org ---
You can probably use the generic "JDBC" driver type and enter that class name
there, but let's leave this bug open for adding native MariaDB support too.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] add native mariadb driver

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

Peter <pe...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
   Target Milestone|4.2.0                       |---

--- Comment #9 from Peter <pe...@apache.org> ---
I done that, we can add it again for a new target anytime

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

Mechtilde <me...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|P5 (lowest)                 |P2
          Developer|---                         |Medium
         Difficulty|                            |
   Target Milestone|---                         |4.2.0

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

--- Comment #8 from Marcus <ma...@apache.org> ---
@Peter:
Sure, you just need to rename the title and chage the target milestone.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oooforum@free.fr

--- Comment #5 from oooforum (fr) <oo...@free.fr> ---
I have no problem to connect a MariaDB
I use this extension to have a native MySQL driver:
https://extensions.openoffice.org/fr/project/mysql-driver-apache-openoffice

Maybe this could be integrated?

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] add native mariadb driver

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

Peter <pe...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Can't use AOO with MariaDB  |add native mariadb driver
                   |and JDBC                    |

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

--- Comment #2 from Mechtilde <me...@apache.org> ---
for documentation

under Linux the class path is: /usr/share/java/mariadb-java-client.jar

The data source URL is: jdbc:mysql://<server name>/<database name>

If you want to edit data you must add "?useHostsInPrivileges=false"

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

Koray Durgut <co...@atomxplus.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |contact@atomxplus.com

--- Comment #4 from Koray Durgut <co...@atomxplus.com> ---
AtOmXpLuS : Everything in AtOmXpLuS.CoM

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

--- Comment #6 from damjan@apache.org ---
(In reply to Mechtilde from comment #0)
> I think it is necessary to be able to use both entries.

But use both HOW?

Should we allow the use of either driver for either database?

Or should we add a "MariaDB" driver that is for MariaDB?

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|contact@atomxplus.com       |

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

Peter <pe...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |petko@apache.org

--- Comment #3 from Peter <pe...@apache.org> ---
Is this still open?

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 128035] Can't use AOO with MariaDB and JDBC

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128035

--- Comment #7 from Peter <pe...@apache.org> ---
Can we rename this issue to "add native mariadb driver" and remove it from 4.2.
Release?

-- 
You are receiving this mail because:
You are the assignee for the issue.