teratail
回答率
85.30%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問エラーの意味は理解できるがどこでエラーが出ているのかわからない

編集履歴

質問編集履歴

3

追加情報

2021/01/14 05:58

投稿

K_3578
K_3578

スコア1282

title CHANGED
File without changes
body CHANGED
@@ -15,46 +15,11 @@
15
15
  例外
16
16
 
17
17
  javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
18
- org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
18
+
19
- org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
20
- org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
21
- org.hibernate.query.Query.getResultList(Query.java:146)
22
- controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
23
- javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
24
- javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
25
- org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
26
- filters.LoginFilter.doFilter(LoginFilter.java:72)
27
- filters.EncodingFilter.doFilter(EncodingFilter.java:38)
28
19
  原因
29
20
 
30
21
  org.hibernate.exception.SQLGrammarException: could not extract ResultSet
31
- org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
22
+
32
- org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
33
- org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
34
- org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
35
- org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
36
- org.hibernate.loader.Loader.getResultSet(Loader.java:2168)
37
- org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
38
- org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
39
- org.hibernate.loader.Loader.doQuery(Loader.java:938)
40
- org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
41
- org.hibernate.loader.Loader.doList(Loader.java:2692)
42
- org.hibernate.loader.Loader.doList(Loader.java:2675)
43
- org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
44
- org.hibernate.loader.Loader.list(Loader.java:2502)
45
- org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
46
- org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
47
- org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
48
- org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
49
- org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
50
- org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
51
- org.hibernate.query.Query.getResultList(Query.java:146)
52
- controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
53
- javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
54
- javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
55
- org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
56
- filters.LoginFilter.doFilter(LoginFilter.java:72)
57
- filters.EncodingFilter.doFilter(EncodingFilter.java:38)
58
23
  原因
59
24
 
60
25
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as task5_1_, trucks0_.task_type as task_typ6_1_, trucks0_.truck_code as truck_co' at line 1
@@ -117,80 +82,6 @@
117
82
 
118
83
  @Column(name = "vehicle_type", nullable = false)
119
84
  private String vehicle_type;
120
-
121
-
122
- public Integer getId() {
123
- return id;
124
- }
125
-
126
- public void setId(Integer id) {
127
- this.id = id;
128
- }
129
-
130
- public java.sql.Date getTask_date() {
131
- return task_date;
132
- }
133
-
134
- public void setTask_date(java.sql.Date task_date) {
135
- this.task_date = task_date;
136
- }
137
-
138
- public java.sql.Time getTask_time() {
139
- return task_time;
140
- }
141
-
142
- public void setTask_time(java.sql.Time task_time) {
143
- this.task_time = task_time;
144
- }
145
-
146
- public String getOffice_name() {
147
- return office_name;
148
- }
149
-
150
- public void setOffice_name(String office_name) {
151
- this.office_name = office_name;
152
- }
153
-
154
-
155
- public void setTask_type(String task_type){
156
- this.task_type = task_type;
157
- }
158
-
159
-
160
- public String getVehicle_code() {
161
- return vehicle_code;
162
- }
163
-
164
- public void setVehicle_code(String vehicle_code) {
165
- this.vehicle_code = vehicle_code;
166
- }
167
-
168
- public String getStack_area() {
169
- return stack_area;
170
- }
171
-
172
- public void setStack_area(String stack_area) {
173
- this.stack_area = stack_area;
174
- }
175
-
176
- public String getWholesale_area() {
177
- return wholesale_area;
178
- }
179
-
180
- public void setWholesale_area(String wholesale_area) {
181
- this.wholesale_area = wholesale_area;
182
- }
183
-
184
- public String getVehicle_type() {
185
- return vehicle_type;
186
- }
187
-
188
- public void setVehicle_type(String vehicle_type) {
189
- this.vehicle_type = vehicle_type;
190
- }
191
-
192
- }
193
-
194
85
  Trucksテーブル
195
86
  *************************** 1. row ***************************
196
87
  Table: trucks
@@ -207,9 +98,100 @@
207
98
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8
208
99
  ```
209
100
 
210
- ### 試したこと
101
+ ### 新たなエラー
102
+ ```
103
+ HTTPステータス 500 - org.hibernate.exception.SQLGrammarException: could not extract ResultSet
104
+ type 例外レポート
211
105
 
