[ODE-528] Modifying tables from other schemas than default via extVar

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.2
• Fix Version/s: 1.3.4
• Component/s: BPEL Runtime
• Environment: All
• Assignee: Rafal Rusin
• Reporter: Rafal Rusin
• Created: 26/Feb/09 15:56
• Updated: 13/Apr/10 23:09
• Resolved: 13/Apr/10 22:29

Description

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.