RE: Issue with jdbc resultset ....

Hello Josu,

apparantly something unexpected goes on here ... could you please
check and tell us:

 - The version of the JDBC driver. (java -jar sapdbc.jar -V)

 - Whether you are using explicitely named result sets (either by
   'setCursorName', or by 'DECLARE CURSOR' commands, or procedures
   with result sets. If you use such a named result set, take care that
   there are no two statements in the same session using the same result
   set name, as otherwise it can get confused.

You might want also create a vtrace of the problem, if it is reproducible
(see http://sapdb.2scale.net/moin.cgi/VTrace), use the stop on error option
with error -4000, and send it to me.

Regards
Alexander Schröder
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Josu [mailto:gollumsss@xxxxxxxxx] 
> Sent: Wednesday, December 22, 2004 10:57 AM
> To: maxdb@xxxxxxxxxxxxxxx
> Subject: Issue with jdbc resultset ....
> 
> When i keep refreshing a resultset to get it in sync with changes in
> other screens by the users i ocasionally get:
> 
> Or this error:
> com.sap.dbtech.jdbc.exceptions.NotSupportedException: SAP DBTech JDBC:
> Method first() of MemoryResultSet is not supported.
> 
> Or an error figuring the number of columns in the resulting resultset
> (it returns 0 when if previous and next calls it returns correct
> values, the 0 is occasional)
> 
> Anybody knows why does this happen? Is there any connection or
> preparedstatement parameter that i miss?
> 
> My prepared statement:
> getConexion().prepareCall(fn,ResultSet.TYPE_SCROLL_INSENSITIVE
> ,ResultSet.CONCUR_READ_ONLY);
> 
> My connection string:
> jdbc:sapdb://10.1.1.4/SGA
> 
> Thanks in advance,
> Josu.
> -- 
> "No es lo mismo ensamblar las piezas de un puzzle a fin de 
> formar un cuadro, 
> que coger un cuadro y hacerlo añicos, al objeto de crear un puzzle"
> Julio Camba, Artículos sobre la II República
> 
> -- 
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    
> http://lists.mysql.com/maxdb?unsub=alexander.schroeder@xxxxxxx
> 
> 
> 

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx