Posts

Posts mit dem Label "MySQL" werden angezeigt.

Spring Framework on OpenShift: persistence.xml and EntityManager Configuration on Wildfly 10 and MySQL

Bild
Running an Web Application with Spring Framework 4.2.x with Spring-Data-JPA and MySQL on OpenShift the RedHat Cloud is good with Wildfly10. But how to configure the MySQL Database for Spring-Data-JPA? Spring-Data-JPA with Wildfly10 and MySQL on Openshift   First Step: edit persistence.xml. Here is an Example: <?xml version="1.0" encoding="UTF-8"?> <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"> <persistence-unit name="mySimpleWorkListPU" transaction-type="JTA"><jta-data-source>java:jboss/datasources/MySQLDS</jta-data-source> <class>org.woehlke.simpleworklist.entities.ActionItem</class> <class>org.woehlke.simpleworklist.entities.Category...

MySQL DataSource for Wildfly10 like Openshift

how to configure Wildfly10 to have a DataSource for MySQL like Openshift the RedHat Cloud. I installed Wildfly10 on ~/srv/wildfly-10.0.0.Final Step 1: Add MySQL Driver to modules: Download the mysql-driver mysql-connector-java-5.1.38.jar from any Maven Repository e.g.:  http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.38/ go to WildFly modules Directory: cd wildfly-10.0.0.Final/modules/system/layers/base mkdir -p mysql/mysql-connector-java/main copy  mysql-driver mysql-connector-java-5.1.38.jar here. add a file module.xml with content: <?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.1"          name="mysql.mysql-connector-java">     <resources>         <resource-root path="mysql-connector-java-5.1.38.jar"/>         <!-- Insert resources here --> ...

MySQL as Default Database in WildFly 8.0.0.CR1

How to  replac the H2 Database for Default DataSource in JBoss WildFly 8.0.0.CR1: Step 1: Add MySQL Driver to modules: Download the mysql-driver mysql-connector-java-5.1.22.jar from any Maven Repository e.g.: http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.22/ go to WildFly modules Directory: cd wildfly-8.0.0.CR1/modules/system/layers/base mkdir -p mysql/mysql-connector-java/main copy  mysql-driver mysql-connector-java-5.1.22.jar here. add a file module.xml with content: <?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.1"          name="mysql.mysql-connector-java">     <resources>         <resource-root path="mysql-connector-java-5.1.22.jar"/>         <!-- Insert resources here -->     </resources>     <dependencies>   ...

macports Update 2.1.0

Yesterday, Tuesday, May 17th 2012 macports.org rolled out the Update to 2.1.0 which I received via the sudo port selfupdate command. There was an Issue with Trac, Python26 and the AJP-WSGI Module for the Apache HTTP Server. Solution was to uninstall python and the AJP-WSGI module via the Force Option: sudo port -f uninstall python26 sudo port -f uninstall ajp-wsgi sudo port install python26 sudo port install ajp-wsgi +python26 References: How to use Trac with ajp-wsgi and Apache https://trac.macports.org/wiki/howto/SetupTracAjpWsgi Getting Apache, MySQL, and PHP Running under MacPorts https://trac.macports.org/wiki/howto/MAMP Getting Subversion under MacPorts https://trac.macports.org/wiki/howto/Subversion often used during testing the new configuration: sudo /opt/local/apache2/bin/apachectl -k restart