Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

PostgreSQL 8.0?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator

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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator

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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator

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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
I'm using JForum with PostgreSQL 8 with no problems.
[originally posted on jforum.net by gangrel-br]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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]
 
Curse your sudden but inevitable betrayal! And this tiny ad too!
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
    Bookmark Topic Watch Topic
  • New Topic