Created query is not supported by my DB

Posted by stacker on Stack Overflow See other posts from Stack Overflow or by stacker
Published on 2010-05-20T18:59:13Z Indexed on 2010/05/20 19:20 UTC
Read the original article Hit count: 110

Filed under:

seam

|

hibernate

|

java

I created an application using seam-gen. The created operation to search the DB ends with and exception (syntax error). The query has a where clause like this:

lower(barcode0_.barcode_ean) like lower((?||'%')) limit ?

Does hibnerate or seam create the where clause which my DB can't understand?

Or is there a workaround for SQL statement related issues in seam?

© Stack Overflow or respective owner

Related posts about seam

Configuring Seam for Glassfish

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I am still migrating to Glassfish instead of Jetty for our application servers and am running into some problems. The application starts up fine, the database tables are created by hibernate and data is imported by my database importer, so Seam is alive, running and well. It appears that… >>> More
Jboss Seam: Enabling Debug page on WebLogic 10.3.2 (11g)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, SKIP TO UPDATE 3 I want to enable the Seam debug page on Weblogic 10.3.2 (11g). So, I have done the following: I have the jboss-seam and jboss-seam-debug jars as dependency in both my ejb and web maven projects (both are modules of my superproject) I put this context parameter in my web… >>> More
Jboss Seam: Enabling Debug page

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I want to enable the debug page. So, I have done the following: I have the jboss-seam and jboss-seam-debug jars as dependency in both my ejb and web maven projects (both are modules of my superproject) I put this context parameter in my web.xml: <context-param> <param-name>org… >>> More
How to tell Seam to inject a local EJB interface (SLSB) and not the remote EJB interface (SLSB)?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am using Seam with JBoss AS. In my application I have a SLSB which is also declared as a seam component using the @Name annotation. I am trying to inject and use this SLSB in another seam component using the @In annotation. My problem is that sometimes Seam injects the local interface… >>> More
Seam conversation ending suddenly when using Redirect

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, Because I get some errors on conversations ending abruptly, I created in my project some test pages that reproduce the issue. The navigation takes place between pageA.xhtml and pageB.xhtml. Please tell me if I am using something in the wrong way. My configuration: Seam 2.2.0.GA WebLogic… >>> More

Related posts about hibernate

Hibernate unable to instantiate default tuplizer - cannot find getter

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to use Hibernate to persist a class that looks like this: public class Item implements Serializable, Comparable<Item> { // Item id private Integer id; // Description of item in inventory private String description; // Number of items described by this inventory item private int… >>> More
Hibernate + PostgreSQL : relation does not exist - SQL Error: 0, SQLState: 42P01

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am having some problems trying to work with PostgreSQL and Hibernate, more specifically, the issue mentioned in the title. I've been searching the net for a few hours now but none of the found solutions worked for me. I am using Eclipse Java EE IDE for Web Developers. Build id: 20090920-1017… >>> More
Problem connecting to Hsqldb via Hibernate when running a Eclipse GWT project.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to run a simple GWT project where I'm trying to do a simple persitence via hibernate to a HSQLDB database. The database I'm using I have been using for at least 2 years with several osgi applications without any problems. So all I done is reused the same configuration and added a simple… >>> More
Hibernate : load and

as seen on Stack Overflow - Search for 'Stack Overflow'
According to the tutorial : http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=27hibernateloadvshibernateget, If you initialize a JavaBean instance with a load method call, you can only access the properties of that JavaBean, for the first time, within the transactional context in which it… >>> More
Hibernate Exception, what wrong ? [[Exception in thread "main" org.hibernate.InvalidMappingException

as seen on Stack Overflow - Search for 'Stack Overflow'
I use netbean 6.7.1 to write "hello world" witch hibernate, but I get some errors, plz help me, thank you very much. my exception init: deps-module-jar: deps-ear-jar: deps-jar: Copying 1 file to F:\Documents and Settings\My Dropbox\DropboxNetBeanProjects\loginspring\build\web\WEB-INF\classes compile-single: run-main: Oct… >>> More