Status: New
Owner: ----
Labels: Type-Defect Priority-Medium Component-SLEE SubComponent-SLEE-Core
Version-2.4.2 Release-Type-FINAL SLEE-2.4.2.FINAL
New issue 2714 by [email protected]: Profiles are not working with
Mysql Database
http://code.google.com/p/mobicents/issues/detail?id=2714
Version tested:
2.4.1-Final
Bug Description:
Try to change default ( HSQL ) db to MySql.
Since by default column field is set to 255 Hibernian creates fields as
tinyblob , for most serializable objects it will not be enough.
There are 3 occurences for that
1) ProfileSpecificationId field , which overcomes 255 chars when serialized
2) serializable field inside subtable ( tables that are created for array's
)
3) Complicated fields.
This issue can be resolved in several ways :
1) Set Lob annotation - this is not too good solution since in this case it
defines longblob which is 4MB in length.
2) Change the default length for problematic fields.
I have modified code and changed it to 300.This way it sets the field type
to blob.This is optimal solution possible.
Attachments:
ConcreteProfileEntityGenerator.java 21.9 KB
JPAProfileTable.java 4.3 KB
