I have just attached an existing external SQL Server database but the Integrity checker says one of the field names is too long for AwareIM and of course I cant edit it.
Anybody hit this problem and found a work around?
Feild name in external database too long
Hi,
I don't know if this helps but the maximum field name size in MySQL is 64 characters. I think that the maximum field name length in Derby may be 30 characters so perhaps that is what is causing your issue.
I found a link from google with the heading "Get rid of the Max lenght of 18 for constraint names" which points to http://osdir.com/ml/apache.db.derby.dev ... 00606.html
Hope that might help a little bit anyway (assuming that the restriction is coming from the underlying database and not AwareIM itself).
Cheers,
Pete
I don't know if this helps but the maximum field name size in MySQL is 64 characters. I think that the maximum field name length in Derby may be 30 characters so perhaps that is what is causing your issue.
I found a link from google with the heading "Get rid of the Max lenght of 18 for constraint names" which points to http://osdir.com/ml/apache.db.derby.dev ... 00606.html
Hope that might help a little bit anyway (assuming that the restriction is coming from the underlying database and not AwareIM itself).
Cheers,
Pete
I am wondering if they set the max length to the lowest common denominator which is 30 with Derby. If so, did they hard code this into the code (unlikely) or set is as a value in some config file or xml file? If you could find that setting, you could likely change it to a higher number as long as you weren't using Derby. Where did you find this info Tom?
Pete
Pete
Hi Tom,
I assume that you are running Derby locally? I am running MySQL locally and it seems to accept attribute name lengths of any length for me. It is a bit of work to convert from Derby to MySQL so jclark, you might want to have Support confirm that this will fix your problem before going to the trouble of converting.
Pete
I assume that you are running Derby locally? I am running MySQL locally and it seems to accept attribute name lengths of any length for me. It is a bit of work to convert from Derby to MySQL so jclark, you might want to have Support confirm that this will fix your problem before going to the trouble of converting.
Pete
Hey Thanks Guys that at least gives me something to go on.
I am interested in using AwareIM on a system that a client has been struggling with limitations and long development times for thier intranet and legacy apps. If I can connect to their databases and show some examples of how AwareIM will help we might have a new customer
It would be interesting to get Supports perspective on this.
I am interested in using AwareIM on a system that a client has been struggling with limitations and long development times for thier intranet and legacy apps. If I can connect to their databases and show some examples of how AwareIM will help we might have a new customer
It would be interesting to get Supports perspective on this.
/John