БЛОГ НА HUSL


Ошибка Android Studio и Connector/J

Автор вопроса: GreenOwl

Задача: Связать apk приложение, созданное в Android Studio и локальный MySQL сервер на Windows.

Установка: Скачал MySQL Installer for Windows здесь, через него установил MySQL Server версии 8.0.29 x64 и Connector/J версии 8.0.29 x64. При конфигурации сервера ставил (всё, что не упомянул выключено):

Development Computer  
TCP/IP [enabled]  
Port 3306  
X Protocol Port 33060  
Open Windows Firewall ports for network access [enabled]  
Use Strong Password Encryption for Authentification (RECOMMENDED) [enabled]  
Password: xxxx  
Configure MySQL Server as a Windows Service [enabled]  
Windows Service Name: MySQL80  
Standard System Account [enabled]  
Add User: DB Admin ---- Password: xxxx ---- name: admin  
Hosts: <All Hosts (%)>  
Authentification MySQL [enabled]  
Start the MySQL Server at System Startup [emabled]  
MySQL user credentials password: xxxx

Дальше просто клацал по кнопочками далее и сервер установлен.

Подготовка: запускаю MySQL 8.0 Command Line Client. Пароль xxxx (везде вводил один пароль). И череда команд:

CREATE DATABASE testdb;
use testdb;
create table test(id int, name text);
insert into test values(1, 'abc');
insert into test values(2, 'xyz');
exit;

Иду в C:\ProgramData\MySQL\MySQL Server 8.0\my.ini, в конце файла устанавливаю bind-address=<IPv4-адрес>, где <IPv4-адрес> (вместе со скобками <>) - мой IPv4-адрес, который я брал из cmd --> ipconfig. Сохраняю файл, иду в "Службы", где ищу MySQL80. Нажал, перезапустил его. Закрываю службы.

Действия: Создаю новый проект в IntelliJ IDEA Community Edition 2022.1.1, где пишу простой код для просмотра содержимого таблиц только что созданной базы данных, где ip - мой IpV4 из ipconfig (в следующем фрагменте кода так-же):

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {

    public static void main(String[] args) {
        String connectionString = "jdbc:mysql://ip:3306/testdb";
        String username = "admin";
        String password = "xxxx";

        try {
            Connection connection = DriverManager.getConnection(connectionString, username, password);
            Statement command = connection.createStatement();
            ResultSet result = command.executeQuery("SELECT * FROM test");
            while (result.next()){
                System.out.println(result.getString(1) + " ---- " + result.getString(2));
            }
            command.close();
        }
        catch (Exception e){
            e.printStackTrace();
        }
    }
}

На выходе получаю:

1 ---- abc
2 ---- xyz

Process finished with exit code 0

Прекрасно, всё работает, переношу копируя всё, что написал в IntelliJ IDEA Community Edition 2022.1.1 в Android Studio:

MainActivity.java

package com.greenowl.android_mysql;

import androidx.appcompat.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.Button;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        Button showButton = findViewById(R.id.button);
        showButton.setOnClickListener(view -> {

            String connectionString = "jdbc:mysql://ip:3306/testdb";
            String username = "admin";
            String password = "xxxx";

            try {
                Connection connection = DriverManager.getConnection(connectionString, username, password);
                Statement command = connection.createStatement();
                ResultSet result = command.executeQuery("SELECT * FROM test");
                while (result.next()){
                    System.out.println(result.getString(1) + " ---- " + result.getString(2));
                }
                command.close();
            }
            catch (Exception e){
                e.printStackTrace();
            }
        });
    }
}

AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    package="com.greenowl.android_mysql">

    <uses-permission android:name="android.permission.INTERNET" />

    <application
        android:allowBackup="true"
        android:usesCleartextTraffic="true"
        android:dataExtractionRules="@xml/data_extraction_rules"
        android:fullBackupContent="@xml/backup_rules"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/Theme.AndroidMySQL"
        tools:targetApi="31">
        <activity
            android:name=".MainActivity"
            android:exported="true">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity">

    <Button
        android:id="@+id/button"
        android:layout_width="207dp"
        android:layout_height="75dp"
        android:text="Button"
        app:layout_constraintBottom_toBottomOf="parent"
        app:layout_constraintEnd_toEndOf="parent"
        app:layout_constraintStart_toStartOf="parent"
        app:layout_constraintTop_toTopOf="parent" />

