Max Rydahl Andersen [
https://community.jboss.org/people/maxandersen] created the
discussion
"Re: Database connection and administration?"
To view the discussion, visit:
https://community.jboss.org/message/753817#753817
--------------------------------------------------------------
Hi Dan,
Happy to hear you like the tools :)
Lets see if I can answer your questions:
#1 it's all controlled via the datasource; in the built in examples you can look in
the persistence.xml and it is using the built-in h2 db (AS7 has H2 instead of hsql db).
#2 the connection parameters are in your JBoss configuration (if running locally look for
the standalone.xml in AS7 install, if running in OpenShift look for
.openshift/config/standalone.xml
#3 admin the database, you can do some tricks to get h2 expose its webui but I would
recommend using mysql or postgressql on openshift - just need to add that cartridge to
your application
and change the persistence.xml to use the ava:jboss/datasources/PostgreSQLDS or
java:jboss/datasources/MysqlDS datasource name.
Then you can install phpmyadmin to manage things.
https://openshift.redhat.com/community/blogs/deploying-and-managing-postg...
https://openshift.redhat.com/community/blogs/deploying-and-managing-postg...
shows how to do it for postgresql
https://openshift.redhat.com/community/blogs/phpmyadmin-your-way-into-ope...
https://openshift.redhat.com/community/blogs/phpmyadmin-your-way-into-ope...
for mysql
hope that helps a bit ?
--------------------------------------------------------------
Reply to this message by going to Community
[
https://community.jboss.org/message/753817#753817]
Start a new discussion in JBoss Tools at Community
[
https://community.jboss.org/choose-container!input.jspa?contentType=1&...]