[jboss-jira] [JBoss JIRA] (AS7-6794) SQLServerXADataSource IntegratedSecurity not working when adding XA JNDI datasource
Vedran Mikulcic created AS7-6794:
------------------------------------
Summary: SQLServerXADataSource IntegratedSecurity not working when adding XA
JNDI datasource
Key: AS7-6794
URL: https://issues.jboss.org/browse/AS7-6794
Project: Application Server 7
Issue Type: Feature Request
Components: Server
Affects Versions: 7.1.1.Final
Environment: Windows
Reporter: Vedran Mikulcic
Assignee: Jason Greene
When setting the IntegratedSecurity in the XA datasource on JBoss to true, Microsoft's
JDBC driver doesn't resolve the 'true' setting to boolean value but throws an
error:
{code}
java.lang.NoSuchMethodException:
com.microsoft.sqlserver.jdbc.SQLServerXADataSource.setIntegratedSecurity(java.lang.String)
{code}
This is only the issue when using the XA datasource, non XA datasources work normally.
Steps to reproduce:
1. In the JBoss AS configuration\standalone\standalone.xml add a new xa-datasource to
JNDI:
{code}
<xa-datasource jta="true"
jndi-name="java:jboss/datasources/jndiName" pool-name="poolName"
enabled="true" use-java-context="true" use-ccm="true">
<!-- this should work but doesn't -->
<xa-datasource-property name="IntegratedSecurity">
true
</xa-datasource-property>
<xa-datasource-property name="ServerName">
localhost
</xa-datasource-property>
<xa-datasource-property name="DatabaseName">
MyDbName
</xa-datasource-property>
<xa-datasource-property name="SelectMethod">
cursor
</xa-datasource-property>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
<driver>sqljdbc</driver>
<xa-pool>
<is-same-rm-override>false</is-same-rm-override>
</xa-pool>
<validation>
<valid-connection-checker
class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"/>
</validation>
</xa-datasource>
{code}
2. Restart JBoss AS
3. Try to execute a query using the configured JNDI connection:
{code}
InitialContext ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:jboss/datasources/jndiName");
Connection conn = null;
try {
conn = ds.getConnection();
// try to execute something
CallableStatement stmt = conn.prepareCall("{? = call
some_stored_procedure()}");
stmt.execute();
} finally {
if (conn != null)
conn.close();
}
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira