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 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user