Issue Details (XML | Word | Printable)

Key: DERBY-28
Type: Bug Bug
Status: Resolved Resolved
Resolution: Cannot Reproduce
Priority: Minor Minor
Assignee: Unassigned
Reporter: Ramandeep Kaur
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

Execute Statement of a SYSIBM sps gives java linkage error and class not found exception.

Created: 01/Oct/04 10:43 PM   Updated: 30/Jul/07 08:59 PM
Return to search
Component/s: SQL
Affects Version/s: 10.0.2.0
Fix Version/s: None

Time Tracking:
Not Specified

Resolution Date: 30/Jul/07 08:59 PM


 Description  « Hide
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.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Kathey Marsden made changes - 30/Jul/07 08:59 PM
Field Original Value New Value
Status Open [ 1 ] Resolved [ 5 ]
Resolution Cannot Reproduce [ 5 ]