[MDEV-10936] CONNECT engine JDBC type can't find JdbcInterface - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1.18
Fix Version/s: 10.1.24, 10.0.31, 10.2.7
Component/s: Packaging, Platform RedHat, Storage Engine - Connect
Labels:
None
Environment:
centOS 7

Description

I have the Oracle JVM installed.

I issue the following command:

set global connect_jvm_path="/usr/java/default/jre/lib/amd64/server";

When I try to do this:

create table rmt_customers engine=connect table_type=JDBC tabname=customers

connection='jdbc:mysql://173.194.84.177:3306/db11006'

option_list='User=root,Password=mypass';

I get this:

Error Code: 1105. ERROR: class wrappers/JdbcInterface not found!

If I look in the plugins directory (/usr/lib64/mysql/plugin) there are no jar files... so I am guessing this is the problem. The documentation says JdbcInterface.jar is included with the binary distribution and will be located in the plugin folder.

Could you attach the jar file to this so I can place it in plugins to try?

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

JavaWrappers.jar
43 kB
2017-09-07 08:36

Issue Links

relates to

MDEV-31231 Remove JavaWrappers.jar from mariadb-test-data and create new mariadb-plugin-connect-jdbc package

Closed

Activity

Ascending order - Click to sort in descending order

Robert Dyas added a comment - 2016-10-02 02:43

using find -name "JdbcInterface.jar" produced no results on my system.

Is JdbcInterface.jar actually included with centos RPM binary distribution in 10.1.18?

Robert Dyas added a comment - 2016-10-02 02:43 using find -name "JdbcInterface.jar" produced no results on my system. Is JdbcInterface.jar actually included with centos RPM binary distribution in 10.1.18?

Elena Stepanova added a comment - 2016-10-03 18:22

It gets built on RPM-based systems, but not included into RPMs, although it should. Thanks for pointing it out.

Meanwhile, I've built it as a part of 10.1.18 release build on CentOS 7 x86_64 and uploaded here:
ftp://ftp.askmonty.org/public/JdbcInterface.jar

Maybe it will help as a workaround.

Elena Stepanova added a comment - 2016-10-03 18:22 It gets built on RPM-based systems, but not included into RPMs, although it should. Thanks for pointing it out. Meanwhile, I've built it as a part of 10.1.18 release build on CentOS 7 x86_64 and uploaded here: ftp://ftp.askmonty.org/public/JdbcInterface.jar Maybe it will help as a workaround.

Robert Dyas added a comment - 2016-10-03 20:13

Fantastic! I was able to get a JDBC connection no problem with this jar file!
There are some bugs, but I'll post those separately.
Thank you!

Robert Dyas added a comment - 2016-10-03 20:13 Fantastic! I was able to get a JDBC connection no problem with this jar file! There are some bugs, but I'll post those separately. Thank you!

Robert Dyas added a comment - 2016-10-06 21:01

Would it be possible for you to post a link to the ApacheInterface.jar file?

Also, I think that since this is a general purpose pooling solution and the file is small and would probably be used in most cases, it would be great if this could be included in the binary distribution just like JdbcInterface.jar

Thank you.

Also PS - zero server crashes with CONNECT JDBC so far !!!

Robert Dyas added a comment - 2016-10-06 21:01 Would it be possible for you to post a link to the ApacheInterface.jar file? Also, I think that since this is a general purpose pooling solution and the file is small and would probably be used in most cases, it would be great if this could be included in the binary distribution just like JdbcInterface.jar Thank you. Also PS - zero server crashes with CONNECT JDBC so far !!!

Sergei Golubchik added a comment - 2017-05-13 12:06

Connect engine uses install_jar() function from the UseJava.cmake package to install JdbcInrerface.jar.
But CentOS 7 has cmake version 2.8.12.2, and in that version install_jar() does not support the COMPONENT option, so the installed file cannot be attributed to the correct RPM package.

I'll replace install_jar() function with the native cmake install(FILES) command, which works fine.

