how do i use spring.database.url syntax???? tried several
comninations....always getting table not found.
application properties
spring.h2.console.enabled=true
spring.datasource.url=jdbc:h2:mem:retail;DB_CLOSE_ON_EXIT=FALSE;
spring.jpa.hibernate.ddl-auto = update
data.sql
INSERT INTO myRetail VALUES('Jai Alai', 7.5);
INSERT INTO myRetail VALUES('Stella Artois', 5.0);
INSERT INTO myRetail VALUES('Lagunitas IPA', 6.2);
COMMIT;
error message:
Error creating bean with name 'entityManagerFactory' defined in class path
resource
[org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class]:
Initialization of bean failed; nested exception is
org.springframework.jdbc.datasource.init.ScriptStatementFailedException:
Failed to execute SQL script statement #1 of URL [file:/C:/Users/ INSERT
INTO myRetail VALUES('Jai Alai', 7.5); nested exception is
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "MYRETAIL" not found; SQL
statement:
INSERT INTO myRetail VALUES('Jai Alai', 7.5) [42102-199]
at org.springframework.beans.factory.support.Abstra
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
