I use the latest postgresql jdbc driver that came
with 7.0.2 and this postgresql.xml database config
file and everything works fine for me.
-tim
<?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: Randahl Fink Isaksen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 11:21 AM
> To: Orion-Interest
> Subject: RE: Is combining Orion and PostgreSQL a good choice
>
>
> Interesting... but are you stating that without fixing bugs
> in the JDBC
> driver for PostgreSQL, it just will not work? If so, I would
> of course like
> to hear what you fixed exactly...
>
> Yours
>
> Randahl
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mike
> Cannon-Brookes
> Sent: 17. januar 2001 13:51
> To: Orion-Interest
> Subject: RE: Is combining Orion and PostgreSQL a good choice
>
>
> I'm using PostgreSQL on an application that is about to go
> live (within the
> next month). Seems to be working fine in testing so far,
> we're moving off
> Sybase 11.0.3.3 on Linux to PostgreSQL (probably 7.1 by the time we go
> live).
>
> I've personally fixed a bug or two in the JDBC driver, but
> other than that
> the latest driver seems very solid.
>
> I use the default schema (the latest one from Orion has a lot of fixes
> contributed by myself and others, the original was horrible).
> Let me know if
> there are any problems with the latest schema.
>
> -mike
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of
> Randahl Fink
> > Isaksen
> > Sent: Wednesday, January 17, 2001 11:01 PM
> > To: Orion-Interest
> > Subject: Is combining Orion and PostgreSQL a good choice
> >
> >
> > I am wondering if using PostgreSQL with Orion would be a good
> > option. So my
> > questions are:
> >
> > 1. Has anyone tried using PostgreSQL with Orion in a
> real-life application
> > (running for a long period with no errors) - and was it a success?
> >
> > 2. Do you use the default database schema for PostgreSQL
> that comes with
> > Orion?
> >
> >
> > Yours
> >
> > Randahl
> >
> >
> >
> >
> >
>
>
>
>