</androidx.constraintlayout.widget.ConstraintLayout>

В коде добавил строку <uses-permission android:name="android.permission.INTERNET" />, и скопировал Connector/J, и в режиме проекта вставил его в app/libs, после сделав "Add as Lib", то есть как внешнюю библиотеку, запуская на физическом телефоне при нажатии на кнопку получаю:

06/03 22:55:54: Launching 'app' on Xiaomi Redmi Note 8 Pro.
Install successfully finished in 314 ms.
$ adb shell am start -n "com.greenowl.android_mysql/com.greenowl.android_mysql.MainActivity" -a android.intent.action.MAIN -c android.intent.category.LAUNCHER
Connected to process 19775 on device 'xiaomi-redmi_note_8_pro-adb-buifzdrw8d8tu44x-f2tLJZ._adb-tls-connect._tcp'.
Capturing and displaying logcat messages from application. This behavior can be disabled in the "Logcat output" section of the "Debugger" settings page.
I/l.android_mysq: Late-enabling -Xcheck:jni
I/l.android_mysq: Unquickening 22 vdex files!
V/studio.deploy: Startup agent attached to VM
V/studio.deploy: No existing instrumentation found. Loading instrumentation from instruments-b4e5f589.jar
W/l.android_mysq: DexFile /data/data/com.greenowl.android_mysql/code_cache/.studio/instruments-b4e5f589.jar is in boot class path but is not in a known location
V/studio.deploy: Applying transforms with cached classes
W/l.android_mysq: Accessing hidden method Landroid/content/res/Resources;->overrideDisplayAdjustments(Ljava/util/function/Consumer;)V (blacklist, linking, denied)
W/l.android_mysq: Accessing hidden method Landroid/app/ResourcesManager;->updateResourcesForActivity(Landroid/os/IBinder;Landroid/content/res/Configuration;IZ)V (greylist-max-o, linking, denied)
W/l.android_mysq: Accessing hidden method Landroid/app/ResourcesManager;->getOrCreateActivityResourcesStructLocked(Landroid/os/IBinder;)Landroid/app/ResourcesManager$ActivityResources; (greylist-max-o, linking, denied)
W/l.android_mysq: Redefining intrinsic method java.lang.Thread java.lang.Thread.currentThread(). This may cause the unexpected use of the original definition of java.lang.Thread java.lang.Thread.currentThread()in methods that have already been compiled.
W/l.android_mysq: Redefining intrinsic method boolean java.lang.Thread.interrupted(). This may cause the unexpected use of the original definition of boolean java.lang.Thread.interrupted()in methods that have already been compiled.
D/NetworkSecurityConfig: No Network Security Config specified, using platform default
D/NetworkSecurityConfig: No Network Security Config specified, using platform default
D/libMEOW: meow reload base cfg path: na
D/libMEOW: meow reload overlay cfg path: /vendor/etc/meow.cfg
D/libMEOW: applied 1 plugins for [com.greenowl.android_mysql]:
D/libMEOW:   plugin 1: [libMEOW_gift.so]:
E/libc: Access denied finding property "ro.vendor.pref_scale_resolution"
D/View: com.greenowl.android_mysql initForcedUseForceDark: 1
E/l.android_mysq: Invalid ID 0x00000000.
D/DecorView[]: getWindowModeFromSystem  windowmode is 1
D/DecorView: createDecorCaptionView windowingMode:1 mWindowMode 1 isFullscreen: true
E/libc: Access denied finding property "ro.vendor.pref_scale_resolution"
E/libc: Access denied finding property "ro.vendor.pref_scale_resolution"
E/libc: Access denied finding property "ro.vendor.pref_scale_resolution"
W/l.android_mysq: Accessing hidden method Landroid/view/View;->computeFitSystemWindows(Landroid/graphics/Rect;Landroid/graphics/Rect;)Z (greylist, reflection, allowed)
W/l.android_mysq: Accessing hidden method Landroid/view/ViewGroup;->makeOptionalFitsSystemWindows()V (greylist, reflection, allowed)
I/SurfaceFactory: [static] sSurfaceFactory = com.mediatek.view.impl.SurfaceFactoryImpl@c609d77
D/ViewRootImpl[MainActivity]: hardware acceleration = true , fakeHwAccelerated = false, sRendererDisabled = false, forceHwAccelerated = false, sSystemRendererDisabled = false
D/libMEOW: applied 1 plugins for [com.greenowl.android_mysql]:
D/libMEOW:   plugin 1: [libMEOW_gift.so]:
I/InputTransport: Create ARC handle: 0xb400007ba57059c0
V/PhoneWindow: DecorView setVisiblity: visibility = 0, Parent = android.view.ViewRootImpl@9b79a13, this = DecorView@1d09450[MainActivity]
D/libMEOW: applied 1 plugins for [com.greenowl.android_mysql]:
D/libMEOW:   plugin 1: [libMEOW_gift.so]:
I/GED: [GT]_get_procNameprocess pid(19775)
I/GED: [GT]_getprocess name(com.greenowl.android_mysql)
I/l.android_mysq: [GT] ret(1) gt_status(00000000) aniso_debug_level(0) gt_aniso_max_level(16) ani so mask(00000001) tri mask(00000002)
I/libMEOW_gift: ctx:0xb400007bb24aaee8, ARC not Enabled.
E/ion: ioctl c0044901 failed with code -1: Invalid argument
E/libc: Access denied finding property "ro.vendor.pref_scale_resolution"
E/libc: Access denied finding property "ro.vendor.pref_scale_resolution"
W/System: A resource failed to call close. 
W/System: A resource failed to call close. 
I/System.out: [socket]:check permission begin!
W/System: ClassLoader referenced unknown path: system/framework/mediatek-cta.jar
I/System.out: [socket] e:java.lang.ClassNotFoundException: com.mediatek.cta.CtaUtils
W/System.err: java.sql.SQLNonTransientConnectionException: Could not create connection to database server.
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1001)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
W/System.err:     at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:580)
W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:218)
W/System.err:     at com.greenowl.android_mysql.MainActivity.lambda$onCreate$0(MainActivity.java:27)
W/System.err:     at com.greenowl.android_mysql.MainActivity$$ExternalSyntheticLambda0.onClick(Unknown Source:0)
W/System.err:     at android.view.View.performClick(View.java:7575)
W/System.err:     at com.google.android.material.button.MaterialButton.performClick(MaterialButton.java:1194)
W/System.err:     at android.view.View.performClickInternal(View.java:7548)
W/System.err:     at android.view.View.access$3600(View.java:837)
W/System.err:     at android.view.View$PerformClick.run(View.java:28933)
W/System.err:     at android.os.Handler.handleCallback(Handler.java:938)
W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:99)
W/System.err:     at android.os.Looper.loop(Looper.java:236)
W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:8057)
W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
W/System.err:     at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:620)
W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1011)
W/System.err: Caused by: android.os.NetworkOnMainThreadException
W/System.err:     at android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1605)
W/System.err:     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:389)
W/System.err:     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:230)
W/System.err:     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:212)
W/System.err:     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:436)
W/System.err:     at java.net.Socket.connect(Socket.java:631)
W/System.err:     at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
W/System.err:     at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
W/System.err:     at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
W/System.err:   ... 20 more
I/l.android_mysq: ProcessProfilingInfo new_methods=0 is saved saved_to_disk=0 resolve_classes_delay=8000
V/PhoneWindow: DecorView setVisiblity: visibility = 4, Parent = android.view.ViewRootImpl@9b79a13, this = DecorView@1d09450[MainActivity]
I/GED: ged_boost_gpu_freq, level 100, eOrigin 2, final_idx 27, oppidx_max 27, oppidx_min 0

