Re: run mysqldump output via JDBC
Posted by:
John Dunn
Date: August 09, 2017 04:21AM
Trial and error has shown it seems to hang on the INSERT statement:
USE `MYDB`;
--
-- Table structure for table `MYTABLE`
--
DROP TABLE `MYTABLE`;
CREATE TABLE `MYTABLE` (
`ADF_SPLIT_TYPE` varchar(10) NOT NULL,
`SEQUENCE` decimal(6,0) DEFAULT NULL,
`PARAMETER_NAME` varchar(20) NOT NULL,
`PARAMETER_DESCRIPTION` varchar(50) DEFAULT NULL,
`REQUIRED` varchar(1) DEFAULT NULL,
`MUST_BE_UNIQUE` varchar(1) DEFAULT NULL,
`VALID_CHARACTERS` varchar(200) DEFAULT NULL,
`CONVERT_TO_UPPERCASE` varchar(1) DEFAULT NULL,
`MAX_LENGTH` decimal(6,0) DEFAULT NULL,
`DEFAULT_VALUE` varchar(200) DEFAULT NULL,
`CHANGEABLE` varchar(1) DEFAULT NULL,
`LIST` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ADF_SPLIT_TYPE`,`PARAMETER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `MYTABLE` WRITE;
INSERT INTO `MYTABLE` VALUES ('ADF',2,'CODE_SPLIT','Document Code Split','N','N','ABCDEFGHIJKLMNOPQRSTUVWXYZ','Y',99,' ','Y',''),('ADF',1,'ENVELOPE_SPLIT','Pages In Envelope Split','N','N','0123456789','Y',2,'4','Y',''),('ADF',3,'INSERT_SPLIT','Marketing Insert Split','N','N','0123456789','Y',1,'0','Y',''),('ADF',4,'PAGE_SPLIT','Pages In Printed File Split','N','N','0123456789','Y',6,'5000','Y','');
UNLOCK TABLES;