Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 2
  • Filter
  • Time
Clear All
new posts
Previous 1 2 template Next
    #16
    Right, we understood that. However *before* adding the brokenCursorAPIs setting, you reported an issue with local MySQL, and that report doesn't make sense.

    If you have the time, we'd appreciate it if you could revert the brokenCursorAPIs setting and show the server log for a failed attempt to contact local MySQL. We just want to double-check that this is in fact a Google-CloudSQL-specific problem.

    Comment

      #17
      Originally posted by Isomorphic View Post
      Right, we understood that. However *before* adding the brokenCursorAPIs setting, you reported an issue with local MySQL, and that report doesn't make sense.

      If you have the time, we'd appreciate it if you could revert the brokenCursorAPIs setting and show the server log for a failed attempt to contact local MySQL. We just want to double-check that this is in fact a Google-CloudSQL-specific problem.
      I get an error message on browser saying: "This method is not allowed on a forward only resultset."

      and the error log is:
      Code:
      === 2012-12-04 20:40:44,659 [02-0] DEBUG SQLTransform - [builtinApplication.prefeituras_fetch] isBeforeFirst()/isAfterLast() throwing exceptions - attempting workaround
=== 2012-12-04 20:40:44,661 [02-4] WARN  RequestContext - dsRequest.execute() failed: 
java.sql.SQLException: This method is not allowed on a forward only resultset.
	at com.google.cloud.sql.jdbc.internal.Exceptions.newNotSupportedOnForwardOnlyException(Exceptions.java:220)
	at com.google.cloud.sql.jdbc.ResultSet.assertScrollableAndOpen(ResultSet.java:798)
	at com.google.cloud.sql.jdbc.ResultSet.getRow(ResultSet.java:723)
	at org.apache.commons.dbcp.DelegatingResultSet.getRow(DelegatingResultSet.java:332)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:571)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:484)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:478)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:472)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:447)
	at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:377)
	at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:287)
	at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:280)
	at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:421)
	at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:635)
	at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1628)
	at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1317)
	at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:293)
	at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:237)
	at com.isomorphic.datasource.DataSource.execute(DataSource.java:1289)
	at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:725)
	at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
	at com.isomorphic.application.AppBase.execute(AppBase.java:491)
	at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1954)
	at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:199)
	at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:156)
	at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:121)
	at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
	at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:246)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.api.socket.dev.DevSocketFilter.doFilter(DevSocketFilter.java:74)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.ResponseRewriterFilter.doFilter(ResponseRewriterFilter.java:123)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:34)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:61)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:125)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
	at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:94)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:383)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:326)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:755)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
=== 2012-12-04 20:40:44,661 [02-0] WARN  RequestContext - dsRequest.execute() failed: 
java.sql.SQLException: This method is not allowed on a forward only resultset.
	at com.google.cloud.sql.jdbc.internal.Exceptions.newNotSupportedOnForwardOnlyException(Exceptions.java:220)
	at com.google.cloud.sql.jdbc.ResultSet.assertScrollableAndOpen(ResultSet.java:798)
	at com.google.cloud.sql.jdbc.ResultSet.getRow(ResultSet.java:723)
	at org.apache.commons.dbcp.DelegatingResultSet.getRow(DelegatingResultSet.java:332)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:571)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:484)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:478)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:472)
	at com.isomorphic.sql.SQLTransform.toListOfMapsOrBeans(SQLTransform.java:447)
	at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:377)
	at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:287)
	at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:280)
	at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:421)
	at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:635)
	at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1628)
	at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1317)
	at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:293)
	at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:237)
	at com.isomorphic.datasource.DataSource.execute(DataSource.java:1289)
	at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:725)
	at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
	at com.isomorphic.application.AppBase.execute(AppBase.java:491)
	at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1954)
	at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:199)
	at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:156)
	at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:121)
	at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
	at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:246)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.api.socket.dev.DevSocketFilter.doFilter(DevSocketFilter.java:74)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.ResponseRewriterFilter.doFilter(ResponseRewriterFilter.java:123)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:34)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:61)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:125)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)
	at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
	at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
	at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
	at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
	at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
	at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:94)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:383)
	at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
	at org.mortbay.jetty.Server.handle(Server.java:326)
	at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
	at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938)
	at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:755)
	at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
	at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
	at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
	at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)

      Comment

        #18
        Thanks. The stack reveals that as expected, you are still using Google-provided software in this case. So it's just Google's stuff that's broken, not MySQL in general.

        Comment

        Previous 1 2 template Next
        Working...
        X