JBOSS 4.0.2 Managed to set up a thin connection with an oracle database (using
an oracle datasource).
However the result set cannot handle Oracle blobs > 4k in size.
I have taken this approach ( which has worked for me before):
get connection (called conn in this example) then:
Statement st = conn.createStatement();
resultSet = st.executeQuery("SELECT IMAGE_BLOB FROM ......);
oracle.sql.BLOB blob = null;
blob = ((oracle.jdbc.driver.OracleResultSet) resultSet).getBLOB(1);
But JBOSS throws a classcast exception at the last line!!
14:40:31,986 ERROR [[DVDImageServlet]] Servlet.service() for servlet
DVDImageServlet threw exception
java.lang.ClassCastException
at datasource.DVDImageServlet.doPost(DVDImageServlet.java:77)
at datasource.DVDImageServlet.doGet(DVDImageServlet.java:106)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
lter.java:81) etc................................
Any ideas? I have found very little out there (on the internet) but this must
be a common problem!!
John
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3883375#3883375
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3883375
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
