dialect « SQL « JPA Q&A

1. Custom SQL function for NHibernate dialect stackoverflow.com

I want to be able to call a custom function called "recent_date" as part of my HQL. Like this: [Date] >= recent_date() I created a new dialect, inheriting from MsSql2000Dialect and specified ...

2. Hibernate 3.6: registerFunction in SQL dialect not working stackoverflow.com

I´m giving up and ask the community ... In my project, I´m using Hibernate 3.6.4.Final and a custom sql dialect:

public class ServiceAppMySQL5InnoDBDialect extends MySQL5InnoDBDialect {

    public ServiceAppMySQL5InnoDBDialect() {
  ...

3. Configuring Hibernate to run multiple SQL Dialects forum.hibernate.org

Hello hibernate community. I'm working currently on a Oracle to SQL Server Migration of a Java application that uses Hibernate for a very large number of queries. I am not a professional DBA by any means, specifically an engineering intern. So with that in mind, any additional resources I could read that you know of would be very helpful. Because there ...

4. Pervasive SQL Dialect forum.hibernate.org

I have two questions which are related... I am somewhat new to Hibernate, having only been using it for about three months now, and have been learning everything by trial and error with no one I "know" who I can ask a question to. I work for Ashley furniture as a custom software developer, I am the only person on the ...

5. Dialects and sql optimization infos forum.hibernate.org

Hello all Is there any way to specify to hibernate to add some extras in generated sql, in order to specify optimization information to the underlying rdbms ? Specifically, I use informix db with large amount of data in multiple tables (tens of millions rows), so specifying a well-tuned execution-plan to the db is a must-have. As informix is unable to ...

6. Custom SQL Dialect forum.hibernate.org

I'm writing an application using a FirstSQL database. Thus far everything has worked pretty well out-of-the-box, even though FirstSQL isn't listed as a supported DB. I'm simply using the DefaultDialect. I've progressed to a point now where I'm considering the potential advantages/difficulties of writing a custom FirstSqlDialect. Could someone explain to me whether this is feasible and how it might be ...

7. Switching sql dialects programmatically forum.hibernate.org

Is there a way of setting the hibernate sql dialect at run time rather than in a properties file. If I have an application that can run on MySQL, Oracle or DB2 I want to be able to flick between databse types via, for example, a JVM parameter rather than having to change a hibernate proeprties file that may be embedded ...