Re: Postgres with IBM ????????

Hi Prison,

I've created Web Sphere packages for Solaria 8, and had to install Web
Sphere numerous times in the process of getting it right (learning curve
thing).

For getting Web Sphere to work with PostgreSQL... it doesn't work right
out of the box. When you install Web Sphere 4.0x (not sure about 4.1)
it asks which database it will be connecting to, for storing it's own
information in (not relating to any
Applications/Servers/Groups/Nodes/etc), and uses specific SQL approaches
depending upon the database selected.

PostgreSQL isn't listed in the available options here. There may have
been a generic "SQL" option, but I don't remember seeing one for that
either.

If you get Web Sphere up and running using a different database (Oracle
8i at the time I was creating packages) then you'll find in the Web
Sphere configuration files (admin.conf file in the <WEBSPHERE_ROOT>/bin
directory I think, but I could be wrong) that you can alter the
configuration to go into a "generic SQL" mode and it appears to even be
able to optionally DO or NOT DO a 2 phase commit (which I remember
someone was telling me was important with PostgreSQL).

So, although it's not supported out-of-the-box, you may in fact somehow
be able to get it to work, with a bit of time an effort (think hours).
:)

Would have liked the time to try it myself (as this would really prove
beneficial for a lot of places) but had more urgent and important things
to do.

BTU - Generally your question is the sort of thing which you need to ask
on the PostgreSQL "General" mailing list, not via a bug report. You'll
probably still find it more beneficial to subscribe to the "General"
mailing list and see what goes on there.

Regards and best wishes,

Justin Cleft

Prison wrote:
>
> Hi friends,
>
> Can any body help me , whether postgres work with IBM websphere ?
>
> if pls kindly give me the details regarding this.
>
> thanx and regards,
> prinson.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi