[GVP 8] Problem with GVP Reporting Server

[genecool]

Hi,

I encounter a problem with Reporting Server which wants not start :

[quote]
12:15:36.470 Trace GVPReportingServer ReportingServer GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
12:15:36.482 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server'processing configuration update
12:15:36.482 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051
12:15:36.482 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051
12:15:36.482 Trace GVPReportingServer ReportingServer GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server 'Message Server' at host '192.168.10.65', port 5051
12:15:36.482 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
12:15:36.497 Standard GVPReportingServer ReportingServer GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer 'CFGMessageServer' at host '192.168.10.65', port 5051
12:15:36.497 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService start of fireServerContacted()
12:15:36.532 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080
12:15:36.575 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook
12:15:36.575 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated
12:15:36.575 Trace GVPReportingServer ReportingServer GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999
12:15:36.575 Standard GVPReportingServer ReportingServer GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
12:15:36.579 Standard GVPReportingServer ReportingServer GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999
12:15:36.583 Trace GVPReportingServer ReportingServer GCTI-153-20001 com.genesyslab.commons.lca.LCAManager  Reporting Server initializing in 'standalone' mode
12:15:36.583 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@1627c16
12:15:37.462 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
12:15:38.431 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session.
12:15:38.790 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED
12:15:38.790 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false
12:15:39.235 Trace GVPReportingServer ReportingServer GCTI-153-20007 com.gvp.rpt.service.DateComponentsPopulationJob DateComponents Population job run
12:15:39.235 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.service.DateComponentsPopulationJob Populating DateComponents from Sat Jan 01 00:00:00 CET 2011 until Tue Jan 01 00:00:00 CET 2013
12:15:40.798 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory
[b]12:15:40.802 Standard GVPReportingServer ReportingServer GCTI-153-50000 com.gvp.rpt.service.StandAloneReportingService Unable to start RS application context, shutting down. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'callSummaryLoggingJob' defined in class path resource [quartz.config.xml]: Cannot resolve reference to bean 'callSummaryLoggingService' while setting bean property 'targetObject'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'datePopulateService' defined in class path resource [ems-rs-withDB.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
[/b]12:15:40.802 Standard GVPReportingServer ReportingServer GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode
12:15:40.802 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
12:15:40.903 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
12:15:40.903 Trace GVPReportingServer ReportingServer GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped
12:15:40.903 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://192.168.10.65:5051 successfully shut down.
12:15:40.903 Trace GVPReportingServer ReportingServer GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://FwkServer:2020 successfully shut down.
12:15:40.907 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed
12:15:40.907 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is completed.
12:15:40.907 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Shutdown of LCAManager is completed.
12:15:40.907 Standard GVPReportingServer ReportingServer GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination
12:15:40.907 Standard GVPReportingServer ReportingServer GCTI-153-04505 com.genesyslab.commons.lca.LCAManager Disconnected from Local Control Agent 'LCA'
12:15:41.009 Interaction GVPReportingServer ReportingServer GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully
12:15:41.009 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
12:15:41.009 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
12:15:41.009 Debug GVPReportingServer ReportingServer GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed
[/quote]

Have you any idea ?

Thanks

[René]

Hi,

Reporting Server cannot connect to database thus it shutdown itself.

[b]nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection[/b]

Check that parameters in 'persistence' section are correct.

R.

[genecool]

Thank you for your response however, I have already check database connection parameters into 'persistence' section.

My particularity is that I have a SQL instance. Do you know how to specify it in the settings?

[cavagnaro]

If using MSSQL: The instance have a TCP Port, right? If not enable it on the MSSQL server settings.
Then on your connection chain the server name should be "server:port" and then it will recognize the instance automatically. Usually MSSQL uses port 1433 as the standard for the default instance but each instance can have its own TCP port, then the client will connect directly to this.
Regards

[genecool]

Ok, so, I had an error in my jdbc string connection.

After having corrected it, I still have an error.

Indeed, Reporting Server initializes indefinitely...

Logs are the following :

[quote]
18:37:08.702 Trace GVPReportingServer  ReportingServer GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
18:37:08.710 Debug GVPReportingServer  ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server'processing configuration update
18:37:08.714 Debug GVPReportingServer  ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051
18:37:08.714 Debug GVPReportingServer  ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://192.168.10.65:5051
18:37:08.714 Trace GVPReportingServer  ReportingServer GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server 'Message Server' at host '192.168.10.65', port 5051
18:37:08.714 Trace GVPReportingServer  ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
18:37:08.734 Standard GVPReportingServer  ReportingServer GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer 'CFGMessageServer' at host '192.168.10.65', port 5051
18:37:08.734 Debug GVPReportingServer  ReportingServer GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService start of fireServerContacted()
18:37:08.765 Trace GVPReportingServer  ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080
18:37:08.804 Debug GVPReportingServer  ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook
18:37:08.804 Debug GVPReportingServer  ReportingServer GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated
18:37:08.804 Trace GVPReportingServer  ReportingServer GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999
18:37:08.804 Standard GVPReportingServer  ReportingServer GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
18:37:08.812 Standard GVPReportingServer  ReportingServer GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999
18:37:08.812 Trace GVPReportingServer  ReportingServer GCTI-153-20001 com.genesyslab.commons.lca.LCAManager  Reporting Server initializing in 'standalone' mode
18:37:08.812 Trace GVPReportingServer  ReportingServer GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is false. Using configuration - [Ljava.lang.String;@29f93b
18:37:09.683 Trace GVPReportingServer  ReportingServer GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
[/quote]

... and nothing else !

[ndongo]

Hello,

I have similar problem with my Reporting Server.
The release is 8.1.502.67. All Genesys prerequises have been correctly setted.
My database is Oracle 11g RAC with partitionning feature.
The probleme is, I cannot start the RS in DB mode and have a JDBC exception like "Cannot open connection".
I have tried all JDBC url to connect the DB but everytime I encounter the same error.

Here's the log message

[quote]18:07:59.142 Trace HOSTRS RS_Dev_OSWin GCTI-153-04100 com.genesyslab.commons.log4j.LoggingManager Logging service started
18:07:59.160 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionSettingProcessor Connection Settings listener for 'Message Server'processing configuration update
18:07:59.161 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService Starting Warm Standby service for CFGMessageServer at Message ServerPRIMARY - tcp://xxx.xxx.xxx.xxx:4335
18:07:59.162 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.ConnectionManagementService request to establish automatic primary/backup reconnect procedure accepted on connection with:CFGMessageServer at Message ServerPRIMARY - tcp://xxx.xxx.xxx.xxx:4335
18:07:59.162 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.ConnectionManagementService Connecting to Message Server 'Message Server' at host 'xxx.xxx.xxx.xxx', port 4335
18:07:59.167 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Successfully obtained configuration from configuration server.
18:07:59.192 Trace HOSTRS RS_Dev_OSWin GCTI-153-20050 com.gvp.rpt.snmp.agentx.subagent.RSSubagent No AgentX Master Agent found in Application Connections
18:07:59.193 Trace HOSTRS RS_Dev_OSWin GCTI-153-20043 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Starting SNMP AgentX Subagent
18:07:59.209 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.ConnectionManagementService Connected to CFGMessageServer 'CFGMessageServer' at host 'xxx.xxx.xxx.xxx', port 4335
18:07:59.246 Trace HOSTRS RS_Dev_OSWin GCTI-153-20044 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Exit SNMP AgentX Subagent
18:07:59.329 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService Creating HTTP connector on: 8080
18:07:59.409 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager activate JVM shutdown hook
18:07:59.410 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is initiated
18:07:59.410 Trace HOSTRS RS_Dev_OSWin GCTI-153-04500 com.genesyslab.commons.lca.LCAManager Connecting to Local Control Agent 'LCA' at host 'localhost', port 4999
18:07:59.411 Standard HOSTRS RS_Dev_OSWin GCTI-153-05061 com.gvp.rpt.service.StandAloneReportingService Initialization completed
18:07:59.424 Standard HOSTRS RS_Dev_OSWin GCTI-153-04503 com.genesyslab.commons.lca.LCAManager Connected to Local Control Agent 'LCA' at host 'localhost', port 4999
18:07:59.427 Trace HOSTRS RS_Dev_OSWin GCTI-153-20001 com.genesyslab.commons.lca.LCAManager  Reporting Server initializing in 'standalone' mode
18:07:59.428 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.StandAloneReportingService PARTITIONING_ENABLED is true. Using configuration - [Ljava.lang.String;@13816e0
18:08:01.946 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Building new Hibernate SessionFactory
18:08:04.627 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.dao.SessionFactoryBean Closing opened DB session.
18:08:06.046 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean Supported JMS broker connections: UNENCRYPTED
18:08:06.047 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.service.RSBrokerFactoryBean JMS broker listening on: tcp://0.0.0.0:61616?transport.closeAsync=false
18:08:06.488 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Partitioning Job INIT STARTED 1344269286488
18:08:06.544 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.partitioning.PartitionMaintenanceJob Failed to archive - RMCallDetailRecord org.hibernate.exception.GenericJDBCException: Cannot open connection
18:08:08.067 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.gvp.rpt.dao.SessionFactoryBean Closing Hibernate SessionFactory
18:08:08.071 Standard HOSTRS RS_Dev_OSWin GCTI-153-40000 com.gvp.rpt.service.StandAloneReportingService Unable to start RS application context, shutting down. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'partitioningService' defined in class path resource [partitioning.config.xml]: Invocation of init method failed; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection
18:08:08.073 Standard HOSTRS RS_Dev_OSWin GCTI-153-30001 com.genesyslab.commons.lca.LCAManager Reporting Server is unable to change its runtime mode
18:08:08.073 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
18:08:08.074 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
18:08:08.076 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
18:08:08.076 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
18:08:08.182 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
18:08:08.187 Trace HOSTRS RS_Dev_OSWin GCTI-153-04109 com.genesyslab.commons.log4j.LoggingManager Logging service stopped
18:08:08.200 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Message ServerPRIMARY - tcp://xxx.xxx.xxx.xxx:4335 successfully shut down.
18:08:08.204 Trace HOSTRS RS_Dev_OSWin GCTI-153-20000 com.genesyslab.commons.ConnectionManagementService Connection to Configuration ServerPRIMARY - tcp://confservhost:4320 successfully shut down.
18:08:08.205 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed
18:08:08.207 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Async init of LCAManager is completed.
18:08:08.211 Standard HOSTRS RS_Dev_OSWin GCTI-153-04505 com.genesyslab.commons.lca.LCAManager Disconnected from Local Control Agent 'LCA'
18:08:08.214 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager Shutdown of LCAManager is completed.
18:08:08.214 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.genesyslab.commons.lca.LCAManager LCA Protocol channel listener removed.
18:08:08.214 Standard HOSTRS RS_Dev_OSWin GCTI-153-05063 com.gvp.rpt.service.StandAloneReportingService Normal termination
18:08:08.320 Interaction HOSTRS RS_Dev_OSWin GCTI-153-30000 com.genesyslab.commons.lca.LCAManager Unexpected JVM shutdown detected. Application will attempt to terminate gracefully
18:08:08.320 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Unregistering RS SNMP AgentX Subagent
18:08:08.321 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.snmp.agentx.subagent.RSSubagent Stopping RS AgentX Subagent.
18:08:08.325 Trace HOSTRS RS_Dev_OSWin GCTI-153-20048 com.gvp.rpt.snmp.agentx.subagent.RSSubagent SNMP AgentX Subagent stopped
18:08:08.325 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Stopping Restlet listening service
18:08:08.326 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Closing RS Configuration/Management context
18:08:08.326 Debug HOSTRS RS_Dev_OSWin GCTI-153-09900 com.gvp.rpt.service.StandAloneReportingService Cleanup sequence is completed[/quote]


Any idea please?

Thanks in advance

[genecool]

Check your Java version.

To solve this issue, I have downgrade my JRE.

[ndongo]

Thanks for your feedback,

I am currently using the jdk1.6.0_31. Do you reminber which version you used to solve the issue?

Thanks in advance

[cavagnaro]

Install according to the documentation...it is specified there.
Get another Java test tool and try to do an ODBC connection on that way.
Message is clear, your connection settings are wrong. Oracle can be very specific.
Also validate the Oracle version is supported just in case if you haven't done it already

[genecool]

Currently I use Java(TM) SE Runtime Environment build 1.6.0_27-b07

[ndongo]

Hello,

In the 81gvp_dep.pdf they talk about Sun JRE 6.19, Update 5,.
I have found in oracle website only JRE 1.60_19 and have installed it. However, the problem is exactly the same that in the log I have previously posted.

I don't no if JRE 1.60_19 is the same thing that Sun JRE 6.19, Update 5? If not could some give me where I can find the right Java version?

Also, do you know an easy tool to test the JDBC connection? My DBMS is Oracle RAC 11g. Genesys tells that it is compatible with the RS 8.1.502.67 I am using.

Thanks in advance for your help

[Kubig]

I use java version 1.6.0_32 and all works fine. Make sure that you have got correctly filled file "JavaServerStarter",which is in install directory of GVP-RS and section "persistence" on GVP-RS application object in CME(or GA) - in this section you can set jdbc url,db passwd,etc.

[ndongo]

Hello,

My "JavaServerStarter" seems to be Ok, here is the content of the file.
[quote][Service]
AppTitle="VP Reporting Server"
AppVersion=8.1.502.67

JVMPath=C:\Program Files (x86)\Java\jre6\bin\client\jvm.dll


MainClass=com/gvp/rpt/service/StandAloneReportingService

EventHandlerMethod=stopWinService


[JavaArgs]
-Xmx1536M
-Xrs=YES


[Djava.class.path]
.\ems-rs.jar
.\mf-service.jar
.\rpt-core.jar
.\rpt-services.jar
.\libs\activemq-core.jar
.\libs\activemq-pool.jar
.\libs\antlr-2.7.6.jar
.\libs\asm-attrs.jar
.\libs\asm.jar
.\libs\cglib-2.1.3.jar
.\libs\com.noelios.restlet.ext.jetty.jar
.\libs\com.noelios.restlet.jar
.\libs\comappblock.jar
.\libs\commons-collections-3.1.jar
.\libs\commons-collections-3.2.1.jar
.\libs\commons-dbcp-1.2.2.jar
.\libs\commons-io-1.3.2.jar
.\libs\commons-lang-2.3.jar
.\libs\commons-logging.jar
.\libs\commons-pool-1.4.jar
.\libs\commons.jar
.\libs\concurrent.jar
.\libs\configurationprotocol.jar 
.\libs\connection.jar
.\libs\dom4j-1.6.1.jar
.\libs\hibernate3.jar  
.\libs\j2ee-management.jar
.\libs\javax.servlet.jar  
.\libs\jaxb-api.jar
.\libs\jaxb-impl.jar  
.\libs\jdbc2_0-stdext.jar
.\libs\jibx-run.jar  
.\libs\jms.jar
.\libs\jta.jar  
.\libs\kvlistbinding.jar
.\libs\kvlists.jar    
.\libs\logging.jar
.\libs\warmstandbyappblock.jar
.\libs\managementprotocol.jar  
.\libs\messagebrokerappblock.jar
.\libs\namespace.jar  
.\libs\ojdbc14.jar
.\libs\org.json.jar    
.\libs\org.mortbay.jetty.ajp.jar
.\libs\org.mortbay.jetty.https.jar
.\libs\org.mortbay.jetty.jar
.\libs\org.mortbay.jetty.util.jar
.\libs\org.restlet.jar
.\libs\protocol.jar    
.\libs\protocolmanagerappblock.jar
.\libs\quartz-1.6.0.jar  
.\libs\relaxngDatatype.jar
.\libs\reportingprotocol.jar
.\libs\slf4j-api.jar
.\libs\log4j-over-slf4j-1.5.11.jar
.\libs\jcl-over-slf4j-1.5.11.jar
.\libs\jul-to-slf4j-1.5.11.jar
.\libs\spring.jar
.\libs\sqljdbc.jar
.\libs\system.jar
.\libs\xbean-spring-3.6.jar
.\libs\xsdlib.jar
.\libs\snmp4j-1.11.1.jar
.\libs\snmp4j-agent-1.4.1.jar
.\libs\snmp4j-agentx-1.3.1a.jar
.\libs\log4j.jar
.\libs\netty-3.2.3.Final.jar
.\libs\org.osgi.core-4.1.0.jar
.\libs\kahadb-5.3.2.jar
[/quote]


Also my RS starts and works correctly when I am in No DB mode (working without DataBase). I mean when the option rs.nodb.enabled = Enable 'No DB' Mode.

I have checked the parameters to connect to the DB (in the persistence section), with SQL Developer I connect correctly the DB. But the RS is unable to open a JDBC connection to the database when I am in DB mode. That's why I am asking of there is an easy tool in order to test a JDBC connection to an Oracle DB

Thanks in advance for ideas.

[Kubig]

Are you sure that the "persistent" section is configured correctly?

hibernate.remote.database = <DB_NAME>
password = <DB_PASSWORD>
hibernate.remote.url = jdbc:...
hibernate.remote.user= <DB_USERNAME>

If yes,could you please try to set option "rs.partitiong.enabled" to false and try to start RS and check log - if the error is in settings,the cause will be same,but the error message will be different.

[René]

Hi,

Can you post here your [persistence] section? Feel free to change names and/or IP addresses for security reasons.

What type and version of database you have?

R.