Re: [OFBiz] Users - MySQL / DatabaseUtil.java incompatability

Posted by Andrew Sykes on Aug 30, 2005; 11:11am
URL: http://ofbiz.116.s1.nabble.com/OFBiz-Users-Problem-starting-or-reseeding-ofbiz-java-net-BindException-Address-already-in-use-tp135695p135700.html

David,

ALTER TABLE <table_name> RENAME <old_col_name> to <new_column_name>
Is not valid

I hacked this to...
ALTER TABLE <table_name> CHANGE <old_col_name> <new_column_name>
<column_description>;

Which now works, but how compatible this would be with other DBs I have
no idea.

On a cursory glance I think there were others too but I'll have to get
back to you on those ones...
--
Andrew Sykes <[hidden email]>
Sykes Development Ltd

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users