REST Interface Bug Version 8.0.0-892

Kyle Nakamoto's Avatar

Kyle Nakamoto

28 Sep, 2009 05:24 PM via web

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>
  1. Support Staff 2 Posted by Chet Patel on 30 Oct, 2009 08:39 PM

    Chet Patel's Avatar

    Should be fixed with builds starting November 1st

  2. Chet Patel closed this discussion on 30 Oct, 2009 08:39 PM.

Comments are currently closed for this discussion. You can start a new one.