106
+ メッセージ org.hibernate.exception.SQLGrammarException: could not extract ResultSet
212
107
 
108
+ 説明 The server encountered an internal error that prevented it from fulfilling this request.
109
+
110
+ 例外
111
+
112
+ javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
113
+ org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:149)
114
+ org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:157)
115
+ org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
116
+ org.hibernate.query.Query.getResultList(Query.java:146)
117
+ controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
118
+ javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
119
+ javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
120
+ org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
121
+ filters.LoginFilter.doFilter(LoginFilter.java:72)
122
+ filters.EncodingFilter.doFilter(EncodingFilter.java:38)
123
+ 原因
124
+
125
+ org.hibernate.exception.SQLGrammarException: could not extract ResultSet
126
+ org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
127
+ org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
128
+ org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
129
+ org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
130
+ org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
131
+ org.hibernate.loader.Loader.getResultSet(Loader.java:2168)
132
+ org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
133
+ org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
134
+ org.hibernate.loader.Loader.doQuery(Loader.java:938)
135
+ org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
136
+ org.hibernate.loader.Loader.doList(Loader.java:2692)
137
+ org.hibernate.loader.Loader.doList(Loader.java:2675)
138
+ org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
139
+ org.hibernate.loader.Loader.list(Loader.java:2502)
140
+ org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
141
+ org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
142
+ org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
143
+ org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
144
+ org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
145
+ org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
146
+ org.hibernate.query.Query.getResultList(Query.java:146)
147
+ controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
148
+ javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
149
+ javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
150
+ org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
151
+ filters.LoginFilter.doFilter(LoginFilter.java:72)
152
+ filters.EncodingFilter.doFilter(EncodingFilter.java:38)
153
+ 原因
154
+
155
+ com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'trucks0_.task_type' in 'field list'
156
+ sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
157
+ sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
158
+ sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
159
+ java.lang.reflect.Constructor.newInstance(Constructor.java:423)
160
+ com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
161
+ com.mysql.jdbc.Util.getInstance(Util.java:408)
162
+ com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
163
+ com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
164
+ com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
165
+ com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
166
+ com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
167
+ com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
168
+ com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
169
+ com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
170
+ org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
171
+ org.hibernate.loader.Loader.getResultSet(Loader.java:2168)
172
+ org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
173
+ org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
174
+ org.hibernate.loader.Loader.doQuery(Loader.java:938)
175
+ org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
176
+ org.hibernate.loader.Loader.doList(Loader.java:2692)
177
+ org.hibernate.loader.Loader.doList(Loader.java:2675)
178
+ org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
179
+ org.hibernate.loader.Loader.list(Loader.java:2502)
180
+ org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
181
+ org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
182
+ org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
183
+ org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
184
+ org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
185
+ org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
186
+ org.hibernate.query.Query.getResultList(Query.java:146)
187
+ controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
188
+ javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
189
+ javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
190
+ org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
191
+ filters.LoginFilter.doFilter(LoginFilter.java:72)
192
+ filters.EncodingFilter.doFilter(EncodingFilter.java:38)
193
+ ```
194
+
213
195
  ### 補足情報（FW/ツールのバージョンなど）
214
196
 
215
197
  使用しているのはEclipse4.6Neonです。

2

情報の追加

2021/01/14 05:58

投稿

K_3578
K_3578

スコア1282

title CHANGED
File without changes
body CHANGED
@@ -59,42 +59,7 @@
59
59
 
60
60
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as task5_1_, trucks0_.task_type as task_typ6_1_, trucks0_.truck_code as truck_co' at line 1
61
61
  sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
62
- sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
62
+
63
- sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
64
- java.lang.reflect.Constructor.newInstance(Constructor.java:423)
65
- com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
66
- com.mysql.jdbc.Util.getInstance(Util.java:408)
67
- com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
68
- com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
69
- com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
70
- com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
71
- com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
72
- com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
73
- com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
74
- com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
75
- org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
76
- org.hibernate.loader.Loader.getResultSet(Loader.java:2168)
77
- org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)
78
- org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)
79
- org.hibernate.loader.Loader.doQuery(Loader.java:938)
80
- org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)
81
- org.hibernate.loader.Loader.doList(Loader.java:2692)
82
- org.hibernate.loader.Loader.doList(Loader.java:2675)
83
- org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2507)
84
- org.hibernate.loader.Loader.list(Loader.java:2502)
85
- org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
86
- org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:392)
87
- org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
88
- org.hibernate.internal.SessionImpl.list(SessionImpl.java:1490)
89
- org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1445)
90
- org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1414)
91
- org.hibernate.query.Query.getResultList(Query.java:146)
92
- controllers.dispatch.DispatchIndexServlet.doGet(DispatchIndexServlet.java:45)
93
- javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
94
- javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
95
- org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
96
- filters.LoginFilter.doFilter(LoginFilter.java:72)
97
- filters.EncodingFilter.doFilter(EncodingFilter.java:38)
98
63
  ```
