Menü
Suche

Warenkorb
Kasse

java.sql.SQLException: Syntaxfehler: Encountered "search" at line 27, column 4.
SELECT
PRODUCT.ID,
PRODUCT.NAME,
PRODUCT.MANUFACTURER_ID,
PRODUCT.PRODUCT_NO,
PRODUCT.WEIGHT,
PRODUCT.COLI,
PRODUCT.VOLUME,
PRODUCT.PRICE_PURCHASE,
PRODUCT.TAX,
PRODUCT.DATE_ADDED,
STORE.AMOUNT,
'prod' as NAMESPACE,
PRODUCT.MODIFIED_AT,
PRODUCT.MODIFIED_COLUMNS,
PRODUCT.CREATED_BY,
STORE.NAMESPACE,
STORE.FOREIGN_ID,
STORE.ID,
STORE.MODIFIED_AT,
STORE.MODIFIED_COLUMNS,
STORE.CREATED_BY
FROM
PRODUCT left join STORE on STORE.NAMESPACE='prod' and STORE.FOREIGN_ID=PRODUCT.ID
WHERE
(PRODUCT.CREATED_BY like 'JQ.DEMO.%') and
({search}) and
1=1
ORDER BY
PRODUCT.PRODUCT_NO
 at jq.io.DBAccess.executeInternal(DBAccess.java:357)
 at jq.io.DBAccess.executeQuery(DBAccess.java:278)
 at jq.edc.task.DBSelect.execute(DBSelect.java:690)
 at jq.task.AbstractTask.run(AbstractTask.java:62)
 at jq.edc.io.PersistorEDC.getData(PersistorEDC.java:267)
 at jq.edc.server.http.ContextEDC.getData(ContextEDC.java:302)
 at jq.edc.server.http.HTMLProcessorEDC.processProfile(HTMLProcessorEDC.java:382)
 at jq.edc.server.http.HTMLProcessorEDC.process(HTMLProcessorEDC.java:287)
 at jq.edc.server.http.ContextEDC.deliverContent(ContextEDC.java:880)
 at jq.edc.server.http.EDCServlet.service(EDCServlet.java:137)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:269)
 at java.security.AccessController.doPrivileged(Native Method)
 at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
 at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:301)
 at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:283)
 at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:56)
 at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:189)
 at java.security.AccessController.doPrivileged(Native Method)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:185)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
 at java.lang.Thread.run(Thread.java:619)


Gesamtsumme:

 Rechnungsadresse         Lieferadresse (nur wenn abweichend)
Vorname *
Name *
Straße *
PLZ *
Ort *
Land *
Email * Nur wenn Sie den Link in der Email, die wir Ihnen
zusenden weden, bestätigen, gilt der Kauf als
abgeschlossen.
 * Pflichtfelder 
  Mit der Bestellung stimmen Sie unseren AGB zu.