You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Jim Richards <gr...@cyber4.org> on 2001/03/14 13:10:24 UTC
PostgreSQL problems.
I'm still getting problems with PostgreSQL (documented previously several
times). Has anyone used it successfully as a database.
Yes, I've got the settings correct, the JDBC string correct, lots of other
things. I really need someone who actually has it working to put their
hand up and say "yes, it does work, this is how I did it."
Thanks.
--
Kumera - a new Open Source Content Management System
for small to medium web sites written in Perl and using XML
http://www.cyber4.org/kumera/index.html
Re: PostgreSQL problems.
Posted by Jim Richards <gr...@cyber4.org>.
At 01:51 PM 14/03/01 +0100, you wrote:
>This does not sound at all like a PostgreSQL problem.
>
>Doesn't the error also show up, when you remove the datasource section?
No. That's the catch, it loads and runs if there's no datasource
section in the struts-config.xml file (although you need to comment
out the database code, or not access it).
--
Kumera - a new Open Source Content Management System
for small to medium web sites written in Perl and using XML
http://www.cyber4.org/kumera/index.html
Re: PostgreSQL problems.
Posted by Matthias Bauer <Ma...@livinglogic.de>.
This does not sound at all like a PostgreSQL problem.
Doesn't the error also show up, when you remove the datasource section?
--- Matthias
Jim Richards wrote:
>
> At 01:28 PM 14/03/01 +0100, you wrote:
> >We are currently using PostgreSQL as a database in a productive system together
> >with struts. We tried with Interbase before, but ran into many many
> >difficulties. So we switched to PostgreSQL and everything went well from then
> >on.
> >
> >What specific kind of problems do you have?
>
> See
>
> http://nagoya.betaversion.org/bugzilla/show_bug.cgi?id=827
>
> --
> Kumera - a new Open Source Content Management System
> for small to medium web sites written in Perl and using XML
> http://www.cyber4.org/kumera/index.html
Re: PostgreSQL problems.
Posted by Jim Richards <gr...@cyber4.org>.
I've finally got the problem sorted out. It was rather obscure, but I think
I could have only solved it because of the "Joy of Open Source(tm)".
When I built my postgresql.jar file, I only put .class files into it, not realising
there were some error_xx.properties file to be put in as well. I was getting
an error during ActionServlet loading because there are documented "not supported"
errors that would throw an SQLException, but since the error_xx.properties was not
there an extra NullPointerException was being thrown (because the ResourceBundle
was null, because there were no .proerties file) and this rippled through the system
and broke init().
I've rebuilt my postgresql.jar file and the system loads, I can access the database
and we'll all live happily ever after.
At 11:30 PM 14/03/01 +1100, Jim Richards wrote:
>At 01:28 PM 14/03/01 +0100, you wrote:
>>We are currently using PostgreSQL as a database in a productive system together
>>with struts. We tried with Interbase before, but ran into many many
>>difficulties. So we switched to PostgreSQL and everything went well from then
>>on.
>>
>>What specific kind of problems do you have?
>
>See
>
> http://nagoya.betaversion.org/bugzilla/show_bug.cgi?id=827
--
Kumera - a new Open Source Content Management System
for small to medium web sites written in Perl and using XML
http://www.cyber4.org/kumera/index.html
Re: PostgreSQL problems.
Posted by Jim Richards <gr...@cyber4.org>.
At 01:28 PM 14/03/01 +0100, you wrote:
>We are currently using PostgreSQL as a database in a productive system together
>with struts. We tried with Interbase before, but ran into many many
>difficulties. So we switched to PostgreSQL and everything went well from then
>on.
>
>What specific kind of problems do you have?
See
http://nagoya.betaversion.org/bugzilla/show_bug.cgi?id=827
--
Kumera - a new Open Source Content Management System
for small to medium web sites written in Perl and using XML
http://www.cyber4.org/kumera/index.html
Re: PostgreSQL problems.
Posted by Matthias Bauer <Ma...@livinglogic.de>.
We are currently using PostgreSQL as a database in a productive system together
with struts. We tried with Interbase before, but ran into many many
difficulties. So we switched to PostgreSQL and everything went well from then
on.
What specific kind of problems do you have?
--- Matthias
Jim Richards wrote:
>
> I'm still getting problems with PostgreSQL (documented previously several
> times). Has anyone used it successfully as a database.
>
> Yes, I've got the settings correct, the JDBC string correct, lots of other
> things. I really need someone who actually has it working to put their
> hand up and say "yes, it does work, this is how I did it."
>
> Thanks.
>
> --
> Kumera - a new Open Source Content Management System
> for small to medium web sites written in Perl and using XML
> http://www.cyber4.org/kumera/index.html