org.jooq.exception.DataAccessException: SQL [select `admin_kpi`.`client_master`.`client_id`, `admin_kpi`.`client_master`.`first_name`, `admin_kpi`.`client_master`.`last_name`, `admin_kpi`.`client_master`.`company`, `admin_kpi`.`client_master`.`address1`, `admin_kpi`.`client_master`.`address2`, `admin_kpi`.`client_master`.`city`, `admin_kpi`.`client_master`.`state`, `admin_kpi`.`client_master`.`country`, `admin_kpi`.`client_master`.`zipcode`, `admin_kpi`.`client_master`.`phone_number`, `admin_kpi`.`client_master`.`group_member`, `admin_kpi`.`client_master`.`user_name`, `admin_kpi`.`client_master`.`email`, `admin_kpi`.`client_master`.`password`, `admin_kpi`.`client_master`.`accountno`, `admin_kpi`.`client_master`.`security_que`, `admin_kpi`.`client_master`.`security_ans`, `admin_kpi`.`client_master`.`payment`, `admin_kpi`.`client_master`.`store`, `admin_kpi`.`client_master`.`inventory`, `admin_kpi`.`client_master`.`activation_code`, `admin_kpi`.`client_master`.`ip_address`, `admin_kpi`.`client_master`.`status`, `admin_kpi`.`client_master`.`register_date`, `admin_kpi`.`client_master`.`enable_desable`, `admin_kpi`.`client_master`.`is_delete`, `admin_kpi`.`client_master`.`data_base`, `admin_kpi`.`client_master`.`secret_id`, `admin_kpi`.`client_master`.`licence_id`, `admin_kpi`.`client_master`.`tokon_no`, `admin_kpi`.`client_master`.`exp_date`, `admin_kpi`.`client_master`.`c_token`, `admin_kpi`.`client_master`.`sub_type`, `admin_kpi`.`client_master`.`pac_exp_date`, `admin_kpi`.`client_master`.`pac_amount`, `admin_kpi`.`client_master`.`act_store`, `admin_kpi`.`client_master`.`def_store`, `admin_kpi`.`client_master`.`is_full_sync`, `admin_kpi`.`client_master`.`eng_flag`, `admin_kpi`.`client_master`.`upg_flag` from `admin_kpi`.`client_master`]; Value '1MrPinnacleMRc-4 yashonandan parkamericaVadodara5390016  1323131232mrmr@demo.comxxxxxx
ASASD2FDFDWhat is your name?   xxxxxxxxx0PinnacleA3Z2UiBLQsCgSDh
xxx.xx.xx.xxxactive2013-11-28 14:52:48enableyadmin_pinnacle_mr123456789123122
2014-12-30
0000-00-00310' can not be represented as java.sql.Date
at org.jooq.impl.Tools.translate(Tools.java:1941)

CREATE TABLE `client_master` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `zipcode` varchar(50) NOT NULL,
  `phone_number` varchar(50) NOT NULL,
  `group_member` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `accountno` varchar(255) NOT NULL,
  `security_que` varchar(255) NOT NULL,
  `security_ans` varchar(255) NOT NULL,
  `payment` varchar(255) NOT NULL,
  `store` text,
  `inventory` enum('xx','xx') NOT NULL DEFAULT 'xx',
  `activation_code` varchar(255) NOT NULL,
  `ip_address` text NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `register_date` datetime NOT NULL,
  `enable_desable` enum('enable','desable') NOT NULL,
  `is_delete` varchar(50) NOT NULL,
  `data_base` varchar(255) NOT NULL,
  `secret_id` varchar(255) NOT NULL,
  `licence_id` varchar(255) NOT NULL,
  `tokon_no` varchar(255) NOT NULL,
  `exp_date` date NOT NULL,
  `c_token` varchar(255) NOT NULL,
  `sub_type` varchar(20) NOT NULL,
  `pac_exp_date` date NOT NULL,
  `pac_amount` varchar(20) NOT NULL,
  `act_store` varchar(255) NOT NULL,
  `def_store` varchar(255) NOT NULL,
  `is_full_sync` enum('0','1','2','3') NOT NULL DEFAULT '0',
  `eng_flag` enum('0','1') NOT NULL DEFAULT '0',
  `upg_flag` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=418 DEFAULT CHARSET=latin1;

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-3.8.0.xsd">
  <!-- Configure the database connection here -->
  <jdbc>
    <driver>com.mysql.jdbc.Driver</driver>
    <url>jdbc:mysql://xx.xx.xx.xx:3306/admin_kpi</url>
    <user>xx</user>
    <password>xx</password>
  </jdbc>

  <generator>
    <name>org.jooq.util.JavaGenerator</name>

    <database>
      <name>org.jooq.util.mysql.MySQLDatabase</name>
      <inputSchema>admin_kpi</inputSchema>
      <includes>.*</includes>
      <excludes></excludes>
    </database>

    <target>
      <packageName>xxxxx</packageName>
      <directory>xxx</directory>
    </target>
  </generator>
</configuration>