java.sql.SQLSyntaxErrorException: Table 'mydb.student' doesn't exist

Question

I am try to make simple spring boot api and generate table automaticaly.But whenI call the api i get an error that tha table not exist ? my application.properties

spring.datasource.username=root
spring.datasource.password=123
logging.level.org.springframework.security=TRACE
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
spring.jpa.properties.hibernate.formate_sql=true
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
server.error.include-message=always```

Santil · Accepted Answer · 2022-03-11 06:45:59Z

4

To generate Tables automatically with spring boot 1. First set your POJO class with the @Entity annotation. 2. Use the bellow Properties and Run the application tables will be created automatically.

spring.datasource.url=jdbc:mysql://localhost:3306/Your DB name
spring.datasource.username= username
spring.datasource.password= password
spring.jpa.hibernate.ddl-auto=update

The four configurations enough to create tables automatically.

answered Mar 11, 2022 at 6:45

Santil

1221 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Serg Vasylchak · Accepted Answer · 2022-03-10 21:43:18Z

1

You configuration won't generate any tables automatically due to non-emdedded database (MySQL). Therefore you must configure ddl-auto explicitly.

spring.jpa.hibernate.ddl-auto=update OR spring.jpa.hibernate.ddl-auto=create-drop

Have a look at Spring Docs for more details.

answered Mar 10, 2022 at 21:43

Serg Vasylchak

9005 silver badges21 bronze badges

Comments

Aitroll · Accepted Answer · 2022-03-11 08:30:25Z

0

To generate your tables you need to implement this lines to your application.properties:

    spring.jpa.hibernate.ddl-auto=update
    spring.datasource.url=jdbc:mysql://${MYSQL_HOST:localhost}:3306/YOURSCHEMA
    spring.datasource.username=YOURUSER
    spring.datasource.password= YOURPASSWORD
    spring.datasource.driver-class-name =com.mysql.jdbc.Driver
    spring.jpa.show-sql: true

You also need to add some dependencies to run the project like the connector to your db, for example I use MySqlConnector. If you have changed this lines and does not work provide me more info about what you want to do by replying this thread.

answered Mar 11, 2022 at 8:30

Aitroll

1

Collectives™ on Stack Overflow

java.sql.SQLSyntaxErrorException: Table 'mydb.student' doesn't exist

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related