How to see the data in the tables of ExampleDS database?
I plan to use ExampleDS (java:jboss/datasources/ExampleDS) for Java development before going to production. It is the standard datasource in Wildfly JBoss server. My app uses JPA and creates tables in the ExampleDS database. I need to see the data in these tables during development, but I don’t know how,
I am developing in IntelliJ. There is a ”database” tab to the upper right. I have previously added databases here and I could see their content. But I don’t know how to add the ExampleDS database. I try to add it by ”data source from URL” --> jdbc:h2:mem:test.
I can then test the connection and it says that it is connected. But no tables are seen in the database, although I can see that tables are created. I can see that by debugging the JPA/JQL code and doing SELECT searches. So how can I see the data in the tables of ExampleDS database?
Please sign in to leave a comment.
Can you confirm that the name of your test database is called "test"?
I would double-check your configuration and make sure that the data source that you're using in your application configuration is identical to "jdbc:h2:mem:test".