The table has a primary key, so that's not the problem. I've recreated the MySqlDataSource object multiple times with the same results.
Suggestions?
Code: Select all
-- Table: test_tbl
-- DROP TABLE IF EXISTS `test_tbl`;
CREATE TABLE `test_tbl` (
`script_id` int AUTO_INCREMENT NOT NULL,
`my_id` varchar(8),
`name` varchar(20),
`task_order` int(10) UNSIGNED ZEROFILL NOT NULL DEFAULT '0000000000',
`sql` text,
/* Keys */
PRIMARY KEY (`script_id`)
) ENGINE = MyISAM;