Apache OpenOffice (AOO) Bugzilla – Issue 49786
updateString doesn't work with MySQL
Last modified: 2013-02-24 21:09:53 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.
Created attachment 26498 [details] Backupfile of MySQL and the odb-file (see Formular Artikel)
sw->oj: the 856 is nicely written into the db, but the "Test" isn't filled into the resultset, it stays as it is.
Set to OOlater
Fixed in cws oj17. Just a ";" was missing :-)
Please verify. Thanks. re-open issue and reassign to msc@openoffice.org
reassign to msc@openoffice.org
reset resolution to FIXED
this is fixed for JDBC for ODBC there is the new issue 64352
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
reopen
Now it's fixed again. :-)
Please verify. Thanks.
Setting target to match CWS
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
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