ptyagi108 / mesh4x

Automatically exported from code.google.com/p/mesh4x
0 stars 0 forks source link

Add support of protecting hibernate adapter creation with long table name #129

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1.Create source hibernate(mysql or access) adapter with long table name
length( max 64 character long)
2.Create target hibernate(mysql or access) adapter with long table name
length( max 64 character long)
3.sync

SQLException... table name not valid or tool long

Observation
Every database has max table name length(which is 64), but it is vendor
specific.During Sync process when sync engine try to create sync table
(followed by mesh4j sync table name pattern ,tablename + _sync) , sync
table name length goes more than 64 character.

Actions we should consider:
1.Get the vendor specific table name length(this can be found from
DatabaseMetaData )
2.Entity name or type name(table name)length <= (max table name length-sync
extension length)

Original issue reported on code.google.com by saiful.raju on 14 Sep 2009 at 9:30