12.12.2012 17:40, Mark Rotteveel wrote: > In JDBC, scrollability is defined by specifying the resultset type at > statement creation with a parameter, and it should not be specified by an > option in the query text by the user. JDBC dictates that if an option is > exposed in the JDBC API, then a user should not specify that option through > query text; a driver implementation itself is free to use query text to > access/enable etc that option (but I would really prefer not to): > > http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#createStatement(int,%20int) > http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#prepareCall(java.lang.String,%20int,%20int) > http://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#prepareStatement(java.lang.String,%20int,%20int) > > Where the resultset type is one of: > TYPE_FORWARD_ONLY The constant indicating the type for a ResultSet object > whose cursor may move only forward. > TYPE_SCROLL_INSENSITIVE The constant indicating the type for a ResultSet > object that is scrollable but generally not sensitive to changes to the > data that underlies the ResultSet. > TYPE_SCROLL_SENSITIVE The constant indicating the type for a ResultSet > object that is scrollable and generally sensitive to changes to the data > that underlies the ResultSet. > > Because of this, having an API that configures the scrollability gives a > lot more flexibility to a driver implementer without resorting to complex > string parsing and manipulation, add to that the potential issue if > somebody specifies WITH SCROLL and the driver does not actually support it.
Point taken, thanks. Dmitry ------------------------------------------------------------------------------ LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
