teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問prepareStatementに変数がバインドされません（ORA-01008)

編集履歴

質問編集履歴

6

微修正

2019/06/12 10:23

投稿

kagemaru
kagemaru

スコア12

test CHANGED
File without changes
test CHANGED
@@ -40,13 +40,13 @@
40
40
 
41
41
  // 更新失敗
42
42
 
43
- logger.info("SevenpsLogDAOImpl.cancelUpdAccessToken SQL Update Faild");
43
+ logger.info("AaaDAOImpl.cancelUpdAccessToken SQL Update Faild");
44
44
 
45
45
  } else {
46
46
 
47
47
  // 更新成功
48
48
 
49
- logger.info("SevenpsLogDAOImpl.cancelUpdAccessToken SQL Update Success");
49
+ logger.info("AaaDAOImpl.cancelUpdAccessToken SQL Update Success");
50
50
 
51
51
  }
52
52
 
@@ -54,7 +54,7 @@
54
54
 
55
55
  t.printStackTrace();
56
56
 
57
- logger.info("SevenpsLogDAOImpl.cancelUpdAccessToken SQL Update Error");
57
+ logger.info("AaaDAOImpl.cancelUpdAccessToken SQL Update Error");
58
58
 
59
59
  } finally {
60
60
 

5

伏字間違い修正

2019/06/12 10:23

投稿

kagemaru
kagemaru

スコア12

test CHANGED
File without changes
test CHANGED
@@ -114,7 +114,7 @@
114
114
 
115
115
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
116
116
 
117
- at jp.co.あaaa.bbb.dao.AaaDAO.cancelUpdAccessToken(AaaDAO.java:388)
117
+ at jp.co.aaa.bbb.dao.AaaDAO.cancelUpdAccessToken(AaaDAO.java:388)
118
118
 
119
119
  at jp.co.aaa.bbb.test.SevenpsLogDAOTest.test002(AaaDAOTest.java:37)
120
120
 

4

社名を伏せました

2019/06/12 10:18

投稿

kagemaru
kagemaru

スコア12

test CHANGED
File without changes
test CHANGED
@@ -114,9 +114,9 @@
114
114
 
115
115
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
116
116
 
117
- at jp.co.zurich.sevenps.dao.AaaDAO.cancelUpdAccessToken(AaaDAO.java:388)
117
+ at jp.co.あaaa.bbb.dao.AaaDAO.cancelUpdAccessToken(AaaDAO.java:388)
118
118
 
119
- at jp.co.zurich.sevenps.test.SevenpsLogDAOTest.test002(AaaDAOTest.java:37)
119
+ at jp.co.aaa.bbb.test.SevenpsLogDAOTest.test002(AaaDAOTest.java:37)
120
120
 
121
121
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
122
122
 

3

prepareStatementを２回投げている部分を修正

2019/06/12 10:17

投稿

kagemaru
kagemaru

スコア12

test CHANGED
File without changes
test CHANGED
@@ -25,8 +25,6 @@
25
25
  Class.forName("oracle.jdbc.driver.OracleDriver");
26
26
 
27
27
  conn = DriverManager.getConnection(path, id, pw);
28
-
29
- ps = conn.prepareStatement(sql);
30
28
 
31
29
  Date currectDateTime = new Date();
32
30
 

2

誤記修正

2019/06/12 10:09

投稿

kagemaru
kagemaru

スコア12

test CHANGED
File without changes
test CHANGED
@@ -90,7 +90,7 @@
90
90
 
91
91
 
92
92
 
93
- 18:37:39,123 SevenpsLogDAOImpl.cancelUpdAccessToken SQL Update Error
93
+ 18:37:39,123 AaaDAOImpl.cancelUpdAccessToken SQL Update Error
94
94
 
95
95
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
96
96
 

1

誤り修正

2019/06/12 09:58

投稿

kagemaru
kagemaru

スコア12

test CHANGED
File without changes
test CHANGED
@@ -116,9 +116,9 @@
116
116
 
117
117
  at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
118
118
 
119
- at jp.co.zurich.sevenps.dao.SevenpsLogDAO.cancelUpdAccessToken(SevenpsLogDAO.java:388)
119
+ at jp.co.zurich.sevenps.dao.AaaDAO.cancelUpdAccessToken(AaaDAO.java:388)
120
120
 
121
- at jp.co.zurich.sevenps.test.SevenpsLogDAOTest.test002(SevenpsLogDAOTest.java:37)
121
+ at jp.co.zurich.sevenps.test.SevenpsLogDAOTest.test002(AaaDAOTest.java:37)
122
122
 
123
123
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
124
124