Internet Shop in Ajax

From Elvanör's Technical Wiki
Jump to navigation Jump to search

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. direct log messages to stdout ###
  1. log4j.appender.stdout=org.apache.log4j.ConsoleAppender
  2. log4j.appender.stdout.Target=System.out
  3. log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
  4. log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
      1. direct messages to file hibernate.log ###
  1. log4j.appender.file=org.apache.log4j.FileAppender
  2. log4j.appender.file.File=hibernate.log
  3. log4j.appender.file.layout=org.apache.log4j.PatternLayout
  4. log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n
      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. log HQL query parser activity
  1. log4j.logger.org.hibernate.hql.ast.AST=debug
      1. log just the SQL

log4j.logger.org.hibernate.SQL=debug

      1. log JDBC bind parameters ###
  1. log4j.logger.org.hibernate.type=info
  2. log4j.logger.org.hibernate.type=debug
      1. log schema export/update ###
  1. log4j.logger.org.hibernate.tool.hbm2ddl=debug
      1. log HQL parse trees
  1. log4j.logger.org.hibernate.hql=debug
      1. log cache activity ###
  1. log4j.logger.org.hibernate.cache=debug
      1. log transaction activity
  1. log4j.logger.org.hibernate.transaction=debug
      1. log JDBC resource acquisition
  1. log4j.logger.org.hibernate.jdbc=debug
      1. enable the following line if you want to track down connection ###
      2. leakages when using DriverManagerConnectionProvider ###
  1. log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=trace