db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4688) With Derby 10.6 and higher, selecting object columns from system tables ERROR XN020: Error marshalling or unmarshalling a user defined type
Date Wed, 02 Jun 2010 23:49:58 GMT
With Derby 10.6 and higher, selecting object columns from system tables ERROR XN020: Error
marshalling or unmarshalling a user defined type
-------------------------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-4688
                 URL: https://issues.apache.org/jira/browse/DERBY-4688
             Project: Derby
          Issue Type: Bug
          Components: Network Client
    Affects Versions: 10.7.0.0
            Reporter: Kathey Marsden
            Priority: Minor


If derby.jar is not in the classpath when a client selects an object from a system table,
for example selecting ALIASINFO from SYS.SYSALIASES an error will result, eg.
ERROR XN020: Error marshalling or unmarshalling a user defined type: org.apache.
derby.catalog.types.RoutineAliasInfo

To reproduce, put only derbyclient.jar and derbytools.jar  in your classpath and connect to
a running server and run:
ij> connect 'jdbc:derby://localhost:1527/wombat;create=trrue';
ij> select * from sys.sysaliases
> > ;
ALIASID                             |ALIAS

     |SCHEMAID                            |JAVACLASSNAME

           |&|&|SYST&|ALIASINFO      |SPECIFICNAME


--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------
ERROR XN020: Error marshalling or unmarshalling a user defined type: org.apache.
derby.catalog.types.RoutineAliasInfo
ij>

With the 10.5 client it gives the text of the procedure or function definition for ALIASINFO
 may have been useful to someone, e.g.
SQLCAMESSAGE(IN SQLCODE INTEGER,IN SQLERRML SMALLINT,IN SQLERRMC VARCHAR(2400),I
N SQLERRP CHAR(8),IN SQLERRD0 INTEGER,IN SQLERR&

I am not sure what can or should be done about this issue.  Workaround include:
-  Cast the value to LONG VARCHAR in the query.
-  Put  the server jars in the classpath if you want to use the objects.
- Remove extraneous columns if they are not used.

I am not sure what can or should be done about this issue, but a release note would at least
help mitigate it.



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message