M
M
Mark Ivanych2017-08-09 19:57:50
Sphinx
Mark Ivanych, 2017-08-09 19:57:50

How to connect SphinxQl to Spring?

Hello,
Set up jett 9.4, mysql 5.6 and sphinx 2.2.9 in docker.
I connect from any container in the console to the Sphinx, it works. And from the application writes

Constructor threw exception; nested exception is 
java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required

@Bean
    public Connection sqlSphinx() throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager
            .getConnection(
                "jdbc:mysql://172.19.0.1:9306?characterEncoding=utf8&maxAllowedPacket=512000",
                "", "");
        return conn;
    }

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Kosarev, 2017-08-11
@jaxtr

Most likely the problem is incompatibility between MySQL jdbc driver and MySQL server.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question