[hibernate-issues] [Hibernate-JIRA] Updated: (HBX-911) Get Default Values From DB

Get Default Values From DB --------------------------- Key: HBX-911 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-911 Project: Hibernate Tools Type: Patch

Components: reverse-engineer Versions: 3.2beta9 Environment: I worked on this patch from the TOOLS_3_2_0_BETA9 branch in SVN. I didn't actually compile the whole of hibernate-tools, I just compiled the classes I wanted to change and got the rest of the binaries from the .jar in the maven repository. If necessary I could provide a maven project that compiles the whole thing into a jar. Reporter: Sorin Silaghi Attachments: default-values.clean.patch, default-values.patch I needed this for the project I am working on. The "client" requested this "feature"... that's for motivation. I don't think it's a great idea but it's useful. First of all sorry for not being able to provide test cases.. I didn't had the time so I used the project I'm working on for tests. This is how it works: I modified JDBCReader and JDBCMetaDataDialect so that the default value is retrieved from the DB. In JDBCBinder in the bindMeta the default value is added as a meta tag. To give user control over the process I added a couple of methods to the reveng strategy interface: public boolean useDefaultValueOnHibernateType(String hibernateType); - this will return true for the hibernateTypes that should have a default value(if available). public String convertDefaultValueForColumn(TableIdentifier table, String columnName, String sqlTypeName, String hibernateTypeName, boolean isForeignKey, String value); - and this one is used to convert the data to a form better suited for the persistence classes I also modified the BasicPOJOClass class so that if the default value saved in the hbm is "" the initialization in the entity class will be the default constructor, for example: "new Date();". Below is an example of how to implement a custom convertDefaultValueForColumn. Part of this could be moved to the default reveng strategy. We decided to threat fields that are foreign keys by creating an empty object with the id specified in the database and dealing with the retrieval of the rest of the data in the service layer. It actually looks better than it sounds in our case. public String convertDefaultValueForColumn(TableIdentifier table, String columnName, String sqlTypeName, String hibernateTypeName, boolean isForeignKey, String value) { if (isForeignKey){ if (hibernateTypeName.contains("org.kobit.ofam.service.model")){ String id; try{ id = Long.valueOf(value).toString() + "L"; }catch(Exception e){ return null; } return "new " + hibernateTypeName.substring(hibernateTypeName.lastIndexOf(".") + 1)+"("+ id +")"; } } Class hibernateTypeClass = null; try { hibernateTypeClass = Class.forName(hibernateTypeName); } catch (ClassNotFoundException e){ log.error("type not found: " + hibernateTypeName); } try{ if (hibernateTypeClass!=null){ if (hibernateTypeClass.equals(String.class)){ value = "\"" + value.substring(1,value.length()-1) + "\""; return value; } if (hibernateTypeClass.equals(Long.class)) return Long.valueOf(value).toString() + "L"; if (hibernateTypeClass.equals(Double.class)) return Double.valueOf(value) + "D"; if (hibernateTypeClass.equals(Boolean.class)) return (Boolean.valueOf(Long.valueOf(value).longValue() > 0L)).toString(); if (hibernateTypeClass.equals(Date.class)) { DateFormat df = DateFormat.getInstance(); return df.format(df.parse(value)); } } }catch(Exception e){ log.error("error converting type " + hibernateTypeName + " :" + e.getMessage() + " for value " + value); return ""; } return ""; }