chris kyte | 2007-01-10 07:55:48.0 | |
Hi,
I get the following exception when trying to perform the following SQL query, what does it mean and how can I fix it please???? Many thanks in advance for any help you can offer. Best Regards, Chris. [10/01/07 15:47:42:207 GMT] 0000001c SystemErr R java.sql.SQLException: Can't parse index expression pack [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.global.SQLState.SQLException(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.v.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.b.char(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.b. [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.b.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.DBFIndex. [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.i.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.d.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.d. [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dbf.u.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.bm.if(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dc.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.dc.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.bm.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.bm.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.ag.a(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.de.executeQuery(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.hxtt.sql.ep.executeQuery(Unknown Source) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:690) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:488) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at uk.co.acl.database.PartDAO.completePartDetails(PartDAO.java:37) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at uk.co.acl.database.DatabaseManager.findPartsForProduct(DatabaseManager.java:345) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at uk.co.acl.userinterface.PartsListForm. [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at java.lang.Class.newInstanceImpl(Native Method) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at java.lang.Class.newInstance(Class.java:1545) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at java.beans.Beans.instantiate(Beans.java:219) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at java.beans.Beans.instantiate(Beans.java:63) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.config.ManagedBeanFactory.newInstance(ManagedBeanFactory.java:204) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.application.ApplicationImpl.createAndMaybeStoreManagedBeans(ApplicationImpl.java:940) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.el.VariableResolverImpl.resolveVariable(VariableResolverImpl.java:84) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.faces.databind.SelectItemsVarResolver.resolveVariable(SelectItemsVarResolver.java:40) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.el.impl.NamedValue.evaluate(NamedValue.java:125) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.el.impl.ComplexValue.evaluate(ComplexValue.java:146) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.el.impl.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:243) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:156) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:137) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at javax.faces.component.UIOutput.getValue(UIOutput.java:147) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.renderkit.html_basic.HtmlBasicInputRenderer.getValue(HtmlBasicInputRenderer.java:84) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.getCurrentValue(HtmlBasicRenderer.java:211) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeEnd(HtmlBasicRenderer.java:171) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:762) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.faces.component.UIJspPanel.encodeRecursive(UIJspPanel.java:292) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.faces.component.UIJspPanel.encodeChildren(UIJspPanel.java:270) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:484) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:489) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:489) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.faces.renderkit.html_extended.LayoutRenderer.encodeChildren(LayoutRenderer.java:255) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:743) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:588) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:525) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.faces.taglib.html_extended.PanelLayoutTag.doEndTag(PanelLayoutTag.java:238) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm._jsp._partslist._jspx_meth_hx_panelLayout_0(_partslist.java:1643) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm._jsp._partslist._jspx_meth_hx_scriptCollector_0(_partslist.java:1668) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm._jsp._partslist._jspx_meth_f_view_0(_partslist.java:1698) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm._jsp._partslist._jspService(_partslist.java:113) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:91) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:762) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:204) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:334) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.faces.context.MultipartExternalContextImpl.dispatch(MultipartExternalContextImpl.java:411) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:254) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:220) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:118) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:762) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1924) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:89) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039) [10/01/07 15:47:42:222 GMT] 0000001c SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1471) | ||
HXTT Support | 2007-01-10 22:18:18.0 | |
>Can't parse index expression pack
PACK is a sql reserved word. Please download the latest package which has supported to use it as column name. | ||
chris | 2007-01-11 01:47:59.0 | |
Downloaded new package and works a treat now, once again, many thanks. |