Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS forum!
  • 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
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

SQL Server 2000 support and ForumRepository cache

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

This is quite important to me... :?

Thanks
[originally posted on jforum.net by Silenius]
 
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
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
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 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
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�۪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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic