You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <ji...@apache.org> on 2007/07/30 22:59:53 UTC
[jira] Resolved: (DERBY-28) Execute Statement of a SYSIBM sps gives
java linkage error and class not found exception.
[ https://issues.apache.org/jira/browse/DERBY-28?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden resolved DERBY-28.
---------------------------------
Resolution: Cannot Reproduce
I cannot reproduce this issue.
ij> execute statement sysibm.getTableTypes;
TABLE_TYPE
------------
SYNONYM
SYSTEM TABLE
TABLE
VIEW
4 rows selected
> Execute Statement of a SYSIBM sps gives java linkage error and class not found exception.
> -----------------------------------------------------------------------------------------
>
> Key: DERBY-28
> URL: https://issues.apache.org/jira/browse/DERBY-28
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.0.2.0
> Reporter: Ramandeep Kaur
> Priority: Minor
>
> Opening this bug on behalf of Mamta Satoor.
> ------------------------------------------------------
> Execute/Create/Drop statement is not supported anymore in
> Derby but we do have internal sps in the database.
> When I try to do say execute statement sysibm.getTableTypes;
> I get 2 exceptions
> Drop statement behaves more gracefully
> ij> drop statement sysibm.getTableTypes;
> ERROR 42X62: 'DROP STATEMENT' is not allowed in the 'SYSIBM'
> schema.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.