Forum:

JForum

PostgreSQL 8.0?

Ranch Hand

Posts: 17424

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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:
/lib /lib/mysql4.0 /lib/mysql4.1 /lib/xxx
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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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:

<!-- BEGIN ERROR STACK TRACE
java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at net.jforum.Command.process(Command.java:106)
	at net.jforum.JForum.service(JForum.java:298)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:66)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:158)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:534)
Caused by: org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
	at org.postgresql.jdbc3.AbstractJdbc3Connection.prepareStatement(AbstractJdbc3Connection.java:352)
	at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:289)
	at net.jforum.drivers.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:105)
	at net.jforum.drivers.generic.AutoKeys.getStatementForAutoKeys(AutoKeys.java:117)
	at net.jforum.drivers.generic.UserModel.addNew(UserModel.java:236)
	at net.jforum.view.forum.UserAction.insertSave(UserAction.java:202)
	... 38 more

END ERROR STACK TRACE-->

[originally posted on jforum.net by Anonymous]

Migrated From Jforum.net

Ranch Hand

Posts: 17424

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Migrated From Jforum.net

Ranch Hand

Posts: 17424

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Migrated From Jforum.net

Ranch Hand

Posts: 17424

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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]