-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Morris Ford wrote: | Mark, | I verified that I am using the latest version. I | have written a small test java program using jdbc | to test updating through a resultset and whenever | I use resultSet.updateString(x, y), I get an | exception that the resultset is not updateable. | Are there any issues involved with required | structure of the table in tha database or | something else like that? I have attached the | source for the java program. | Morris Ford | | --- Mark Matthews <[EMAIL PROTECTED]> | wrote: | |>-----BEGIN PGP SIGNED MESSAGE----- |>Hash: SHA1 |> |>Morris Ford wrote: |>| Several Questions: |>| |>| Does the 'MM' jdbc driver for MySQL support |>| updateable record sets? |> |>Yes, it has for a year or so. You should make |>sure you're using the |>latest version, 2.0.14, available from |>http://mmmysql.sourceforge.net/ |> |> - -Mark |> |> |> |>-----BEGIN PGP SIGNATURE----- |>Version: GnuPG v1.0.6-2 (MingW32) |>Comment: Using GnuPG with Mozilla - |>http://enigmail.mozdev.org |> |> | | iEYEARECAAYFAj0R50cACgkQlyjUJM+7nP7a7gCgjIh0SRgPyG9e4g2DamDbaZgD | |>LDsAn04fYBQhFr4stgg2oN+yijRNUaGL |>=gb8M |>-----END PGP SIGNATURE----- |> |> |> | | --------------------------------------------------------------------- | |>Before posting, please check: |> http://www.mysql.com/manual.php (the |>manual) |> http://lists.mysql.com/ (the list |>archive) |> |>To request this thread, e-mail |><[EMAIL PROTECTED]> |>To unsubscribe, e-mail |> | | <[EMAIL PROTECTED]> | |>Trouble unsubscribing? Try: |>http://lists.mysql.com/php/unsubscribe.php |> |> |> | | | | __________________________________________________ | Do You Yahoo!? | Yahoo! - Official partner of 2002 FIFA World Cup | http://fifaworldcup.yahoo.com
Have you read the JDBC spec? ResultSets are not updateable if the result set references more than one table, or does not include the primary key(s) of the table. Your table must have primary keys, and you must have them selected in the query that generates the ResultSet. Otherwise, ~ the driver can not uniquely identify the row you are trying to update. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma ~ __ ___ ___ ____ __ ~ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> ~ / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ~ <___/ www.mysql.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj0SP+IACgkQtvXNTca6JD+GEACeM60s7PGBnpURr+LJyu4lnIxM cFYAoJogiAQn6xYYKriTCMvUBMxRoOoF =bYWY -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php