Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.98 KB | None | 0 0
  1. <JDBC name="databaseAppender" tableName="APPLICATION_LOG">
  2. <ConnectionFactory class="com.yauhenikuntsevich.training.onlinestore.services.utils.ConnectionToDB"
  3. method="openConnectionToDB" />
  4. <Column name="EVENT_ID" literal="APPLICATION_LOG_SEQUENCE.NEXTVAL" />
  5. <Column name="EVENT_DATE" isEventTimestamp="true" />
  6. <Column name="LEVEL" pattern="%level" />
  7. <Column name="LOGGER" pattern="%logger" />
  8. <Column name="MESSAGE" pattern="%message" />
  9. <Column name="THROWABLE" pattern="%ex{full}" />
  10. </JDBC>
  11.  
  12. package com.yauhenikuntsevich.training.onlinestore.services.utils;
  13.  
  14. import java.sql.Connection;
  15. import java.sql.DriverManager;
  16.  
  17. public class ConnectionToDB {
  18. private static final String URL = "jdbc:postgresql://localhost:5432/onlinestore";
  19. private static final String USER_NAME = "postgres";
  20. private static final String PASSWORD = "postgres1";
  21.  
  22. public static Connection openConnectionToDB() {
  23. try {
  24. return DriverManager.getConnection(URL, USER_NAME, PASSWORD);
  25. } catch (Exception e) {
  26. System.out.println("Сonnection failed");
  27. e.printStackTrace();
  28. }
  29. return null;
  30. }
  31. }
  32.  
  33. 2016-12-08 21:20:10,229 ERROR Unable to write to database [jdbcManager{ description=databaseAppender, bufferSize=0, connectionSource=factory{ public static java.sql.Connection com.yauhenikuntsevich.training.onlinestore.services.utils.ConnectionToDB.openConnectionToDB() }, tableName=APPLICATION_LOG, columns=[ { name=EVENT_ID, layout=null, literal=APPLICATION_LOG_SEQUENCE.NEXTVAL, timestamp=false }, { name=EVENT_DATE, layout=null, literal=null, timestamp=true }, { name=LEVEL, layout=%level, literal=null, timestamp=false }, { name=LOGGER, layout=%logger, literal=null, timestamp=false }, { name=MESSAGE, layout=%message, literal=null, timestamp=false }, { name=THROWABLE, layout=%ex{full}, literal=null, timestamp=false } ] }] for appender [databaseAppender]. org.apache.logging.log4j.core.appender.AppenderLoggingException: Failed to insert record for log event in JDBC manager: Метод org.postgresql.jdbc.PgPreparedStatement.setNString(int, String) ещё не реализован
  34.  
  35. at org.apache.logging.log4j.core.appender.db.jdbc.JdbcDatabaseManager.writeInternal(JdbcDatabaseManager.java:125)
  36. at org.apache.logging.log4j.core.appender.db.AbstractDatabaseManager.write(AbstractDatabaseManager.java:167)
  37. at org.apache.logging.log4j.core.appender.db.AbstractDatabaseAppender.append(AbstractDatabaseAppender.java:105)
  38. at org.apache.logging.log4j.core.config.AppenderControl.callAppender(AppenderControl.java:99)
  39. at org.apache.logging.log4j.core.config.LoggerConfig.callAppenders(LoggerConfig.java:430)
  40. at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:409)
  41. at org.apache.logging.log4j.core.config.LoggerConfig.log(LoggerConfig.java:367)
  42. at org.apache.logging.log4j.core.Logger.logMessage(Logger.java:112)
  43. at org.apache.logging.slf4j.Log4jLogger.log(Log4jLogger.java:375)
  44. at org.eclipse.jetty.util.log.JettyAwareLogger.log(JettyAwareLogger.java:620)
  45. at org.eclipse.jetty.util.log.JettyAwareLogger.info(JettyAwareLogger.java:314)
  46. at org.eclipse.jetty.util.log.Slf4jLog.info(Slf4jLog.java:74)
  47. at org.eclipse.jetty.util.log.Log.initialized(Log.java:186)
  48. at org.eclipse.jetty.util.log.Log.getLogger(Log.java:288)
  49. at org.eclipse.jetty.util.log.Log.getLogger(Log.java:278)
  50. at org.eclipse.jetty.util.component.AbstractLifeCycle.<clinit>(AbstractLifeCycle.java:35)
  51. at com.yauhenikuntsevich.training.onlinestore.web.StartJetty.main(StartJetty.java:22)
  52.  
  53. Caused by: java.sql.SQLFeatureNotSupportedException: Метод org.postgresql.jdbc.PgPreparedStatement.setNString(int, String) ещё не реализован
  54. at org.postgresql.Driver.notImplemented(Driver.java:646)
  55. at org.postgresql.jdbc.PgPreparedStatement.setNString(PgPreparedStatement.java:1518)
  56. at org.apache.logging.log4j.core.appender.db.jdbc.JdbcDatabaseManager.writeInternal(JdbcDatabaseManager.java:110)
  57. ... 16 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement