Seung,
Here is my data-sources.xml and postgres.xml. I'm using postgres 7.0
and the 7.0.2 jdbc driver with great success.
-tim
<?xml version="1.0"?>
<!DOCTYPE data-sources PUBLIC "Orion data-sources"
"http://www.orionserver.com/dtds/data-sources.dtd">
<data-sources>
<!--
An example DataSource that uses an ordinary JDBC-driver to
create the connections,
to install; set the proper URL to the db, specify the db-
driver name and
unrem the below section. This creates all the needed kinds
of data-sources, transactional, pooled and EJB-aware
sources.
-->
<data-source
name="Default data-source"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
schema="database-schemas/postgresql.xml"
url="jdbc:postgresql://localhost/ejb"
connection-driver="org.postgresql.Driver"
username="ejb"
password="password"
/>
</data-sources>
<?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="timestamp" />
<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>
> -----Original Message-----
> From: Seung Bang [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 01, 2000 1:10 PM
> To: Orion-Interest
> Subject: Re: Orion w/ postgresql
>
>
> Mike & Guilherme:
>
> Thanks very much for your tips.
> I tried as you guys instructed, and the same errors were produced.
> My postgresql jdbc driver is now the brand new 7.0.2 driver, and
> the '/usr/local/orion/config/database-schemas/postgresql.xml' file
> has null="" section in place of null="null". And of course I tried
> null="null" back in. All the trials yielded the same problem.
> Please.... Anybody? Any clue???
> Thanks very very much...
>
>
> Seung,
>
>
>
>