На виртуальной машине результат идентичен:

06/03 22:57:56: Launching 'app' on Pixel 3a API 30.
Install successfully finished in 1 s 585 ms.
$ adb shell am start -n "com.greenowl.android_mysql/com.greenowl.android_mysql.MainActivity" -a android.intent.action.MAIN -c android.intent.category.LAUNCHER
Connected to process 18943 on device 'emulator-5554'.
Capturing and displaying logcat messages from application. This behavior can be disabled in the "Logcat output" section of the "Debugger" settings page.
D/NetworkSecurityConfig: No Network Security Config specified, using platform default
D/NetworkSecurityConfig: No Network Security Config specified, using platform default
D/libEGL: loaded /vendor/lib/egl/libEGL_emulation.so
D/libEGL: loaded /vendor/lib/egl/libGLESv1_CM_emulation.so
D/libEGL: loaded /vendor/lib/egl/libGLESv2_emulation.so
W/l.android_mysq: Accessing hidden method Landroid/view/View;->computeFitSystemWindows(Landroid/graphics/Rect;Landroid/graphics/Rect;)Z (greylist, reflection, allowed)
W/l.android_mysq: Accessing hidden method Landroid/view/ViewGroup;->makeOptionalFitsSystemWindows()V (greylist, reflection, allowed)
D/HostConnection: HostConnection::get() New Host Connection established 0xeef7b570, tid 19009
D/HostConnection: HostComposition ext ANDROID_EMU_CHECKSUM_HELPER_v1 ANDROID_EMU_native_sync_v2 ANDROID_EMU_native_sync_v3 ANDROID_EMU_native_sync_v4 ANDROID_EMU_dma_v1 ANDROID_EMU_direct_mem ANDROID_EMU_host_composition_v1 ANDROID_EMU_host_composition_v2 ANDROID_EMU_vulkan ANDROID_EMU_deferred_vulkan_commands ANDROID_EMU_vulkan_null_optional_strings ANDROID_EMU_vulkan_create_resources_with_requirements ANDROID_EMU_YUV_Cache ANDROID_EMU_vulkan_ignored_handles ANDROID_EMU_has_shared_slots_host_memory_allocator ANDROID_EMU_vulkan_free_memory_sync ANDROID_EMU_vulkan_shader_float16_int8 ANDROID_EMU_vulkan_async_queue_submit ANDROID_EMU_sync_buffer_data ANDROID_EMU_read_color_buffer_dma GL_OES_vertex_array_object GL_KHR_texture_compression_astc_ldr ANDROID_EMU_host_side_tracing ANDROID_EMU_gles_max_version_2 
W/OpenGLRenderer: Failed to choose config with EGL_SWAP_BEHAVIOR_PRESERVED, retrying without...
D/EGL_emulation: eglCreateContext: 0xeef7b0a0: maj 2 min 0 rcv 2
D/EGL_emulation: eglMakeCurrent: 0xeef7b0a0: ver 2 0 (tinfo 0xef2bb9f0) (first time)
I/Gralloc4: mapper 4.x is not supported
D/HostConnection: createUnique: call
D/HostConnection: HostConnection::get() New Host Connection established 0xeef7ad20, tid 19009
D/goldfish-address-space: allocate: Ask for block of size 0x100
D/goldfish-address-space: allocate: ioctl allocate returned offset 0x3f3ffe000 size 0x2000
D/HostConnection: HostComposition ext ANDROID_EMU_CHECKSUM_HELPER_v1 ANDROID_EMU_native_sync_v2 ANDROID_EMU_native_sync_v3 ANDROID_EMU_native_sync_v4 ANDROID_EMU_dma_v1 ANDROID_EMU_direct_mem ANDROID_EMU_host_composition_v1 ANDROID_EMU_host_composition_v2 ANDROID_EMU_vulkan ANDROID_EMU_deferred_vulkan_commands ANDROID_EMU_vulkan_null_optional_strings ANDROID_EMU_vulkan_create_resources_with_requirements ANDROID_EMU_YUV_Cache ANDROID_EMU_vulkan_ignored_handles ANDROID_EMU_has_shared_slots_host_memory_allocator ANDROID_EMU_vulkan_free_memory_sync ANDROID_EMU_vulkan_shader_float16_int8 ANDROID_EMU_vulkan_async_queue_submit ANDROID_EMU_sync_buffer_data ANDROID_EMU_read_color_buffer_dma GL_OES_vertex_array_object GL_KHR_texture_compression_astc_ldr ANDROID_EMU_host_side_tracing ANDROID_EMU_gles_max_version_2 
W/System.err: java.sql.SQLNonTransientConnectionException: Could not create connection to database server.
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
W/System.err:     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1001)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
W/System.err:     at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:580)
W/System.err:     at java.sql.DriverManager.getConnection(DriverManager.java:218)
W/System.err:     at com.greenowl.android_mysql.MainActivity.lambda$onCreate$0(MainActivity.java:27)
W/System.err:     at com.greenowl.android_mysql.MainActivity$$ExternalSyntheticLambda0.onClick(Unknown Source:0)
W/System.err:     at android.view.View.performClick(View.java:7448)
W/System.err:     at com.google.android.material.button.MaterialButton.performClick(MaterialButton.java:1194)
W/System.err:     at android.view.View.performClickInternal(View.java:7425)
W/System.err:     at android.view.View.access$3600(View.java:810)
W/System.err:     at android.view.View$PerformClick.run(View.java:28305)
W/System.err:     at android.os.Handler.handleCallback(Handler.java:938)
W/System.err:     at android.os.Handler.dispatchMessage(Handler.java:99)
W/System.err:     at android.os.Looper.loop(Looper.java:223)
W/System.err:     at android.app.ActivityThread.main(ActivityThread.java:7656)
W/System.err:     at java.lang.reflect.Method.invoke(Native Method)
W/System.err:     at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:592)
W/System.err:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:947)
W/System.err: Caused by: android.os.NetworkOnMainThreadException
W/System.err:     at android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1605)
W/System.err:     at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:389)
W/System.err:     at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:230)
W/System.err:     at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:212)
W/System.err:     at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:436)
W/System.err:     at java.net.Socket.connect(Socket.java:621)
W/System.err:     at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
W/System.err:     at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
W/System.err:     at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
W/System.err:     at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
W/System.err:   ... 20 more

