OAA2 Java library Release : 2.2 BioSPICE_SimpleDBClient Connecting Connected to tcp(Host,Port) Connection Made Registering BioSPICE_SimpleDBClient Starting BioSPICE_SimpleDBClient Ready. Sending request: executeQuery('select * from simple_table', ResultSetID, Status) Connecting to direct_connect server at addr(tcp('www.xxx.yyy.zzz',3331)) Connected to tcp('www.xxx.yyy.zzz',3331) Status = Good Sending request: columnCount('BioSPICE:RSID:2', NumberOfColumns, Status) Status = Good Sending request: columnNames('BioSPICE:RSID:2', ColumnNames, Status) Status = Good Sending request: columnTypes('BioSPICE:RSID:2', ColumnTypes, Status) Status = Good Sending request: next('BioSPICE:RSID:2', Row, Status) Status = Good Sending request: nextN('BioSPICE:RSID:2', 3, Rows, Status) Status = Good Getting all remaining rows... ...this can take a while for a large result set... Sending request: all('BioSPICE:RSID:2', AllRemainingRows, Status) Status = Good Sending request: close('BioSPICE:RSID:2', Status) Status = Good *** RESULTS *** query = select * from simple_table RSID = 'BioSPICE:RSID:2' Column Count = 3 Column Names = [id,name,entry_date] Column Types = [int4,varchar,date] Row 1 = ['1','Abe','1991-01-01'] Row 2 = ['2','Betty','1992-02-02'] Row 3 = ['3','Cal','1993-03-03'] Row 4 = ['4','Dot','1994-04-04'] Row 5 = ['5','Ed','1995-05-05']