Details
-
Fix
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.13.4
-
None
Description
Current Situation
The Job Streams plugin does not work with SQL Server. The reason for this is a misbehavior of the SQL Server JDBC Driver.
The reporting.hibernate.cfg.xml configuration file for the JobScheduler Master uses a maxPoolSize value 1:
<property name="hibernate.c3p0.maxPoolSize">1</property>
Desired Behavior
the reporting.hibernate.cfg.xml for the JobScheduler Master should set the maxPoolSize value to 3:
<property name="hibernate.c3p0.maxPoolSize">3</property>
This will make the Job Streams work with SQL Server databases.
Workaround
Change the configuration file manually.
Attachments
Issue Links
- relates to
-
JITL-623 SOSHibernate: SQL Server set LOCK_TIMEOUT command should not create a new connection
- Known Issue