• 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
  • 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

Oracle 10g Plz

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello and Hi,

I have read through this forum and was very happy to know that JForum have been sucessfully ported to Oracle. I am working on a similar project and need some help on as to how to port it on Oracle 10g Database. Just wanted to know what are the changes to be made in the config files so as to JForum gets connected with Oracle.

I have downloaded the JForum CVS files. And have gone through the files, but am not getitng the Installation screen for JForum, so that i can select Oracle as the database. Looks like there is some other way to do this.... Help me out plz

Regards
Harish
[originally posted on jforum.net by donraja_ht]
 
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
CVS version does not have the web installer enabled. You should manually install it - http://www.jforum.net/install_no_wizard.jsp

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
Thanks.. I will check that out
[originally posted on jforum.net by donraja_ht]
 
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
Thanks Rafael,

I have done the folowing changes in the SystemGlobals.properties file



I am not sure about database.datasource.name so left is as it is.....Also changed the oracle.properties file for the username, password and dbname including the host name. But still no luck i an ending up with the following error message....

net.jforum.exceptions.DatabaseException: Error while trying to start the database: net.jforum.exceptions.DatabaseException: java.sql.SQLException: invalid arguments in call
net.jforum.ForumStartup.startDatabase(ForumStartup.java:88)
net.jforum.JForum.init(JForum.java:91)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
java.lang.Thread.run(Thread.java:534)


Is there anything else i will need to configure Rafael.

Thanks in advance..!!

Regards
Harish
[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
I'll take a look

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
Thanks, waiting for your reply eagerly!!
[originally posted on jforum.net by donraja_ht]
 
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
Hi and Hello!

Rafael Looks like i have resolved the problem with Oracle, I have done the following changes with the

SimpleConnection.java file i have modified the following function.




and guess what the above error message was gone and i could connect to Oracle 10g database with wonders...:-)

I am still doing testing with all the modues with this database, if there are any other vulnerability with Oracle then plz do let me know......
I will also post the final result of testing later...I would also would like to test Multilingual feature with Oracle :-)

Wish Me luck


Thanks Again!!
Harish
[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
HI Rafael !!

I have done some testing on JForum using oracle.......good to say that everything is working fine apart from one small error, so posting the stacktrace here, please have a look and suggest me any solution for this....I think this is related to the BLOB thing.....cause i am getting this error message when ever i try to post any messages....



Thanks and Regards
Harish
[originally posted on jforum.net by donraja_ht]
 
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
OK, I'll check this out

btw, are you using the latest cvs version?

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
Hi,

Yes, i have downloaded it last week also with the above error message i and getting this error too.....



Hope this will help in solving the bug which i am facing, I too am trying my best on resolving this issue, cause we want to use JForum with Oracle :-), If i find any solution then i will post it here, and tell me if the CVS files have been updated from last week, if yes then i will download it again.......

Regards
Harish
[originally posted on jforum.net by donraja_ht]
 
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
Hi,

Just to add to the above error message here is some more stacktrace...as mentioned above it looks like the issue is with the BLOB field...



Also i have downloaded the CVS files on 1st week of November 2005, do you think i should redownload the files again, are there any major changes made to the code.....? if so then please do let me know i will download the source code again.

Regards
Harish
[originally posted on jforum.net by donraja_ht]
 
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
Sorry for reposting the same issue :-)
[originally posted on jforum.net by donraja_ht]
 
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
Hello Rafael !

Well i am glad that the above issue is finally resolved...I just updated some files from the CVS and that did the trick :-) thanks again....


;-)
Thanks and regards
Harish
[originally posted on jforum.net by donraja_ht]
 
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
Yeah, I'm glad that, after more than one year, Oracle support is finally 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:
  • Quote
  • Report post to moderator
which files? I'm having the same problems.
[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
Me too.

Make a tutorial...
[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
Rafael. You might want to add oracle as an option on your installation instructions if it is availabe. Currently, the only three choices listed are hsqldb, mysql, & psql. I did my first install with hsqldb even though I am using an oracle database on my application because I didn't know that oracle was an option. Thanks so much for all your support.
[originally posted on jforum.net by rzavi4jc]
 
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
Version 2.1.5 already has Oracle there.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic