Dialect « Query « JPA Q&A

1. Configure Hibernate to escape underscores in LIKE clause using SQL Server dialect stackoverflow.com

I have a SQL SELECT query which has a LIKE clause containing an underscore, which should specifically look for an underscore, not treat it as a wildcard:

SELECT * FROM my_table ...

2. Using different projection functions in Hibernate criteria API based in Dialect stackoverflow.com

I want to use a standard deviation projection in a query that Im constructing using the criteria API. I can do something simply like this

public class StdDevProjection extends AggregateProjection {

  ...

3. Unable to find dialect of hibernate in resteasy application stackoverflow.com

I have a hibernate project which interacts with Oracle 10g database, and have a seperate dynamic web project in which we have defined rest web services.. Now when we ...

4. sql query in Hibernate stackoverflow.com

I'm carrying out a SQL query which looks like:

SELECT thi.*
FROM track_history_items thi
JOIN artists art
  ON thi.artist_id = art.id
WHERE thi.type = TrackBroadcast
Group By art.name
ORDER thi.created_at DESC

this works fine when I run ...

5. Problem with GROUP BY in hibernate with PostgreSql dialect stackoverflow.com

Helllo I have this HQL query, that works fine using MySQL dialect, however it doesn't work using PostgreSQL dialect - it just reports "must appear in the GROUP BY clause or ...

6. selecting a dialect before build a sessionfactory forum.hibernate.org

Hi, my company's application is in the progress of supporting a second database alongside our current one. This means we will be supporting 2 different dialects, the old one, Postgres8 and the new one Oracle10g. My question is if it's possible to alter Hibernate's dialect depending on a server setting. The problem I face is that we have to set our ...

7. Dialect QED devel - exception in Session.createQuery forum.hibernate.org

Author Message jfranks Post subject: Dialect QED devel - exception in Session.createQuery Posted: Tue Jan 13, 2004 3:21 pm Newbie Joined: Fri Jan 02, 2004 12:48 pm Posts: 5 Hi, I'm implementing a new dialect for QED (http:www.quadcap.com) in Hibernate 2.1. Running 'ant eg' and getting a run-time exception for Session.createQuery, which is used in 'viewAllAuctionsSlow' and 'viewAllAuctionsFast' methods ...

8. Oracle dialect n queries specific to Oracle viz STARTS WITH forum.hibernate.org

9. how to find out dialect? forum.hibernate.org

I need to be able to deploy my application on multiple platforms with varying database products. I'm using long text fields (over 4k), which means (I guess) that I must use different set of commands for fetching data when using Oracle compared to, say, MySQL. We are not living in a perfect world and I can l live with that - ...

10. Question/proposal auto sql-query choose based on dialect forum.hibernate.org

Is it possible to have a named native sql auto selected via the current dialet setting for the session/sessionFactory. i.e. in programming code we can refer to just "q1". and automatically be given the correct query based on the current dialet. ... ... thanks, Matthew Payne

11. Selecting the correct dialect for mySql database forum.hibernate.org

Hibernate version: 2.1.6 Name and version of the database you are using: MySql 4.0.17 I've just discovered the really useful features: setMaxResults() & setFirstResult() in hibernate, but i've ran into a problem! When I call list() on a Query with maxResults set I get the following error: java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax. ...

12. select distinct limit query in DB2 (bug in DB2 dialect) forum.hibernate.org

public String getLimitString(String sql, boolean hasOffset) { StringBuffer pagingSelect = new StringBuffer(sql.length() + 100).append( "select * from(select temp_.*, rownumber()over(order by 1)as row_ from(") .append(sql) ...

13. possible bug in order by for net.sf.hibernate.dialect.SQLSer forum.hibernate.org

The following query returns an error because the order by and group by fields do not use the aliais. The hsql is below: Is there some other way I need to do this? select hp.DisputedHolding.Account.Id, hp.DisputedHolding.Account.Name, count(*) from HoldingParam hp group by hp.DisputedHolding.Account.Id, hp.DisputedHolding.Account.Name order by hp.DisputedHolding.Account.Name Hibernate version: 2.1.7 Mapping documents:

14. Problem with ilike query and postgres dialect forum.hibernate.org

Hi all, i am focusing an error, when trying to use ilike operator in a hql query. I get everytime the message: unexpected token: ilike When using only like it works without any Problem. Unfortunatly Postgres is using ilike as case sensitive, so I need to use ilike. Is this a bug in the WhereParser ? I was not able to ...

15. Database dialect specific named HQL or SQL queries forum.hibernate.org

Hibernate version: 3.0 I'm looking for a way to override selected named queries depending on the database dialect used. I see that this is supported via dialect-scope for database objects. Is there an easy way to either include mapping resources depending on the dialect if it is not possible to scope them by dialect within the resource files? (We are using ...

16. Informix dialect and limited select forum.hibernate.org

Hi all! I used setFirstResult and setMaxResults with informix but Hibernate generate query "select first ... from" and when the results are retrieved it iterates them and returns as list only the records from the first to maxresult size. That is working well but i think that i`ll be more fast when the query is generated like "select skip :first first ...

17. Select for update in SQL Server dialect? forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp [b]version 2.1.7:[/b] I would like to have two implementations of TableHiLoGenerator running in my application. Both id generators access the same SQL Server database, which contains the hibernate_unique_key table. Obviously I don't want both implementations grabbing the same seed value from the hibernate_unique_key table to prevent primary key collisions, so I ...

18. Named queries specific to a dialect forum.hibernate.org

19. dialect-scope with named native SQL queries? forum.hibernate.org

I was wondering if it's possible to associate a dialect scope for named native sql queries in the mappings xml file. I'm looking for the dialect-scope functionality that the element provides, but inside the element. For example: Code: select nextval('mysequence') as value ...

20. Can I select the dialect per Datasource? forum.hibernate.org

Hello all! Environment: JBoss 4.2 / EJB3 I want to make my application compatible to several databases. One EAR, different possible datasources. For some reason (which is not topic of this post), when using Oracle as database, I have to supply my own dialect. I can put a hibernate.dialect property into my persistence.xml, but persistence.xml is inside EAR, so changing datasource ...

21. db2 dialect paging sorting subquery forum.hibernate.org

Hi, I'm currently facing problem with db2 dialect. I'm trying to order by subquery with paging activated as well. Example: select a.id , (select count( aig ) from AgentInGroup aig where aig.agentGroup =a ) as agentAlias from Agent a order by col_1_0_ which generates sql: select * from ( select rownumber() over( order by col_1_0_) as rownumber_, agent0_.SLA_ID as col_0_0_, (select ...

22. using differnet SQL queries for different dialects forum.hibernate.org

Hi all, I have a need for using unions in native SQL, hence for different dialects I need to use different sql queries (because of some differences in keywords etc). So I need to be able to get the Configuration object, and from that, the Dialect in use, so I can decide which SQL query to use. Can anyone help me ...