[
https://issues.apache.org/jira/browse/DERBY-4688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kathey Marsden updated DERBY-4688:
----------------------------------
Issue & fix info: Release Note Needed,Repro attached,Workaround attached
(was: Release Note Needed)
Urgency: Low
Bug behavior facts: Embedded/Client difference,Regression
Labels: derby_triage10_9 (was: )
Issue Type: Bug (was: Task)
Triage for 10.9. Switch to bug, regression, repro attached and Work around
attached. Unless someone shows enthusiasm for fixing it, I think users will
need to use the work around of including derby.jar in their client classpath
if they want to select these columns from the system tables. We may want to
consider resolving it won't fix
> 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.1.1
> Reporter: Kathey Marsden
> Priority: Minor
> Labels: derby_triage10_9
> Attachments: ReproDerby4688.java, derby-4688_diff_try1.txt,
> releaseNote.html
>
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
