OJB MySQL 配置

1. repository-database.xml
<jdbc-connection-descriptor
     jcd-alias="defaultO"
     default-connection="true"
       platform="MySQL"
        jdbc-level="2.0"
        driver="org.gjt.mm.mysql.Driver"
        protocol="jdbc"
        subprotocol="mysql"
     dbalias="//localhost:3306/mydb"
       username="root"
        password=""
     eager-release="false"
        batch-mode="true"
     useAutoCommit="1"
     ignoreAutoCommitExceptions="false">

     <connection-pool maxActive="21" validationQuery="" />

     <sequence-manager
          className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
         <attribute attribute-name="grabSize" attribute-value="20"/>
         <attribute attribute-name="autoNaming" attribute-value="true"/>
         <attribute attribute-name="globalSequenceId" attribute-value="false"/>
         <attribute attribute-name="globalSequenceStart" attribute-value="10000"/>
     </sequence-manager>

</jdbc-connection-descriptor>

2. 创建sequence表

CREATE TABLE OJB_HL_SEQ
(
      TABLENAME varchar (175) NOT NULL,
      FIELDNAME varchar (70) NOT NULL,
      MAX_KEY integer,
      GRAB_SIZE integer,
      VERSION integer,
      PRIMARY KEY (TABLENAME,FIELDNAME)
);