aspose file tools*
The moose likes JForum and the fly likes Internal HSQLDB to external HSQLDB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Internal HSQLDB to external HSQLDB" Watch "Internal HSQLDB to external HSQLDB" New topic
Author

Internal HSQLDB to external HSQLDB

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Well as the post name sais i'm trying to move from using the default internal database and run it independently of Jforum. I plan to use the accounts for other pages on my site.

Now i've gotten hsqldb to run with the JForum files no problem. I viewed the data with the the database manager swing. However I can't seem to find all the properties and configuration information to properly connect.

I've tried doing a search, but there was 300+ DB problems. And i'm not sure the exact term to use to narrow the search.

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

Joined: Apr 22, 2012
Posts: 17424
I'm not an HSQLDB expert but I think in order to use it across multiple applications you need to run it in one of it's server modes. I assume that's what you mean by external HSQLDB?

The default jforum access uses "In process mode" which can only be used by a single application.

Converting shouldn't be hard, just transfer the tables and data from the jForum Application DB to the HSQLDB server, and change the database.connection.string property to use the correct syntax.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
" Now i've gotten hsqldb to run with the JForum files no problem. I viewed the data with the the database manager swing. However I can't seem to find all the properties and *configuration information to properly connect. "

The server mode was easy. it's the fact that jForum doesn't use it in server more that's the problem. It's already *configured for internal use. So it's not using it in server mode.

Any suggestions, I would greatly appreciate it.
[originally posted on jforum.net by jaydryu]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
You're making it harder than it is... the only application difference between using the server and the internal mode, is the JDBC URL. The HSQLDB driver is the same for both and it handles all the "magic".

The JDBC URL is set in your jforum-custom.conf file via the database.connection.string parameter. So the URL should change from something like:


to

Where database.connection.host and database.connection.dbname are defined by the properties setting in the config file.

Of course, you will also need the correct settings for the database.connection.username and database.connection.passwords properties as well.
[originally posted on jforum.net by monroe]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Internal HSQLDB to external HSQLDB