Stack Overflow
Stack Overflow

Questions tagged [rowset]

66 questions
19
votes
2 answers

ResultSet vs RowSet: Which one to choose and when?

So I'm aware of some relative differences i.e., the ResultSet has an 'open connection' to the database whereas a RowSet works in a 'disconnected' fashion. But that's pretty much what I understand (may be incorrect): My question is then this - under…
PhD
  • 11,202
  • 14
  • 64
  • 112
15
votes
4 answers

Implementations of RowSet, CachedRowSet etc

Until today I was working with ResultSet when handling results from queries. But today I read a little about RowSet and CachedRowset and I realized they can serve my purposes better. While in all the examples I read where RowSet and CachedRowSet…
Bennyz
  • 623
  • 2
  • 18
  • 36
6
votes
2 answers

Rowset does not support scrolling backward

I am trying to query a MySQL database with the below code: 'declare the variables Dim Connection Dim Recordset Dim SQL 'declare the SQL statement that will query the database SQL = "SELECT * FROM CUSIP" 'create an instance of the ADO connection…
Telson Alva
  • 842
  • 6
  • 22
  • 37
3
votes
1 answer

How do I place an IN parameter with a LIKE with a RowSet?

I have fighting to get a IN parameter to work inside of a LIKE statement now for hours! I am using a CachedRowSet, which I understand should follow the same rules as a PreparedStatement. Here is the basic query: CachedRowSet cache; String sql =…
WolfmanDragon
  • 7,851
  • 14
  • 49
  • 61
3
votes
1 answer

Peoplesoft CreateRowset with related display record

According to the Peoplebook here, CreateRowset function has the parameters {FIELD.fieldname, RECORD.recname} which is used to specify the related display record. I had tried to use it like the following (just for example): &rs1 =…
Coleman
  • 33
  • 3
3
votes
1 answer

Classic ASP - how to get all T-SQL stored procedure rowsets

I have simple SQL stored procedure with several SELECT statements in it and want to extract this information like this: Set cmd = Server.CreateObject("ADODB.command") cmd.CommandType = adCmdStoredProc cmd.CommandText =…
gotqn
  • 42,737
  • 46
  • 157
  • 243
2
votes
1 answer

Java 8 to Java 19 migration of RowSet

When migrating my project to Java 19, I am getting this error related to our use of RowSet: cannot access class com.sun.rowset.CachedRowSetImpl (in module java.sql.rowset) because module java.sql.rowset does not export com.sun.rowset to module and…
user20913388
2
votes
1 answer

Can RowSets be used with PreparedStatements?

I have just found RowSets for database querying with JDBC. They are stateless and cacheable, they look to be superior to ResultSets. Can PreparedStatements be used with them though? PreparedStatements are a performance booster for querying very…
WolfmanDragon
  • 7,851
  • 14
  • 49
  • 61
2
votes
1 answer

Randomly access to rowset/resultset with PDO Mysql and PHP

I want to access randomly to a result sets retuned from a Stored Procedure using PDO Mysql and PHP. I found PDOStatement::nextRowset but the access to the result sets seems to be sequential. EDIT I'm looking for some like this: $pdo = new…
Cristhian Boujon
  • 4,060
  • 13
  • 51
  • 90
2
votes
2 answers

Updating RowSet if table content is changed?

Is it possible to update/refresh a RowSet's in case the table content is changed (for e.g. another application modifies it)? So this way I 'always' have an up-to-date version of the table. I looked into RowSetListener, but these events seem to get…
Daniel Szalay
  • 4,041
  • 12
  • 57
  • 103
2
votes
2 answers

About the JDBC RowSet

i know about what a RowSet is and all; what i would like to know is if it works properly and is accepted already, or if it still has it's bugs and isn't as widely accepted as the classic ResultSet. it looks good to me so far, but i want to hear more…
cesar
  • 8,944
  • 12
  • 46
  • 59
2
votes
1 answer

PeopleSoft make page readonly - specific rows

I have a page that contains a parent record and several children records. There is a field (level 1) that is a checkbox that is a "final draft" field - after this is checked no more changes can be made (even in correction mode); a new row/effdt…
Chip
  • 1,653
  • 2
  • 20
  • 27
2
votes
1 answer

Including dynamic images in a PDF with BIRT

I am trying to use BIRT 2.5.0 to generate a pdf file. BIRT is called from pHp (this is done thanks to JavaBridge and a Tomcat server). And I am simply trying to create a checkbox, checked under certain conditions. I looked a bit on the internet and…
PiroXXI
  • 47
  • 1
  • 7
1
vote
2 answers

XML rowset and MsXML2

I have a rowset coming back using the Microsoft rowset schema from my stock control system. However when using msxml2 to read the document I don't seem to be able to access the data (Written in vbscript)