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]
