Breaking News
Home / Java / Java Issues / Unknown column in ‘field list’ java.lang.RuntimeException

Unknown column in ‘field list’ java.lang.RuntimeException

Issue

2011-12-23 12:13:31,292[Thread-16]ERROR SubscriptionXmlService -Failed to query account : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘source’ in ‘field list’
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘source’ in ‘field list’
     at com.infuze.service.subscription.workflow.SubscriptionAddonWorkflow.executeProcess
     at com.infuze.service.workflow.WorkflowExecutor.execute(WorkflowExecutor.java:24)
     at com.infuze.service.subscription.xml.SubscriptionXmlService.addon(SubscriptionXmlService.java:262)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at com.livrona.xhttpi.XHttpInvoker.execute(Unknown Source)
     at com.infuze.server.service.XmlServiceActionHandler.execute(XmlServiceActionHandler.java:28)
     at com.livrona.haxe.server.RequestHandler.executeRequest(RequestHandler.java:149)
     at com.livrona.haxe.server.RequestHandler.run(RequestHandler.java:77)<!>

Answer

This exception is caused when the field name specified in the select sql clause does not exists in the database. To resolve this simply fix your SQL select query to use the correct field name that exits in the table or add the missing field as referred in the SQL select query to the database table if it is required.

[pb_builder]

Check Also

Hibernate SQL Error: 904

Issue 2012-02-21 12:20:00,341[ExecuteThread: ’93’ for queue: ‘default’]DEBUG CustomerDAOFactory [#23640743#]-method : CustomerAttribDAO getCustomerAttributesDAO() 2012-02-21 12:20:00,341[ExecuteThread: ’93’ …

Advertisment ad adsense adlogger