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 2009/02/26 16:57:02 UTC
[jira] Created: (ODE-528) Modifying tables from other schemas than
default via extVar
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
Environment: All
Reporter: Rafal Rusin
Fix For: 1.3
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.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (ODE-528) Modifying tables from other schemas
than default via extVar
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ 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
[jira] Resolved: (ODE-528) Modifying tables from other schemas than
default via extVar
Posted by "Rafal Rusin (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rafal Rusin resolved ODE-528.
-----------------------------
Resolution: Fixed
> 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
[jira] Updated: (ODE-528) Modifying tables from other schemas than
default via extVar
Posted by "Rafal Rusin (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rafal Rusin updated ODE-528:
----------------------------
Attachment: addSchemaToSelectInsertUpdate.diff
Here's a patch
> 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
> Environment: All
> Reporter: Rafal Rusin
> Fix For: 1.3
>
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-528) Modifying tables from other schemas than
default via extVar
Posted by "Alexis Midon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexis Midon updated ODE-528:
-----------------------------
Fix Version/s: (was: 1.3.1)
1.3.2
> 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.1
> Environment: All
> Reporter: Rafal Rusin
> Fix For: 1.3.2
>
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (ODE-528) Modifying tables from other schemas than
default via extVar
Posted by "Alex Boisvert (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/ODE-528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alex Boisvert updated ODE-528:
------------------------------
Fix Version/s: (was: 1.3.3)
1.3.4
> 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
> 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.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (ODE-528) Modifying tables from other schemas than
default via extVar
Posted by "Rafal Rusin (JIRA)" <ji...@apache.org>.
[ 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