teratail
回答率
85.30%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問eclipseとmysqlが接続できない

編集履歴

質問編集履歴

4

コードの変更

2018/12/14 06:31

投稿

nononon
nononon

スコア10

title CHANGED
File without changes
body CHANGED
@@ -55,7 +55,7 @@
55
55
  Connection conn = null;
56
56
  String url = "jdbc:mysql://localhost/helloworld?useSSL=false&requireSSL=false";
57
57
  String user = "root";
58
- String password = "gundamV2";
58
+ String password = "password";
59
59
  String msg = "";
60
60
 
61
61
  try {

3

コードの変更

2018/12/14 06:31

投稿

nononon
nononon

スコア10

title CHANGED
File without changes
body CHANGED
@@ -51,36 +51,38 @@
51
51
 
52
52
  public static void main(String[] args) {
53
53
  // TODO 自動生成されたメソッド・スタブ
54
+
54
-
55
+ Connection conn = null;
56
+ String url = "jdbc:mysql://localhost/helloworld?useSSL=false&requireSSL=false";
57
+ String user = "root";
58
+ String password = "gundamV2";
55
59
  String msg = "";
60
+
56
61
  try {
57
62
  // ドライバロード
58
63
  Class.forName("com.mysql.jdbc.Driver");
59
64
 
60
65
  // MySQLに接続
61
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost/helloworld?autoReconnect=true&useSSL=false");
66
+ conn = DriverManager.getConnection(url, user, password);
62
67
 
63
68
  // ステートメント生成
64
- Statement stmt = con.createStatement();
69
+ Statement stmt = conn.createStatement();
65
70
 
66
71
  // SQLを実行
67
- String sqlStr = "SELECT * FROM testhelloworld";
68
- ResultSet rs = stmt.executeQuery(sqlStr);
72
+ ResultSet rs = stmt.executeQuery("SELECT * FROM test");
69
73
 
70
74
  // 結果行をループ
71
75
  while(rs.next()){
72
76
  // レコードの値
73
- int id = rs.getInt("user_id");
77
+ int Field = rs.getInt("helloworld");
74
- String name = rs.getString("user_name");
78
+
75
-
76
79
  //表示
77
- System.out.println(id + "：" + name);
80
+ System.out.println(Field);
78
81
  }
79
82
 
80
83
  // 接続を閉じる
81
84
  rs.close();
82
85
  stmt.close();
83
- con.close();
84
86
  }catch (ClassNotFoundException e){
85
87
  msg = "ドライバのロードに失敗しました";
86
88
  System.out.println(msg);

2

エラーとコードを修正しました

2018/12/14 06:30

投稿

nononon
nononon

スコア10

title CHANGED
File without changes
body CHANGED
@@ -5,41 +5,39 @@
5
5
  ### 発生している問題・エラーメッセージ
6
6
  ```ここに言語を入力
7
7
  ドライバのロードに失敗しました
8
- com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
8
+ java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
9
+ at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
10
+ at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
11
+ at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
12
+ at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
13
+ at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
14
+ at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
15
+ at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
16
+ at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
17
+ at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
18
+ at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
19
+ at java.sql.DriverManager.getConnection(DriverManager.java:664)
20
+ at java.sql.DriverManager.getConnection(DriverManager.java:270)
21
+ at MyQuery.main(MyQuery.java:18)
22
+ Caused by: com.mysql.cj.exceptions.CJException: Access denied for user ''@'localhost' (using password: NO)
9
23
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
10
24
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
11
25
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
12
26
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
13
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
14
- at com.mysql.jdbc.Util.getInstance(Util.java:408)
15
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
16
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
17
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
18
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
27
+ at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
19
- at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2105)
20
- at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2030)
28
+ at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
21
- at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
22
- at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
23
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
24
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
25
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
26
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
27
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
28
- at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
29
+ at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
30
+ at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:129)
31
+ at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:809)
32
+ at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:734)
33
+ at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:702)
34
+ at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:132)
35
+ at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:540)
36
+ at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202)
29
- at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
37
+ at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1442)
30
- at java.sql.DriverManager.getConnection(DriverManager.java:664)
31
- at java.sql.DriverManager.getConnection(DriverManager.java:270)
32
- at MyQuery.main(MyQuery.java:18)
33
- Caused by: java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
34
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
35
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
36
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
37
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
38
- at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
39
- at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
40
- at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
38
+ at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
41
- at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2046)
39
+ at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
42
- ... 13 more
40
+ ... 7 more
43
41
 
44
42
  ```
45
43
  ### 該当のソースコード
@@ -57,7 +55,7 @@
57
55
  String msg = "";
58
56
  try {
59
57
  // ドライバロード
60
- Class.forName("com.mysql.cj.jdbc.Driver");
58
+ Class.forName("com.mysql.jdbc.Driver");
61
59
 
62
60
  // MySQLに接続
63
61
  Connection con = DriverManager.getConnection("jdbc:mysql://localhost/helloworld?autoReconnect=true&useSSL=false");

1

打ちなおしたものとエラーコードを追加しました

2018/12/13 07:00

投稿

nononon
nononon

スコア10

title CHANGED
File without changes
body CHANGED
@@ -3,11 +3,47 @@
3
3
 
4
4
 
5
5
  ### 発生している問題・エラーメッセージ
6
-
6
+ ```ここに言語を入力
7
7
  ドライバのロードに失敗しました
8
+ com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
9
+ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
10
+ at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
11
+ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
12
+ at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
13
+ at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
14
+ at com.mysql.jdbc.Util.getInstance(Util.java:408)
15
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
16
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
17
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
18
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
19
+ at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2105)
20
+ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2030)
21
+ at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778)
22
+ at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
23
+ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
24
+ at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
25
+ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
26
+ at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
27
+ at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
28
+ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
29
+ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
30
+ at java.sql.DriverManager.getConnection(DriverManager.java:664)
31
+ at java.sql.DriverManager.getConnection(DriverManager.java:270)
32
+ at MyQuery.main(MyQuery.java:18)
33
+ Caused by: java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
34
+ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
35
+ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
36
+ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
37
+ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
38
+ at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
39
+ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
40
+ at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
41
+ at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2046)
42
+ ... 13 more
8
43
 
44
+ ```
9
45
  ### 該当のソースコード
10
-
46
+ ```該当のソースコード
11
47
  import java.sql.Connection;
12
48
  import java.sql.DriverManager;
13
49
  import java.sql.ResultSet;
@@ -21,7 +57,7 @@
21
57
  String msg = "";
22
58
  try {
23
59
  // ドライバロード
24
- Class.forName("org.gjt.mm.mysql.Driver");
60
+ Class.forName("com.mysql.cj.jdbc.Driver");
25
61
 
26
62
  // MySQLに接続
27
63
  Connection con = DriverManager.getConnection("jdbc:mysql://localhost/helloworld?autoReconnect=true&useSSL=false");
@@ -50,13 +86,15 @@
50
86
  }catch (ClassNotFoundException e){
51
87
  msg = "ドライバのロードに失敗しました";
52
88
  System.out.println(msg);
89
+ e.printStackTrace();
53
90
  }catch (Exception e){
54
91
  msg = "ドライバのロードに失敗しました";
55
92
  System.out.println(msg);
93
+ e.printStackTrace();
56
94
  }
57
95
  }
58
96
  }
59
-
97
+ ```
60
98
  と出てしまうのでmysql-connector-java-5.1.47-bin.jarを入れるフォルダが間違っているのかなと思っています。
61
99
  ### 試したこと
62
100