Thank you David and Toby for pointing this out to us. We'll try to use the
underlying Connection, this sounds very good.
Alexander Jerusalem
At 03:20 11.04.01, David Jencks wrote:
>Hi,
>Thanks for the clarification of what you are working with.
>
>The Minerva pools (to fake an XADatasource from a nonXA driver) hand out a
>wrapped connection, transferring exactly the connection interface to a
>"DriverManager" obtained connection.-- these will obviously not have the
>Oracle extensions you need.
>
>I think your choices are to
>1. Use the Oracle XA driver with which so many people have rather vocal
>problems-- assuming that it implements the Oracle extensions you need and
>works with the OracleSpatialManager.
>
>2. Modify the Minerva wrapper connection to either expose the additional
>interface if any the Oracle connection exposes or add a method to return
>the underlying Oracle connection. I would expect that if you don't hold
>onto the underlying Oracle connection between method calls the latter might
>work-- but I have certainly never tried anything like this. Do you know
>what it is about the Oracle connection that makes it work with the
>OracleSpatialManager? implementing class? interfaces? existence of special
>methods?
>
>
>I would think that the particular connection or connection wrapper you used
>should not have an influence on available datatypes-- aren't these all used
>in the statement and resultset classes?
>
>David Jencks
>
>On 2001.04.10 05:52:18 -0400 Alexander Jerusalem wrote:
> > Hi David. Thank you for your answer.
> >
> > Let me clarify a few things: Roman is not using cmp. When he says
> > "bean-managed" he means bean managed transactions not bean managed
> > persistence. What he tries to do is to read a longitude/latitude value
> > from
> > an Oracle Spatial column inside a stateless SessionBean. This column has
> > the proprietary Oracle type MDSYS.SDO_GEOMETRY and the Oracle way to read
> > a
> > value from such a column is by using the OracleSpatialManager class to
> > create a GeometryAdapter.
> >
> > Now the problem is that a connection that he gets from the connection
> > pool,
> > obviously isn't usable by the OracleSpatialManager. So the questions
> > seems
> > to come down to: is the Connection returned by the connection pool any
> > different (and in what way?) from a connection returned directly by the
> > DriverManager? Can such a connection use Oracle specific JDBC extensions
> > like Spatial datatypes?
> >
> > thanks,
> > Alexander Jerusalem
> >
> >
> > At 04:53 10.04.01, you wrote:
> > >Hi,
> > >
> > >I can't say I understand entirely why you are getting the results you
> > see,
> > >but I'm not surprised.
> > >
> > >Some comments interspersed below
> > >
> > >On 2001.04.09 14:00:36 -0400 Roman Wittchen wrote:
> > > > As my EJB was bean-managed, I had no problems with the connection
> > pool. I
> > > > got my connection simply by calling "con =
> > datasource.getConnection();".
> > > > But since I changed my EJB from bean-managed to container-managed, I
> > am
> > > > not
> > > > able to use the ascertained connection as before.
> > > >
> > > > For example:
> > > > I have to put the connection object to a oracle-spatial-method, to
> > > > receive a
> > > > sdoAdapter object ... code looks something like this ...
> > > >
> > > > GeometryAdapter sdoAdapter = OraSpatialManager.getGeometryAdapter
> > ("SDO",
> > > > "8.1.6", null, STRUCT.class, null, con);
> > >
> > >Where do you get con? I would expect if you get it the same way you get
> > a
> > >connection for bmp, this ought to work---the connection ought to be
> > >associated with a XAConnection that has the correct transaction.
> > However
> > >this is unusual to say the least. Essentially you are mixing cmp and
> > bmp.
> > > >
> > > > But unfortunately sdoAdapter is always null. So I changed the code to
> > ...
> > > >
> > > > GeometryAdapter sdoAdapter = OraSpatialManager.getGeometryAdapter
> > ("SDO",
> > > > "8.1.6", null, STRUCT.class, null, DriverManager.getConnection
> > > > ("jdbc:oracle:thin:@xxx:nnnn:xxxxxx","user", "pw"));
> > >
> > >Here you are getting a connection directly from the driver manager...
> > >bypassing all pooling and transaction management. You may get a
> > >GeometryAdapter but any work you do on it will be outside the container
> > >managed transaction.
> > > >
> > > > And then it works, ... but I don't want to use this possibility,
> > because
> > > > the
> > > > configuration code is hard-coded.
> > > >
> > > > Does anybody know, why this is so ?
> > > >
> > > > And another peculiar thing is, that, if i change the EJB back to
> > > > bean-managed, only the connection-pool variante works, and the
> > hard-coded
> > > > drivermanger variante does not work anymore (then ... the sdoadapter
> > > > object
> > > > is null).
> > >
> > >Again, not surprising that it doesn't work, since you are mixing pooled
> > >connections connected to XAConnections and non pooled connections
> > expected
> > >to manage their own transactions.
> > > >
> > > > Help is appreciated.
> > > >
> > > > Best regards,
> > > > Roman Wittchen
> > >
> > >I don't know what this GeometryAdapter is, but if you need a connection
> > to
> > >get one, you should be getting the connection from the pool so the
> > >transaction is under container control. Is there some reason not to use
> > >bmp for this? In any case you need to get a connection yourself.
> > >
> > >
> > >I think a more sophisticated approach here that would let you do cmp
> > would
> > >be to write a resource adapter for oracle connections +
> > GeometryAdapters,
> > >presumable extending the CCI version of the example BlackBox adapter
> > from
> > >sun. This would work with the jbosscx JCA implementation. However,
> > after
> > >you do this to really get cmp without having to write code that directly
> > >accesses a geometryAdapter you would have to change JAWS very
> > >substantially. On the other hand, the changes might be very little more
> > >than the changes needed to make JAWS work with the CCI - blackbox (which
> > I
> > >haven't examined thoroughly yet).
> > >
> > >It's even possible that Oracle might be working on such a resource
> > >adapter... who knows...
> > >
> > >Hope this is a little helpful.
> > >
> > >David Jencks
> > > >
> > > >
> > > > _______________________________________________
> > > > JBoss-user mailing list
> > > > [EMAIL PROTECTED]
> > > > http://lists.sourceforge.net/lists/listinfo/jboss-user
> > > >
> > >
> > >
> > >_______________________________________________
> > >JBoss-user mailing list
> > >[EMAIL PROTECTED]
> > >http://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
> >
>
>
>_______________________________________________
>JBoss-user mailing list
>[EMAIL PROTECTED]
>http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
