jboss as 7.1.3 issue - deployment of .ear file issue

[gevans_mt]

Hi there,

Been trying to solve an issue in which I have a standalone.xml file that is configured to use postgre and when I deploy the .ear file from my development team and it works just fine even with the postgre server stopped/off. However, when they give me an updated standalone.xml that is supposed to use MSSQL Server, I get the errors attached in the jboss_server_deployment.log.

We are using jboss-as-7.1.3.Final and I cannot upgrade it at this time or I would.

I have attached the 2 standalone.xml files as well as follows.

• standalone-mssql.xml
• standalone-postgres-working.xml

I have replaced my company name in all of the files with <company_name> as I do not know if I am allowed to post files with my company name in them and I do not want to run afoul of any company rules.

I am not sure why it works under the postgre xml but not under the mssql xml, and I am at a loss as to where to go from here. I have asked our developers and others at my company that are more familiar with jboss than I am and they have told me that the mssql xml works on their machines (Windows). I am running this under CentOS 7, so maybe there is some problem I am unaware of there as well.

Any help, tips, or suggestions would be greatly appreciated.

Regards,

Greg

[jaikiran]

<driver name="sqljdbc" module="com.microsoft.sqlserver">
                        <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                    </driver>

How did you setup that driver's module? Can you post the folder contents of the com.microsoft.sqlserver module directory and also the module.xml of that module?

[gevans_mt]

Contents of the com.microsoft.sqlserver directory under main

module.xml  sqljdbc4.jar  sqljdbc4.jar.index

module.xml

<module xmlns="urn:jboss:module:1.1" name="com.microsoft.sqlserver">

    <resources>

        <resource-root path="sqljdbc4.jar"/>

        <!-- Insert resources here -->

    </resources>

    <dependencies>

        <module name="javax.api"/>

        <module name="javax.transaction.api"/>

        <module name="javax.servlet.api" optional="true"/>

    </dependencies>

</module>

Note: I haen't touched these at all, because frankly I don't know enough to do anything here

[jaikiran]

I actually can't say for sure why this would work on Windows but not on Linux. I have suspicion that this has to do with the driver loading failing for some reason. 7.1.3 has a known bug where it doesn't report the driver loading failure [AS7-5751] Properly report module load failures while adding JDBC driver - JBoss Issue Tracker. It's been fixed in 7.1.4.Final (the pull request was this [7.1 branch] Fix AS7-5751 by properly reporting module load failures for JDBC drivers by jaikiran · Pull Request #3250 ·…), which should be easy to upgrade/migrate to, if you want to give it a try.

If however, you can't migrate to that version, then the only way to really figure out why it's failing is to attach a debugger to the server and check the code in the JdbcDriverAdd class of the server.