aspose file tools*
The moose likes JForum and the fly likes PostgreSQL 8.0? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » JForum
Reply locked New topic
Author

PostgreSQL 8.0?

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Has anyone tested if JForum could work with the latest stable version of PostrgreSQL (8.0) ?
AFAIK, at least the driver should be changed (postgresql-8.0.xxx.jdbc3.jar)

This would be very interesting at least for two reasons:
- Native Windows version (no more Cygwing required)
- continuous backup

Thanks in advance,

Jake Robwood.
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I have downloaded it but not tested yet. Can you say if the new jdbc driver will be compatible with older versions of postgresql?

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:I have downloaded it but not tested yet. Can you say if the new jdbc driver will be compatible with older versions of postgresql?

Sorry, I can't. As a rule of thumb, usually there's no compatibility between major versions(like in the case of MySQL). In theroy it works, but there are stability problems in most of the cases. At least that was my experience with all the other databases.
I would wonder if PosgreSQL would be the exception from the rule .

Jake Robwood.
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
hehehe.. I just downloaded mysql 4.1 and the latest version of connector/j. It simply does not work. There are so many exceptions that I want to kill mysql developers.

I was able to run jforum under mysql 4.1 using an older version of the jdbc driver, though.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Rafael Steil wrote:hehehe.. I just downloaded mysql 4.1 and the latest version of connector/j. It simply does not work. There are so many exceptions that I want to kill mysql developers.

I was able to run jforum under mysql 4.1 using an older version of the jdbc driver, though.

IMHO, to avoid the exeptions and frustrations with differend packages, there are thou a few things one could do(unfortunately for some of them some structural chages in JForum would be required):
- use the database driver only for the designated generation.
- do not use betas, especially in DB domain. They are much too important to be beta.
- change the build structure to allow more versions for the databases, e.g:

Of course, the SQL scritps need no duplication cause mostly they work for all the version of a specific database.
- use a property file to select the correct database, so that there could be more than one build target (this is not that complicated as it looks, and will help avoid most of the problems).
- if you use eclipse(or other IDE), use the ANT support from the IDE, and not the "simple compile".

This strategy is used in a lot of projects. E.g. : the very popular AppFuse: https://appfuse.dev.java.net/

Jake Robwood.
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Anonymous wrote:
IMHO, to avoid the exeptions and frustrations with differend packages, there are thou a few things one could do(unfortunately for some of them some structural chages in JForum would be required):
- use the database driver only for the designated generation.


Well, in most cases the same driver should work for all previous versions. The problem with mysql 4.1 is that the stable drivers, 3.1.6, causes the system to break. Using a previous version all work fine.


- do not use betas, especially in DB domain. They are much too important to be beta.


I try to avoid most of the time.


- change the build structure to allow more versions for the databases, e.g:

Of course, the SQL scritps need no duplication cause mostly they work for all the version of a specific database.
- use a property file to select the correct database, so that there could be more than one build target (this is not that complicated as it looks, and will help avoid most of the problems).


All of this is supported by jforum since the begginning.


- if you use eclipse(or other IDE), use the ANT support from the IDE, and not the "simple compile".


Well, it is really more quick to use the internal compiler than run ant. I provide a build.xml for people whose does not want to use an IDE.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I'm using JForum with PostgreSQL 8 with no problems.
[originally posted on jforum.net by gangrel-br]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Yep. I tested in yesterday and works fine. Even the installer is working.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I'm having trouble getting it to work with PostgreSQL 8 on Windows XP, running JBoss 3.2.6. The installer works fine, but whatever I try to do on the forum (register, post topic), I get the following error:


[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Please check WEB-INF/config/jforum-custom.conf and WEB-IFN/config/database/postgresql/postgresql.properties to see if database.support.autokeys is set to false

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
The previous post (the one above Rafael) was me. The properties you mention was not set at all (not to true and not to false). I added these properties, but still have trouble. I'm going to reinstall the whole shebang to see if it could work.
[originally posted on jforum.net by olas]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Reinstallation did not improve the situation. I still get the following message:



I've added the following in jforum-custom.conf and postgresql.properties:

[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Reinstallation did not improve the situation. I still get the following message:



I've added the following in jforum-custom.conf and postgresql.properties:

[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Reinstallation did not improve the situation. I still get the following message:



I've added the following in jforum-custom.conf and postgresql.properties:


PS! I tried to submit after preview now, and it did not work... Had to write a new reply.
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Reinstallation did not improve the situation. I still get the following message:



I've added the following in jforum-custom.conf and postgresql.properties:

[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Reinstallation did not improve the situation. I still get the following message:



I've added the following in jforum-custom.conf and postgresql.properties:

[originally posted on jforum.net by olas]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PostgreSQL 8.0?