2 Replies Latest reply on Oct 5, 2006 1:00 PM by Michael Barker

    Bug in installer with oracle enabled

    Rudi Vankeirsbilck Newbie

      Guess 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>