File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes probleme with datasource configuration Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JForum
Bookmark "probleme with datasource configuration" Watch "probleme with datasource configuration" New topic
Author

probleme with datasource configuration

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi all,

I want to use JForum with a datasource configuration...
I'm on weblogic 8.1... I configure a datasource named "cx_jforum"...

On the installation of jforum (http://localhost:8080/jforum/install.jsp) I configure the forum like this :

Connection Type : "datasource"
DataSource name : "cx_jforum".

The tables are created. The forum run... But, when I want to create a new cat�gories :

On the windows :




On the HTML source :



Any ideas ???
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Others informations, I' using :

- windowsXP SP2
- oracle database
- JForum 2.1.7
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I resolve the problem in change value of database.support.autokeys to false !!

But now, when I want to create a new topic, I've the following error :


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

Joined: Apr 22, 2012
Posts: 17424
I went to reinstall JForum via jahia whin JDBC configuration... It work !!!

But, if I replace

database.connection.implementation = net.jforum.SimpleConnection
by
database.connection.implementation=net.jforum.DataSourceConnection

in jforum-custom.properties

And add database.datasource.name=cx_jforum

It work, but, if I post a new topic...



and in the server logs :



What do you think of that ?
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Nobody can help me ???

When I don't use datasource but directly JDBC configuration, it work fine... But, I must to configure it whith datasource configuration...
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
A template error generally is a secondary error. Check your logs to see if there is an error ocuring before this one.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thank you very much for your aswer !!

First, during initialisation, I've :



When I click on "new post" button, I've :



I type a message with a title, and when I submit :



Thank you if you've an idea !!
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I just want to say that I use jahia portlet which integrated JForum 2.1.5
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
One thing I noticed was a problem finding a log4j class. I can't remember if this is distributed in the install zip or not. It might not be since Tomcat, JBoss, and others generally have this. You might try getting the log4j.jar and adding it to your webapp's lib directory.

http://logging.apache.org/log4j/docs/


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

Joined: Apr 22, 2012
Posts: 17424
There is a file named log4j-1.2.12.jar in /WEB-INF/lib directory of jahia JForum application.

Do you think it's good ??
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hmm, is it a read-only access to the DB problem? E.g., you can display lots of stuff but all the DB insert/update forms fail, like posting a new topic, reply, or changing your profile info?

If that's the case, you may need to check the rights of the DB user you are connecting with.
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
HI monroe !! I've a big big problem !!!

All the problem that I says are resolve when I use FireFox... But, I must to Use IE for the portal !!

PLEASE can you help me, I'm very desapointed !!!

Why it work on FF and not on IE ???

When I'm on IE, I've javascript errors :


(there is nothing after PAGE/)

It can be the origin of my problems no ???
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi, thank you for your interrest

I can't change my profil (404 error)...

I can't create or edit topic (ERROR net.jforum.exceptions.ExceptionWriter.handleExceptionData:75 - net.jforum.exceptions.TemplateNotFoundException: Template for action editSave is not defined)

But, I can create forum and cat�gories, I can change the users groups etc...

I can't configure the general configuration in administration view (404 error) but I can change the configuration in "attachement configuration".

It's strang... Have you any idea ??? Thank you v�ry much !!
[originally posted on jforum.net by tinico]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
HEY !!!

There is a bug in your forum... When I Submit the message before, I've see it :



But It not the topic subject... So, have you an idea on my problem ??

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

Joined: Apr 22, 2012
Posts: 17424
Sorry for the delay, just getting back from a long weekend in New England....

At this point, I don't know what to tell you. It's most likely a problem with the jahia portal implementation. AFAIK, this was not done by the jForum folks since there is no org.jahia package code in the repository.

Perhaps the jahia support/developer community can better help you get this working?
[originally posted on jforum.net by monroe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Ok thanks !!

I find the cause of the problem !!
When I use DebugBar on Internet Explorer, I find an URL which is generated and used by jahia portlet !!

This URL is (when I want to validate a Edited message) to long to be accepted by IE7...

So, how can I do ???


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

Joined: Apr 22, 2012
Posts: 17424
Hi,

did you find a solution for your problem ?
I've got exactly the same exception (Template for action insertSave is not defined) when I use datasource. But for me, it doesn't work neither in IE neither in FireFox
[originally posted on jforum.net by toomtooms]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I find the solution !!
The problem comes from a cast in the OracleUtils.writeBlobUTF16BinaryStream method. Weblogic wraps the oracle classes. Therefore, the BLOB object is a weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB object an not oracle.sql.BLOB object.

The solution is to use the last version of the JForum code. It's corrected in it !
[originally posted on jforum.net by toomtooms]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Oups, sorry, I haven't red your message !!

Yes I have had this probleme and I solve it with the same solution you've used !

But, can you post long message now ??? Test to post a long message with longer over than 30 lines ! If it don't work, I've a solution for you that I've implemented !

[originally posted on jforum.net by tinico]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: probleme with datasource configuration
 
Similar Threads
java.net.NoRouteToHostException: No route to host: connect
java.lang.reflect.InvocationTargetException on WebLogic 8.1 SP5 & Oracle 9i
Oracle Exception after installation while creating category
Error accessing RSS links using Oracle
Unsupported feature on 2.1.7