On Thu, 7 Dec 2000, Cosmin P wrote:
> I have DB2 ver 7.1 and orion 1.3.8.
>
> Does anyone have an example of a DB2 Database schema?
This is what I cooked up to test DB2. Seems to work ok, except for a
couple of points:
- No JDBC driver for DB2 that I'm aware of supports blobs
(Which is why we decided against it)
- DB2 datatype "double" can not _quite_ store Double.MAX_VALUE,
it falls a few decimals short
<?xml version="1.0"?>
<!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
"http://www.orionserver.com/dtds/database-schemas.dtd">
<database-scheme name="DB2" not-null="not null" null="default null"
primary-key="primary key">
<type-mapping type="java.lang.String" name="varchar(255)" />
<type-mapping type="int" name="integer" />
<type-mapping type="long" name="bigint" />
<type-mapping type="float" name="double" />
<type-mapping type="double" name="double" />
<type-mapping type="byte" name="smallint" />
<type-mapping type="char" name="smallint" />
<type-mapping type="short" name="smallint" />
<type-mapping type="boolean" name="char(1)" />
<type-mapping type="java.util.Date" name="timestamp" />
<type-mapping type="java.io.Serializable" name="blob(1 M)" />
<disallowed-field name="add" />
<disallowed-field name="admin" />
<disallowed-field name="after" />
<disallowed-field name="all" />
<disallowed-field name="alter" />
<disallowed-field name="and" />
<disallowed-field name="any" />
<disallowed-field name="append" />
<disallowed-field name="as" />
<disallowed-field name="asc" />
<disallowed-field name="async" />
<disallowed-field name="authorization" />
<disallowed-field name="before" />
<disallowed-field name="begin" />
<disallowed-field name="between" />
<disallowed-field name="binary" />
<disallowed-field name="bookmark" />
<disallowed-field name="by" />
<disallowed-field name="call" />
<disallowed-field name="cascade" />
<disallowed-field name="cascaded" />
<disallowed-field name="case" />
<disallowed-field name="cast" />
<disallowed-field name="catalog" />
<disallowed-field name="char" />
<disallowed-field name="check" />
<disallowed-field name="close" />
<disallowed-field name="coalesce" />
<disallowed-field name="column" />
<disallowed-field name="commit" />
<disallowed-field name="commitblock" />
<disallowed-field name="committed" />
<disallowed-field name="constraint" />
<disallowed-field name="corresponding" />
<disallowed-field name="create" />
<disallowed-field name="cross" />
<disallowed-field name="current" />
<disallowed-field name="cursor" />
<disallowed-field name="data" />
<disallowed-field name="date" />
<disallowed-field name="dec" />
<disallowed-field name="decimal" />
<disallowed-field name="declare" />
<disallowed-field name="default" />
<disallowed-field name="delete" />
<disallowed-field name="dense" />
<disallowed-field name="desc" />
<disallowed-field name="distinct" />
<disallowed-field name="domain" />
<disallowed-field name="double" />
<disallowed-field name="drop" />
<disallowed-field name="else" />
<disallowed-field name="elseif" />
<disallowed-field name="enable" />
<disallowed-field name="end" />
<disallowed-field name="escape" />
<disallowed-field name="event" />
<disallowed-field name="except" />
<disallowed-field name="exec" />
<disallowed-field name="execute" />
<disallowed-field name="exists" />
<disallowed-field name="explain" />
<disallowed-field name="export" />
<disallowed-field name="external" />
<disallowed-field name="extract" />
<disallowed-field name="fetch" />
<disallowed-field name="fixed" />
<disallowed-field name="float" />
<disallowed-field name="for" />
<disallowed-field name="foreign" />
<disallowed-field name="forever" />
<disallowed-field name="forward" />
<disallowed-field name="from" />
<disallowed-field name="fromfixed" />
<disallowed-field name="full" />
<disallowed-field name="get" />
<disallowed-field name="grant" />
<disallowed-field name="group" />
<disallowed-field name="having" />
<disallowed-field name="hint" />
<disallowed-field name="identified" />
<disallowed-field name="if" />
<disallowed-field name="import" />
<disallowed-field name="in" />
<disallowed-field name="index" />
<disallowed-field name="inner" />
<disallowed-field name="insert" />
<disallowed-field name="int" />
<disallowed-field name="integer" />
<disallowed-field name="internal" />
<disallowed-field name="intersect" />
<disallowed-field name="into" />
<disallowed-field name="is" />
<disallowed-field name="isolation" />
<disallowed-field name="java" />
<disallowed-field name="join" />
<disallowed-field name="key" />
<disallowed-field name="leave" />
<disallowed-field name="left" />
<disallowed-field name="level" />
<disallowed-field name="like" />
<disallowed-field name="local" />
<disallowed-field name="lock" />
<disallowed-field name="long" />
<disallowed-field name="loop" />
<disallowed-field name="mainmemory" />
<disallowed-field name="master" />
<disallowed-field name="merge" />
<disallowed-field name="messsage" />
<disallowed-field name="modify" />
<disallowed-field name="natural" />
<disallowed-field name="new" />
<disallowed-field name="next" />
<disallowed-field name="no" />
<disallowed-field name="not" />
<disallowed-field name="null" />
<disallowed-field name="nullif" />
<disallowed-field name="numeric" />
<disallowed-field name="of" />
<disallowed-field name="old" />
<disallowed-field name="on" />
<disallowed-field name="only" />
<disallowed-field name="optimistic" />
<disallowed-field name="option" />
<disallowed-field name="or" />
<disallowed-field name="order" />
<disallowed-field name="outer" />
<disallowed-field name="pessimistic" />
<disallowed-field name="plan" />
<disallowed-field name="post" />
<disallowed-field name="precision" />
<disallowed-field name="prepare" />
<disallowed-field name="primary" />
<disallowed-field name="privileges" />
<disallowed-field name="procedure" />
<disallowed-field name="propagate" />
<disallowed-field name="public" />
<disallowed-field name="publication" />
<disallowed-field name="read" />
<disallowed-field name="real" />
<disallowed-field name="references" />
<disallowed-field name="referencing" />
<disallowed-field name="register" />
<disallowed-field name="rename" />
<disallowed-field name="repeatable" />
<disallowed-field name="replica" />
<disallowed-field name="reply" />
<disallowed-field name="restart" />
<disallowed-field name="restrict" />
<disallowed-field name="result" />
<disallowed-field name="return" />
<disallowed-field name="returns" />
<disallowed-field name="reverse" />
<disallowed-field name="revoke" />
<disallowed-field name="right" />
<disallowed-field name="role" />
<disallowed-field name="rollback" />
<disallowed-field name="rowid" />
<disallowed-field name="rownum" />
<disallowed-field name="rowspermessage" />
<disallowed-field name="rowver" />
<disallowed-field name="savepoint" />
<disallowed-field name="scan" />
<disallowed-field name="schema" />
<disallowed-field name="select" />
<disallowed-field name="sequence" />
<disallowed-field name="serializable" />
<disallowed-field name="set" />
<disallowed-field name="smallint" />
<disallowed-field name="some" />
<disallowed-field name="sort" />
<disallowed-field name="sql" />
<disallowed-field name="sqlerror" />
<disallowed-field name="start" />
<disallowed-field name="subscribe" />
<disallowed-field name="subscription" />
<disallowed-field name="sync_config" />
<disallowed-field name="table" />
<disallowed-field name="then" />
<disallowed-field name="time" />
<disallowed-field name="timeout" />
<disallowed-field name="tinyint" />
<disallowed-field name="to" />
<disallowed-field name="transaction" />
<disallowed-field name="transactions" />
<disallowed-field name="trigger" />
<disallowed-field name="union" />
<disallowed-field name="unique" />
<disallowed-field name="unregister" />
<disallowed-field name="user" />
<disallowed-field name="using" />
<disallowed-field name="value" />
<disallowed-field name="values" />
<disallowed-field name="varbinary" />
<disallowed-field name="varchar" />
<disallowed-field name="varwchar" />
<disallowed-field name="view" />
<disallowed-field name="wait" />
<disallowed-field name="wchar" />
<disallowed-field name="when" />
<disallowed-field name="where" />
<disallowed-field name="while" />
<disallowed-field name="with" />
<disallowed-field name="work" />
<disallowed-field name="write" />
<disallowed-field name="wchar" />
<disallowed-field name="wvarchar" />
</database-scheme>