Sergei Golubchik added a comment - 2017-05-13 12:06 Connect engine uses install_jar() function from the UseJava.cmake package to install JdbcInrerface.jar . But CentOS 7 has cmake version 2.8.12.2, and in that version install_jar() does not support the COMPONENT option, so the installed file cannot be attributed to the correct RPM package. I'll replace install_jar() function with the native cmake install(FILES) command, which works fine.

Mohit Chandel added a comment - 2017-09-07 05:26 - edited

Hi,

I installed mariadb 10.2.8 on Debian 9 with connect plugin.

JdbcInterface.jar file was not installed on my system.

sysadmin@netmon:~$ uname -a

Linux netmon 4.9.0-3-amd64 #1 SMP Debian 4.9.30-2+deb9u3 (2017-08-06) x86_64 GNU/Linux

sysadmin@netmon:~$ cat /etc/debian_version

9.1

sysadmin@netmon:~$ dpkg -l | grep -i mariadb

ii  libdbd-mysql-perl                4.041-2                        amd64        Perl5 database interface to the MariaDB/MySQL database

ii  libmariadb3                      10.2.8+maria~stretch           amd64        MariaDB database client library

ii  libmariadbclient18:amd64         10.1.26-0+deb9u1               amd64        MariaDB database client library

ii  mariadb-client-10.2              10.2.8+maria~stretch           amd64        MariaDB database client binaries

ii  mariadb-client-core-10.2         10.2.8+maria~stretch           amd64        MariaDB database core client binaries

ii  mariadb-common                   10.2.8+maria~stretch           all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)

ii  mariadb-plugin-connect           10.2.8+maria~stretch           amd64        Connect storage engine for MariaDB

ii  mariadb-server-10.2              10.2.8+maria~stretch           amd64        MariaDB database server binaries

ii  mariadb-server-core-10.2         10.2.8+maria~stretch           amd64        MariaDB database core server files

ii  mysql-common                     10.2.8+maria~stretch           all          MariaDB database common files (e.g. /etc/mysql/my.cnf)

sysadmin@netmon:~$ dpkg -c /var/cache/apt/archives/mariadb-plugin-connect_10.2.8+maria~stretch_amd64.deb

drwxr-xr-x root/root         0 2017-08-17 15:37 ./

drwxr-xr-x root/root         0 2017-08-17 15:37 ./etc/

drwxr-xr-x root/root         0 2017-08-17 15:37 ./etc/mysql/

drwxr-xr-x root/root         0 2017-08-17 15:37 ./etc/mysql/conf.d/

-rw-r--r-- root/root        40 2017-08-17 15:37 ./etc/mysql/conf.d/connect.cnf

drwxr-xr-x root/root         0 2017-08-17 15:37 ./usr/

drwxr-xr-x root/root         0 2017-08-17 15:37 ./usr/lib/

drwxr-xr-x root/root         0 2017-08-17 15:37 ./usr/lib/mysql/

drwxr-xr-x root/root         0 2017-08-17 15:37 ./usr/lib/mysql/plugin/

-rw-r--r-- root/root   1650256 2017-08-17 15:37 ./usr/lib/mysql/plugin/ha_connect.so

drwxr-xr-x root/root         0 2017-08-17 15:37 ./usr/share/

drwxr-xr-x root/root         0 2017-08-17 15:37 ./usr/share/doc/

drwxr-xr-x root/root         0 2017-08-17 15:37 ./usr/share/doc/mariadb-plugin-connect/

-rw-r--r-- root/root       470 2017-08-17 15:37 ./usr/share/doc/mariadb-plugin-connect/changelog.gz

-rw-r--r-- root/root      2501 2017-08-17 15:35 ./usr/share/doc/mariadb-plugin-connect/copyright

If any other information is required, pls let me know.

