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表
[pre]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)
);[/pre]
|
