  | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | JSP - A mailing list about Java Server Pages specification and reference | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
  | | | ResultSetInPool | ResultSetInPool 2004-09-30 - By Balogh Zolt?n
Back As far as I remember I have tried and it doesn't work properly... the type of blob is oracle.sql.BLOB. If I use the java.sql.blob type there is some problem with storing in the Oracle DB. (in this case the cast is not necessary)
However I seem that this org.jboss.pool.jdbc.ResultSetInPool is used by the developers but where is this class...???? I can't believe it that I can find this jar file...
-- --Original Message-- -- From: A mailing list for Java(tm) 2 Platform, Enterprise Edition [mailto:J2EE-INTEREST@(protected)]On Behalf Of Partha Ranjan Das Sent: 2004.szeptember 30. 15:11 To: J2EE-INTEREST@(protected) Subject: Re: ResultSetInPool
Does it not work without the cast in the first place...?
> -- ---- -- > From: Balogh Zolt?n[SMTP:zoltan.balogh-sys@(protected)] > Sent: Thursday, September 30, 2004 5:32 PM > To: J2EE-INTEREST@(protected) > Subject: ResultSetInPool > > Hi! > > The following code works with Jboss3.2.1 properly: > > ResultSet rest = prepStmt.executeQuery(); > while (rest.next()){ > blob = ((OracleResultSet)rest).getBLOB(3); > > but with Jboss4.0 one exception is thrown because the cast is not > possible. > I have searched for some solution in topics and I found the following > solution: > blob = > ((OracleResultSet)(((ResultSetInPool)rest).getUnderlyingResultSet())).getB > LOB(3); > > But my problem is that I am not able to find the ResultSetInPool class in > the jars. > Has it existed yet? How could I solve this OracleResultSet problem? > > Thanks, > Zolt?n > > > ========================================================================== > = To unsubscribe, send email to listserv@(protected) and include in the > body of the message "signoff J2EE-INTEREST". For general help, send email > to listserv@(protected) and include in the body of the message "help". > > ********************************************************************* Disclaimer: The information in this e-mail and any attachments is confidential / privileged. It is intended solely for the addressee or addressees. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. *********************************************************************
=========================================================================== To unsubscribe, send email to listserv@(protected) and include in the body of the message "signoff J2EE-INTEREST". For general help, send email to listserv@(protected) and include in the body of the message "help".
=========================================================================== To unsubscribe, send email to listserv@(protected) and include in the body of the message "signoff J2EE-INTEREST". For general help, send email to listserv@(protected) and include in the body of the message "help".
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73"> <TITLE>RE: ResultSetInPool</TITLE> </HEAD> <BODY>
<P><FONT SIZE=2>As far as I remember I have tried and it doesn't work properly. ..</FONT> <BR><FONT SIZE=2>the type of blob is oracle.sql.BLOB. </FONT> <BR><FONT SIZE=2>If I use the java.sql.blob type there is some problem with storing in the Oracle DB. </FONT> <BR><FONT SIZE=2>(in this case the cast is not necessary)</FONT> </P>
<P><FONT SIZE=2>However I seem that this org.jboss.pool.jdbc.ResultSetInPool is used by the developers but where is this class...????</FONT> <BR><FONT SIZE=2>I can't believe it that I can find this jar file...</FONT> </P> <BR>
<P><FONT SIZE=2>-- --Original Message-- --</FONT> <BR><FONT SIZE=2>From: A mailing list for Java(tm) 2 Platform, Enterprise Edition</FONT> <BR><FONT SIZE=2>[<A HREF="mailto:J2EE-INTEREST@(protected)">mailto:J2EE -INTEREST@(protected)</A>]On Behalf Of Partha Ranjan Das</FONT> <BR><FONT SIZE=2>Sent: 2004.szeptember 30. 15:11</FONT> <BR><FONT SIZE=2>To: J2EE-INTEREST@(protected)</FONT> <BR><FONT SIZE=2>Subject: Re: ResultSetInPool</FONT> </P> <BR>
<P><FONT SIZE=2>Does it not work without the cast in the first place...?</FONT> </P>
<P><FONT SIZE=2>> -- ---- --</FONT> <BR><FONT SIZE=2>> From: Balogh Zolt?n[SMTP:zoltan.balogh-sys@(protected)]</FONT> <BR><FONT SIZE=2>> Sent: Thursday, September 30, 2004 5:32 PM</FONT> <BR><FONT SIZE=2>> To: J2EE-INTEREST@(protected)</FONT> <BR><FONT SIZE=2>> Subject: ResultSetInPool< /FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Hi! </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> The following code works with Jboss3.2.1 properly: </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> ResultSet rest = prepStmt.executeQuery(); </FONT> <BR><FONT SIZE=2>> while (rest.next()){ </FONT> <BR><FONT SIZE=2>> blob = ((OracleResultSet)rest).getBLOB(3); </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> but with Jboss4.0 one exception is thrown because the cast is not</FONT> <BR><FONT SIZE=2>> possible. </FONT> <BR><FONT SIZE=2>> I have searched for some solution in topics and I found the following</FONT> <BR><FONT SIZE=2>> solution: </FONT> <BR><FONT SIZE=2>> blob =</FONT> <BR><FONT SIZE=2>> ((OracleResultSet)(((ResultSetInPool)rest) .getUnderlyingResultSet())).getB</FONT> <BR><FONT SIZE=2>> LOB(3); </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> But my problem is that I am not able to find the ResultSetInPool class in</FONT> <BR><FONT SIZE=2>> the jars. </FONT> <BR><FONT SIZE=2>> Has it existed yet? How could I solve this OracleResultSet problem? </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> Thanks, </FONT> <BR><FONT SIZE=2>> Zolt?n </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> ========================================================= =================</FONT> <BR><FONT SIZE=2>> = To unsubscribe, send email to listserv@(protected) and include in the</FONT> <BR><FONT SIZE=2>> body of the message "signoff J2EE-INTEREST". For general help, send email</FONT> <BR><FONT SIZE=2>> to listserv@(protected) and include in the body of the message "help". </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>> </FONT> <BR><FONT SIZE=2>************************************************************** *******</FONT> <BR><FONT SIZE=2>Disclaimer: The information in this e-mail and any attachments is</FONT> <BR><FONT SIZE=2>confidential / privileged. It is intended solely for the addressee or</FONT> <BR><FONT SIZE=2>addressees. If you are not the addressee indicated in this message, you may</FONT> <BR><FONT SIZE=2>not copy or deliver this message to anyone. In such case, you should destroy</FONT> <BR><FONT SIZE=2>this message and kindly notify the sender by reply email. Please advise</FONT> <BR><FONT SIZE=2>immediately if you or your employer does not consent to Internet email for</FONT> <BR><FONT SIZE=2>messages of this kind.</FONT> <BR><FONT SIZE=2>************************************************************** *******</FONT> </P>
<P><FONT SIZE=2>=============================================================== ============</FONT> <BR><FONT SIZE=2>To unsubscribe, send email to listserv@(protected) and include in the body</FONT> <BR><FONT SIZE=2>of the message "signoff J2EE-INTEREST". For general help, send email to</FONT> <BR><FONT SIZE=2>listserv@(protected) and include in the body of the message "help".</FONT> </P>
</BODY> </HTML> =========================================================================== To unsubscribe, send email to listserv@(protected) and include in the body of the message "signoff J2EE-INTEREST". For general help, send email to listserv@(protected) and include in the body of the message "help". <p>
|
|
 |