|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
no scrollable cursors in oracle?
background
im trying to connect java to oracle8 (not 8i) using jdbc-odbc bridge (type 1 driver). 'previous' button on my GUI is supposed to display previous records and 'next' button moves to next records. the next button works fine...but on clicking previous buttons...i get exception that ResultSet is TYPE_FORWARD_ONLY. then i read this in ODBC help docs: ---------------------------------- The Microsoft Cursor Library is a DLL that emulates scrollable cursor support. When loaded, it positions itself between the Microsoft Driver Manager and the Oracle ODBC driver.Therefore, all ODBC calls go through the cursor library, which in turn calls the Oracle ODBC driver. The Microsoft Cursor Library parses SQL syntax to support the ‘WHERE CURRENT OF cursor’ clause. The Microsoft Cursor Library also modifies SQL statements before passing them to the Oracle ODBC driver. For example, ‘FOR UPDATE’ and ‘WHERE CURRENT OF cursor’ syntax cannot be seen by the Oracle ODBC driver. The attribute SQL_ATTR_ODBC_CURSORS of the SQLSetConnectAttr call specifies how the Microsoft Driver Manager uses the Microsoft Cursor Library. A value of SQL_CUR_USE_IF_NEEDED directs the Microsoft Driver Manager to load the Microsoft Cursor Library if the Oracle ODBC driver does not support ‘FETCH PRIOR’, and a value of SQL_CUR_USE_ODBC always loads the Microsoft Cursor Library. A value of SQL_CUR_USE_DRIVER requests the Oracle ODBC driver to use its internal scrolling capabilities (of which there are none). ----------------------------------- i cant figure out a way out of this problem. none of the people i contacted, and various programming message boards, are able to help. u guyz are my last hope. if anyone knows a way out of this (how to make cursor scrollable)....plz help. *curls up in a dark corner to cry* ps. oh yeah! the same java code works fine wid access. |
|
#2
|
||||
|
||||
|
Please don't use the inefficient jdbc-odbc bridge, Oracle provides a native jdbc driver here
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > no scrollable cursors in oracle? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|