Author: rr
Date: Tue Apr 13 22:29:40 2010
New Revision: 933805
URL: http://svn.apache.org/viewvc?rev=933805&view=rev
Log:
ODE-528: Modifying tables from other schemas than default via extVar (fix)
Modified:
ode/branches/APACHE_ODE_1.X/bpel-runtime/src/main/java/org/apache/ode/bpel/extvar/jdbc/DbExternalVariable.java
Modified:
ode/branches/APACHE_ODE_1.X/bpel-runtime/src/main/java/org/apache/ode/bpel/extvar/jdbc/DbExternalVariable.java
URL:
http://svn.apache.org/viewvc/ode/branches/APACHE_ODE_1.X/bpel-runtime/src/main/java/org/apache/ode/bpel/extvar/jdbc/DbExternalVariable.java?rev=933805&r1=933804&r2=933805&view=diff
==============================================================================
---
ode/branches/APACHE_ODE_1.X/bpel-runtime/src/main/java/org/apache/ode/bpel/extvar/jdbc/DbExternalVariable.java
(original)
+++
ode/branches/APACHE_ODE_1.X/bpel-runtime/src/main/java/org/apache/ode/bpel/extvar/jdbc/DbExternalVariable.java
Tue Apr 13 22:29:40 2010
@@ -142,7 +142,8 @@ class DbExternalVariable {
sb.append(c.colname);
}
- sb.append(" from " + table);
+ sb.append(" from ");
+ sb.append(schema + "." + table);
if (_keycolumns.size() > 0) {
sb.append(" where ");
first = true;
@@ -166,7 +167,7 @@ class DbExternalVariable {
private void createUpdate() {
_updcolumns.clear();
StringBuilder sb = new StringBuilder("update ");
- sb.append(table);
+ sb.append(schema + "." + table);
sb.append(" set ");
boolean first = true;
for (Column c : _columns) {
@@ -213,7 +214,7 @@ class DbExternalVariable {
private void createInsert() {
_inscolumns.clear();
StringBuilder sb = new StringBuilder("insert into ");
- sb.append(table);
+ sb.append(schema + "." + table);
sb.append(" ( ");
boolean first = true;
for (Column c : _columns) {
