search

vladmihalcea / high-performance-java-persistence

The High-Performance Java Persistence book and video course code examples
Apache License 2.0
1.31k stars 489 forks source link

one-to-many issue #24

Closed srncristea closed 6 years ago

srncristea commented 6 years ago

check accEnt and tokenEnt and accRepoImpl classes from core/src/main/java/com/sorinc/test/hibernate/one2many pachage

vladmihalcea commented 6 years ago

@srncristea Nu compileaza. Lipseste AccountRepository, dependency-urile de Lombok. Nu e nevoie se adaugi si service layerul. E suficient sa ai numai entitiatile si sa incerci sa emulezi operatiile ce le faci.

vladmihalcea commented 6 years ago

@srncristea Vezi ca am facut un branch nou si am scos afara tot in afara de entitati si query-ul ala.

Eventual incearca sa te joci cu exemplul ca sa il faci sa crape la fel ca la tine.

vladmihalcea commented 6 years ago

Am modificat sa incarce si scripturile si imi merge ok. UIte logul:

"C:\Program Files\Java\jdk1.8.0_152\bin\java" -ea -Dbitronix.tm.journal.disk.logPart1Filename=D:\Vlad\Work\GitHub\high-performance-java-persistence\core\target/btm1.log -Dbitronix.tm.journal.disk.logPart2Filename=D:\Vlad\Work\GitHub\high-performance-java-persistence\core\target/btm2.log -Xms1024m -Xmx1024m -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2017.1.5\lib\idea_rt.jar=64246:C:\Program Files\JetBrains\IntelliJ IDEA 2017.1.5\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\IntelliJ IDEA 2017.1.5\lib\idea_rt.jar;C:\Program Files\JetBrains\IntelliJ IDEA 2017.1.5\plugins\junit\lib\junit-rt.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_152\jre\lib\rt.jar;D:\Vlad\Work\GitHub\high-performance-java-persistence\core\target\test-classes;D:\Vlad\Work\GitHub\high-performance-java-persistence\core\target\classes;D:\Vlad\Work\GitHub\high-performance-java-persistence\lib\ojdbc7-12.1.0.2.jar;D:\Vlad\Work\GitHub\high-performance-java-persistence\lib\xdb6-12.1.0.2.jar;D:\Vlad\Work\GitHub\high-performance-java-persistence\lib\orai18n-12.1.0.2.jar;D:\Vlad\Work\GitHub\high-performance-java-persistence\lib\xmlparserv2-12.1.0.2.jar;D:\Vlad\Work\GitHub\high-performance-java-persistence\lib\oraclepki-12.1.0.2.jar;D:\Vlad\Work\GitHub\high-performance-java-persistence\lib\osdt_cert-12.1.0.2.jar;D:\Vlad\Work\GitHub\high-performance-java-persistence\lib\osdt_core-12.1.0.2.jar;C:\Users\mihal\.m2\repository\org\slf4j\slf4j-api\1.7.7\slf4j-api-1.7.7.jar;C:\Users\mihal\.m2\repository\ch\qos\logback\logback-classic\1.1.2\logback-classic-1.1.2.jar;C:\Users\mihal\.m2\repository\ch\qos\logback\logback-core\1.1.2\logback-core-1.1.2.jar;C:\Users\mihal\.m2\repository\org\apache\commons\commons-lang3\3.3.2\commons-lang3-3.3.2.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-core\5.2.17.Final\hibernate-core-5.2.17.Final.jar;C:\Users\mihal\.m2\repository\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;C:\Users\mihal\.m2\repository\org\hibernate\javax\persistence\hibernate-jpa-2.1-api\1.0.0.Final\hibernate-jpa-2.1-api-1.0.0.Final.jar;C:\Users\mihal\.m2\repository\org\javassist\javassist\3.22.0-GA\javassist-3.22.0-GA.jar;C:\Users\mihal\.m2\repository\antlr\antlr\2.7.7\antlr-2.7.7.jar;C:\Users\mihal\.m2\repository\org\jboss\spec\javax\transaction\jboss-transaction-api_1.2_spec\1.0.1.Final\jboss-transaction-api_1.2_spec-1.0.1.Final.jar;C:\Users\mihal\.m2\repository\org\jboss\jandex\2.0.3.Final\jandex-2.0.3.Final.jar;C:\Users\mihal\.m2\repository\com\fasterxml\classmate\1.3.0\classmate-1.3.0.jar;C:\Users\mihal\.m2\repository\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;C:\Users\mihal\.m2\repository\org\hibernate\common\hibernate-commons-annotations\5.0.1.Final\hibernate-commons-annotations-5.0.1.Final.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-c3p0\5.2.17.Final\hibernate-c3p0-5.2.17.Final.jar;C:\Users\mihal\.m2\repository\com\mchange\c3p0\0.9.5.2\c3p0-0.9.5.2.jar;C:\Users\mihal\.m2\repository\com\mchange\mchange-commons-java\0.2.11\mchange-commons-java-0.2.11.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-hikaricp\5.2.17.Final\hibernate-hikaricp-5.2.17.Final.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-spatial\5.2.17.Final\hibernate-spatial-5.2.17.Final.jar;C:\Users\mihal\.m2\repository\org\geolatte\geolatte-geom\1.2.0\geolatte-geom-1.2.0.jar;C:\Users\mihal\.m2\repository\com\vividsolutions\jts\1.13\jts-1.13.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-validator\5.2.3.Final\hibernate-validator-5.2.3.Final.jar;C:\Users\mihal\.m2\repository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-jpamodelgen\5.2.17.Final\hibernate-jpamodelgen-5.2.17.Final.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-envers\5.2.17.Final\hibernate-envers-5.2.17.Final.jar;C:\Users\mihal\.m2\repository\javax\el\javax.el-api\2.2.4\javax.el-api-2.2.4.jar;C:\Users\mihal\.m2\repository\javax\transaction\jta\1.1\jta-1.1.jar;C:\Users\mihal\.m2\repository\javax\servlet\javax.servlet-api\3.0.1\javax.servlet-api-3.0.1.jar;C:\Users\mihal\.m2\repository\org\hibernate\hibernate-ehcache\5.2.17.Final\hibernate-ehcache-5.2.17.Final.jar;C:\Users\mihal\.m2\repository\net\sf\ehcache\ehcache\2.10.3\ehcache-2.10.3.jar;C:\Users\mihal\.m2\repository\net\ttddyy\datasource-proxy\1.3.3\datasource-proxy-1.3.3.jar;C:\Users\mihal\.m2\repository\p6spy\p6spy\2.1.4\p6spy-2.1.4.jar;C:\Users\mihal\.m2\repository\org\hsqldb\hsqldb\2.4.0\hsqldb-2.4.0.jar;C:\Users\mihal\.m2\repository\org\postgresql\postgresql\42.2.1\postgresql-42.2.1.jar;C:\Users\mihal\.m2\repository\com\oracle\jdbc\ojdbc8\12.2.0.1\ojdbc8-12.2.0.1.jar;C:\Users\mihal\.m2\repository\com\oracle\jdbc\ucp\12.2.0.1\ucp-12.2.0.1.jar;C:\Users\mihal\.m2\repository\mysql\mysql-connector-java\6.0.6\mysql-connector-java-6.0.6.jar;C:\Users\mihal\.m2\repository\com\microsoft\sqlserver\mssql-jdbc\6.4.0.jre8\mssql-jdbc-6.4.0.jre8.jar;C:\Users\mihal\.m2\repository\net\sourceforge\jtds\jtds\1.3.1\jtds-1.3.1.jar;C:\Users\mihal\.m2\repository\io\dropwizard\metrics\metrics-core\3.1.0\metrics-core-3.1.0.jar;C:\Users\mihal\.m2\repository\com\zaxxer\HikariCP\1.3.3\HikariCP-1.3.3.jar;C:\Users\mihal\.m2\repository\org\codehaus\btm\btm\2.1.4\btm-2.1.4.jar;C:\Users\mihal\.m2\repository\org\flywaydb\flyway-core\3.2.1\flyway-core-3.2.1.jar;C:\Users\mihal\.m2\repository\com\vladmihalcea\flexy-pool\flexy-btm\2.0.0\flexy-btm-2.0.0.jar;C:\Users\mihal\.m2\repository\com\vladmihalcea\flexy-pool\flexy-pool-core\2.0.0\flexy-pool-core-2.0.0.jar;C:\Users\mihal\.m2\repository\com\vladmihalcea\flexy-pool\flexy-dropwizard-metrics\2.0.0\flexy-dropwizard-metrics-2.0.0.jar;C:\Users\mihal\.m2\repository\io\dropwizard\metrics\metrics-jmx\4.0.2\metrics-jmx-4.0.2.jar;C:\Users\mihal\.m2\repository\com\vladmihalcea\flexy-pool\flexy-hikaricp\2.0.0\flexy-hikaricp-2.0.0.jar;C:\Users\mihal\.m2\repository\com\vladmihalcea\db-util\0.0.1\db-util-0.0.1.jar;C:\Users\mihal\.m2\repository\org\slf4j\jcl-over-slf4j\1.6.1\jcl-over-slf4j-1.6.1.jar;C:\Users\mihal\.m2\repository\commons-lang\commons-lang\2.5\commons-lang-2.5.jar;C:\Users\mihal\.m2\repository\org\aspectj\aspectjrt\1.8.7\aspectjrt-1.8.7.jar;C:\Users\mihal\.m2\repository\org\aspectj\aspectjweaver\1.8.7\aspectjweaver-1.8.7.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-beans\4.3.3.RELEASE\spring-beans-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-core\4.3.3.RELEASE\spring-core-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-context\4.3.3.RELEASE\spring-context-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-aop\4.3.3.RELEASE\spring-aop-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-expression\4.3.3.RELEASE\spring-expression-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-tx\4.3.3.RELEASE\spring-tx-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-orm\4.3.3.RELEASE\spring-orm-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-jdbc\4.3.3.RELEASE\spring-jdbc-4.3.3.RELEASE.jar;C:\Users\mihal\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.7.4\jackson-databind-2.7.4.jar;C:\Users\mihal\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.7.0\jackson-annotations-2.7.0.jar;C:\Users\mihal\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.7.4\jackson-core-2.7.4.jar;C:\Users\mihal\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\mihal\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;C:\Users\mihal\.m2\repository\org\springframework\spring-test\4.3.3.RELEASE\spring-test-4.3.3.RELEASE.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 com.sorinc.test.hibernate.one2many.AccountRepositoryTest,test_find_acc_by_credentials
DEBUG [Alice]: o.j.logging - Logging Provider: org.jboss.logging.Slf4jLoggerProvider
INFO  [Alice]: o.h.j.i.u.LogHelper - HHH000204: Processing PersistenceUnitInfo [
    name: AccountRepositoryTest
    ...]
