Product Knowledge Base

Space shortcuts

Page tree

Versions Compared

Old Version 13

changes.mady.by.user Andreas Püschel

Saved on

compared with

New Version 14

changes.mady.by.user Andreas Püschel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you are using the Managed Jobs then the file ./web/custom/custom_inc.php have to configure too.
See here.

Examples for the Configuration of factory.ini, hibernate.cfg.xml and sos_settings.ini

MySQL

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=scheduler -password=scheduler
 db_class               = SOSMySQLConnection
 ...

...

Code Block
 [configuration]
 class         = SOSMySQLConnection
 driver        = com.mysql.jdbc.Driver
 url           = jdbc:mysql://localhost:3306/scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

MySQL via mariaDB

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=org.mariadb.jdbc.Driver jdbc:mysql://localhost:3306/scheduler -user=scheduler -password=scheduler
 db_class               = SOSMySQLConnection
 ...

...

Code Block
 [configuration]
 class         = SOSMySQLConnection
 driver        = org.mariadb.jdbc.Driver
 url           = jdbc:mysql://localhost:3306/scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

Oracle

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:scheduler -user=scheduler -password=scheduler
 db_class               = SOSOracleConnection
 ...

...

Code Block
 [configuration]
 class         = SOSOracleConnection
 driver        = oracle.jdbc.driver.OracleDriver
 url           = jdbc:oracle:thin:@localhost:1521:scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

Microsoft SQL Server

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler -user=scheduler -password=scheduler
 db_class               = SOSMSSQLConnection
 ...

...

Code Block
 [configuration]
 class         = SOSMSSQLConnection
 driver        = com.microsoft.sqlserver.jdbc.SQLServerDriver
 url           = jdbc:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

Microsoft SQL Server via jTDS

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler -user=scheduler -password=scheduler
 db_class               = SOSMSSQLConnection
 ...

...

Code Block
 [configuration]
 class         = SOSMSSQLConnection
 driver        = net.sourceforge.jtds.jdbc.Driver
 url           = jdbc:jtds:sqlserver://localhost:1433;sendStringParametersAsUnicode=false;selectMethod=cursor;databaseName=scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

PostgreSQL

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=org.postgresql.Driver jdbc:postgresql://localhost:5432/scheduler -user=scheduler -password=scheduler
 db_class               = SOSPgSQLConnection
 ...

...

Code Block
 [configuration]
 class         = SOSPgSQLConnection
 driver        = org.postgresql.Driver
 url           = jdbc:postgresql://localhost:5432/scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

DB2

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=com.ibm.db2.jcc.DB2Driver jdbc:db2://localhost:50000/scheduler:driverType=2;retrieveMessagesFromServerOnGetMessage=true; -user=scheduler -password=scheduler
 db_class               = SOSDB2Connection
 ...

...

Code Block
 [configuration]
 class         = SOSDB2Connection
 driver        = com.ibm.db2.jcc.DB2Driver
 url           = jdbc:db2://localhost:50000/scheduler:driverType=2;retrieveMessagesFromServerOnGetMessage=true;
 user          = scheduler
 password      = scheduler
 compatibility = normal

Sybase

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=com.sybase.jdbc3.jdbc.SybDriver jdbc:sybase:Tds:localhost:5000/scheduler -user=scheduler -password=scheduler
 db_class               = SOSSybaseConnection
 ...

...

Code Block
 [configuration]
 class         = SOSSybaseConnection
 driver        = com.sybase.jdbc3.jdbc.SybDriver
 url           = jdbc:sybase:Tds:localhost:5000/scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

Sybase via jTDS

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=net.sourceforge.jtds.jdbc.Driver jdbc:jtds:sybase://localhost:5000/scheduler -user=scheduler -password=scheduler
 db_class               = SOSSybaseConnection
 ...

...

Code Block
 [configuration]
 class         = SOSSybaseConnection
 driver        = net.sourceforge.jtds.jdbc.Driver
 url           = jdbc:jtds:sybase://localhost:5000/scheduler
 user          = scheduler
 password      = scheduler
 compatibility = normal

Firebird

factory.ini:

Code Block
 [spooler]
 ...
 db                     = jdbc -class=org.firebirdsql.jdbc.FBDriver jdbc:firebirdsql://localhost:3050/scheduler -user=scheduler -password=scheduler
 db_class               = SOSFbSQLConnection
 ...

...