JPA: entity object is not appeared in the H2 console

Question

In my spring app i have the below entity:

import lombok.Data;

@Data
@Entity

public class Profile {

    @Id
    @GeneratedValue
    Long id;

    String name;
    String address;
    String description;
    String img;

public Profile(String name, String address, String description, String img) {
        this.name = name;
        this.address = address;
        this.description = description;
        this.img = img;
    }

}

and then the repository is:

@Repository
public interface ProfileRepository extends JpaRepository<Profile,Long> {

}

Here is my pom.xml:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-devtools</artifactId>
    <scope>runtime</scope>
</dependency>
        <dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <scope>runtime</scope>
</dependency>

So, i expect when i go to the h2 console uri:

http://localhost:8080/h2-console/login.do?jsessionid=ae6ba7021a23e0ebb4a4844381546e72

It shows the table related to the object Profile.

The problem is: there is no table called Profile.

So, why i don't have the profile table?

The application.properties is empty

Here is how i connect to H2

And when i run my application, it says:

[2m2017-06-29 10:07:21.106[0;39m [32m INFO[0;39m [35m51392[0;39m [2m---[0;39m [2m[  restartedMain][0;39m [36morg.hibernate.dialect.Dialect           [0;39m [2m:[0;39m HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
[2m2017-06-29 10:07:21.557[0;39m [32m INFO[0;39m [35m51392[0;39m [2m---[0;39m [2m[  restartedMain][0;39m [36morg.hibernate.tool.hbm2ddl.SchemaExport [0;39m [2m:[0;39m HHH000227: Running hbm2ddl schema export
[2m2017-06-29 10:07:21.557[0;39m [32m INFO[0;39m [35m51392[0;39m [2m---[0;39m [2m[  restartedMain][0;39m [36morg.hibernate.tool.hbm2ddl.SchemaExport [0;39m [2m:[0;39m HHH000230: Schema export complete

So, it seems that, the application makes the schema of database. Am i right?

Because you need to instruct SpringBoot to create the Schema. https://docs.spring.io/spring-boot/docs/current/reference/html/howto-database-initialization.html and https://stackoverflow.com/questions/29758136/h2-db-in-spring-boot-hibernate-does-not-generate-db-schema — Alex Roig, Jun 28 '17 at 12:41
@Salman now you setup a db name in `application.properties`: *dbname*. So when you try to connect to db from H2 console (`http://localhost:8080/h2-console`) you have to use `jdbc:h2:mem:dbname` as 'JDBC URL'. Port 9092 you have to use from your IDE (or from over SQL tool) to connect to H2 DB server. — Cepr0, Jun 29 '17 at 06:14

score 1 · Answer 1 · answered Mar 05 '19 at 21:29

you need to set h2 configuration in application.properties write these lines

spring.h2.console.enabled=true
spring.datasource.url=jdbc:h2:mem:testdb --> whatever url you find when open console
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.jpa.hibernate.ddl-auto=create

score 0 · Answer 2 · answered Jun 28 '17 at 12:43

0

Check if your main class that contains the annotation @SpringBootConfiguration is in the root of hierarchy of your package

answered Jun 28 '17 at 12:43

hassan bassi

41
1
3

score 0 · Answer 3 · answered Jun 28 '17 at 12:50

You can also achieve so by writing the schema.sql file that creates tables and can load data by placing the file in your src/main/resources location. There are a lot of different ways you can do this. I like the schema.sql file because it has something that you can look at and manage.

score 0 · Answer 4 · answered Jun 28 '17 at 21:25

0

Then you open 'http://localhost:8080/h2-console' you need to specify 'JDBC URL'. By default (as I understand you use default setting because your application.properties is empty) this value is:

jdbc:h2:mem:testdb

IMHO H2 Console is not the best choice for the developer. You can work with H2 right from your IDE - see my answer.

answered Jun 28 '17 at 21:25

Cepr0

28,144
8
75
101

i have updated my question with ur hint, but still does not work – Sal-laS Jun 29 '17 at 06:06
@Salman now you setup a db name in `application.properties`: *dbname*. So when you try to connect to db from H2 console (`http://localhost:8080/h2-console`) you have to use `jdbc:h2:mem:dbname` as 'JDBC URL'. Port 9092 you have to use from your IDE (or from over SQL tool) to connect to H2 DB server. – Cepr0 Jun 29 '17 at 06:15

score 0 · Answer 5 · answered Apr 02 '23 at 21:56

0

I had the same problem, I solved it by moving the entity to the main app package.

Note: using @ComponentScan over the main app class didn't solve the issue nither a separate class with @Configuratin @ComponentScan ( basePackages = {"thepackage"})

answered Apr 02 '23 at 21:56

Mahmoud Khalaf

26
1

JPA: entity object is not appeared in the H2 console

5 Answers5