Combined hibernate and logging configuration files for orkweb and orktrack.

Please refer to new documentation regarding manual deployment of orkweb and orktrack.

git-svn-id: https://oreka.svn.sourceforge.net/svnroot/oreka/trunk@571 09dcff7a-b715-0410-9601-b79a96267cd0

5 files changed, 114 insertions, 59 deletions

diff --git a/orkbasej/java/database-example.hbm.xml b/orkbasej/java/database-example.hbm.xml
new file mode 100644
index 0000000..73a5a04
--- /dev/null
+++ b/orkbasej/java/database-example.hbm.xml
@@ -0,0 +1,21 @@
+<?xml version="1.0" encoding="UTF-8"?>

+<!DOCTYPE hibernate-configuration PUBLIC

+		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"

+		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

+<hibernate-configuration>

+    <session-factory>    

+	<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>

+	<property name="hibernate.connection.maxconnections">100</property>

+	<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

+	<property name="hibernate.connection.url">jdbc:mysql://localhost/test</property>

+	<property name="hibernate.connection.password">password</property>

+	<property name="hibernate.connection.username">root</property>

+	

+	<property name="hibernate.hbm2ddl.auto">update</property> <!-- update, create, create-drop -->

+	<property name="hibernate.show_sql">false</property>	

+	

+	<property name="hibernate.jdbc.use_scrollable_resultset">true</property>

+	<property name="hibernate.max_fetch_depth">1</property>

+	<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

+    </session-factory>

+</hibernate-configuration>
\ No newline at end of file
diff --git a/orkbasej/java/mysql.hbm.template.xml b/orkbasej/java/database.hbm.xml
index 3806981..af84017 100644
--- a/orkbasej/java/mysql.hbm.template.xml
+++ b/orkbasej/java/database.hbm.xml
@@ -1,19 +1,21 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE hibernate-configuration PUBLIC
-		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
-		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
-<hibernate-configuration>
-    <session-factory>    
-	<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
-	<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
-	<property name="hibernate.connection.url">jdbc:mysql://localhost/test</property>
-	<property name="hibernate.connection.password">password</property>
-	<property name="hibernate.connection.username">root</property>
-	
-	<property name="hibernate.hbm2ddl.auto">update</property> <!-- update, create, create-drop -->
-	<property name="hibernate.show_sql">false</property>	
-	
-	<property name="hibernate.max_fetch_depth">1</property>
-	<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
-    </session-factory>
-</hibernate-configuration>
+<?xml version="1.0" encoding="UTF-8"?>

+<!DOCTYPE hibernate-configuration PUBLIC

+		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"

+		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

+<hibernate-configuration>

+    <session-factory>    

+	<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>

+	<property name="hibernate.connection.maxconnections">100</property>

+	<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

+	<property name="hibernate.connection.url">jdbc:mysql://localhost/test</property>

+	<property name="hibernate.connection.password">password</property>

+	<property name="hibernate.connection.username">root</property>

+	

+	<property name="hibernate.hbm2ddl.auto">update</property> <!-- update, create, create-drop -->

+	<property name="hibernate.show_sql">false</property>	

+	

+	<property name="hibernate.jdbc.use_scrollable_resultset">true</property>

+	<property name="hibernate.max_fetch_depth">1</property>

+	<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

+    </session-factory>

+</hibernate-configuration>

diff --git a/orkbasej/java/log4j.template.properties b/orkbasej/java/log4j.template.properties
deleted file mode 100644
index af9e970..0000000
--- a/orkbasej/java/log4j.template.properties
+++ /dev/null
@@ -1,40 +0,0 @@
-### stdout ###
-log4j.appender.stdout=org.apache.log4j.ConsoleAppender
-log4j.appender.stdout.Target=System.out
-log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
-log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
-
-### logfile ###
-log4j.appender.file=org.apache.log4j.FileAppender
-log4j.appender.file.File=c:\oreka\oreka.log
-log4j.appender.file.layout=org.apache.log4j.PatternLayout
-log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
-
-# HUB is a socket hub appender
-#log4j.appender.HUB=org.apache.log4j.net.SocketHubAppender
-#log4j.appender.HUB.layout=org.apache.log4j.PatternLayout
-#log4j.appender.HUB.layout.ConversionPattern=[cc]%d{MMM-dd HH:mm:ss} %-14.14c{1}- %m%n
-#log4j.appender.HUB.port=9000
-
-log4j.rootLogger=info, file, stdout
-
-#################
-### Hibernate logging
-log4j.logger.org.hibernate=info
-#log4j.logger.org.hibernate=debug
-### log just the SQL
-#log4j.logger.org.hibernate.SQL=debug
-### log JDBC bind parameters ###
-log4j.logger.org.hibernate.type=info
-#log4j.logger.org.hibernate.type=debug
-### log schema export/update ###
-log4j.logger.org.hibernate.tool.hbm2ddl=info
-### log HQL parse trees
-#log4j.logger.org.hibernate.hql=debug
-### log cache activity ###
-#log4j.logger.org.hibernate.cache=debug
-### log JDBC resource acquisition
-#log4j.logger.org.hibernate.jdbc=debug
-### enable the following line if you want to track down connection ###
-### leakages when using DriverManagerConnectionProvider ###
-#log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace
diff --git a/orkbasej/java/logging-example.properties b/orkbasej/java/logging-example.properties
new file mode 100644
index 0000000..f0c657e
--- /dev/null
+++ b/orkbasej/java/logging-example.properties
@@ -0,0 +1,36 @@
+### stdout ###
+log4j.appender.stdout=org.apache.log4j.ConsoleAppender
+log4j.appender.stdout.Target=System.out
+log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
+#log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %c %5p %C{1}:%L - %m%n
+log4j.appender.stdout.layout.ConversionPattern=%d{ISO8601} %c %5p - %m%n

