[
https://issues.apache.org/jira/browse/JS2-809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12547779
]
Joachim Müller commented on JS2-809:
------------------------------------
Dennis, I was in a rush when I answered your questions: Of course we must use
the TransactionAwareDataSourceProxy since we are proxying the DataSource and
inject the target datasource into the proxy via spring (see spring configs).
I am attaching the patch again, striped by the reference to the JS2-666 issue.
> Add table schema aware datasource proxy
> ---------------------------------------
>
> Key: JS2-809
> URL: https://issues.apache.org/jira/browse/JS2-809
> Project: Jetspeed 2
> Issue Type: New Feature
> Components: Persistence and DAO
> Affects Versions: 2.1, 2.1.2, 2.1.3, 2.2
> Reporter: Joachim Müller
> Fix For: 2.1.3, 2.2
>
> Attachments: patch.diff
>
>
> In some environments (DB2, Oracle, PostGres) the table schema may be not
> equally associated with the user name, provided in the jdbc connection
> parameters. At the moment it is not possible to set the table schema used for
> the db connections.
> This table schema aware datasource proxy optionally injects a schema
> selection sql statement into an existing database connection. It proxies a
> DataSource and executes an injected sql statement on every getConnection()
> call.
> The proxy can be configured via the spring configurations files and therefore
> allows to add table schema support to the import functionality only. This
> might come in handy if you have to import into a certain table schema and
> cannot rely on the web application container datasource configuration that
> might already support table schemas (like websphere does).
> The solution was inspired from
> http://forum.springframework.org/showthread.php?t=10728, although the runtime
> schema switching functionality was stripped.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
