Jive Forums cannot Connect to the Database when Setting up the JDBC Connection (Doc ID 431794.1)

Last updated on NOVEMBER 20, 2023

Applies to:

Symptoms

Jive cannot connect to the database when
Setting up the Jive Forums for a Web Center installation at
http://<HOST>:<PORT>/owc_discussions/admin/setup

It returns the following error on the Standard Database Connection screen:

A connection to the database could not be made. View the error message by
opening the "[jiveHome]/logs/jive.error.log" log file, then go back to fix the
problem

In the same time the following exception is logged into the jive.error.log:

2007.05.16 15:19:52 [error] Could not load theme mappings
2007.05.16 15:19:52 [error] Could not load theme mappings
2007.05.16 15:20:24 [<init>] Failed to create new connections on startup.
Attempt 1 of 3
java.sql.SQLException: invalid arguments in call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:206)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:430)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:
32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.jivesoftware.base.database.ConnectionPool.createCon(ConnectionPool.java:
581)
at com.jivesoftware.base.database.ConnectionPool.<init>(ConnectionPool.java:
114)
at com.jivesoftware.base.database.DefaultConnectionProvider.
start(DefaultConnectionProvider.java:90)
at com.jivesoftware.base.database.ConnectionManager.
setConnectionProvider(ConnectionManager.java:600)
at com.jivesoftware.forum.action.setup.ThirdPartyDatasourceSetupAction.
setupDriver(ThirdPartyDatasourceSetupAction.java:225)
at com.jivesoftware.forum.action.setup.ThirdPartyDatasourceSetupAction.
execute(ThirdPartyDatasourceSetupAction.java:154)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at sun.reflect.DelegatingMethodAccessorImpl.
invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.opensymphony.xwork.DefaultActionInvocation.
invokeAction(DefaultActionInvocation.java:364)
at com.opensymphony.xwork.DefaultActionInvocation.
invokeActionOnly(DefaultActionInvocation.java:216)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActi
onInvocation.java:190)
at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.
doIntercept(DefaultWorkflowInterceptor.java:168)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.
intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvoc
ation.java:188)
at com.opensymphony.xwork.validator.ValidationInterceptor.doInt
ercept(ValidationInterceptor.java:115)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.
intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActi
onInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.webwork.interceptor.FileUploadInterceptor.
intercept(FileUploadInterceptor.java:171)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(De
faultActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterce
ptor.java:151)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(Default
ActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.xwork.interceptor.AroundInterceptor.
intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultAc
tionInvocation.java:188)
at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.
intercept(ExceptionMappingInterceptor.java:186)
at com.opensymphony.xwork.DefaultActionInvocation.
invoke(DefaultActionInvocation.java:188)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:
113)
at com.opensymphony.webwork.dispatcher.DispatcherUtils.
serviceAction(DispatcherUtils.java:225)
at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(Fil
terDispatcher.java:202)
at com.jivesoftware.base.action.util.JiveFilterDispatcher.
doFilter(JiveFilterDispatcher.java:54)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.
java:17)
at com.jivesoftware.util.SetResponseCharacterEncodingFilter.
doFilter(SetResponseCharacterEncodingFilter.java:63)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain
.java:17)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:
39)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.
java:17)
at com.jivesoftware.base.util.webwork.JiveActionContextCleanUp.
doFilter(JiveActionContextCleanUp.java:63)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.
java:17)
at com.jivesoftware.util.SetRequestCharacterEncodingFilter.
doFilter(SetRequestCharacterEncodingFilter.java:72)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.
java:17)
at com.jivesoftware.base.util.MaintenanceFilter.doFilter(MaintenanceFilter.
java:83)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.
java:17)
at com.jivesoftware.forum.upgrade.UpgradeFilter.doFilter(UpgradeFilter.java:53)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.
java:17)
at com.jivesoftware.base.util.ApplicationInitializedFilter.
doFilter(ApplicationInitializedFilter.java:66)
at com.evermind.server.http.ServletRequestDispatcher.
invoke(ServletRequestDispatcher.java:620)
at com.evermind.server.http.ServletRequestDispatcher.
forwardInternal(ServletRequestDispatcher.java:369)
at com.evermind.server.http.HttpRequestHandler.handleNotF
ound(HttpRequestHandler.java:1035)
at com.evermind.server.http.HttpRequestHandler.
doProcessRequest(HttpRequestHandler.java:905)
at com.evermind.server.http.HttpRequestHandler.
processRequest(HttpRequestHandler.java:447)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:302)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:190)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.
run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.
procClientSocket(ServerSocketAcceptHandler.java:239)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$70
0(ServerSocketAcceptHandler.java:34)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.
run(ServerSocketAcceptHandler.java:880)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.
run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)

Oracle was selected from the JDBC Presets list with the following correct details:
JDBC Driver Class: oracle.jdbc.driver.OracleDriver
JDBC URL: 'jdbc:oracle:thin:@<DB_HOSTNAME>:<DB_PORT>:<SID>'

The Jive Forum installation was done correctly by following the documentation/install-guide.html .
The Jive database was set up correctly into the schema called jive with the script
jive_forums_oracle.sql as suggested by documentation/database.html .

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.