PageRenderTime 31ms CodeModel.GetById 29ms RepoModel.GetById 1ms app.codeStats 0ms

/lib/apache-log4j/contribs/ThomasFenner/configfile_example.txt

https://bitbucket.org/arkban/somersault
Plain Text | 52 lines | 38 code | 14 blank | 0 comment | 0 complexity | eef131e06a3112f63ddebf3a2223e1bb MD5 | raw file
Possible License(s): LGPL-2.1, BSD-3-Clause, Apache-2.0 
    

  1. # Licensed to the Apache Software Foundation (ASF) under one or more
    2. 

  2. # contributor license agreements.  See the NOTICE file distributed with
    3. 

  3. # this work for additional information regarding copyright ownership.
    4. 

  4. # The ASF licenses this file to You under the Apache License, Version 2.0
    5. 

  5. # (the "License"); you may not use this file except in compliance with
    6. 

  6. # the License.  You may obtain a copy of the License at
    7. 

  7. #
    8. 

  8. #      http://www.apache.org/licenses/LICENSE-2.0
    9. 

  9. #
    10. 

  10. # Unless required by applicable law or agreed to in writing, software
    11. 

  11. # distributed under the License is distributed on an "AS IS" BASIS,
    12. 

  12. # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    13. 

  13. # See the License for the specific language governing permissions and
    14. 

  14. # limitations under the License.
    15. 

  15. 

  16. # Here is a Configuration-file example, which can be used with the PropertyConfigurator :
    17. 

  17. 

  18. 

  19. 

  20. # Declare a appender variable named JDBC
    21. 

  21. log4j.rootCategory=JDBC
    22. 

  22. 

  23. # JDBC is a class of JDBCAppender, which writes messages into a database
    24. 

  24. log4j.appender.JDBC=JDBCAppender
    25. 

  25. 

  26. # 1. Database-options to connect to the database
    27. 

  27. log4j.appender.JDBC.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=LENZI)(Port=1521))(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=LENZI)(Port=1526)))(CONNECT_DATA=(SID=LENZI)))
    28. 

  28. log4j.appender.JDBC.username=mex_pr_dev60
    29. 

  29. log4j.appender.JDBC.password=mex_pr_dev60
    30. 

  30. 

  31. # 2. Connector-option to specify your own JDBCConnectionHandler
    32. 

  32. #log4j.appender.JDBC.connector=MyConnectionHandler
    33. 

  33. 

  34. # 3. SQL-option to specify a static sql-statement which will be performed with every occuring message-event
    35. 

  35. #log4j.appender.JDBC.sql=INSERT INTO LOGTEST (id, msg, created_on, created_by) VALUES (1, @MSG@, sysdate, 'me')
    36. 

  36. 

  37. # 4. Table-option to specify one table contained by the database
    38. 

  38. log4j.appender.JDBC.table=logtest
    39. 

  39. 

  40. # 5. Columns-option to describe the important columns of the table (Not nullable columns are mandatory to describe!)
    41. 

  41. log4j.appender.JDBC.columns=id_seq~EMPTY	id~ID~MyIDHandler	msg~MSG	created_on~TIMESTAMP	created_by~STATIC~Thomas Fenner (t.fenner@klopotek.de)
    42. 

  42. 

  43. # 6. Layout-options to define the layout of the messages (optional)
    44. 

  44. #log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout
    45. 

  45. #log4j.appender.JDBC.layout.ConversionPattern=%m
    46. 

  46. 

  47. # 7. Buffer-option to define the size of the message-event-buffer (optional)
    48. 

  48. #log4j.appender.JDBC.buffer=1
    49. 

  49. 

  50. # 8. Commit-option to define a auto-commitment (optional)
    51. 

  51. #log4j.appender.JDBC.commit=Y
    52. 

  52. 

  53.