Re:[h2] TABLE NOT FOUND ERROR

[vitthaljadhav0404]

Hiii

Do u solve this error?

Sent from my Redmi 4A

On rakeshagarwal...@gmail.com, 8 Apr 2019 1:53 pm wrote:

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="">

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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

--
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.