[jboss-jira] [JBoss JIRA] (AS7-3020) Define and use different JDBC driver versions as modules

[Jason Greene (JIRA)]

    [ https://issues.jboss.org/browse/AS7-3020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12690278#comment-12690278 ] 

Jason Greene commented on AS7-3020:
-----------------------------------

Those version values specify which jdbc version, not which module version to use. These must matched against the entries in the java.sql.Driver file (there can be more than one Driver version in the same archive).

The module version should be specified as "com.microsoft.sqlserver:2.0" like you list above. What failure do you receive with this setting?
                
> Define and use different JDBC driver versions as modules
> --------------------------------------------------------
>
>                 Key: AS7-3020
>                 URL: https://issues.jboss.org/browse/AS7-3020
>             Project: Application Server 7
>          Issue Type: Bug
>          Components: Documentation, Server
>    Affects Versions: 7.1.0.CR1
>            Reporter: Michael Voegele
>            Assignee: Jason Greene
>              Labels: datasource, driver, major-version, minor-version, module
>         Attachments: module_2.0.xml, module_main.xml, sqljdbc4_2.0.jar, sqljdbc4_3.0.jar
>
>
> When defining a JDBC driver as module and providing two versions as follows:
> {quote}
> JBOSS_HOME/modules/com/microsoft/sqlserver/main/
> JBOSS_HOME/modules/com/microsoft/sqlserver/2.0/
> {quote}
> with according jar and module.xml
> and defining the driver as follows in standalone.xml:
> {quote}
> <driver name="mssql" module="com.microsoft.sqlserver" major-version="2" minor-version="0">
>   <xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
> </driver>
> {quote}
> the following error is thrown:
> {quote}
> 15:53:32,805 ERROR [org.jboss.as.controller] (ServerService Thread Pool -- 25) -> JBAS014612: Operation ("add") failed - address: ([
>     ("subsystem" => "datasources"),
>     ("jdbc-driver" => "mssql")
> ]): java.lang.IllegalStateException: JBAS010435: Specified driver version doesn't match with actual driver version
> {quote}
> When debugging class JdbcDriverAdd, the slot main is always used.
> I also tried to configure the driver as:
> {quote}
> <driver name="mssql" module="com.microsoft.sqlserver" slot="2.0">
> or
> <driver name="mssql" module="com.microsoft.sqlserver:2.0">
> {quote}
> but this does not work and is also not foreseen as from the scheme.
> Also, there is no documentation of how to use major- and minor-version, only the following can be seen in the xsd:
> {quote}
> Specifies the major/minor version of this driver. If the major and minor version is omitted the first available Driver in module will be used.
> {quote}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira