Java Community | Help. Code. Learn.•10mo ago

Connection Error between Spring Boot and MySQL :

Application Properties: spring.datasource.url=jdbc:mysql://localhost:3306/ems spring.datasource.username=root spring.datasource.password=admin1234 server.port = 5045 spring.jpa.properties..dialect=org.hibernate.dialect.MySQLDialect spring.jpa.hibernate.ddl-auto=update when i run this code, it doesn't make any table in mySql (ems database)

14 Replies

JavaBot•10mo ago

⌛ This post has been reserved for your question.

Hey @DigitalDynamo! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

dan1st•10mo ago

Can you please show the full stack trace?

DigitalDynamoOP•10mo ago

this is my output

DigitalDynamoOP•10mo ago

table doesn't show any feilds

john•10mo ago

package entity; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.GeneratedValue; import jakarta.persistence.Id; import jakarta.persistence.Table; import lombok.*; @Getter @Setter @AllArgsConstructor @NoArgsConstructor @Entity @Table(name="Employee")

public class Employee {

    
    @Id
    @GeneratedValue
    private long id;
    
    //@Column(name="first_name")
    private String firstname;
    private String lastname;
    private String email;
}

public class Employee {

    
    @Id
    @GeneratedValue
    private long id;
    
    //@Column(name="first_name")
    private String firstname;
    private String lastname;
    private String email;
}

This message has been formatted automatically. You can disable this using /preferences.

dan1st•10mo ago

Did you click the refresh button on the top right?

DigitalDynamoOP•10mo ago

yup

dan1st•10mo ago

Entity classes must be in a subpackage of your main class

DigitalDynamoOP•10mo ago

may be this is wrong ??

dan1st•10mo ago

the entity package must be imside com.example.demo and the other packages should be as well

DigitalDynamoOP•10mo ago

oo i see thanks alot

JavaBot•10mo ago

If you are finished with your post, please close it. If you are not, please ignore this message. Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

DigitalDynamoOP•10mo ago

i will try then tell you

JavaBot•10mo ago

Post Closed

This post has been closed by <@805083232369770526>.

Gaming

Programming

Connection Error between Spring Boot and MySQL :