Registering a SQL function with JPA/Hibernate

I would like to know what's the best way to register a custom SQL function with JPA/Hibernate.

Do I have to go through extending the MysqlInnodb dialect or is there a better way?

Can anyone please provide code samples and pointers to relevant documentation?


Yes extending the dialect is a good way of registering custom SQL function.

Add something like this in your Dialect classes constructor.

registerFunction("current_timestamp", new NoArgSQLFunction(Hibernate.TIMESTAMP) );
registerFunction("date", new StandardSQLFunction(Hibernate.DATE) );

Look at the source code of one of the existing dialect classes.

Need Your Help

how to start, developing swing based application with few panels with next buttons for each

java swing jpanel jbutton next

I'm new to java.I'm creating a swing based UI. I've created 2 frames, each one in separate .java file inside same package.

Alarm doesn't trigger the AlarmReveicer


I am coding a simple alarm test in android, but as mentionned in the title the AlarmReceiver isn't triggered !

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.