Mohit Chandel added a comment - 2017-09-07 05:26 - edited Hi, I installed mariadb 10.2.8 on Debian 9 with connect plugin. JdbcInterface.jar file was not installed on my system. sysadmin@netmon:~$ uname -a Linux netmon 4.9.0-3-amd64 #1 SMP Debian 4.9.30-2+deb9u3 (2017-08-06) x86_64 GNU/Linux sysadmin@netmon:~$ cat /etc/debian_version 9.1 sysadmin@netmon:~$ dpkg -l | grep -i mariadb ii libdbd-mysql-perl 4.041-2 amd64 Perl5 database interface to the MariaDB/MySQL database ii libmariadb3 10.2.8+maria~stretch amd64 MariaDB database client library ii libmariadbclient18:amd64 10.1.26-0+deb9u1 amd64 MariaDB database client library ii mariadb-client-10.2 10.2.8+maria~stretch amd64 MariaDB database client binaries ii mariadb-client-core-10.2 10.2.8+maria~stretch amd64 MariaDB database core client binaries ii mariadb-common 10.2.8+maria~stretch all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf) ii mariadb-plugin-connect 10.2.8+maria~stretch amd64 Connect storage engine for MariaDB ii mariadb-server-10.2 10.2.8+maria~stretch amd64 MariaDB database server binaries ii mariadb-server-core-10.2 10.2.8+maria~stretch amd64 MariaDB database core server files ii mysql-common 10.2.8+maria~stretch all MariaDB database common files (e.g. /etc/mysql/my.cnf) sysadmin@netmon:~$ dpkg -c /var/cache/apt/archives/mariadb-plugin-connect_10.2.8+maria~stretch_amd64.deb drwxr-xr-x root/root 0 2017-08-17 15:37 ./ drwxr-xr-x root/root 0 2017-08-17 15:37 ./etc/ drwxr-xr-x root/root 0 2017-08-17 15:37 ./etc/mysql/ drwxr-xr-x root/root 0 2017-08-17 15:37 ./etc/mysql/conf.d/ -rw-r--r-- root/root 40 2017-08-17 15:37 ./etc/mysql/conf.d/connect.cnf drwxr-xr-x root/root 0 2017-08-17 15:37 ./usr/ drwxr-xr-x root/root 0 2017-08-17 15:37 ./usr/lib/ drwxr-xr-x root/root 0 2017-08-17 15:37 ./usr/lib/mysql/ drwxr-xr-x root/root 0 2017-08-17 15:37 ./usr/lib/mysql/plugin/ -rw-r--r-- root/root 1650256 2017-08-17 15:37 ./usr/lib/mysql/plugin/ha_connect.so drwxr-xr-x root/root 0 2017-08-17 15:37 ./usr/share/ drwxr-xr-x root/root 0 2017-08-17 15:37 ./usr/share/doc/ drwxr-xr-x root/root 0 2017-08-17 15:37 ./usr/share/doc/mariadb-plugin-connect/ -rw-r--r-- root/root 470 2017-08-17 15:37 ./usr/share/doc/mariadb-plugin-connect/changelog.gz -rw-r--r-- root/root 2501 2017-08-17 15:35 ./usr/share/doc/mariadb-plugin-connect/copyright If any other information is required, pls let me know.

Olivier Bertrand added a comment - 2017-09-07 08:35

FYI: The JdbcInterface.jar file is obsolete, containing only the JdbcInterface wrapper.
The file to have is the JavaWrappers.jar that contains all the wrappers used by CONNECT, including the ones required by the new MONGO table type.
As a workaround, I'll attach this file here.

Olivier Bertrand added a comment - 2017-09-07 08:35 FYI: The JdbcInterface.jar file is obsolete, containing only the JdbcInterface wrapper. The file to have is the JavaWrappers.jar that contains all the wrappers used by CONNECT, including the ones required by the new MONGO table type. As a workaround, I'll attach this file here.

Mohit Chandel added a comment - 2017-09-08 04:53

Thanks Oliver.

The documentation needs to be updated.

CONNECT JDBC Table Type

Mohit Chandel added a comment - 2017-09-08 04:53 Thanks Oliver. The documentation needs to be updated. CONNECT JDBC Table Type

People

Assignee:: Sergei Golubchik

Reporter:: Robert Dyas

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2016-10-02 02:34

Updated:: 2023-05-18 12:18

Resolved:: 2017-05-16 08:57

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration