SQL Server 2000 support and ForumRepository cache

[Migrated From Jforum.net]

Hello Everyone,

I�۪m planning to integrate jForum with another application.
The problem is that the application uses SQL Server database.
Are you planning to support SQL Server soon? I�۪m not sure I can finish the development version because I�۪m not yet an experienced developer with J2EE.

Regards,
Samuel
[originally posted on jforum.net by Silenius]

[Migrated From Jforum.net]

Please answer me.

This is quite important to me... :?

Thanks
[originally posted on jforum.net by Silenius]

[Migrated From Jforum.net]

2.1.5 cvs seems to have better support for sqlserver. Paging is working =)
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Can I ask what do I need to do to make the forum running with JBoss and SQL Server?

What I�۪ve done so far was:

�ۢ get the 2.1.5 version from the CVS
�ۢ edit sqlserver.properties file to specify database password and host
�ۢ edit the build.xml file to correct the deploy dir for run with JBoss

I�۪ve read in http://www.jforum.net/development.jsp that I must create a jforum-custon.conf file for my own configuration data, but what do I need to put there to make it work with SQL Server? Or must I edit SystemGlobals.properties for doing that?

One more thing, must I firstly create the database or the setup of the forum will create it automatically?

Many Thanks,
Samuel Santos

PS: If I manage to make the forum running with SQL Server, and if you are interested, I can contribute with a pt_PT translation.
[originally posted on jforum.net by Silenius]

[Migrated From Jforum.net]

I don't know about JBOSS but this is how I did with Tomcat:

* Got the 2.1.5 version from the CVS
* Made zip with Ant and build.xml
* Unzipped to webapps directory
* Defined JNDI Datasource
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
* Made manual install
http://www.jforum.net/install_no_wizard.jsp

Database part of my SystemGlobals.properties
#####################
# DATABASE SETTINGS
#####################
# Database type to use
database.driver.name=sqlserver

# Can be net.jforum.SimpleConnection, net.jforum.PooledConnection
# or net.jforum.DataSourceConnection
database.connection.implementation = net.jforum.DataSourceConnection

# Enable / Disable transactions
database.use.transactions = true

# DataSource name, in case of using net.jforum.DataSourceConnection
database.datasource.name = java:comp/env/jdbc/jforum

# Time in milliseconds
database.ping.delay = 3600000

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Ok, I�۪ve go through the manual install.

I�۪ve done so far:
�ۢ get the 2.1.5 version from the CVS
�ۢ edit sqlserver.properties file to specify database password and host
�ۢ edit the build.xml file to correct the deploy dir for run with JBoss
�ۢ create the database in SQL Server
�ۢ Change the database.driver.name in SystemGlobals.properties to sqlserver
�ۢ (I�۪ve maintained net.jforum.SimpleConnection)
�ۢ remove the line "install = net.jforum.view.install.InstallAction" from the file WEB-INF/config/modulesMapping.properties
�ۢ made the deployment with eclipse

Now the forum is running, but has some serious bugs:
�ۢ when I add a category or a forum they don�۪t appear in the listings (in administration and Forum index)


How can I solve this situation?

Regards,
Samuel Santos

PS: I haven't defined JNDI Datasource. I�۪m new in J2EE and I don�۪t know what�۪s for and if I need it with JBoss��? ops:
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

when I add a category or a forum they don�۪t appear in the listings (in administration and Forum index)

I forgot to say that they are in the database...

Many thanks.
Samuel Santos
[originally posted on jforum.net by Silenius]

[Migrated From Jforum.net]

I've got the last files from cvs and I�۪ve found a bug pattern.

When I sign on with a user belonging to the administration or exp group, I can�۪t see the posted categories, forums, and threads in the administration and in the forum index (but they exist in the database).

When I clear the sessions and restart JBoss I can see the posted items with anonymous user or a user belonging to the general group, but not with an administration and ext group user.

Isn�۪t this bug related to the ForumRepository cache?

How can I correct this bug?

Need help please��?

Regars,
Samuel Santos
[originally posted on jforum.net by Silenius]

[Migrated From Jforum.net]

Hi samuel,

Did you solve your problems? Are there any problems pending regarding to SQL Server 2000?
[originally posted on jforum.net by cagin]

[Migrated From Jforum.net]

Hello,

The last time I checked, the sqlserver scripts were working fine, they still have some bugs caused by "LIMIT" in some queries.

Regards
[originally posted on jforum.net by Silenius]

[Migrated From Jforum.net]

If you tell which query, I can take a look. But the latest version of sqlserver.sql in CVS should have no LIMIT keyword usage (at least the one I had sent to Rafael didn't
[originally posted on jforum.net by cagin]