On Tuesday 01 April 2008, Patrick Linskey wrote:
> Or, even more simply:
>
> em.getTransaction().begin();
> Connection c = OpenJPAPersistence.cast(em).getConnection();
Actually for what I need I need to cast this to a DelegatingConnection
and then get the PGConnection by casting its InnermostDelegate.
But yes, this works - thank you.
> try {
> ...
> } finally {
> c.close(); // the connection is a wrapper; this decrements the
> reference count
> }
> em.getTransaction().commit();
>
> Additionally, note that OpenJPA 1.1.0-SNAPSHOT has support for fields
> of type InputStream; with this support, OpenJPA will never fully load
> the data into memory.
I can see how this will work for readonly values, how about write ones?
Also looking in the 1.1.0 manual I can not find any reference to InputStream.
David
>
> -Patrick
>
> On Mon, Mar 31, 2008 at 8:31 PM, Pinaki Poddar <[EMAIL PROTECTED]> wrote:
> > Hi,
> > Following should work:
> >
> >
> >
> > import javax.persistence.EntityManager;
> > import org.apache.openjpa.kernel.Broker;
> > import org.apache.openjpa.jdbc.kernel.JDBCStore;
> > import org.apache.openjpa.persistence.JPAFacadeHelper;
> > import java.sql.Connection;
> >
> > EntityManager em = emf.createEntityManager();
> > Broker broker = JPAFacadeHelper.toBroker(em);
> >
> > JDBCStore store = (JDBCStore)broker.getStoreManager();
> > Connection con = store.getConnection();
> >
> > David Goodenough-3 wrote:
> > > I need to get to the real JDBC Connection object so that I can do some
> > > processing using Postgresql extensions (in particular the LargeObject
> > > support). I do not expect OpenJPA to understand what I am doing, but
> > > I need to access the Connection object and I need what I do to be
> > > in the same transaction as that used by OpenJPA (so also it needs to
> > > be the same transaction).
> > >
> > > The manual suggests:-
> > >
> > > OpenJPAEntityManagerFactory kemf = OpenJPAPersistence.cast(emf);
> > > OpenJPAConfiguration conf = kemf.getConfiguration();
> > >
> > > on page 190, but kemf does not have a getConfiguration method
> > > according to Eclipse (using OpenJPA 1.0.2).
> > >
> > > The OpenJPAConfiguration javadoc is not much use either in that it
> > > does tell me where to get it from.
> > >
> > > Any ideas?
> > >
> > > David
> >
> > --
> > View this message in context:
> > http://www.nabble.com/How-to-get-I-get-to-the-read-JDBC-Connection-object
> >...-tp16400383p16401689.html Sent from the OpenJPA Users mailing list
> > archive at Nabble.com.
