db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (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 Thu, 03 Jun 2010 12:47:55 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12875086#action_12875086
] 

Rick Hillegas commented on DERBY-4688:
--------------------------------------

Hi Kathey,

Removing the extraneous column from the query may be the best advice we can give. For the
other workarounds we need to point out that the object columns in the catalogs are not part
of Derby's public api, as the Reference Guide says. Another workaround (needing the same disclaimer)
would be to wrap the sysaliases scan in a table function which can unpack AliasInfo on the
server side.

Are you thinking of adding a release note to the 10.6.1 download page? I think that bundling
a new release note with the distributions would involve vetting a new release.

Thanks,
-Rick

> 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