Questions tagged [cachedrowset]
57 questions
0
votes
1 answer
Jtable setValueAt is made irrelevant
I succeeded in making a Jtable which loads from the database using CachedRowSet. I placed the table in a jframe and call the Ui when pressing a button.
When I try to change the values in the cell, they are automatically reset to their original…
Y. Leonce Eyog
- 883
- 2
- 13
- 29
0
votes
0 answers
can insert new row in null cachedrowset?
There is SQLException java.lang.NullPointerException when moveToInsertRow() method called.
rsStock.moveToInsertRow();
rsStock.updateInt(1, 1);
rsStock.updateInt(2, 1);
rsStock.insertRow();
rsStock.moveToCurrentRow();
ram
- 29
- 10
0
votes
2 answers
How to add column to CachedRowSet in java 7?
I want to append a new column in the fashion of
public CachedRowSet addColumn(cachedRowSet Original,List- column, String columnName);
or
public CachedRowSet addColumn(cachedRowSet Original,int column,String columnName);
with the column value…
sakurashinken
- 3,940
- 8
- 34
- 67
0
votes
0 answers
cached Row set populate method not working for sqlserver database
I wrote following code
public JSONObject getListByUserSQLQuery(JSONObject preparedQuery,final int jsonType,final MapmMap,final JSONObject pagination)
throws Exception {
SqlParameterSource…
Darshan Patel
- 3,176
- 6
- 26
- 49
0
votes
1 answer
getBytes() working with ResultSet but not CachedRowSet
I have a Derby SQL database in which I have a table containing a blob field that needs to contain a serialized object.
I access it through JDBC.
The problem is that when I de-serialize the object using a ResultSet all works fine, but if I use a…
sowdust
- 87
- 1
- 9
0
votes
0 answers
How to replace the first two columns of CachedRowSet with one column?
I am using CachedRowSetImpl to store data fetched from db.
But I want to replace first two columns with one my own column .
My code to fetch data is :
cachedRowSet = new CachedRowSetImpl();
…
Volodymyr Levytskyi
- 3,364
- 9
- 46
- 83
0
votes
1 answer
CachedRowSet :: release() vs. close()
I am using a javax.sql.rowset.CachedRowSet object which I pass around in my code. The ResultSet from which it was populated is closed just before the CachedRowSet is passed to the rest of my code (only for reading, I do not update or modify it in…
Marcus Junius Brutus
- 26,087
- 41
- 189
- 331
0
votes
2 answers
Strange behavior for java class CachedRowSetImpl
I have so difficulty to use the CachedRowSetImpl class in java.
I want to analyse the data of a huge postgres table, that contains ~35,000,000 lines and 3 integer columns.
I cannot load everything into my computer physical memory, then I want to…
user2346654
- 51
- 5
0
votes
2 answers
Google web toolkit doesn't work with CachedRowSet
I'm trying to creating a web app using GWT. In my application, I use MySQL as database. I tried to use a connection pool to control the number of connections to the database. However, Google web toolkit doesn't support CachedRowSet, which prevent me…
Progress Programmer
- 7,076
- 14
- 49
- 54
0
votes
1 answer
Save data on multiple tables using Java JBDC CacheRowSet?
As the question above. Can I save data to multiple tables at a time on a CachedRowSet using a JOIN query statement?
Sample sql query statement as below
SELECT * FROM student INNER JOIN class ON student.class_id = class.id
Is it possible or should…
Duy Tran
- 85
- 1
- 2
- 9
0
votes
1 answer
CachedRowSet, ResultSetDynaClass or Another Collection?
I'm cleaning up a very poorly done, large, webapp. I can't do it all at once, so I am taking it in pieces. One thing I would like to do is implement a class with functions that take SQL statements and then returns a collection. My plan is once…
Steve
- 3,127
- 14
- 56
- 96
-1
votes
1 answer
The column index is out of range: 1, number of columns: 0
i updated the UPSERT_DELETE_JOB_COUNTERS.
Now i think the "upsert" works with the new Query =) Or what do you think?
regards,
Peter
`private static final String UPSERT_DELETE_JOB_COUNTERS =
"UPDATE rating.delete_job_counters SET delete_count…
user3181885
- 49
- 2
- 9