Re: PostgreSQL problems.
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.
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
Re: PostgreSQL problems.
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.
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.
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