<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Trouble with MS SQL 2005 and JBoss 4.0.5 - Tomcat works though?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/romerom">Mike Romero</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/560946#560946">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hey Guys,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have a webapp that I'm trying to port from Tomcat to JBoss.  There are two datasources.  One is MySQL, one is MSSQL 2005.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I was able to get the MySQL datasource working in JBoss, but MS SQL is giving me the strangest error.  "Connection Refused".  I know the error itself isn't strange at all, it's just that... there is no network or firewall issue.  There is no issue about the SQL server being down or not listening on that port.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Tomcat works.  JBoss 4.0.5 doesn't.  I haven't tried other versions of JBoss; this is just the version we use here where I work so I am setting my environment up to match theirs.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>web.xml:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml"><span class="jive-xml-tag"><resource-ref></span>   <span class="jive-xml-tag"><description></span>Helios<span class="jive-xml-tag"></description></span>
  <span class="jive-xml-tag"><res-ref-name></span>jdbc/Helios<span class="jive-xml-tag"></res-ref-name></span>
  <span class="jive-xml-tag"><res-type></span>javax.sql.DataSource<span class="jive-xml-tag"></res-type></span>
  <span class="jive-xml-tag"><res-auth></span>Container<span class="jive-xml-tag"></res-auth></span>
<span class="jive-xml-tag"></resource-ref></span>
<span class="jive-xml-tag"><resource-ref></span>
  <span class="jive-xml-tag"><description></span>webCheck<span class="jive-xml-tag"></description></span>
  <span class="jive-xml-tag"><res-ref-name></span>jdbc/webCheck<span class="jive-xml-tag"></res-ref-name></span>
  <span class="jive-xml-tag"><res-type></span>javax.sql.DataSource<span class="jive-xml-tag"></res-type></span>
  <span class="jive-xml-tag"><res-auth></span>Container<span class="jive-xml-tag"></res-auth></span>
<span class="jive-xml-tag"></resource-ref></span>
</code></pre><p><br/>jboss-web.xml:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml"><span class="jive-xml-tag"><?xml version="1.0" encoding="UTF-8"?></span> <span class="jive-xml-tag"><jboss-web></span>
<span class="jive-xml-tag"><resource-ref></span>
<span class="jive-xml-tag"><res-ref-name></span>jdbc/Helios<span class="jive-xml-tag"></res-ref-name></span>
<span class="jive-xml-tag"><res-type></span>javax.sql.DataSource<span class="jive-xml-tag"></res-type></span>
<span class="jive-xml-tag"><jndi-name></span>java:jdbc/Helios<span class="jive-xml-tag"></jndi-name></span>
<span class="jive-xml-tag"></resource-ref></span>
<span class="jive-xml-tag"><resource-ref></span>
<span class="jive-xml-tag"><res-ref-name></span>jdbc/webCheck<span class="jive-xml-tag"></res-ref-name></span>
<span class="jive-xml-tag"><res-type></span>javax.sql.DataSource<span class="jive-xml-tag"></res-type></span>
<span class="jive-xml-tag"><jndi-name></span>java:jdbc/webCheck<span class="jive-xml-tag"></jndi-name></span>
<span class="jive-xml-tag"></resource-ref></span> <span class="jive-xml-tag"></jboss-web></span>
</code></pre><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>sql-ds.xml:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><pre class="jive-pre"><code class="jive-code jive-xml"><span class="jive-xml-tag"><local-tx-datasource></span>
  <span class="jive-xml-tag"><jndi-name></span>jdbc/webCheckORIG<span class="jive-xml-tag"></jndi-name></span>
  <span class="jive-xml-tag"><connection-url></span>jdbc:sqlserver://hostname.domain.edu:5555;databaseName=dbname<span class="jive-xml-tag"></connection-url></span>
  <span class="jive-xml-tag"><driver-class></span>com.microsoft.sqlserver.jdbc.SQLServerDriver<span class="jive-xml-tag"></driver-class></span>
  <span class="jive-xml-tag"><user-name></span>user<span class="jive-xml-tag"></user-name></span>
  <span class="jive-xml-tag"><password></span>pass<span class="jive-xml-tag"></password></span>
<span class="jive-xml-tag"></local-tx-datasource></span>
<span class="jive-xml-tag"><xa-datasource></span> 
  <span class="jive-xml-tag"><jndi-name></span>jdbc/webCheck<span class="jive-xml-tag"></jndi-name></span> 
  <span class="jive-xml-tag"><track-connection-by-tx></span><span class="jive-xml-tag"></track-connection-by-tx></span> 
  <span class="jive-xml-tag"><isSameRM-override-value></span>false<span class="jive-xml-tag"></isSameRM-override-value></span> 
  <span class="jive-xml-tag"><xa-datasource-class></span>com.microsoft.sqlserver.jdbc.SQLServerXADataSource<span class="jive-xml-tag"></xa-datasource-class></span> 
  <span class="jive-xml-tag"><xa-datasource-property name="ServerName"></span>hostname.domain.edu<span class="jive-xml-tag"></xa-datasource-property></span> 
  <span class="jive-xml-tag"><xa-datasource-property name="PortNumber"></span>5555<span class="jive-xml-tag"></xa-datasource-property></span> 
  <span class="jive-xml-tag"><xa-datasource-property name="DatabaseName"></span>dbname<span class="jive-xml-tag"></xa-datasource-property></span> 
  <span class="jive-xml-tag"><xa-datasource-property name="SelectMethod"></span>cursor<span class="jive-xml-tag"></xa-datasource-property></span> 
  <span class="jive-xml-tag"><xa-datasource-property name="User"></span>user<span class="jive-xml-tag"></xa-datasource-property></span> 
  <span class="jive-xml-tag"><xa-datasource-property name="Password"></span>pass<span class="jive-xml-tag"></xa-datasource-property></span> 
  <span class="jive-xml-comment"><!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --></span>
  <span class="jive-xml-tag"><metadata></span>
    <span class="jive-xml-tag"><type-mapping></span>MS SQLSERVER2005<span class="jive-xml-tag"></type-mapping></span>
  <span class="jive-xml-tag"></metadata></span>
<span class="jive-xml-tag"></xa-datasource></span>
</code></pre><p><br/>I've been through a few different SQL configs in that "sql-ds.xml" file based on various examples on the web.  The problem is always the same - "Connection Refused".</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The problem is that I can connect using SQL Server Management Studio as well as from within Eclipse when my webapp is started in Tomcat.  It's just that for some reason, JBoss doesn't seem to get it.  Another little nugget.  Telnet to the port? Nope, that doesn't work.  From a server on the same segment, telnet doesn't work either.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I started out with an older version of "sqljdbc.jar", then upgraded to 2.0, then 3.0, then attempted to use the "jtds" driver.  Each of these produce "Connection Refused".  I've tried with and without JNDI as well.  Same problem <span> :( </span>  This is truly puzzling.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Any ideas? Is there some compatibility issue between SQL Server 2005 and JBoss 4.0.5?  The one thing I noticed is that the example above uses the type-mapping of "MS SQLSERVER2005", only, in "standardjbosscmp-jdbc.xml", there is no entry for 2005, only "MS SQLSERVER" and "MS SQLSERVER2000".  This leads me to believe that a newer version of JBoss might have additional support for SQL Server 2005 and that I might just be going against the stream.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Hopefully you guys have some ideas <span> :) </span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Why does SQL Server Management Studio and Tomcat work?  Why does JBoss fail with a "Connection Refused" similarly to the way Telnet does?</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/560946#560946">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>