That could very well be. We were using postgres 7.0.1 and it may have been
a known bug.
Tell you what, Randahl, if you end up having issues with date let me know
and i'll send you our driver hack. I fully recommend postgres, it's by far
my favorite opensource database.
sach
robot6
%s/windows/linux/g
On Wed, 17 Jan 2001, Tim Drury wrote:
>
> 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
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
