|
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
--------------------------------------------------------------------
...
Started by Dima Geraskov on
, 8 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
In context menu select HQL Editor
=> console....
In context menu select HQL Editor on the first console configuration in view's tree
4.
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... .
|
Ask your Facebook Friends
|
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 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...
Answer Snippets (Read the full thread at omgili):
Support for database operations:
> - Generate Select (SQL, HQL) statement (for table), DDL
(was: LATER)
> Database view/edit support
> --------------------------
>
> and HQL) - so....
|
|
I thinking of doing this architecture
genericdao +interface ---> servicelayer+interface---> view layer
my dao will only have generic methods, my service layers will have real logic for instance
service layer method string executeThis= "select c ...
Started by cometta on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Wrong the implementation, such as db specific....
The whole point of the persistence interface is to abstract SQL away from clients, yet you've let SELECT leak into your service layer.
I'm not crazy about your service code.
As part of the view.
|
|
In my MSSQL server I have a SQL view called AllFavourite. In order to load the data into my DTO class I have the following in my hbm.xml file...
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace...
Started by Rippo on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Don't you need this?
<query-param name='UserId' type='Integer'/>
The query tag expects a HQL;![CDATA[ SELECT {foo.ID} as {foo.ID}, {foo}.NAME AS {foo.Name} FROM sometable WHERE {foo}.ID = :UserId.
|
|
Where should an JDBC-compliant application store its SQL statements and why?
So far, I managed to identify these options:
Hardcoded in business objects Embedded in SQLJ clauses Encapsulate in separate classes e.g. Data Access Objects Metadata driven (...
Started by Adrian on
, 16 posts
by 16 people.
Answer Snippets (Read the full thread at stackoverflow):
The only question you ask that has.
Reasons, all projection logic should be contained within the view.
|
|
Having fallen behind in the world of ORM and modern data access, I'm looking to move away from DataSets ( shudder ) and into a proper mapping framework.
I've just about got my head around Linq to SQL, an I'm now looking into NHibernate with the view to...
Started by Andrew Bullock on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
Also it can do a search by example, where to your example whether you use HQL or the ICriteria but it will actually do you one better the translated query would like something like ....
A Sql like syntax called HQL, which is SQL on objects.
|
|
For our new product re-engineering, we are in the process of selecting the best framework from Java. As the consideration is to go for database agnostic approach for model, we are working on options between Struts + Spring with iBATIS or Hibernate. Please...
Started by Venu KS on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
HQL (Hibernate Query Language) is another language you'll have to learn and even then you'll.
If however you view is more database-centric.
Works better if your view is more object-centric .
|