Internet Shop in Ajax

SQL Tables

ShopItem

• ID
• ShopID
• Price
• Name
• Auction / Sale
• Image
• Description
• Status
• DateEntered

ShopCategory

• ShopID
• Name
• ID
• Subcategory (boolean)

log4j.rootLogger=info, R log4j.appender.R=org.apache.log4j.RollingFileAppender log4j.appender.R.File=${catalina.home}/logs/tomcat.log log4j.appender.R.MaxFileSize=10MB log4j.appender.R.MaxBackupIndex=10 log4j.appender.R.layout=org.apache.log4j.PatternLayout log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n

1. 1. 1. direct log messages to stdout ###
2. log4j.appender.stdout=org.apache.log4j.ConsoleAppender
3. log4j.appender.stdout.Target=System.out
4. log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
5. log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

1. 1. 1. direct messages to file hibernate.log ###
2. log4j.appender.file=org.apache.log4j.FileAppender
3. log4j.appender.file.File=hibernate.log
4. log4j.appender.file.layout=org.apache.log4j.PatternLayout
5. log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

1. 1. 1. set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.logger.org.apache.catalina=warn, R log4j.logger.org.hibernate=warn, R

1. log4j.rootLogger=warn, stdout

1. log4j.logger.org.hibernate=info
2. log4j.logger.org.hibernate=debug

1. 1. 1. log HQL query parser activity
2. log4j.logger.org.hibernate.hql.ast.AST=debug

1. 1. 1. log just the SQL

log4j.logger.org.hibernate.SQL=debug

1. 1. 1. log JDBC bind parameters ###
2. log4j.logger.org.hibernate.type=info
3. log4j.logger.org.hibernate.type=debug

1. 1. 1. log schema export/update ###
2. log4j.logger.org.hibernate.tool.hbm2ddl=debug

1. 1. 1. log HQL parse trees
2. log4j.logger.org.hibernate.hql=debug

1. 1. 1. log cache activity ###
2. log4j.logger.org.hibernate.cache=debug

1. 1. 1. log transaction activity
2. log4j.logger.org.hibernate.transaction=debug

1. 1. 1. log JDBC resource acquisition
2. log4j.logger.org.hibernate.jdbc=debug

1. 1. 1. enable the following line if you want to track down connection ###
      2. leakages when using DriverManagerConnectionProvider ###
2. log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace