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-postgresql-on-openshift
 
https://openshift.redhat.com/community/blogs/deploying-and-managing-postgresql-on-openshift
 shows how to do it for postgresql 

 
https://openshift.redhat.com/community/blogs/phpmyadmin-your-way-into-openshift-express-database-management-bliss
 
https://openshift.redhat.com/community/blogs/phpmyadmin-your-way-into-openshift-express-database-management-bliss
 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&containerType=14&container=2128]

_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to