99
64
 
100
65
  ### 該当のソースコード
@@ -225,6 +190,21 @@
225
190
  }
226
191
 
227
192
  }
193
+
194
+ Trucksテーブル
195
+ *************************** 1. row ***************************
196
+ Table: trucks
197
+ Create Table: CREATE TABLE `trucks` (
198
+ `id` int(11) NOT NULL AUTO_INCREMENT,
199
+ `office_name` varchar(10) DEFAULT NULL,
200
+ `truck_code` varchar(15) DEFAULT NULL,
201
+ `truck_type` varchar(10) DEFAULT NULL,
202
+ `task_date` date DEFAULT NULL,
203
+ `stack_area` varchar(10) DEFAULT NULL,
204
+ `wholesale_area` varchar(10) DEFAULT NULL,
205
+ `task_time` time DEFAULT NULL,
206
+ PRIMARY KEY (`id`)
207
+ ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8
228
208
  ```
229
209
 
230
210
  ### 試したこと

1

文の修正

2021/01/14 05:37

投稿

K_3578
K_3578

スコア1282

title CHANGED
File without changes
body CHANGED
@@ -123,7 +123,7 @@
123
123
  ),
124
124
  })
125
125
  @Entity
126
- public class Trucks{
126
+ public class Vehicles{
127
127
  @Id
128
128
  @Column(name = "id")
129
129
  @GeneratedValue(strategy = GenerationType.IDENTITY)
@@ -141,8 +141,8 @@
141
141
  @Column(name = "office_name", nullable = false)
142
142
  private String office_name;
143
143
 
144
- @Column(name = "truck_code", nullable = false)
144
+ @Column(name = "vehicle_code", nullable = false)
145
- private String truck_code;
145
+ private String vehicle_code;
146
146
 
147
147
  @Column(name = "stack_area", nullable = false)
148
148
  private String stack_area;
@@ -150,8 +150,8 @@
150
150
  @Column(name = "wholesale_area", nullable = false)
151
151
  private String wholesale_area;
152
152
 
153
- @Column(name = "truck_type", nullable = false)
153
+ @Column(name = "vehicle_type", nullable = false)
154
- private String truck_type;
154
+ private String vehicle_type;
155
155
 
156
156
 
157
157
  public Integer getId() {
@@ -192,12 +192,12 @@
192
192
  }
193
193
 
194
194
 
195
- public String getTruck_code() {
195
+ public String getVehicle_code() {
196
- return truck_code;
196
+ return vehicle_code;
197
197
  }
198
198
 
199
- public void setTruck_code(String truck_code) {
199
+ public void setVehicle_code(String vehicle_code) {
200
- this.truck_code = truck_code;
200
+ this.vehicle_code = vehicle_code;
201
201
  }
202
202
 
203
203
  public String getStack_area() {
@@ -216,12 +216,12 @@
216
216
  this.wholesale_area = wholesale_area;
217
217
  }
218
218
 
219
- public String getTruck_type() {
219
+ public String getVehicle_type() {
220
- return truck_type;
220
+ return vehicle_type;
221
221
  }
222
222
 
223
- public void setTruck_type(String truck_type) {
223
+ public void setVehicle_type(String vehicle_type) {
224
- this.truck_type = truck_type;
224
+ this.vehicle_type = vehicle_type;
225
225
  }
226
226
 
227
227
  }