• 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

Change database conf from hsqldb to MsSql

 
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, I've sucessfully install jForum with hsqldb but to deploy it with our system, I have to change the database config to use MsSQL. I did the search and change the config but unfortunately it still uses the hsqld. And I don't know how and what to change the code in webapp . Currently, I'm using Tomcat 5.5. Please, help me!

Code in jforum->SystemsGlobal.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.PooledConnection


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

# DataSource name, in case of using net.jforum.core.db.DataSourceConnection
database.datasource.name = java:/MySqlDS

# Time in seconds to healthcheck all database connections
database.ping.delay = 3600

# Extra parameters to pass to C3P0 (only when using PooledConnection)
# Form is key=value;key2=value2;keyN=valueN
c3p0.extra.params = checkoutTimeout=120000;debugUnreturnedConnectionStackTraces=false;unreturnedConnectionTimeout=180




I'd also added the changes as in https://coderanch.com/t/576985 #14565


The console show that I still use hsqldb although I have changed the database config
INFO: Starting service Catalina
18/09/2007 12:16:07 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
18/09/2007 12:16:07 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
18/09/2007 12:16:08 org.apache.catalina.core.ApplicationContext log
INFO: org.apache.webapp.balancer.BalancerFilter: init(): ruleChain: [org.apache.webapp.balancer.RuleChain: [org.apache.webapp.balancer.rules.URLStringMatchRule: Target string: News / Redirect URL: http://www.cnn.com], [org.apache.webapp.balancer.rules.RequestParameterRule: Target param name: paramName / Target param value: paramValue / Redirect URL: http://www.yahoo.com], [org.apache.webapp.balancer.rules.AcceptEverythingRule: Redirect URL: http://jakarta.apache.org]]
18/09/2007 12:16:09 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/09/2007 12:16:09 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/09/2007 12:16:09 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
18/09/2007 12:16:09 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
18/09/2007 12:16:09 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-9090
18/09/2007 12:16:09 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
18/09/2007 12:16:09 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/27 config=null
18/09/2007 12:16:09 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
18/09/2007 12:16:09 org.apache.catalina.startup.Catalina start
INFO: Server startup in 2511 ms
12:16:27,944 INFO [JForumBaseServlet ] Starting JForum. Debug mode is true
12:16:27,979 INFO [ConfigLoader ] Using cache engine: net.jforum.cache.DefaultCacheEngine
12:16:27,988 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.BBCodeRepository
12:16:28,001 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RankingRepository
12:16:28,008 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SmiliesRepository
12:16:28,017 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.ForumRepository
12:16:28,026 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.TopicRepository
12:16:28,036 INFO [ConfigLoader ] Creating an instance of net.jforum.SessionFacade
12:16:28,041 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.PostRepository
12:16:28,047 INFO [ConfigLoader ] Creating an instance of net.jforum.util.search.quartz.QuartzSearchIndexerJob
12:16:28,058 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.Tpl
12:16:28,065 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RolesRepository
12:16:28,068 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SecurityRepository
12:16:28,081 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.BanlistRepository
12:16:28,281 INFO [FileMonitor ] Watching C:\dev\workspace\jforum/WEB-INF/config/languages/en_US.properties
12:16:28,302 INFO [ConfigLoader ] Loading JDBC driver net.jforum.dao.sqlserver.SqlServerDataAccessDriver
[color=red]12:16:28,639 INFO [FileMonitor ] Watching C:\dev\workspace\jforum/WEB-INF/config/database/generic/generic_queries.sql

12:16:28,639 INFO [FileMonitor ] Watching C:\dev\workspace\jforum/WEB-INF/config/database/hsqldb/hsqldb.sql

12:16:28,642 INFO [FileMonitor ] Watching C:\dev\workspace\jforum/WEB-INF/config/SystemGlobals.properties
12:16:28,642 INFO [FileMonitor ] Watching C:\dev\workspace\jforum/WEB-INF/config/jforum-custom.conf
log4j:WARN No appenders could be found for logger (com.mchange.v2.log.MLog).
log4j:WARN Please initialize the log4j system properly.
12:16:29,787 INFO [ConfigLoader ] Loading clickstream config from C:\dev\workspace\jforum/WEB-INF/config/clickstream-jforum.xml




[originally posted on jforum.net by novi]
 
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
Check your jforum-custom.conf

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
I found a good solution for MS SQL 2000 at http://www.jforum.net/jira/browse/JF-656.

However there are some problem with attachment (SQL statement must not be null)??
I'll do further test to check the other functions are working fine or not.
[originally posted on jforum.net by novi]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic