<p dir="auto"><strong><a href="https://jira.spring.io/secure/ViewProfile.jspa?name=balaji" rel="nofollow">Balaji Varanasi</a></strong> opened <strong><a href="https://jira.spring.io/browse/SPR-6053?redirect=false" rel="nofollow">SPR-6053</a></strong> and commented</p>
<p dir="auto">When executing a Sybase stored procedure using SimpleJdbcCall class, the database metadata is not being loaded. The logs show the following messages:</p>
<p dir="auto">org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory - SQL Server is not one of the databases fully supported for procedure calls -- supported are: [Apache Derby, DB2, MySQL, Microsoft SQL Server, Oracle, Sybase]<br>
org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory - Metadata processing disabled - you must specify all parameters explicitly<br>
org.springframework.jdbc.core.metadata.CallMetaDataProviderFactory - Using org.springframework.jdbc.core.metadata.GenericCallMetaDataProvider</p>
<p dir="auto">After little research, I found that our Sybase database is named "SQL Server" and the commonDatabaseName method in JdbcUtils being used to get the database name compares against the string "sql server".</p>
<p dir="auto">This problem gets fixed if the comparison with "sql server" is done without considering the case.</p>
<hr>
<p dir="auto"><strong>Affects:</strong> 2.5.6, 3.0 M4</p>
<p dir="auto"><strong>Attachments:</strong></p>
<ul dir="auto">
<li><a href="https://jira.spring.io/secure/attachment/15652/sybase.patch" rel="nofollow">sybase.patch</a> (<em>822 bytes</em>)</li>
</ul>
<p dir="auto"><strong>Issue Links:</strong></p>
<ul dir="auto">
<li><a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="398103705" data-permission-text="Title is private" data-url="https://github.com/spring-projects/spring-framework/issues/11630" data-hovercard-type="issue" data-hovercard-url="/spring-projects/spring-framework/issues/11630/hovercard" href="https://github.com/spring-projects/spring-framework/issues/11630">#11630</a> Sybase isn't detected by metadata when using WebLogic JDBC Driver (<em><strong>"is duplicated by"</strong></em>)</li>
<li><a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="398098648" data-permission-text="Title is private" data-url="https://github.com/spring-projects/spring-framework/issues/10936" data-hovercard-type="issue" data-hovercard-url="/spring-projects/spring-framework/issues/10936/hovercard" href="https://github.com/spring-projects/spring-framework/issues/10936">#10936</a> Include 'ASE' in the list of product names recognised by JDBCUtils as Sybase (<em><strong>"is duplicated by"</strong></em>)</li>
</ul>
<p dir="auto"><strong>Referenced from:</strong> commits <a class="commit-link" data-hovercard-type="commit" data-hovercard-url="https://github.com/spring-projects/spring-framework/commit/ea674f2fa61d53c68902120dd666d6756ef5656e/hovercard" href="https://github.com/spring-projects/spring-framework/commit/ea674f2fa61d53c68902120dd666d6756ef5656e"><tt>ea674f2</tt></a>, <a class="commit-link" data-hovercard-type="commit" data-hovercard-url="https://github.com/spring-projects/spring-framework/commit/b482d6db121033e7ee0feed2854d277343f393e1/hovercard" href="https://github.com/spring-projects/spring-framework/commit/b482d6db121033e7ee0feed2854d277343f393e1"><tt>b482d6d</tt></a></p>
<p dir="auto"><strong><a href="https://jira.spring.io/secure/ViewProfile.jspa?name=phancke" rel="nofollow">Patrick Hancke</a></strong> opened <strong><a href="https://jira.spring.io/browse/SPR-3165?redirect=false" rel="nofollow">SPR-3165</a></strong> and commented</p>
<p dir="auto">The Freemarker macro below displays a text area but performs a HTML escape of the 'stringStatusValue' variable. Nothing wrong with that, except that the 'bind' macro also does a HTML escape in case the "defaultHtmlEscape" context-param is set in the 'web.xml'. This is the case in my application, so I end up with a duplicate HTML escape of the textarea content. As a workaround, I've rewritten the 'formTextarea' macro to prevent the HTML escape.</p>
<p dir="auto">&lt;#macro formTextarea path attributes="" &gt;<br>
&lt;<code class="notranslate">@bind</code> path/&gt;</p>
&lt;textarea id="${status.expression}" name="${status.expression}" ${attributes}&gt;${stringStatusValue?html}\&lt;/textarea&gt;
<p dir="auto">&lt;/#macro&gt;</p>
<p dir="auto">&lt;#macro bind path&gt;<br>
&lt;#if htmlEscape?exists&gt;<br>
&lt;#assign status = springMacroRequestContext.getBindStatus(path, htmlEscape)&gt;<br>
&lt;#else&gt;<br>
&lt;#assign status = springMacroRequestContext.getBindStatus(path)&gt;<br>
&lt;/#if&gt;<br>
&lt;#-- assign a temporary value, forcing a string representation for any<br>
kind of variable.  This temp value is only used in this macro lib --&gt;<br>
&lt;#if status.value?exists &amp;&amp; status.value?is_boolean&gt;<br>
&lt;#assign stringStatusValue=status.value?string&gt;<br>
&lt;#else&gt;<br>
&lt;#assign stringStatusValue=status.value?default("")&gt;<br>
&lt;/#if&gt;<br>
&lt;/#macro&gt;</p>
<hr>
<p dir="auto"><strong>Affects:</strong> 2.0 final</p>