Issue 49786 - updateString doesn't work with MySQL
Summary: updateString doesn't work with MySQL
Status: CLOSED FIXED
Alias: None
Product: App Dev
Classification: Unclassified
Component: api (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P3 Trivial
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@api
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-05-24 15:00 UTC by georgsalvenmoser
Modified: 2013-02-24 21:09 UTC (History)
1 user (show)

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


Attachments
Backupfile of MySQL and the odb-file (see Formular Artikel) (56.19 KB, application/octet-stream)
2005-05-24 15:05 UTC, georgsalvenmoser
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description georgsalvenmoser 2005-05-24 15:00:19 UTC
I have a MySQL DB 4.1 (or 5.04) connect it with JDBC 3.1.7 to OOo1.9.104 (or 
OOo1.1.4) on WinXP Home
When I make and updatable ResultSet I can write Data to the DB with
updateBoolean and updateDouble but when I try to write Data to an Varchar
with updateString it dosn't work.
When I try it with dBase it works.

Here my Macro:

Sub Main

Dim DatenbankKontext as Object
Dim Datenquelle as Object
Dim Verbindung as Object
Dim Statement as Object
Dim Resultset as Object

DatenbankKontext = createUnoService("com.sun.star.sdb.DatabaseContext")
Datenquelle = DatenbankKontext.getByName("Test")
Verbindung = Datenquelle.getConnection( "", "" )
Statement = Verbindung.createStatement()
Statement.ResultSetConcurrency = 1008
Resultset = Statement.executeQuery("SELECT * FROM bestart")

Resultset.next()
Resultset.updateString (6, "Test")
Resultset.updateDouble (13, 856)
Resultset.updateRow()
msgbox Resultset.getString (6)

Resultset.close()
Statement.close()
Verbindung.close()

End Sub


Thanks
Georg Salvenmoser 

PS.: I couldn't find where I can attach the sample document. If it is useful I
can send them with E-Mail.
Comment 1 georgsalvenmoser 2005-05-24 15:05:43 UTC
Created attachment 26498 [details]
Backupfile of MySQL and the odb-file (see Formular Artikel)
Comment 2 stephan.wunderlich 2005-05-25 10:34:45 UTC
sw->oj: the 856 is nicely written into the db, but the "Test" isn't filled into
the resultset, it stays as it is.
Comment 3 ocke.janssen 2005-05-25 10:40:30 UTC
Set to OOlater
Comment 4 ocke.janssen 2006-03-09 10:27:10 UTC
Fixed in cws oj17.

Just a ";" was missing :-)
Comment 5 ocke.janssen 2006-04-10 07:59:22 UTC
Please verify. Thanks.

re-open issue and reassign to msc@openoffice.org
Comment 6 ocke.janssen 2006-04-10 07:59:26 UTC
reassign to msc@openoffice.org
Comment 7 ocke.janssen 2006-04-10 07:59:29 UTC
reset resolution to FIXED
Comment 8 marc.neumann 2006-04-12 13:53:29 UTC
this is fixed for JDBC for ODBC there is the new issue 64352
Comment 9 marc.neumann 2006-08-23 13:01:57 UTC
works in 2.03 but not in  current version.

The same reason for this issue, is return with cws warnings01.

PLease fix again.

Bye Marc
Comment 10 marc.neumann 2006-08-23 13:02:29 UTC
reopen
Comment 11 ocke.janssen 2006-08-31 09:10:06 UTC
Now it's fixed again. :-)
Comment 12 ocke.janssen 2006-09-04 12:42:03 UTC
Please verify. Thanks.
Comment 13 joerg.skottke 2006-09-06 08:10:04 UTC
Setting target to match CWS
Comment 14 marc.neumann 2006-09-18 14:45:15 UTC
verified in CWS sb59

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=SRC680%2Fsb59
Comment 15 marc.neumann 2006-10-20 12:43:52 UTC
Hi,

this is fixed in the current master. The current master is available at
http://download.openoffice.org/680/index.html

I close this issue now.

Bye Marc