Click here to Skip to main content
15,921,606 members
Home / Discussions / Database
   

Database

 
GeneralRe: advanced ADO.NET and Oracle Database Pin
Mike Dimmick4-Feb-04 2:39
Mike Dimmick4-Feb-04 2:39 
GeneralUsing UDFs in a SELECT Pin
Colin Angus Mackay3-Feb-04 5:28
Colin Angus Mackay3-Feb-04 5:28 
GeneralRe: Using UDFs in a SELECT Pin
michanne4-Feb-04 3:02
michanne4-Feb-04 3:02 
GeneralRe: Using UDFs in a SELECT Pin
Colin Angus Mackay4-Feb-04 4:28
Colin Angus Mackay4-Feb-04 4:28 
GeneralRe: Using UDFs in a SELECT Pin
michanne4-Feb-04 8:38
michanne4-Feb-04 8:38 
GeneralRe: Using UDFs in a SELECT Pin
Mike Dimmick9-Feb-04 3:51
Mike Dimmick9-Feb-04 3:51 
Generaltabledef access using ADO.NET Pin
kcharney2-Feb-04 12:03
kcharney2-Feb-04 12:03 
GeneralProblems with Access and Odbc Pin
jan larsen1-Feb-04 23:18
jan larsen1-Feb-04 23:18 
Has anyone else experienced problems with Access accessed through ODBC?
I'm using JDBC and the JDBC-ODBC bridge from Sun. The process is this:
1. A row, let's call it <code>R</code>, is updated using SQL an not the updateXXX API.
2. <code>R</code> is fetched into a resultset and a <code>long</code> value, L, is retrieved.
3. <code>L</code> is incremented and <code>R</code> gets updated, again using simple SQL.


The problem is in step 3. The executeUpdate() reports that 1 row is updated, and if I had executed the SQL in Access directly that would have been the case.
But the row is actually not updated at all, the Statement object is set to AutoCommit and everythings seems fine, so this is really the most horrible of all errors: One that just silently let's the user, and the developer, think that all is OK while the data just gets corrupted.

One solution could be to use MSDE instead, but I'm sure that a lot of users would want to use Access.
I really would like to know if this is an ODBC problem or an error in the JDBC-ODBC bridge.


"After all it's just text at the end of the day. - Colin Davies

"For example, when a VB programmer comes to my house, they may say 'does your pool need cleaning, sir ?' " - Christian Graus
Questionedit value from datagrid but can't update database-how? Pin
Member 5754691-Feb-04 15:42
Member 5754691-Feb-04 15:42 
GeneralMicrosoft SQL 2 tables alias GROUP BY questions Pin
Member 57510430-Jan-04 15:59
Member 57510430-Jan-04 15:59 
GeneralRe: Microsoft SQL 2 tables alias GROUP BY questions Pin
Edbert P3-Feb-04 11:50
Edbert P3-Feb-04 11:50 
GeneralReading in an XML File into a DataSet Pin
Member 64401630-Jan-04 7:55
Member 64401630-Jan-04 7:55 
GeneralRe: Reading in an XML File into a DataSet Pin
Mazdak31-Jan-04 5:36
Mazdak31-Jan-04 5:36 
GeneralADO.NET,C#, and MS:Access Pin
Nick Jacobs30-Jan-04 5:38
Nick Jacobs30-Jan-04 5:38 
GeneralCDao MFC classes and a Access 97 DB Pin
Phil.Benson29-Jan-04 21:46
professionalPhil.Benson29-Jan-04 21:46 
GeneralRe: CDao MFC classes and a Access 97 DB Pin
Steve S10-Feb-04 6:27
Steve S10-Feb-04 6:27 
GeneralRe: CDao MFC classes and a Access 97 DB Pin
Phil.Benson10-Feb-04 20:27
professionalPhil.Benson10-Feb-04 20:27 
GeneralRe: CDao MFC classes and a Access 97 DB Pin
Phil.Benson11-Feb-04 1:40
professionalPhil.Benson11-Feb-04 1:40 
GeneralC++ and Database Pin
vin29-Jan-04 19:07
vin29-Jan-04 19:07 
GeneralRe: C++ and Database Pin
basementman30-Jan-04 10:30
basementman30-Jan-04 10:30 
Generalcalculate datacolumn Pin
Member 57546929-Jan-04 18:12
Member 57546929-Jan-04 18:12 
GeneralRe: calculate datacolumn Pin
-Dr_X-30-Jan-04 17:31
-Dr_X-30-Jan-04 17:31 
GeneralProblem of ADO Recordset Pin
Member 55036929-Jan-04 17:37
Member 55036929-Jan-04 17:37 
GeneralUsing List Control with ADO Pin
girl_lash29-Jan-04 16:59
girl_lash29-Jan-04 16:59 
GeneralRetrieving autonumber when inserting data in a table Pin
Anonymous29-Jan-04 9:10
Anonymous29-Jan-04 9:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.