Bug in installer with oracle enabled
rudivankeirsbilck Oct 4, 2006 1:32 PMGuess this is a bug. It has happened 3 times no so it can't be a coincidence anymore.
Not sure if this is the right place to be posting it but here it is:
run the installer with java -jar install.jar, go through the screens and choose orace as database. Either generate a datasource or reuse an existing one, both end up with the same error.
The mail.ear/mail.sar/META-INF/jboss-service.xml will contain:
<!-- Store using the JDBC3 Blob Store with the Oracle Database --> <!-- <mbean code="org.jboss.mail.store.jdbc3.JDBC3Store" name="jboss.mail:type=MailServices,name=JDBC3Store,db=Oracle"> <attribute name="PageSize">32384</attribute> <attribute name="Compress">false</attribute> <attribute name="CompressBufferSize">8192</attribute> <attribute name="ReadStatement">SELECT ID, DATA FROM BLOB_MAIL_STORE WHERE ID = ?</attribute> <attribute name="WriteStatement">SELECT ID, DATA FROM BLOB_MAIL_STORE WHERE ID = ? FOR UPDATE</attribute> <attribute name="IdColumn">ID</attribute> <attribute name="BlobColumn">DATA</attribute> <attribute name="UseStreams">false</attribute> <attribute name="Connected">false</attribute> <attribute name="StartIndex">1</attribute> </mbean>
Resulting in:
19:24:23,262 INFO [EARDeployer] Init J2EE application: file:/Applications/JBossMailServer/versions/1.0M5/server/default/deploy/mail.ear/ 19:24:23,418 ERROR [STDERR] [Fatal Error] jboss-service.xml:174:8: The string "--" is not permitted within comments. 19:24:23,419 ERROR [MainDeployer] Could not initialise deployment: file:/Applications/JBossMailServer/versions/1.0M5/server/default/deploy/mail.ear/ org.jboss.deployment.DeploymentException: The string "--" is not permitted within comments.; - nested throwable: (org.xml.sax.SAXParseException: The string "--" is not permitted within comments.) at org.jboss.deployment.SARDeployer.init(SARDeployer.java:217) at org.jboss.deployment.MainDeployer.init(MainDeployer.java:861) at org.jboss.deployment.MainDeployer.init(MainDeployer.java:881) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:798) at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
It suffices to remove the lines that says:
<!--
from the block that defines the blob store for the oracle database.
Ending up with:
<!-- Store using the JDBC3 Blob Store with the Oracle Database --> <mbean code="org.jboss.mail.store.jdbc3.JDBC3Store" name="jboss.mail:type=MailServices,name=JDBC3Store,db=Oracle"> <attribute name="PageSize">32384</attribute> <attribute name="Compress">false</attribute> <attribute name="CompressBufferSize">8192</attribute> <attribute name="ReadStatement">SELECT ID, DATA FROM BLOB_MAIL_STORE WHERE ID = ?</attribute> <attribute name="WriteStatement">SELECT ID, DATA FROM BLOB_MAIL_STORE WHERE ID = ? FOR UPDATE</attribute> <attribute name="IdColumn">ID</attribute> <attribute name="BlobColumn">DATA</attribute> <attribute name="UseStreams">false</attribute> <attribute name="Connected">false</attribute> <attribute name="StartIndex">1</attribute> </mbean>