Ubik Batch Server FAQ
From UbikWiki
(→Administration) |
(→How do I set a JDBC connection property) |
||
Line 2: |
Line 2: | ||
=== How do I set a JDBC connection property === | === How do I set a JDBC connection property === | ||
Use the Ubik Web Controler or open <INSTALL_DIR>/config/datasource.xml and add or modify for your pool the parameter connectionProperties(Format of the string must be [propertyName=property;]*: | Use the Ubik Web Controler or open <INSTALL_DIR>/config/datasource.xml and add or modify for your pool the parameter connectionProperties(Format of the string must be [propertyName=property;]*: | ||
| - | < | + | <source lang="xml"> |
<parameter> | <parameter> | ||
<name>connectionProperties</name> | <name>connectionProperties</name> | ||
<value>currentSchema=TEST</value> | <value>currentSchema=TEST</value> | ||
</parameter></source> | </parameter></source> | ||
| + | |||
===How do I change the retention period for Batches History in Database === | ===How do I change the retention period for Batches History in Database === | ||
Open the file <INSTALL_DIR>/config/config.properties and change: | Open the file <INSTALL_DIR>/config/config.properties and change: | ||
Revision as of 17:47, 18 November 2007
Administration
How do I set a JDBC connection property
Use the Ubik Web Controler or open <INSTALL_DIR>/config/datasource.xml and add or modify for your pool the parameter connectionProperties(Format of the string must be [propertyName=property;]*:
<parameter> <name>connectionProperties</name> <value>currentSchema=TEST</value> </parameter>
How do I change the retention period for Batches History in Database
Open the file <INSTALL_DIR>/config/config.properties and change:
# Cleanup delay in days for tables BATCH_HEAD and BATCH_TRT CLEANUP_DELAY=30
How do I setup my mail server parameters
Open the file <INSTALL_DIR>/config/mail.xml and change:
<?xml version="1.0" encoding="UTF-8"?> <!-- #Release @VERSION@ at @DATE@ --> <mail> <mailHost>smtp.ubik-ingenierie.com</mailHost> <mailer>UbikBatch</mailer> <mailPort>25</mailPort> </mail>
How do I declare my custom plugin
Open the file <INSTALL_DIR>/config/plugin-manager.xml and add:
<plug-in className="com.ubikingenierie.console.monitoring.plugin.HealthMonitorPlugin"
id="com.ubikingenierie.console.monitoring.plugin.HealthMonitorPlugin">
<set-property property="propertyOfClass" value="valueToSet"></set-property>
...
<set-property property="otherValue" value="3000000"></set-property>
</plug-in>How do I declare my custom extension
Open the file <INSTALL_DIR>/config/extension-manager.xml and add:
<extension className="com.ubikingenierie.console.si3si.extension.SI3SIExtension" > </extension>
I get the following message on deployment of a big BAR
java.lang.OutOfMemoryError: PermGen space
Ensure you use the last JDK 5 available version Open <INSTALL_DIR>/bin/setEnv.bat or <INSTALL_DIR>/bin/setenv.cfg and set correctly the PermGen space using JAVA_OPTS:
-XX:MaxPermSize=128M
My database type is not correctly detected
Open <INSTALL_DIR>/config/config.properties and set HIBERNATE_CONFIGURED_DIALECT:
# Force a dialect for Hibernate to override auto detection # For DB2 : com.ubikingenierie.console.persistance.hibernate.DB2ExtendedDialect(*) HIBERNATE_CONFIGURED_DIALECT=org.hibernate.dialect.MySQL5InnoDBDialect
(*) : see DB2Dialect.getCurrentTimestampSQLFunctionName() uses Oracle syntax
I have the following messages in the logs
11:49:27,464 WARN LoadContexts? fail-safe cleanup (collections)... org.hibernate.engine.loading.CollectionLoadContext@cd7045<rs=org.hsqldb.jdbc.jdbcResultSet@192e6b6>
Nothing's wrong, it's a small issue that will be resolved in future versions of Hibernate, since it's indirectly a logging issue, you can hide those messages by adding:
log4j.category.org.hibernate.engine.loading.LoadContexts=ERROR
In <INSTALL_DIR>/config/log.properties
Authors
- Philippe Mouawad
