API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 6th, 2019
188
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.21 KB | None | 0 0
raw download clone embed print report
  1. java.lang.IllegalStateException: Failed to execute CommandLineRunner
  2. at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:735) ~[spring-boot-1.5.7.RELEASE.jar:1.5.7.RELEASE]
  3. at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:716) ~[spring-boot-1.5.7.RELEASE.jar:1.5.7.RELEASE]
  4. at org.springframework.boot.SpringApplication.afterRefresh(SpringApplication.java:703) ~[spring-boot-1.5.7.RELEASE.jar:1.5.7.RELEASE]
  5. at org.springframework.boot.SpringApplication.run(SpringApplication.java:304) ~[spring-boot-1.5.7.RELEASE.jar:1.5.7.RELEASE]
  6. at com.ef.Parser.main(Parser.java:46) [classes/:na]
  7. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_151]
  8. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_151]
  9. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_151]
  10. at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_151]
  11. at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) [spring-boot-devtools-1.5.7.RELEASE.jar:1.5.7.RELEASE]
  12. Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Unable to acquire JDBC Connection
  13. at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:431) ~[spring-orm-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  14. at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) ~[spring-tx-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  15. at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:447) ~[spring-tx-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  16. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:277) ~[spring-tx-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  17. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  18. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  19. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) ~[spring-aop-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  20. at com.ef.service.LogEntityServiceImpl$$EnhancerBySpringCGLIB$$574ab47e.saveAllLogEntities(<generated>) ~[classes/:na]
  21. at com.ef.Parser.run(Parser.java:105) [classes/:na]
  22. at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:732) ~[spring-boot-1.5.7.RELEASE.jar:1.5.7.RELEASE]
  23. ... 9 common frames omitted
  24. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Unable to acquire JDBC Connection
  25. at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
  26. at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
  27. at org.hibernate.jpa.spi.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1700) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
  28. at org.hibernate.jpa.internal.TransactionImpl.begin(TransactionImpl.java:48) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
  29. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:189) ~[spring-orm-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  30. at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:380) ~[spring-orm-4.3.11.RELEASE.jar:4.3.11.RELEASE]
  31. ... 18 common frames omitted
  32. Caused by: org.hibernate.exception.SQLGrammarException: Unable to acquire JDBC Connection
  33. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  34. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  35. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  36. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  37. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:90) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  38. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:112) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  39. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:230) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  40. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:237) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  41. at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:214) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  42. at org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:52) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  43. at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1512) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  44. at org.hibernate.jpa.internal.TransactionImpl.begin(TransactionImpl.java:45) ~[hibernate-entitymanager-5.0.12.Final.jar:5.0.12.Final]
  45. ... 20 common frames omitted
  46. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'logparser'
  47. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_151]
  48. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_151]
  49. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_151]
  50. at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_151]
  51. at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.6.jar:na]
  52. at com.mysql.jdbc.Util.getInstance(Util.java:381) ~[mysql-connector-java-5.1.6.jar:na]
  53. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) ~[mysql-connector-java-5.1.6.jar:na]
  54. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) ~[mysql-connector-java-5.1.6.jar:na]
  55. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) ~[mysql-connector-java-5.1.6.jar:na]
  56. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) ~[mysql-connector-java-5.1.6.jar:na]
  57. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910) ~[mysql-connector-java-5.1.6.jar:na]
  58. at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923) ~[mysql-connector-java-5.1.6.jar:na]
  59. at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273) ~[mysql-connector-java-5.1.6.jar:na]
  60. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031) ~[mysql-connector-java-5.1.6.jar:na]
  61. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718) ~[mysql-connector-java-5.1.6.jar:na]
  62. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) ~[mysql-connector-java-5.1.6.jar:na]
  63. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_151]
  64. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_151]
  65. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_151]
  66. at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_151]
  67. at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[mysql-connector-java-5.1.6.jar:na]
  68. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) ~[mysql-connector-java-5.1.6.jar:na]
  69. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) ~[mysql-connector-java-5.1.6.jar:na]
  70. at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) ~[tomcat-jdbc-8.5.20.jar:na]
  71. at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) ~[tomcat-jdbc-8.5.20.jar:na]
  72. at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) ~[tomcat-jdbc-8.5.20.jar:na]
  73. at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) ~[tomcat-jdbc-8.5.20.jar:na]
  74. at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:482) ~[tomcat-jdbc-8.5.20.jar:na]
  75. at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) ~[tomcat-jdbc-8.5.20.jar:na]
  76. at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118) ~[tomcat-jdbc-8.5.20.jar:na]
  77. at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107) ~[tomcat-jdbc-8.5.20.jar:na]
  78. at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131) ~[tomcat-jdbc-8.5.20.jar:na]
  79. at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  80. at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:386) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  81. at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:87) ~[hibernate-core-5.0.12.Final.jar:5.0.12.Final]
  82. ... 27 common frames omitted
  83.  
  84. @EnableJpaRepositories("com.ef.repository")
  85. @SpringBootApplication(scanBasePackages = {"com.ef"}, exclude = JpaRepositoriesAutoConfiguration.class)
  86. public class Parser implements CommandLineRunner {
  87.  
  88.  
  89. @Autowired
  90. private IpAddressService ipAddressService;
  91.  
  92. @Autowired
  93. private HttpInfoMessageService httpInfoMessageService;
  94.  
  95. @Autowired
  96. private LogEntityService logEntityService;
  97.  
  98. // @Autowired
  99. // private IpService ipService;
  100.  
  101. public Parser() {
  102.  
  103. }
  104.  
  105. public static void main(String[] args) throws Exception {
  106.  
  107. SpringApplication application = new SpringApplication(Parser.class);
  108. application.run(args);
  109. }
  110.  
  111. /*
  112. * print all the IP addresses that is over the threshold
  113. * with all the http messages
  114. * */
  115. public static void printIpsAboveThresholdWithHttpMessages(List<IpAddress> ipAddresses) {
  116.  
  117. System.out.println(" IP : COMMENT ");
  118. ipAddresses.forEach(ipAddress -> {
  119. ipAddress.getHttpInfoMessage2s().forEach(
  120. httpInfoMessage -> {
  121. System.out.println(ipAddress.getAddress() + " : " + httpInfoMessage.getStatus());
  122. }
  123. );
  124.  
  125. System.out.println();
  126. });
  127. }
  128.  
  129. @Override
  130. public void run(String... args) throws Exception {
  131.  
  132. /*Options options = new Options();
  133.  
  134. Option start = new Option("startDate", "startDate", true, "Start date");
  135. start.setRequired(true);
  136. options.addOption(start);
  137.  
  138. Option duration = new Option("duration", "duration", true, "duration");
  139. duration.setRequired(true);
  140. options.addOption(duration);
  141.  
  142. Option threshold = new Option("threshold", "threshold", true, "threshold");
  143. threshold.setRequired(true);
  144. options.addOption(threshold);
  145.  
  146. CommandLineParser parser = new DefaultParser();
  147. HelpFormatter formatter = new HelpFormatter();
  148. CommandLine cmd;
  149.  
  150. try {
  151. cmd = parser.parse(options, args);
  152. } catch (ParseException e) {
  153. System.out.println(e.getMessage());
  154. formatter.printHelp("utility-name", options);
  155.  
  156. System.exit(1);
  157. return;
  158. }
  159.  
  160. String startDate = cmd.getOptionValue("startDate").trim().replace(".", " ");
  161. String dur = String.valueOf(cmd.getOptionValue("duration")).trim();
  162. int thers = (int) Integer.valueOf(cmd.getOptionValue("threshold").trim());*/
  163.  
  164. List<LogEntity> allRecords = FileManager.readFileByLines("Log.txt");
  165.  
  166. // save all the log entities to the MySQL database
  167. logEntityService.saveAllLogEntities(allRecords);
  168.  
  169. List<IpAddress> ipAddresses = DataOrganizationHelper
  170. .getIpAddressesFromAllRecordsWithDurationAndThresHold(allRecords, "2017-10-02 17:14:55",
  171. "daily", 100);
  172.  
  173. // some experiment
  174. // List<Ip> ips = DataOrganizationHelper.getIpFromAllRecordsWithDurationAndThresHold(allRecords, "2017-10-02 17:14:55",
  175. // "daily", 100);
  176. // System.out.println("The size is = " + ips.size());
  177. // ipService.saveAllIps(ips);
  178.  
  179. printIpsAboveThresholdWithHttpMessages(ipAddresses);
  180.  
  181. // save the ip addresses and the http messages to the MySQL database
  182. ipAddressService.saveAllIpAddressses(ipAddresses);
  183.  
  184. exit(0);
  185. }
  186. }
  187.  
  188. spring.application.name=Wallethub Log Parser
  189.  
  190. # MySQL configuration
  191. spring.datasource.url=jdbc:mysql://localhost/LogParser
  192. spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
  193. spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  194.  
  195. # database username and the password
  196. spring.datasource.username=testuser
  197. spring.datasource.password=testpassword
  198.  
  199. # for the console app
  200. spring.main.web-environment=false
  201. spring.main.banner-mode=off
  202.  
  203.  
  204. # ===============================
  205. # = JPA / HIBERNATE
  206. # ===============================
  207.  
  208. # Show or not log for each sql query
  209. spring.jpa.show-sql=false
  210.  
  211. # Hibernate ddl auto (create, create-drop, update): with "update" the database
  212. # schema will be automatically updated accordingly to java entities found in
  213. # the project
  214. spring.jpa.hibernate.ddl-auto=create
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!