INFO  [Alice]: o.h.Version - HHH000412: Hibernate Core {5.2.17.Final}
INFO  [Alice]: o.h.c.Environment - HHH000206: hibernate.properties not found
INFO  [Alice]: o.h.s.i.SpatialService - HHH80000001: hibernate-spatial integration enabled : true
DEBUG [Alice]: o.h.c.i.RegionFactoryInitiator - Cache region factory : org.hibernate.cache.internal.NoCachingRegionFactory
INFO  [Alice]: o.h.a.c.Version - HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
INFO  [Alice]: o.h.d.Dialect - HHH000400: Using dialect: org.hibernate.dialect.MySQL57Dialect
INFO  [Alice]: o.h.e.b.i.EnversServiceImpl - Envers integration enabled? : true
INFO  [Alice]: o.h.v.i.u.Version - HV000001: Hibernate Validator 5.2.3.Final
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:0, Success:False, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["alter table token drop foreign key FKftkstvcfb74ogw02bo5261kno"], Params:[]
WARN  [Alice]: o.h.t.s.i.ExceptionHandlerLoggedImpl - GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlString(SchemaDropperImpl.java:375) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.internal.SchemaDropperImpl.applySqlStrings(SchemaDropperImpl.java:359) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.internal.SchemaDropperImpl.applyConstraintDropping(SchemaDropperImpl.java:331) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.internal.SchemaDropperImpl.dropFromMetadata(SchemaDropperImpl.java:230) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.internal.SchemaDropperImpl.performDrop(SchemaDropperImpl.java:154) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:126) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.internal.SchemaDropperImpl.doDrop(SchemaDropperImpl.java:112) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:144) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:312) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:892) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    at com.vladmihalcea.book.hpjp.util.AbstractTest.newEntityManagerFactory(AbstractTest.java:259) [test-classes/:na]
    at com.vladmihalcea.book.hpjp.util.AbstractTest.init(AbstractTest.java:81) [test-classes/:na]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_152]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_152]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_152]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_152]
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) [junit-4.12.jar:4.12]
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) [junit-4.12.jar:4.12]
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24) [junit-4.12.jar:4.12]
    at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) [junit-4.12.jar:4.12]
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) [junit-4.12.jar:4.12]
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) [junit-4.12.jar:4.12]
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) [junit-4.12.jar:4.12]
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) [junit-4.12.jar:4.12]
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363) [junit-4.12.jar:4.12]
    at org.junit.runner.JUnitCore.run(JUnitCore.java:137) [junit-4.12.jar:4.12]
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68) [junit-rt.jar:na]
    at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:51) [junit-rt.jar:na]
    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242) [junit-rt.jar:na]
    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70) [junit-rt.jar:na]
