Re:[h2] TABLE NOT FOUND ERROR

Fri, 12 Apr 2019 08:26:10 -0700

If u don't got solution then u will give me access ur system



Sent from my Redmi 4A
On [email protected], 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 [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.

--
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.

Reply via email to