the default PostgreSQL data-schema/postgresql.xml
is wrong.  try this one:

<?xml version="1.0"?>
<!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
"http://www.orionserver.com/dtds/database-schemas.dtd">

<database-scheme name="PostGreSQL" max-table-name-length="25" not-null="not
null" null="" primary-key="primary key">
    
    <type-mapping type="java.lang.String" name="varchar" />
    <type-mapping type="java.lang.Integer" name="int8" />
    <type-mapping type="int" name="int4" />
    <type-mapping type="long" name="int8" />
    <type-mapping type="float" name="float4" />
    <type-mapping type="double" name="float8" />
    <type-mapping type="byte" name="int2" />
    <type-mapping type="char" name="char" />
    <type-mapping type="short" name="int2" />
    <type-mapping type="boolean" name="bool" />
    <type-mapping type="java.util.Date" name="date" />
    <type-mapping type="java.io.Serializable" name="oid" />
    <type-mapping type="java.math.BigDecimal" name="decimal" />

    <disallowed-field name="parent" />
    <disallowed-field name="password" />
    <disallowed-field name="username" />
    <disallowed-field name="date" />
    <disallowed-field name="order" />
    <disallowed-field name="old" />
    <disallowed-field name="user" />

</database-scheme>

-tim

> -----Original Message-----
> From: Guilherme Ceschiatti [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 15, 2000 1:15 AM
> To: Orion-Interest
> Subject: ATM example with PostgreSQL
> 
> 
> Hi!
> 
> Has anyone tried the ATM example with postgresql ? Any CMP 
> bean that I try to
> deploy can't create the tables correctly.
> 
> []s
> Guiga
> 
> 

Reply via email to