I have an entity with a property whose column name contains a question mark.How do I map the column name so that an HQL query will correctly generate SQL with the column name wrapped appropriately (i.
i hav ahql query..it gets the data used between two dates..i wriiten a query like this from com.cod.model.Billing where datecolumn between \'2011-4-4\' and \'2011-4-20\'
I have a DetachedCriteria which I am using to search a table based on a name field. I want to make the search case-insensitive, and am wondering if there is a way to do this without using HQL. Somethi
Let\'s say I get the user to pick long and lat on map. I have database with fo开发者_如何学Gollowing columns:
I\'m using NHibernate with Active Record and I\'m trying to sum up a column and return the result. The column is a decimal(38,12). However when I do this I get the SQL Exception:
I have a table that is going to consist of columns of integers, each essentially being a sequence.Each row represent a single customer account and the sequences tied to it.
Basically I want to eager-load properties. I have the following HQL query: SELECT u.id AS id, u.name AS text, u AS obj FROM User AS u fetch all properties
I have a Blog domain class, which has many messages: class B开发者_如何学Golog { String description
I need to run a query that uses a function I created on the Oracle SQL(10g) database. I\'ve seen that Hibernate supports some aggregate functions (avg, sum, min, max and some forms of count) but I w
For example: EXISTS ( SELECT * FROM [table] W开发者_开发百科HERE ... ) How to make such query using Hibernate?HQL doesn\'t allow to use exists statement.