ORMUtil : formatSqlDate is hardcoded for Oracle database

[Olivier Chapiteau]

The OrmUtil offer a service to format a date on database : formatSqlDate().
The problem is that ORMUtil is hardcoded to work on an Oracle database, causing a call to an Oracle only sql date format method :

 private static int dbType = SQLUtil.DB_TYPE_ORACLE;

Can we change this harcoded setting to DB_TYPE_MYSQL ?

[Jiri Dvorak (jiri-dvorak)]

Yes, absolutely, the variable OrmUtil.dbType is static (application-wide) but modifiable (it is *NOT* coded as "static final"); the value DB_TYPE_ORACLE is only as the default. Any application using the ORM toolkit can set it to a database type actually used (currently limited to just Oracle and MySQL).

The standard way to do that is, at application start-up, call the method OrmUtil.setDbType. For example, see the following code snipped in FluID, method BusinessObjectDispatcher.init(), which is called when the Web application is starting up in Tomcat:

 private static synchronized void init() {
  OrmUtil.setDbType(SQLUtil.DB_TYPE_MYSQL);
  initializedFlag = true;
  CommonDTO.setSkipEmptyXmlTagsFlag(true);
  // SessionContext.setReleaseJdbcConnectionEarly(true);
 }