You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Rafal Rusin (JIRA)" <ji...@apache.org> on 2010/04/13 13:22:49 UTC
[jira] Assigned: (ODE-528) Modifying tables from other schemas than
default via extVar
[ https://issues.apache.org/jira/browse/ODE-528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rafal Rusin reassigned ODE-528:
-------------------------------
Assignee: Rafal Rusin
> 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