As i was very late, i ve just restored the old dbcp version and then, putted SharedPoolDataSource in the place of Jdbc2Pool supporting class. Now, it's running fine! I guess it's enough, isnt it?
If i use this suggestion --> Try using the standard getBlob() method from the java.sql.ResultSet (returns a java.sql.Blob)--> i will get an exception, since Oracle doesnt implements JDBC correctly, so i cant use Blob in Oracle database. Thank you for the last hint! I ve never heard before about DelegatingResultSet! Do you think important to test it, even the new version is running fine? Thank you very much, Euclides. -----Mensagem original----- De: Dirk Verbeeck [mailto:[EMAIL PROTECTED] Enviada em: terca-feira, 14 de outubro de 2003 18:48 Para: Jakarta Commons Developers List Assunto: Re: RES: Needing help with DBCP - slow response time Try using the standard getBlob() method from the java.sql.ResultSet (returns a java.sql.Blob) Or if you really want to use the oracle specific BLOB then you can do: if (rs instanceof DelegatingResultSet) { DelegatingResultSet drs = (DelegatingResultSet) rs; OracleResultSet ors = (OracleResultSet) drs.getInnermostDelegate(); BLOB blob = ors.getBLOB("TE_ANEXO_DICA"); } -- Dirk Jose Euclides da Silva Junior - DATAPREVRJ wrote: >Dear Dirk, >bad news! >I have done these steps bellows: updating process of DBCP & POOL packages. >Unfortunatelly, since i have done it, i have been getting a cast error >message when my app runs. See bellow: > >exception > >java.lang.ClassCastException > at BancoServlet.getDica(BancoServlet.java:459) > at BancoServlet.recuperaDicaTopico(BancoServlet.java:373) > at BancoServlet.service(BancoServlet.java:238) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio n >FilterChain.java:247) > >The worst is: the line 459 is this one. The Blob headache... It was running >before this change... > BLOB blob = ((OracleResultSet)rs).getBLOB("TE_ANEXO_DICA"); > if ( blob.length() == 0) > >Any help will be appreciated! >Euclides. > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
