Issue 112274 - Update resultset not possible any more
Summary: Update resultset not possible any more
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: MySQL Connector/OOo (show other issues)
Version: DEV300m80
Hardware: PC All
: P2 Trivial with 1 vote (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: oooqa, regression, release_blocker
: 113113 (view as issue list)
Depends on:
Blocks: 111112
  Show dependency tree
 
Reported: 2010-06-10 11:41 UTC by Mechtilde
Modified: 2010-07-28 16:02 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Mechtilde 2010-06-10 11:41:10 UTC 
I try to do my accounting as i do since years.

with version DEV300_m81 after leaving the row with a TAB creating a new row I
get the following message

   SQL-Status: HYC00

   OResultSet::updateDouble: feature not implemented.

I use the mysql connector with a mysql database as backend.



It works fine with the internal HSQL DB as backend
Comment 1 Mechtilde 2010-06-10 11:42:30 UTC 
.
Comment 2 Mechtilde 2010-06-10 12:07:18 UTC 
.
Comment 3 ocke.janssen 2010-06-11 13:00:17 UTC 
The problem here is that the MySQL driver doesn't return the correct value for
the RESULTSETCONCURRENCY and call moveToInsertRow doesn't throw an exception.
Comment 4 Mechtilde 2010-06-11 14:19:14 UTC 
is it possible to get ASAP a test version of a new mysql connector?

I'll test ASAP the other connectors. If this is only a problem of the mysql
connector I will set it here as subcomponent
Comment 5 Mechtilde 2010-06-12 07:44:56 UTC 
I change the subcomponent

It will be a stopper without getting a new mysql-connector.

After first tests it seems to work with JDBC.
Comment 6 Mechtilde 2010-06-12 07:58:25 UTC 
It did not work with version 1.0.1 from
ftp://qa-upload.services.openoffice.org/MySQLConnectorOOo/
Comment 7 uwe.luebbers 2010-06-14 14:07:42 UTC 
Adjusted target
Comment 8 uwe.luebbers 2010-06-14 15:44:14 UTC 
Added MH to cc
Comment 9 Mechtilde 2010-06-14 15:46:24 UTC 
Also with the JDBC driver there are new problems with version 3.3 m82

I can't update datasets with forms.

they are updated in the underlying myssql db but I can't leave the row to go to
the next dataset.

It works with 3.2.1
Comment 10 Mechtilde 2010-06-14 15:59:10 UTC 
now I test the ODBC driver
Comment 11 Frank Schönheit 2010-06-14 19:56:32 UTC 
@mechtilde: please submit a separate issue for the JDBC driver problem. While it
is well possible that both problems are related, it is not sure both need the
same fix.
Comment 12 ocke.janssen 2010-07-09 07:01:41 UTC 
Fixed in cws dba33g
Comment 13 ocke.janssen 2010-07-14 11:57:14 UTC 
Please verify. Thanks.
Comment 14 ocke.janssen 2010-07-14 13:38:12 UTC 
*** Issue 113113 has been marked as a duplicate of this issue. ***
Comment 15 marc.neumann 2010-07-20 11:55:36 UTC 
verified in CWS dba33g

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33g
Comment 16 Mechtilde 2010-07-28 16:02:05 UTC 
verified in OOO330_m2

thanks to the dba team

-> closed