Hello,
I just started getting this error. One workaround is to use a different
name for the column which seems to fix the problem. I used to get the same
exception and renaming the column Telephone to Phone seemed to fix the
problem.
Surely this is a bug.
*type* Exception report
*message* *org.jooq.exception.DataAccessException: SQL [select
`ofpro_dev`.`OfficeSpaces`.`id`, `ofpro_dev`.`OfficeSpaces`.`Provider`,
`ofpro_dev`.`OfficeSpaces`.`Address`, `ofpro_dev`.`OfficeSpaces`.`Phone`,
`ofpro_dev`.`OfficeSpaces`.`Email1`, `ofpro_dev`.`OfficeSpaces`.`District`,
`ofpro_dev`.`OfficeSpaces`.`Style`, `ofpro_dev`.`OfficeSpaces`.`Budget`,
`ofpro_dev`.`OfficeSpaces`.`isCoWorking`,
`ofpro_dev`.`OfficeSpaces`.`Image`, `ofpro_dev`.`OfficeSpaces`.`Notes`,
`ofpro_dev`.`OfficeSpaces`.`Area`, `ofpro_dev`.`OfficeSpaces`.`Submarket`,
`ofpro_dev`.`OfficeSpaces`.`Latitude`,
`ofpro_dev`.`OfficeSpaces`.`Longitude`,
`ofpro_dev`.`OfficeSpaces`.`isActive`, `ofpro_dev`.`OfficeSpaces`.`Price`,
`ofpro_dev`.`OfficeSpaces`.`SquareFootage`,
`ofpro_dev`.`OfficeSpaces`.`NoOfDesks`,
`ofpro_dev`.`OfficeSpaces`.`isExternal`,
`ofpro_dev`.`OfficeSpaces`.`AvailabilityFrom`,
`ofpro_dev`.`OfficeSpaces`.`OfficeNo`, `ofpro_dev`.`OfficeSpaces`.`Floor`
from `ofpro_dev`.`OfficeSpaces` where
(`ofpro_dev`.`OfficeSpaces`.`Latitude` between ? and ? and
`ofpro_dev`.`OfficeSpaces`.`Longitude` between ? and ?)]; Unknown column
'ofpro_dev.OfficeSpaces.Email1' in 'field list'*
*description* *The server encountered an internal error that prevented it
from fulfilling this request.*
*exception*
javax.servlet.ServletException: org.jooq.exception.DataAccessException: SQL
[select `ofpro_dev`.`OfficeSpaces`.`id`, `ofpro_dev`.`OfficeSpaces`.`Provider`,
`ofpro_dev`.`OfficeSpaces`.`Address`, `ofpro_dev`.`OfficeSpaces`.`Phone`,
`ofpro_dev`.`OfficeSpaces`.`Email1`, `ofpro_dev`.`OfficeSpaces`.`District`,
`ofpro_dev`.`OfficeSpaces`.`Style`, `ofpro_dev`.`OfficeSpaces`.`Budget`,
`ofpro_dev`.`OfficeSpaces`.`isCoWorking`, `ofpro_dev`.`OfficeSpaces`.`Image`,
`ofpro_dev`.`OfficeSpaces`.`Notes`, `ofpro_dev`.`OfficeSpaces`.`Area`,
`ofpro_dev`.`OfficeSpaces`.`Submarket`, `ofpro_dev`.`OfficeSpaces`.`Latitude`,
`ofpro_dev`.`OfficeSpaces`.`Longitude`, `ofpro_dev`.`OfficeSpaces`.`isActive`,
`ofpro_dev`.`OfficeSpaces`.`Price`, `ofpro_dev`.`OfficeSpaces`.`SquareFootage`,
`ofpro_dev`.`OfficeSpaces`.`NoOfDesks`,
`ofpro_dev`.`OfficeSpaces`.`isExternal`,
`ofpro_dev`.`OfficeSpaces`.`AvailabilityFrom`,
`ofpro_dev`.`OfficeSpaces`.`OfficeNo`, `ofpro_dev`.`OfficeSpaces`.`Floor` from
`ofpro_dev`.`OfficeSpaces` where (`ofpro_dev`.`OfficeSpaces`.`Latitude` between
? and ? and `ofpro_dev`.`OfficeSpaces`.`Longitude` between ? and ?)]; Unknown
column 'ofpro_dev.OfficeSpaces.Email1' in 'field list'
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:489)
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:436)
org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:177)
*root cause*
org.jooq.exception.DataAccessException: SQL [select
`ofpro_dev`.`OfficeSpaces`.`id`, `ofpro_dev`.`OfficeSpaces`.`Provider`,
`ofpro_dev`.`OfficeSpaces`.`Address`, `ofpro_dev`.`OfficeSpaces`.`Phone`,
`ofpro_dev`.`OfficeSpaces`.`Email1`, `ofpro_dev`.`OfficeSpaces`.`District`,
`ofpro_dev`.`OfficeSpaces`.`Style`, `ofpro_dev`.`OfficeSpaces`.`Budget`,
`ofpro_dev`.`OfficeSpaces`.`isCoWorking`, `ofpro_dev`.`OfficeSpaces`.`Image`,
`ofpro_dev`.`OfficeSpaces`.`Notes`, `ofpro_dev`.`OfficeSpaces`.`Area`,
`ofpro_dev`.`OfficeSpaces`.`Submarket`, `ofpro_dev`.`OfficeSpaces`.`Latitude`,
`ofpro_dev`.`OfficeSpaces`.`Longitude`, `ofpro_dev`.`OfficeSpaces`.`isActive`,
`ofpro_dev`.`OfficeSpaces`.`Price`, `ofpro_dev`.`OfficeSpaces`.`SquareFootage`,
`ofpro_dev`.`OfficeSpaces`.`NoOfDesks`,
`ofpro_dev`.`OfficeSpaces`.`isExternal`,
`ofpro_dev`.`OfficeSpaces`.`AvailabilityFrom`,
`ofpro_dev`.`OfficeSpaces`.`OfficeNo`, `ofpro_dev`.`OfficeSpaces`.`Floor` from
`ofpro_dev`.`OfficeSpaces` where (`ofpro_dev`.`OfficeSpaces`.`Latitude` between
? and ? and `ofpro_dev`.`OfficeSpaces`.`Longitude` between ? and ?)]; Unknown
column 'ofpro_dev.OfficeSpaces.Email1' in 'field list'
org.jooq_3.9.3.MYSQL.debug(Unknown Source)
org.jooq.impl.Tools.translate(Tools.java:1985)
org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:676)
org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:363)
org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:315)
org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2708)
uk.co.propx.ofpro.model.OfficeSpace.findInRectangle(OfficeSpace.java:123)
uk.co.propx.ofpro.api.v1.OfficeSpaceService.findInRectagle(OfficeSpaceService.java:36)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
org.glassfish.jersey.internal.Errors.process(Errors.java:315)
org.glassfish.jersey.internal.Errors.process(Errors.java:297)
org.glassfish.jersey.internal.Errors.process(Errors.java:267)
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:436)
org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:177)
*root cause*
java.sql.SQLSyntaxErrorException: Unknown column
'ofpro_dev.OfficeSpaces.Email1' in 'field list'
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536)
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115)
com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983)
com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826)
com.mysql.cj.jdbc.PreparedStatement.execute(PreparedStatement.java:1153)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:195)
org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:270)
org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:349)
org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:315)
org.jooq.impl.SelectImpl.fetch(SelectImpl.java:2708)
uk.co.propx.ofpro.model.OfficeSpace.findInRectangle(OfficeSpace.java:123)
uk.co.propx.ofpro.api.v1.OfficeSpaceService.findInRectagle(OfficeSpaceService.java:36)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
org.glassfish.jersey.internal.Errors.process(Errors.java:315)
org.glassfish.jersey.internal.Errors.process(Errors.java:297)
org.glassfish.jersey.internal.Errors.process(Errors.java:267)
org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:436)
org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:177)
*note* *The full stack trace of the root cause is available in the Apache
Tomcat/8.0.27 logs.*
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
