aspose file tools*
The moose likes JForum and the fly likes Integration and security Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "Integration and security" Watch "Integration and security" New topic
Author

Integration and security

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi,
I would like to know for the security (relation in the database) of the forum because I would like to integrate this beautiful forum in a Portail. The Portail have already a database with Oracle. so i would like to interface the 2 database.
thank you for your help.
luc
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
The JForum code uses a datamodel for all data.

If you look in the package "", you will see all of the code related to storing and retrieving data.

Modifying to work with Oracle is not a dead simple port. First, you need to install the Oracle JDBC driver. Next, you have to change the JForum JDBC URL to point to your Oracle database and the new driver.

However, that is the easy part. The real issue is going to be JForum's use of the MySQL TEXT datatype. Oracle has no such datatype. In fact, Oracle can only handle text of VARCHAR(255). I have run into this problem with EVERY Oracle port, and it sucks. The fact that Oracle has never included a TEXT datatype tells me that their DB design is too rigid to accomodate it (not a good sign).

This is why, in every DB design I have done, I put all TEXT field into completely separate tables and reference them from the real records. This was I can accomodate Oracle (and other DBs) more easily.

In the case of JForum, that will not be the case (the TEXT fields are inline with the records). So, you will need to find a special Oracle field that can accomodate text of length more than 255. I forget what was used in the past, but I believe there is a binary datatype that you can use.

The bottom line: more than 15 minutes of work!

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

Joined: Apr 22, 2012
Posts: 17424
You can use Blob in the place of Text, afaik.

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

Joined: Apr 22, 2012
Posts: 17424
There where a bunch of mods done to BugRat, the bug reporting system written for the Giant Java Tree (www.gjt.org). You can download the complete BugRat source at http://www.gjt.org/pkg/bugrat/.

The few mods that I saw from an initial scan of the code follow. First, it appears that Oracle does not distinguish between an empty string ("") and a string that is NULL. BugRat had used NULL strings to indicate that a category level was "unset", but had to be updated to use "." instead:



I realize it is not that complete, but I hope it helps.

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

Joined: Apr 22, 2012
Posts: 17424
That last post was from me.

I think it points out a bug. I was posting that comment for some long period of time. I was logged in as myself. However, I think the session timed out while I was editting the post, and so when I posted it, I became anonymous.
[originally posted on jforum.net by time]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
time wrote:That last post was from me.

I think it points out a bug. I was posting that comment for some long period of time. I was logged in as myself. However, I think the session timed out while I was editting the post, and so when I posted it, I became anonymous.


If you don't check "Log me on automatically", then yes, the container will invalidate your session after a long period of inactivity ( 30 minutes ) and you get an anonymous user id. If you'd checked to log in automatically, the system would ensure you don't loose your id.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Integration and security