[ https://issues.apache.org/jira/browse/DERBY-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12546082 ]
Andrew McIntyre commented on DERBY-3230: ---------------------------------------- I know of WinRAR for Windows (http://www.rarlab.com/), and there's GNU unrar for the various Unix OSes. > Selecting data from a Table raises Error XN008: Query processing has been > terminated due to an error on the server > ------------------------------------------------------------------------------------------------------------------ > > Key: DERBY-3230 > URL: https://issues.apache.org/jira/browse/DERBY-3230 > Project: Derby > Issue Type: Bug > Components: Network Client, Network Server > Affects Versions: 10.3.1.4 > Environment: Windows XP > Reporter: Stefan Huber > Priority: Critical > Attachments: test.rar > > > I got a table (PCLASS) in my database where I cannot select the data via a > simple select statement: > - If I execute 'select * from PCLASS': XN008: Query processing has been > terminated due to an error on the server > - If I execute 'select * from PCLASS order by CLASSNAME': it works > - If I add or remove only one row to/from the table: it works > If I use the embedded driver everything works fine. But as soon as I use the > derby network client to access the database, this problem occurs. > This is very odd. I spent a lot of time to do some research on this behavior > because I could not believe that the network client produces errors depending > on the data contained in a table. But after all it looks like I managed to > fill the table with an exact amount of data that causes this error to arise. > To reproduce the problem download the attached file and follow these > instructions: > * extract test.rar to $derby.system.home$ > * start derby network server > * start ji utility and execute the following commands: > ** connect to database test using client driver: > connect 'jdbc:derby://localhost/test;user=ZOL;password=zol'; > ** select content of table PCLASS > select * from PCLASS; > --> Error XN008: Query processing has been terminated due to an error on the > server > ** disconnect from database > disconnect; > ** shutdown database 'test' > connect > 'jdbc:derby://localhost/test;user=ZOL;password=zol;shutdown=true'; > ** connect to database 'test' using embedded driver: > connect 'jdbc:derby:test;user=ZOL;password=zol'; > ** select content of table PCLASS > select * from PCLASS; > --> everything o.k. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.