Quick Copy paste Code Snippets

When using hibernate maven plugin to generate your tables you may have noticed hibernate generates obfuscated foreign key constraint names which are unreadable. In order to change the constraint names you can apply the @ForeignKey annotation to give your foreign keys more meaningful names as shown below. Take note if you take this approach you will need to take by insuring no duplicate constraint names are created. import @org.hibernate.annotations.ForeignKey;   @ForeignKey( name = "FK_PI_COMPANY_ID" ) @ManyToOne(targetEntity = Company.class, fetch = FetchType.EAGER) @JoinColumn(name = "COMPANY_ID", nullable = true) private Company company;

The following code snippet shows you how to convert GUID to a varchar SELECT SYS.STANDARD.TO_CHAR(SYS_GUID()) FROM DUAL

The following code snippet shows you how to download content i.e PDF and Excel files from Server. Since its a JSP page the output stream has been cleared so binary content will not be corrupted. Code can be converted to a servlet if required To change to other content formats for download just change setContentType e.g response.setContentType("image/png");