How to add column to CachedRowSet in java 7?

Question

I want to append a new column in the fashion of

public CachedRowSet addColumn(cachedRowSet Original,List<item> column, String columnName);

or

public CachedRowSet addColumn(cachedRowSet Original,int column,String columnName);

with the column value repeated if it is a primitive.

What is the best way to do this?

score 2 · Accepted Answer · answered Aug 09 '14 at 05:13

2

Hmm.. hard to answer without knowing the context. Who is providing that CachedRowSet? They might or might not offer a way to generate a new instance. Are you using CachedRowSetImpl from the RI?

The RowSet is not really intended for that. Can you add it to the generating SQL? SELECT a,b,'additional' from .... Or you can use your CachedRowSet and generate JoinedRowSet with a FULL_JOIN with a single field result set.

answered Aug 09 '14 at 05:13

eckes

10,103
1
59
71

Its coming from a jdbc Teradata query. I'm using the .populate(RowSet r) method to save the rowset after the statement is closed. – sakurashinken Aug 09 '14 at 19:57

score 0 · Answer 2 · answered Sep 11 '15 at 22:17

0

You can't do that in SQL, let alone CachedRowSet, without executing DDL, and CachedRowSet doesn't support that. The part about a repeating value is an elementary violation of 3NF. You probably don't want to do any of this.

answered Sep 11 '15 at 22:17

user207421

305,947
44
307
483

How to add column to CachedRowSet in java 7?

2 Answers2