REST Interface Bug Version 8.0.0-892
Version 8.0.0-892
Bug when using Rest interface
http://server:port/ws/spaces
Invalid request, resource ref (rref parameter) was not
specified.
<title>Grails Runtime Exception</title>
<style type="text/css">
.message {
border: 1px solid black;
padding: 5px;
background-color:#E9E9E9;
}
.stack {
border: 1px solid black;
padding: 5px;
overflow:auto;
height: 300px;
}
.snippet {
padding: 5px;
background-color:white;
border:1px solid black;
margin:3px;
font-family:courier;
}
</style>
<h1>Grails Runtime Exception</h1>
<h2>Error Details</h2>
<div class="message">
<strong>Error 500:</strong> Hibernate operation: could not inser
t: [com.saffrontech.ws.domain.Request]; uncategorized
SQLException for SQL [inse
rt into request (version, access_key, date_created, last_updated,
query_str, uri
) values (?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1364];
Field 'user_ id' doesn't have a default value; nested exception is
java.sql.SQLException: Fie
ld 'user_id' doesn't have a default value
<strong>Servlet:</strong> grails<br/>
<strong>URI:</strong> /ws/grails/resource/show.dispatch<br/>
<strong>Exception Message:</strong> Field 'user_id' does
n't have a default value
<strong>Caused by:</strong> Hibernate operation: could n
ot insert: [com.saffrontech.ws.domain.Request]; uncategorized
SQLException for S
QL [insert into request (version, access_key, date_created,
last_updated, query_
str, uri) values (?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code
[1364]; Fiel
d 'user_id' doesn't have a default value; nested exception is
java.sql.SQLExcept
ion: Field 'user_id' doesn't have a default value
<strong>Class:</strong> RequestFilters <br />
<strong>At Line:</strong> [139] <br />
<strong>Code Snippet:</strong><br />
<div class="snippet">
</div>
</div>
<h2>Stack Trace</h2>
<div class="stack">
<pre>org.springframework.jdbc.UncategorizedSQLException: Hibernate
operation: could not insert:
[com.saffrontech.ws.domain.Request]; uncategorized SQLException for
SQL [insert into request (version, access_key, date_created, l
ast_updated, query_str, uri) values (?, ?, ?, ?, ?, ?)]; SQL state
[HY000]; erro r code [1364]; Field 'user_id' doesn't have a default
value; nested exception is java.sql.SQLException: Field 'user_id'
doesn't have a default value
at
RequestFilters$_closure1_closure3_closure7.doCall(RequestFilters.groovy:139)<
br/> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationF
ilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.ca
talina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
icationFilterChain.java:188)
at org.apache.catalina.core.ApplicationF
ilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.a
pache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(Applica
tionDispatcher.java:691)
at org.apache.catalina.core.ApplicationDispatche
r.processRequest(ApplicationDispatcher.java:469)
at org.apache.catalina.c
ore.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.
java:301)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFil
ter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.Appl
icationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.a
pache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterCha
in.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFil
ter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.Appl
icationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCha
in.java:188)
at org.apache.catalina.core.ApplicationFilterChain.inter
nalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.c
ore.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.jav
a:210)
at org.apache.catalina.core.StandardContextValve.invoke(Standard
ContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.in
voke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorRepor
tValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.Stan
dardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.ca
talina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.a
pache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processCo
nnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.Po
olTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.to
mcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:8
1)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Field 'user_id' doesn't have a
default value
at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.m
ysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdb c.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlI O.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.sendCo mmand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO .java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStat
ement.java:1737)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Prepar
edStatement.java:2022)
at com.mysql.jdbc.PreparedStatement.executeUpdat
e(PreparedStatement.java:1940)
at com.mysql.jdbc.PreparedStatement.exec
uteUpdate(PreparedStatement.java:1925)
at org.apache.commons.dbcp.Deleg
atingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at $Proxy6.saveOrUpdate(Unknown Source)
... 31 more
</div>
Comments are currently closed for this discussion. You can start a new one.
Support Staff 2 Posted by Chet Patel on 30 Oct, 2009 08:39 PM
Should be fixed with builds starting November 1st
Chet Patel closed this discussion on 30 Oct, 2009 08:39 PM.