[Pgpool-general] PgPool install, Part Deux

[J. Carlos Muro]

2009/7/8 J. Carlos Muro <murojc at gmail.com>

> In my company we aren't.. yet. We are migrating all databases from a very
> expensive db system to PG*. I have found that we have tables with fields
> "default now()", and in the applications there are inserts sort of "insert
> into table1 values (now())". I have instructed our developers to study the
> possibility of generating dates from the application level. Later, we will
> see how Hibernate behaves with pgpool.. Well, we are adapting our
> environment to work with pgpool. You know, if it finally works, we will save
> lots of money. :)
>

For the information: we have created an small application that uses
Hibernate as persistence. Deployed it in JBoss (5.1.0) connects to pgpool
via an xa-datasource executing selects, inserts, updates, deletes on a table
both with latin and cyrillic (russian) characters. There is no problem. It
worked as expected.

We are still studying the case, why do our applications not work in this
schema.. One of our guys suspects it is due to an issue of high
overload/delay on our servers (specially in those with pgpool and
postgresql), not to talk about the 'now()' issue..
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090709/7841c7a7/attachment.html>