0003746: Enable overridding of setting TYPE_SCROLL_INSENSITIVE

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0003746

[Quercus]

feature

always

11-05-09 11:32

11-05-09 12:47

Reporter

PeterJ

View Status

public

Assigned To

nam

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

4.0.2

Product Version

4.0.2

Product Build

Summary

0003746: Enable overridding of setting TYPE_SCROLL_INSENSITIVE

Description

I am trying to extend Quercus to support another database, but that database does not support TYPE_SCROLL_INSENSITIVE for queries, which means that neither the JdbcConnectionResource.query or JdbcStatementResource.prepare methods are working for me.

The patch that I have attached creates a new method, JdbcConnectionResource.canSeek(), and used that method to determine what parameters to add to a query. By default, it returns true, which means existing code continues to work as is. Then developers working on integrating other databases can override canSeek() when extending JdbcConnectionResource. (I have tested this.)

Steps To Reproduce

Additional Information

Attached Files

quercus_scroll_insensitive.txt [^] (2,299 bytes) 11-05-09 11:32

Relationships

Notes
(0004286) nam 11-05-09 12:47	feature request added protected boolean isSeekable() { return true; }

Issue History
Date Modified	Username	Field	Change
11-05-09 11:32	PeterJ	New Issue
11-05-09 11:32	PeterJ	File Added: quercus_scroll_insensitive.txt
11-05-09 11:33	PeterJ	Issue Monitored: PeterJ
11-05-09 12:46	nam	Status	new => assigned
11-05-09 12:46	nam	Assigned To	=> nam
11-05-09 12:47	nam	Status	assigned => closed
11-05-09 12:47	nam	Note Added: 0004286
11-05-09 12:47	nam	Resolution	open => fixed
11-05-09 12:47	nam	Fixed in Version	=> 4.0.2

Mantis 1.0.0rc3[^]

31 total queries executed.
26 unique queries executed.