[
https://issues.apache.org/jira/browse/ODE-528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12856679#action_12856679
]
Hudson commented on ODE-528:
----------------------------
Integrated in ODE-1.x #100 (See
[http://hudson.zones.apache.org/hudson/job/ODE-1.x/100/])
ODE-528: Modifying tables from other schemas than default via extVar (fix)
> Modifying tables from other schemas than default via extVar
> -----------------------------------------------------------
>
> Key: ODE-528
> URL: https://issues.apache.org/jira/browse/ODE-528
> Project: ODE
> Issue Type: Bug
> Components: BPEL Runtime
> Affects Versions: 1.3.2
> Environment: All
> Reporter: Rafal Rusin
> Assignee: Rafal Rusin
> Fix For: 1.3.4
>
> Attachments: addSchemaToSelectInsertUpdate.diff
>
>
> I did a following entry for extVar in deploy.xml
> <xvar:externalVariable id="var1">
> <jdbc:jdbc>
> <jdbc:datasource-jndi>myds</jdbc:datasource-jndi>
> <jdbc:table>MYSCHEMA1.MYTABLE</jdbc:table>
> </jdbc:jdbc>
> </xvar:externalVariable>
> My default schema from JDBC connection is MYSCHEMA2.
> When I insert, select or update values in DB, there's a following sql
> generated:
> insert into MYTABLE values (...)
> however it ought to be:
> insert into MYSCHEMA1.MYTABLE values (...)
> then a "table doesn't exist" error is issued at runtime (note that extVar
> initialization completes successfully).
> I did some research and fixed it in
> bpel-runtime/src/main/java/org/apache/ode/bpel/extvar/jdbc/DbExternalVariable.java
> for ode1x.
> I run extvar test, which completed successfully.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
