users@glassfish.java.net

Re: EJB writing binary BLOB data - impossible with oracle JDBC on glassfish?

From: Mitesh Meswani <Mitesh.Meswani_at_Sun.COM>
Date: Fri, 05 Mar 2010 16:00:51 -0800

>Alternatively, is there a way in Glassfish to get your hands on and use the native Oracle resources without breaking transactional integrity?

Use com.sun.appserv.jdbc.DataSource.getConnection(Connection con) to unwrap

On 3/5/2010 1:10 PM, glassfish_at_javadesktop.org wrote:
> I find that all the examples provided by Oracle thin-mode JDBC drivers for writing BLOB data into the database involves driver-specific classes. None are provided that use JDBC standard methods.
>
> Eg:
> http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/advanced/LOBSample/LOBSample.java.html
>
> I have tested the JDBC standard ways of manipulating BLOBs and I have tried a number of ways and a number of Oracle JDBC drivers including the latest but I have found that none of them work. You either end up with exceptions, or a NULL blob.
>
> This presents a problem for glassfish because glassfish provides wrapped JDBC classes to the application. For example to create a blob using oracle's native classes you need access to the unwrapped native classes.
>
> Is updating oracle binary BLOB data from EJBs thus impossible without Oracle fixing their driver?
>
> Alternatively, is there a way in Glassfish to get your hands on and use the native Oracle resources without breaking transactional integrity?
> [Message sent by forum member 'dcam' (david_at_pastornet.net.au)]
>
> http://forums.java.net/jive/thread.jspa?messageID=390309
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>
>