Что не так? Вроде же использовал всё тоже самое, и подключался по IP а не по localhost, и не по 10.0.2.2. Что делать? Как исправить ситуацию. Возможно это связано с тем, что при попытке входа в MySQL Server после этих всех действий пароль уже не действителен? Этого я тоже не понимаю. Нигде его не менял, ничего с ним не делал, но после этих действий приходиться переустанавливать сервер. Спасибо.

EDIT: Разобрался с проблемой. Для этого необходимо было изменить код MainActivity.java на:

package com.greenowl.android_mysql;

import androidx.appcompat.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.Button;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        Button showButton = findViewById(R.id.button);
        showButton.setOnClickListener(view -> {
            new Thread(() -> {
                String connectionString = "jdbc:mysql://ip:3306/testdb?useSSL=false";
                String username = "admin";
                String password = "xxxx";

                try {
                    Connection connection = DriverManager.getConnection(connectionString, username, password);
                    Statement command = connection.createStatement();
                    ResultSet result = command.executeQuery("SELECT * FROM test");
                    while (result.next()){
                        System.out.println(result.getString(1) + " ---- " + result.getString(2));
                    }
                    command.close();
                }
                catch (Exception e){
                    e.printStackTrace();
                }
            }).start();
        });
    }
}

Также я вместо моего локального ip в my.ini поставил 0.0.0.0 для надежности. Еще пришлось заменить Connector/J версии 8.0.29 x64 на mysql-connector-java-5.1.46-bin.jar.

Очень помогла статья. Четко расписано что да как сделать. Также в конце строки connectionString добавляем "?useSSL=false" - так работает без предупреждений, хотя и с ними уже всё в норме.


Источник

Ответы (0 шт):

licensed under cc by-sa 3.0 with attribution.