{"id":14897,"date":"2022-10-09T14:00:48","date_gmt":"2022-10-09T08:30:48","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/"},"modified":"2022-10-09T14:00:48","modified_gmt":"2022-10-09T08:30:48","slug":"solved-mysql-java-exception-before-start-of-result-set-duplicate","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/","title":{"rendered":"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-2260656\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"2260656\" data-parentid=\"2260575\" data-score=\"1\" data-position-on-page=\"3\" data-highest-scored=\"0\" data-question-has-accepted-highest-score=\"0\" itemprop=\"suggestedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>In your code snippet you create PreparedStatements but you do not use them correctly. Prepared statements are meant to be used as a kind of &#8216;statement template&#8217; which is bound to values before it executes. To quote the javadoc:<\/p>\n<pre><code>   PreparedStatement pstmt = con.prepareStatement(\n                                 \"UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?\");\n   pstmt.setBigDecimal(1, 153833.00)\n   pstmt.setInt(2, 110592)\n<\/code><\/pre>\n<p>This has two big advantages over your current usage of PreparedStatement:<\/p>\n<ul>\n<li>one PreparedStatement can be used for multiple executes<\/li>\n<li>it <strong>prevents<\/strong> a possible <strong>SQL injection<\/strong> attack<\/li>\n<\/ul>\n<p>The second one here is the biggie, if for instance your variables <code>first<\/code> and <code>last<\/code> are collected in a user interface and not reformatted, you run the risk of parts of SQL being input for those values, which then end up in your statements! Using bound parameters they will just be used as values, not part of the SQL statement.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved MySQL + JAVA Exception: Before start of result set [duplicate] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] In your code snippet you create PreparedStatements but you do not use them correctly. Prepared statements are meant to be used as a kind of &#8216;statement template&#8217; which is bound to values before it executes. To quote the javadoc: PreparedStatement pstmt = con.prepareStatement( &#8220;UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?&#8221;); pstmt.setBigDecimal(1, &#8230; <a title=\"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\" aria-label=\"More on [Solved] MySQL + JAVA Exception: Before start of result set [duplicate]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[323,906,340],"class_list":["post-14897","post","type-post","status-publish","format-standard","hentry","category-solved","tag-java","tag-jdbc","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] MySQL + JAVA Exception: Before start of result set [duplicate] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] In your code snippet you create PreparedStatements but you do not use them correctly. Prepared statements are meant to be used as a kind of &#8216;statement template&#8217; which is bound to values before it executes. To quote the javadoc: PreparedStatement pstmt = con.prepareStatement( &quot;UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?&quot;); pstmt.setBigDecimal(1, ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-09T08:30:48+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate]\",\"datePublished\":\"2022-10-09T08:30:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\"},\"wordCount\":145,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"java\",\"jdbc\",\"mysql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\",\"name\":\"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-09T08:30:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate] - JassWeb","og_description":"[ad_1] In your code snippet you create PreparedStatements but you do not use them correctly. Prepared statements are meant to be used as a kind of &#8216;statement template&#8217; which is bound to values before it executes. To quote the javadoc: PreparedStatement pstmt = con.prepareStatement( \"UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?\"); pstmt.setBigDecimal(1, ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/","og_site_name":"JassWeb","article_published_time":"2022-10-09T08:30:48+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate]","datePublished":"2022-10-09T08:30:48+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/"},"wordCount":145,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["java","jdbc","mysql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/","url":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/","name":"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-09T08:30:48+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-java-exception-before-start-of-result-set-duplicate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] MySQL + JAVA Exception: Before start of result set [duplicate]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/14897","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=14897"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/14897\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=14897"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=14897"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=14897"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}