agoncal/agoncal-fascicle-jpa

Code of my JPA Fascicle

agoncal-fascicle-jpa's Issues

H2 DB Issue--when I try to RUn this code

[EL Info]: 2019-08-13 13:39:52.247--ServerSession(1010856212)--EclipseLink, version: Eclipse Persistence Services - 2.7.3.v20180807-4be1041
[EL Info]: connection: 2019-08-13 13:39:52.446--ServerSession(1010856212)--/file:/C:/Program1/GitProjs/JPA_Antolio/agoncal-fascicle-jpa/advanced/ex02/target/classes/_cdbookstorePU login successful
[EL Warning]: 2019-08-13 13:39:52.504--ServerSession(1010856212)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Table "SEQUENCE" not found; SQL statement:
DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN' [42102-197]
Error Code: 42102
Call: DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'
Query: DataModifyQuery(sql="DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'")

"Deployment Descriptor" persistence.xml and confusion :)

Hi Antonio,
today I bought your fascicle at Amazon and I have to thank you first. I never read a technical book that was so easy to follow. No bloat like "how to install maven" in the middle of the content or "hey, this is how scrum works" :).

However, I have a problem with the chapter "Deployment Descriptor" and the "persistence.xml". You told me to have https://github.com/agoncal/agoncal-fascicle-jpa/blob/master/getting-started/src/main/resources/META-INF/persistence.xml . However, the file references "cdbookstoreCreate.ddl" and "cdbookstoreDrop.ddl".

Where can I find both of these files? And where am I supposed to store them?

I set up a fresh Ubuntu 18.04 just for this question:

apt install maven (3.6.0)
apt install openjdk-8-jdk (javac 1.8.0_212)

I downloaded and started the h2 database (version 1.4.199).

And then I executed:

git clone https://github.com/agoncal/agoncal-fascicle-jpa.git
cd agoncal-fascicle-jpa
cd first-step
mvn test

And it just worked but I don't know why :). I'm an "EE"-noob so be kind to me :).

I'm aware of https://github.com/agoncal/agoncal-fascicle-jpa/blob/master/getting-started/src/main/java/org/agoncal/fascicle/jpa/gettingstarted/artist.ddl and I expected this file to be referenced inside the persistence.xml.

Are you willing to clear my confusion? :)

Thanks in advance.

Regards,
Andreas