Unable to bind elements of jtable in netbeans with MySql database table
843806Feb 24 2009 — edited Feb 24 2009I am using netbeans IDE 6.5 an developing basic desktop application in swing. My problem is that whenever i try to bind jTable's elements with table in MySql database by rigth clicking on jtable and selecting bind>elements>Import data from>database connection>......................jtable doesn't get all columns if table in database has more than 9 columns. If columns are less than/ equal to 9 then all columns are fetched, but then also one column's name is fetched as 'a' instead of 'HeaderNo'.
I've tried everything from committing changes in MySql and then reconnecting, creating fresh new tables with different names and columns,restarting netbeans but in vain. I don't think there is some any restriction about binding elements of jtable with database table because at one instance it fetched 10 columns; so there must be some another problem. My table has 22 columns, though i don't intend to show all of them in jtable yet it's required that it should show more than 10. So If any of guys have dealt with similar problem, help me out here; If not, give it a try. i'll really appreciate your help.