-
Notifications
You must be signed in to change notification settings - Fork 2
/
PlainConnector4MySqlTest.java
73 lines (63 loc) · 2.45 KB
/
PlainConnector4MySqlTest.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
/**
* http://thisthread.blogspot.com/2017/08/connecting-to-oracle-via-jdbc.html
*/
package dd;
import static org.junit.Assert.*;
import java.sql.Connection;
import java.sql.SQLException;
import org.junit.BeforeClass;
import org.junit.Test;
public class PlainConnector4MySqlTest {
// private static final String KLASS = "com.mysql.jdbc.Driver";
/**
* When required, explicitly use no SSL connection (useSSL=false) to avoid
* warning:
*
* WARN: Establishing SSL connection without server's identity verification is
* not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements
* SSL connection must be established by default if explicit option isn't set.
* For compliance with existing applications not using SSL the
* verifyServerCertificate property is set to 'false'. You need either to
* explicitly disable SSL by setting useSSL=false, or set useSSL=true and
* provide truststore for server certificate verification.
*/
private static final String URL = "jdbc:mysql://localhost:3306/sakila?serverTimezone=Europe/Rome";
private static final String USER = "root";
private static final String PASSWORD = "password";
private static PlainConnector connector;
private static Connection connection;
@BeforeClass
public static void setUp() {
connector = new PlainConnector(URL, USER, PASSWORD);
try {
connection = connector.getConnection();
} catch (SQLException e) {
fail(e.getMessage());
}
}
@Test
public void testBadUser() {
PlainConnector connector = null;
connector = new PlainConnector(URL, "Unknown", PASSWORD);
try {
connector.getConnection();
fail("No connection expected for unknown user");
} catch (SQLException e) {
String expectedState = "28000";
assertEquals(expectedState, e.getSQLState());
int expectedCode = 1045;
assertEquals(expectedCode, e.getErrorCode());
}
}
@Test
public void testGetDatabaseNameVersion() {
try {
// String expected = "5.7.19-log";
String expected = "8.0.17";
String actual = connector.getDatabaseVersion(connection);
assertEquals(expected, actual);
} catch (SQLException e) {
fail(e.getMessage());
}
}
}