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

Oracle 10g Plz

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
Thanks.. I will check that out
[originally posted on jforum.net by donraja_ht]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
I'll take a look

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

Joined: Apr 22, 2012
Posts: 17424
Thanks, waiting for your reply eagerly!!
[originally posted on jforum.net by donraja_ht]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
Sorry for reposting the same issue :-)
[originally posted on jforum.net by donraja_ht]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
which files? I'm having the same problems.
[originally posted on jforum.net by Anonymous]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Me too.

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

Joined: Apr 22, 2012
Posts: 17424
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

Joined: Apr 22, 2012
Posts: 17424
Version 2.1.5 already has Oracle there.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle 10g Plz