• Post Reply 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
  • Ron McLeod
  • Paul Clapham
  • Devaka Cooray
  • Tim Cooke
Sheriffs:
  • Rob Spoor
  • Liutauras Vilda
  • paul wheaton
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Mikalai Zaikin
  • Carey Brown
  • Piet Souris
Bartenders:
  • Stephan van Hulst

Integration and security

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

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]
 
They worship nothing. They say it's because nothing lasts forever. Like this tiny ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
    Bookmark Topic Watch Topic
  • New Topic