|
One of the main reasons I use Hibernate is that it provides the flexibility to switch to another database without having to rewrite any code.
But until now I did not figure out a good way to define additional views on the tables to which my hibernate ...
Started by __roland__ on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Tables to create a "view" or you can use HQL to select a subset of the columns mapped by other you to SELECT from the database view and get Hibernate to automatically hydrate the data into yourCan you declare the ....
|
|
On Wed, 5 Dec 2007 03:31:51 -0500 (EST), "Alexander Chabatar (JIRA)" <jira-events@lists.jboss.org> wrote:
Database view/edit support
--------------------------
Key: JBIDE-1443
URL: http://jira.jboss.com/jira...
, 3 posts
Answer Snippets (Read the full thread at omgili):
Support for database operations:
> - Generate Select (SQL, HQL) statement (for table), DDL for database operations:
> - Generate Select (SQL, HQL) statement (for table), DDL (for table/entire
....
|
|
I have two hibernate entities User and Blog. User can be interested in multiple Tags. Blog can belong to multiple Tags. For a User, How do i find the Blogs which belong to the Tags the User is interested in?
I need something like
Select * from Blog where...
Started by Sathish on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This is the HQL query that worked without any additional entities:
select bAre you looking for something....
My previous solution of creating a USER_BLOGS view was too slow.
Tables like UserTag and BlogTag to use in HQL query.
|
Ask your Facebook Friends
|
Hibernate version:
3.0.1
Code between sessionFactory.openSession() and session.close():
Code: ProjectionList projectionList = Projections.projectionList();
projectionList.add(Property.forName("id"), "id");
projectionList.add(Property.forName("fileName...
Started by hamster on
, 6 posts
by 5 people.
Answer Snippets (Read the full thread at hibernate):
Will not come again
Thank You I still face similar problem
The generated HQL uses an alias which: "MPRODUCT1_"."NAME_DBCOL": invalid identifier
the HQL where clause is:
where this_.Product_Code.
|
|
On Mon, 17 Dec 2007 05:04:43 -0500 (EST), "Dima Geraskov (JIRA)" <jira-events@lists.jboss.org> wrote:
Code Assist not work in HQL Editor when configuration was not loaded
--------------------------------------------------------------------
...
, 4 posts
Answer Snippets (Read the full thread at omgili):
In context menu select HQL menu ....
Right Click on the first console configuration in view's tree
> 4.
In context menu select HQL Editor.
Right Click on the first console configuration in view's tree
> 4.
|
|
Hi All,
I have been sifting through pages on Google looking for the answer to no avail, however I think I am just phrasing the question incorrectly.
The scenario is as follows: I have an entity which users are able to either vote for or against. For arguments...
Started by Ross on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Then you can run HQL / Criteria against it like any on the Business entity, but should be creating a view model that represents the business entity with the flag that you are talking....
Database and map the view model to the view.
|
|
Given the following tables:
Resources:
ID int,
Name varchar(100),
Address varchar(500),
City varchar(100),
etc.
ResourceViews:
Id int,
resourceId int,
userId int,
viewDate DateTime
every time a resource is looked at, an entry is added to the ResourceView...
Started by Chris Conway on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Try this:
DetachedCriteria dcriteria = DetachedCriteria.For<ResourceView>("rv") .Add(Restrictions.Eq("userId", 3)) .SetProjection(Projections.GroupProperty("rv.PostID")) .AddOrder(Order.Desc(Projections.Count("rv.Id"))) .SetMaxResults(5); var results... .
|
|
I'm propositioning NHibernate for a project we're doing at my company and I'd like to know if NHibernate can be optimized to only retrieve specific columns on a table when using the Criteria query language.
For example. Let's say I have a table with 3...
Started by MBonig on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Http(Projections.Property("Name")) .Add(Projections.Property("ID")) ) .List<IList>() .Select(l => new use anyway, you can create an SQL....
You wish to use and only those will be included in the select clause of the compiled query.
|
|
On Mon, 10 Sep 2007 22:21:14 -0500 (CDT), "John Mazzitelli (JIRA)" <noreply@atlassian.com> wrote:
NullPointerException in insert-select query
-------------------------------------------
Key: HHH-2833
URL: http...
, 2 posts
Answer Snippets (Read the full thread at omgili):
; )
> ----------
> If I were to pass in the HQL (the INSERT INTO...SELECT) via:
> NullPointerException in insert-select query
> -------------------------------------------
> Components: query-hql
....
|
|
Having installed Hibernate Tools in Eclipse, how can I view the would-be generated SQL query of from the JPA query language? (I'm using Hibernate as my JPA implementation)
My Java DAO class looks something like:
public List<Person> findById(int ...
Started by Steve Kuo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
That's the feature of hibernate runtime, when Tools provide you with HQL editor, so you can test the queries before you put them....
2) Make sure you have the Dynamic SQL Preview view.
And then there is an option to Open in HQL Editor).
|
