How to view the Wildfly database?

omega09 Jun 4, 2017 4:06 PM

Using Wildfly 10.1, when I persist entities they are saved into database tables.

How can I view these tables? I'm experimenting with different JPA entity relationships and would like to see the results.

1. Re: How to view the Wildfly database?

jaikiran Jun 5, 2017 6:27 AM (in response to omega09)

Depending on which database server you are using it comes with a tool (either command line or GUI) which allows you to browse its tables. These tools are available as part of your database installation and not through WildFly installation.
Actions
2. Re: How to view the Wildfly database?

mayerw01 Jun 5, 2017 6:47 AM (in response to omega09)

The IDEs (like NetBeans, Eclipse or JDeveloper) also provide nice options to inspect the databases.
Actions
3. Re: How to view the Wildfly database?

omega09 Jun 5, 2017 2:00 PM (in response to jaikiran)

Wildfly 10.1 comes with a database as any JavaEE 7 compliant app server. I didn't install anything else except for Wildfly 10 and am able to write to a database. I don't understand the question "which database server am I using".
Actions
4. Re: How to view the Wildfly database?

omega09 Jun 5, 2017 3:56 PM (in response to mayerw01)

I'm using Eclipse Neon 3. Can you recommend anything or at least what plugin to search for? Keywords?
Actions
5. Re: How to view the Wildfly database?

abhijithumbe Jun 6, 2017 3:18 AM (in response to omega09)

Switch to "Database development " perspective and in the leftside panel you can see options to connect to external DB.
Actions
6. Re: How to view the Wildfly database?

mayerw01 Jun 6, 2017 6:45 AM (in response to omega09)

To be exact: WildFly bundles H2 as an in-memory, in-process database. wildfly-quickstart/h2-console at master · sgilda/wildfly-quickstart · GitHub
To configure the connection in Eclipse you may just copy the url from the ExampleDS datasource
Actions

Go to original post