[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: JBOSS 4.2.0 & MySQL

[jdijkmeijer]

I have had the same a few times: configuring jboss to use mysql as default database, so I wrote a simple ant task

Not sure if 4.2 is complete, it worked well for 4.0.2 (I made a few changes, for 4.2 standardjaws has been replaces by standardjbosscmp-jdbc) but the server starts without a error.

have funnn


  | <?xml version="1.0"?>
  | 
  | <project name="mysql" default="mysql" basedir=".">
  | 
  |     <property name="jboss_home" value="/Applications/jboss-4.2.0.GA/"/>
  |     <property name="server_conf" value="server/default"/>
  |     <property name="dburl" value="jdbc:mysql://localhost/jboss"/>
  |     <property name="dbuser" value="jboss"/>
  |     <property name="dbpassword" value="jboss"/>
  |     <property name="mysql_lib_dir" value="/Users/jahoo/dev/testsvn/resources/lib12GA"/>
  |     <property name="mysql_file" value="mysql-connector-java-5.0.5-bin.jar"/>
  | 
  |     <target name="mysql"
  |             description="does change mysql to standard db">
  | 	<copy file="${mysql_lib_dir}/${mysql_file}" tofile="${jboss_home}/${server_conf}/lib/${mysql_file}"/>
  |         <delete file="${jboss_home}/${server_conf}/deploy/hsqldb-ds.xml"/>
  |         <copy file="${jboss_home}/docs/examples/jca/mysql-ds.xml" tofile="${jboss_home}/${server_conf}/deploy/mysql-ds.xml"/>
  |         <replaceregexp file="${jboss_home}/${server_conf}/deploy/mysql-ds.xml"  match="MySqlDS" replace="DefaultDS"/>
  |         <replaceregexp file="${jboss_home}/${server_conf}/deploy/mysql-ds.xml"  match="<connection-url>.*</connection-url>" replace="<connection-url>${dburl}</connection-url>"/>
  |         <replaceregexp file="${jboss_home}/${server_conf}/deploy/mysql-ds.xml"  match="user-name>.*<" replace="user-name>${dbuser}<"/>
  |         <replaceregexp file="${jboss_home}/${server_conf}/deploy/mysql-ds.xml"  match="password>.*<" replace="password>${dbpassword}<"/>
  |         <replace file="${jboss_home}/${server_conf}/conf/standardjbosscmp-jdbc.xml"  token="<type-mapping>Hypersonic SQL</type-mapping>" value="<type-mapping>mySQL</type-mapping>"/>
  |         <replace file="${jboss_home}/${server_conf}/conf/standardjbosscmp-jdbc.xml"  token="<fk-constraint>false</fk-constraint>" value="<fk-constraint>true</fk-constraint>"/>
  | 	<delete file="${jboss_home}/${server_conf}/deploy/jms/hsqldb-jdbc2-service.xml"/>
  | 	<delete file="${jboss_home}/${server_conf}/deploy/jms/hsql-jdbc2-service.xml"/>
  |         <copy file="${jboss_home}/docs/examples/jms/mysql-jdbc2-service.xml" tofile="${jboss_home}/${server_conf}/deploy/jms/mysql-jdbc2-service.xml"/>
  |         <replace file="${jboss_home}/${server_conf}/deploy/jms/mysql-jdbc2-service.xml" token="MySqlDS" value="DefaultDS" />
  |         <replace file="${jboss_home}/${server_conf}/conf/login-config.xml" token="<policy>">
  | 	   <replacetoken><![CDATA[<policy>
  | <application-policy name = "MySqlDbRealm">
  |     <authentication>
  |         <login-module code = "org.jboss.resource.security.ConfiguredIdentityLoginModule" flag = "required">
  |             <module-option name = "principal">jboss</module-option>
  |             <module-option name = "userName">jboss</module-option>
  |              <module-option name = "password">jboss</module-option>
  |             <module-option name = "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DefaultDS</module-option>
  |         </login-module>
  |     </authentication>
  | </application-policy>
  | ]]></replacetoken>
  |    </replace>
  | </target>
  | </project>
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4054967#4054967

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4054967