+
+### orkweb.log ###
+log4j.appender.file=org.apache.log4j.RollingFileAppender
+log4j.appender.file.File=c:/orkweb.log

+log4j.appender.file.MaxFileSize=7000KB

+log4j.appender.file.MaxBackupIndex=20
+log4j.appender.file.layout=org.apache.log4j.PatternLayout
+log4j.appender.file.layout.ConversionPattern=%d{ISO8601} %c %5p - %m%n

+

+### orklicense.log ###

+log4j.logger.net.sf.oreka.orkweb.LicenseManager=info, license

+log4j.appender.license=org.apache.log4j.RollingFileAppender

+log4j.appender.license.File=c:/orklicense.log

+log4j.appender.license.MaxFileSize=200KB

+log4j.appender.license.MaxBackupIndex=3

+log4j.appender.license.layout=org.apache.log4j.PatternLayout

+log4j.appender.license.layout.ConversionPattern=%d{ISO8601} %c %5p - %m%n
+

+log4j.rootLogger=info, file, stdout

+log4j.logger.net.sf.oreka=info

+log4j.logger.net.sf.oreka.orktrack=info

+log4j.logger.org.hibernate=error

+log4j.logger.org.hibernate.SQL=off

+log4j.logger.org.apache.tapestry=info

+log4j.logger.tapestry=error

+log4j.logger.org.apache.hivemind=info

+log4j.logger.hivemind=error

+log4j.logger.org.logicalcobwebs.proxool=error

+log4j.logger.org.apache.catalina=error

+log4j.logger.uk.ltd.getahead=warn

diff --git a/orkbasej/java/logging.properties b/orkbasej/java/logging.properties
new file mode 100644
index 0000000..f0c657e
--- /dev/null
+++ b/orkbasej/java/logging.properties
@@ -0,0 +1,36 @@
+### stdout ###
+log4j.appender.stdout=org.apache.log4j.ConsoleAppender
+log4j.appender.stdout.Target=System.out
+log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
+#log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %c %5p %C{1}:%L - %m%n
+log4j.appender.stdout.layout.ConversionPattern=%d{ISO8601} %c %5p - %m%n

+
+### orkweb.log ###
+log4j.appender.file=org.apache.log4j.RollingFileAppender
+log4j.appender.file.File=c:/orkweb.log

+log4j.appender.file.MaxFileSize=7000KB

+log4j.appender.file.MaxBackupIndex=20
+log4j.appender.file.layout=org.apache.log4j.PatternLayout
+log4j.appender.file.layout.ConversionPattern=%d{ISO8601} %c %5p - %m%n

+

+### orklicense.log ###

+log4j.logger.net.sf.oreka.orkweb.LicenseManager=info, license

+log4j.appender.license=org.apache.log4j.RollingFileAppender

+log4j.appender.license.File=c:/orklicense.log

+log4j.appender.license.MaxFileSize=200KB

+log4j.appender.license.MaxBackupIndex=3

+log4j.appender.license.layout=org.apache.log4j.PatternLayout

+log4j.appender.license.layout.ConversionPattern=%d{ISO8601} %c %5p - %m%n
+

+log4j.rootLogger=info, file, stdout

+log4j.logger.net.sf.oreka=info

+log4j.logger.net.sf.oreka.orktrack=info

+log4j.logger.org.hibernate=error

+log4j.logger.org.hibernate.SQL=off

+log4j.logger.org.apache.tapestry=info

+log4j.logger.tapestry=error

+log4j.logger.org.apache.hivemind=info

+log4j.logger.hivemind=error

+log4j.logger.org.logicalcobwebs.proxool=error

+log4j.logger.org.apache.catalina=error

+log4j.logger.uk.ltd.getahead=warn