On Tue, Apr 10, 2001 at 11:52:18AM +0200, 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?
The problem is probably caused by the fact that the connection pool returns
its own implementation of java.sql.Connection that delegates to the
vendor-specific one, so the vendor-specific methods are not available.
I think there are two possible solutions:
1) Cast the connection you receive from the pool to
org.opentools.minerva.xa.wrapper.XAClientConnection and call the
getUnderlyingConnection method.
2) Use the Oracle XADataSource implementation instead of the Minerva
wrapper.
Toby.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
