Just had a look at the code on the weekend, and I am afraid there´s no such functionality available to obtain an instance of the (potentially) DataSource used within Castor to obtain JDBC connections. That's in core Castor JDO, to be precise. Werner
________________________________
From: Sébastien PERES-LABOURDETTE - Public [mailto:[EMAIL PROTECTED]
Sent: Freitag, 23. Februar 2007 15:54
To: [email protected]
Subject: Re: [castor-user] CastorTransactionManager
:) copy that
My class hierarchy currently relies on Castor JDOManagers (10
instances, more to come).
I just need to mix Spring JdbcTemplate queries with OQLQueries where my
object model fails on performance.
If there is a standard way to get the DataSource Instance (or null if
there isn't) from a JDOManager instance, that would be nice.
Thanks for reading.
Werner Guttmann a écrit :
I am not going as far as saying that you should not try to do
this, but please be aware that the bean factories as provided by Spring and
Castor itself work togetehr to e.g. guarantee that transaction enlistement
works as specified, etc.
Can you briefly describe what you are trying to achieve.
Werner
________________________________
From: Sébastien PERES-LABOURDETTE - Public
[mailto:[EMAIL PROTECTED]
Sent: Freitag, 23. Februar 2007 14:54
To: [email protected]
Subject: Re: [castor-user] CastorTransactionManager
Indeed.
(I won't pretend to be a "core J2EE Patterns"
architect best friend but considering my current needs and duties , it would be
useful.)
Werner Guttmann a écrit :
Are you trying to say that you are not using
Spring and its configuration files to define Spring beans for a Castor JDO
manager, a JDBC DataSource, a JDBCTemplate, etc ?
Werner
________________________________
From: Sébastien PERES-LABOURDETTE -
Public [mailto:[EMAIL PROTECTED]
Sent: Freitag, 23. Februar 2007 14:34
To: [email protected]
Subject: Re: [castor-user]
CastorTransactionManager
I don't have any of such beans, i just
have a heavy jdo-conf xml file .....
How can i get some ?
Werner Guttmann a écrit :
Oh, by simply wiring the same spring
bean definition for the jdbc datasource to both the jdbc template and Castor.
Werner
________________________________
From: Sébastien PERES-LABOURDETTE -
Public [mailto:[EMAIL PROTECTED]
Sent: Freitag, 23. Februar 2007 14:15
To: [email protected]
Subject: Re: [castor-user]
CastorTransactionManager
This is it :
What is the standard way to use (or
re-use) my jdo Database Datasource to instantiate a JdbcTemplate the standard
way :
new JdbcTemplate
<http://www.springframework.org/docs/api/org/springframework/jdbc/core/JdbcTemplate.html#JdbcTemplate%28javax.sql.DataSource%29>
(DataSource
<http://java.sun.com/j2se/1.5.0/docs/api/javax/sql/DataSource.html> dataSource)
?
Werner Guttmann a écrit :
Hi,
there's no rule that manadates that a
JDBC template has to use a JDBC connection that has been instantiated from
within Castor. Just instantiate a jdbcTemplate using the standard way, and
Spring (together with Castor's help and vice versa) will be able to figure that
there's already an active transaction associated with a given JDBC connection
(and thus re-use it).
Werner
________________________________
From: Sébastien PERES-LABOURDETTE
[mailto:[EMAIL PROTECTED]
Sent: Freitag, 23. Februar 2007 12:40
To: [email protected]
Subject: Re: [castor-user]
CastorTransactionManager
You are right, this is just what i wish
to do, but how do you get a JDBCTemplate working with a JDOManager (or a
Database) since it expects a DataSource ?
For native JDBC code (out of spring)
this is easy with Database.getJDBCConnection()
Werner Guttmann a écrit :
Yes, that is true. But the limitation
is that this still needs to run within the context of a Spring platform tx
manager, as all the code written is Spring-specific. In other words, I do not
think that it is possible to use things your way.
If you want to use Castor JDO and plain
JDBC from 'within' Spring, please consider using the JDBCTemplate classes, as
this is designed for exectly this need, i.e. to span transactions across
multiple datasources.
Regards
Werner
________________________________
From: Sébastien PERES-LABOURDETTE -
Public [mailto:[EMAIL PROTECTED]
Sent: Freitag, 23. Februar 2007 11:48
To: Castor User
Subject: [castor-user]
CastorTransactionManager
Hi.
Performance issues leads me to mix jdo
with some plain jdbc code.
For that reason, i wish to use the
spring orm implementation for castor.
I wrote a method :
public DataSource getDbDs(String
dbId) {
CastorTransactionManager ctm =
new CastorTransactionManager(_jdoMap.get(dbId));
return ctm.getDataSource();
}
_jdoMap being a map of JDOManagers
successfully initialized.
Each JDOManager points to a database
conf that maps a data-source such :
<data-source
class-name="org.apache.commons.dbcp.BasicDataSource">
<param
name="driver-class-name" value="com.informix.jdbc.IfxDriver" />
<param name="username"
value="informix" />
<param name="password"
value="informix" />
<param name="url"
value="jdbc:informix-sqli://url" />
<param name="maxActive"
value="10" />
<param name="initialSize"
value="3" />
<param
name="removeAbandoned" value="true" />
</data-source>
But the "getDbDs" method returns null
anyway.
Any issue ?
NB :
The javadoc for
"CastorTransactionManager" specifies this :
"With a CastorDialect specified, this
implementation also supports direct DataSource access within a transaction
(i.e. plain JDBC code working with the same DataSource). This allows for mixing
services that access Castor JDO (including transactional caching) and services
that use plain JDBC (without being aware of Castor JDO)! Application code needs
to stick to the same simple Connection lookup pattern as with
DataSourceTransactionManager (i.e. DataSourceUtils.getConnection)."
--
Sébastien PERES-LABOURDETTE
--
Cordialement,
Sébastien PERES-LABOURDETTE <mailto:[EMAIL PROTECTED]>
Responsable applications portail.
Service Informatique
<http://www.omerin.com> Tél : (+33)4-73-82-57-65
Fax : (+33)4-73-82-50-10
--
Sébastien PERES-LABOURDETTE
--
Sébastien PERES-LABOURDETTE
--
Sébastien PERES-LABOURDETTE
--
Sébastien PERES-LABOURDETTE
ATT4092716.png
Description: ATT4092716.png