Caused by: java.sql.SQLSyntaxErrorException: Table 'high_performance_java_persistence.token' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536) ~[mysql-connector-java-6.0.6.jar:6.0.6]
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513) ~[mysql-connector-java-6.0.6.jar:6.0.6]
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115) ~[mysql-connector-java-6.0.6.jar:6.0.6]
    at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983) ~[mysql-connector-java-6.0.6.jar:6.0.6]
    at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1936) ~[mysql-connector-java-6.0.6.jar:6.0.6]
    at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:891) ~[mysql-connector-java-6.0.6.jar:6.0.6]
    at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:795) ~[mysql-connector-java-6.0.6.jar:6.0.6]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_152]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_152]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_152]
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_152]
    at net.ttddyy.dsproxy.proxy.StatementProxyLogic.invoke(StatementProxyLogic.java:147) ~[datasource-proxy-1.3.3.jar:na]
    at net.ttddyy.dsproxy.proxy.jdk.StatementInvocationHandler.invoke(StatementInvocationHandler.java:33) ~[datasource-proxy-1.3.3.jar:na]
    at com.sun.proxy.$Proxy26.execute(Unknown Source) ~[na:na]
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final]
    ... 37 common frames omitted
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:14, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["drop table if exists account"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:2, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["drop table if exists token"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:0, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["SET foreign_key_checks = 0"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:2, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["drop table if exists account"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:1, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["drop table if exists token"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:21, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["drop table if exists contact"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:0, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["SET foreign_key_checks = 1"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:35, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["create table account(
  id bigint(20) AUTO_INCREMENT primary key,
  first_name varchar(200) not null,
  last_name varchar(200) not null,
  mid_name varchar(100) ,
  username varchar(200) not null,
  password varchar(200) not null, 
  email varchar(200) not null,
  phone varchar(200) not null,
  type varchar(100) not null,
  country varchar(100) not null,
  county varchar(50),
  town varchar(100),
  street varchar(100),
  zip_code varchar(100),
  created_at timestamp default current_timestamp,
  updated_at timestamp default current_timestamp
 )"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:42, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["create table token (
  id bigint(20) AUTO_INCREMENT primary key,
  reference varchar(36) not null,
  jwt varchar(300) not null,
  account_id bigint(20) not null,
  created_at timestamp default current_timestamp,
  updated_at timestamp default current_timestamp,

  CONSTRAINT tokens_fk FOREIGN KEY (account_id) REFERENCES account(id)
)"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:38, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["CREATE TABLE contact (
  id bigint(20) AUTO_INCREMENT primary key,
  first_name varchar(100) not null,
  last_name varchar(100) not null,
  email varchar(200) not null,
  phone varchar(100) not null,
  postal_code varchar(20) not null,

  created_at timestamp default current_timestamp,
  updated_at timestamp default current_timestamp
)"], Params:[]
INFO  [Alice]: o.h.t.s.i.SchemaCreatorImpl - HHH000476: Executing import script 'ScriptSourceInputFromUrl(file:/D:/Vlad/Work/GitHub/high-performance-java-persistence/core/target/test-classes/sorin/data.sql)'
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:9, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["insert into account(first_name, last_name, mid_name, username, password, email, phone, type, country, county, town, street, zip_code) values('f_n', 'l_n', 'm_n', 'username_1', 'password_1', 'nobody@fake.net', '00401234567891', 'business', 'Ro', 'Cj', 'cluj-napoca', 'Garii 21', '400345')"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:6, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["insert into account(first_name, last_name, mid_name, username, password, email, phone, type, country, county, town, street, zip_code) values('f_n', 'l_n', 'm_n', 'username_2', 'password_2', 'nobody@fake.net', '00401234567891', 'business', 'Ro', 'Cj', 'cluj-napoca', 'Garii 21', '400345')"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:12, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["insert into token(reference, jwt, account_id) values('dd127237-e266-45fd-8a05-a26c7ee54371', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c', 1)"], Params:[]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:5, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["insert into token(reference, jwt, account_id) values('70b5f071-129a-4b3b-be50-1a9569b9ef7e', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c', 2)"], Params:[]
INFO  [Alice]: o.h.t.s.i.SchemaCreatorImpl - HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@5631962'
WARN  [Alice]: b.t.Configuration - cannot get this JVM unique ID. Make sure it is configured and you only use ASCII characters. Will use IP address instead (unsafe for production usage!).
WARN  [Alice]: b.t.j.DiskJournal - active log file is unclean, did you call BitronixTransactionManager.shutdown() at the end of the last run?
INFO  [Alice]: o.h.h.i.QueryTranslatorFactoryInitiator - HHH000397: Using ASTQueryTranslatorFactory
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:3, Success:True, Type:Prepared, Batch:False, QuerySize:1, BatchSize:0, Query:["select accountrep0_.id as id1_0_, accountrep0_.created_at as created_2_0_, accountrep0_.updated_at as updated_3_0_, accountrep0_.country as country4_0_, accountrep0_.county as county5_0_, accountrep0_.email as email6_0_, accountrep0_.first_name as first_na7_0_, accountrep0_.last_name as last_nam8_0_, accountrep0_.mid_name as mid_name9_0_, accountrep0_.password as passwor10_0_, accountrep0_.phone as phone11_0_, accountrep0_.street as street12_0_, accountrep0_.town as town13_0_, accountrep0_.type as type14_0_, accountrep0_.username as usernam15_0_, accountrep0_.zip_code as zip_cod16_0_ from account accountrep0_ where accountrep0_.username=? and accountrep0_.password=?"], Params:[(username_1, password_1)]
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:4, Success:True, Type:Prepared, Batch:False, QuerySize:1, BatchSize:0, Query:["select tokens0_.account_id as account_6_1_0_, tokens0_.id as id1_1_0_, tokens0_.id as id1_1_1_, tokens0_.created_at as created_2_1_1_, tokens0_.updated_at as updated_3_1_1_, tokens0_.account_id as account_6_1_1_, tokens0_.jwt as jwt4_1_1_, tokens0_.reference as referenc5_1_1_ from token tokens0_ where tokens0_.account_id=?"], Params:[(1)]
INFO  [Alice]: o.h.e.i.StatisticalLoggingSessionEventListener - Session Metrics {
    19704107 nanoseconds spent acquiring 2 JDBC connections;
    500938 nanoseconds spent releasing 2 JDBC connections;
    26400406 nanoseconds spent preparing 2 JDBC statements;
    11246227 nanoseconds spent executing 2 JDBC statements;
    0 nanoseconds spent executing 0 JDBC batches;
    0 nanoseconds spent performing 0 L2C puts;
    0 nanoseconds spent performing 0 L2C hits;
    0 nanoseconds spent performing 0 L2C misses;
    13499264 nanoseconds spent executing 1 flushes (flushing a total of 2 entities and 1 collections);
    55704 nanoseconds spent executing 1 partial-flushes (flushing a total of 0 entities and 0 collections)
}
INFO  [Alice]: o.h.t.s.i.SchemaDropperImpl$DelayedDropActionImpl - HHH000477: Starting delayed drop of schema as part of SessionFactory shut-down'
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:0, Success:False, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["alter table token drop foreign key FKftkstvcfb74ogw02bo5261kno"], Params:[]
ERROR [Alice]: o.h.t.s.i.SchemaDropperImpl$DelayedDropActionImpl - HHH000478: Unsuccessful: alter table token drop foreign key FKftkstvcfb74ogw02bo5261kno
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:0, Success:False, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["drop table if exists account"], Params:[]
ERROR [Alice]: o.h.t.s.i.SchemaDropperImpl$DelayedDropActionImpl - HHH000478: Unsuccessful: drop table if exists account
DEBUG [Alice]: n.t.d.l.SLF4JQueryLoggingListener - Name:DATA_SOURCE_PROXY, Time:18, Success:True, Type:Statement, Batch:False, QuerySize:1, BatchSize:0, Query:["drop table if exists token"], Params:[]

Process finished with exit code 0