Recent changes to bugshttps://sourceforge.net/p/spwrapper/bugs/2008-10-06T15:32:32ZRecent changes to bugs<const% broken for multiline statements2008-10-06T15:32:32Z2008-10-06T15:32:32ZGiovannihttps://sourceforge.net/u/bricconi/https://sourceforge.net08c92912791ae160b73da0ae46dfacb4a9936a47<div class="markdown_content"><p>This to let everybody know that unfortunately <const% expressions does not work for multiline statement.<br />
example<br />
select <const% substring(field,10) a,<br />
0.5*field2 %const><br />
from table...</p>
<p>is broken because the regular experession does not work with \r\n characters.</p>
<p>I will fix this soon</p>
<p>Giovanni</p></div>CallableStatement to OracleCallableStatement ClassCastExcept2006-12-08T11:42:13Z2006-12-08T11:42:13ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.net88b4d8b617ca92fdbc93baf9b9af8a56ce9e5eaf<div class="markdown_content"><p>Generated class contains the following line that throws an exception (java.lang.ClassCastException:org.jboss.resource.adapter.jdbc.WrappedCallableStatement):</p>
<p>((OracleCallableStatement)statement).registerOutParameter(1,OracleTypes.CURSOR);</p>
<p>Also, the following line throws the same exception:</p>
<p>P_RECORDSET=((OracleCallableStatement)statement).getCursor(1);</p>
<p>System:<br />
OS: GNU/Linux - Fedora Core 5<br />
DB: Oracle 10g<br />
JDK: 1.5.0_9<br />
AS: JBoss 4.0.5<br />
DB Connection via JNDI datasource.</p></div>