We are using Orion with Postgres v7 here and we have no such problem.
On Mon, Aug 14, 2000 at 12:06:07PM -0400, KirkYarina wrote:
> FWIW, we found major problems with postgresql. Running a test that created
> and deleted EBs caused index and data files to grow
> continuously. Recovering data space took a "vacuum" command, but the only
> way to recover deleted index file space was to copy tables. In addition
> every test run was slower than the one before it - from my notes when run 3
> times each run took twice as long as the one before. The same tests took
> the same time every run when using Hypersonic or Sybase.
>
> This was several months ago, so perhaps it's been fixed. We deleted
> postgres and moved on...
>
> Our old data-sources.xml section is below, just in case it helps. I
> believe I had to edit the database-schema file to change null="null" to
> null="" also.
>
> Kirk Yarina
>
> At 05:58 PM 8/12/00 -0700, you wrote:
> >Are the postgres drivers built in to orion? I want to make some changes to
> >them.
> >
> >I'm trying to use postgres as my datasource in Orion. It sets up fine, but
> >I need to make some changes to the driver implementation. I'm having a
> >bunch of problems with the date and timestamp implementations. I found on
> >the PostGres mailing lists that it's a pretty common problem and you just
> >have to modifiy ResultSet for your setup.
> >
> >The problem I'm having is that I can't seem to override the drivers in
> >orion. I've tried putting a jar of postgres drivers in the orion/lib
> >directory, but it still seems to be using some other drivers.
> >
> >-Lkb
> >/**
> > * @author: Lorin Kobashigawa-Bates <[EMAIL PROTECTED]>
> > * @title: CodeMonkey / COO - Robot6 Inc.
> > * @phone: 415.345.8872
> > * @addr: 1177 Polk St. San Francisco, CA 94109
> > */
>
> from datasources.xml:
>
> <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"
> url="jdbc:postgresql://ourhost/ejbtest"
> connection-driver="org.postgresql.Driver"
> username="admin"
> password="123"
> schema="database-schemas/postgresql.xml"
> />
>
>
> Kirk Yarina
> [EMAIL PROTECTED]
>
>
--
Adam Cassar
Senior Web Developer
___________________________________________
NetRegistry http://www.netregistry.au.com
Tel: +61 2 9699 6099 | Fax: +61 2 9699 6088
PO Box 270 Broadway NSW 2007 Australia