From 8711bc55a374bb564cb292aec69b5267f75eb310 Mon Sep 17 00:00:00 2001 From: Michael Wilson Date: Thu, 20 Nov 2014 21:06:25 +0100 Subject: Fixed Bug: no new user possible --> query changed --- dozentenmodulserver/src/main/java/sql/SQL.java | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'dozentenmodulserver/src/main/java/sql') diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index db23a90a..455b1e6d 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -283,7 +283,8 @@ public class SQL { prest.setString(5, mail); prest.setString(6, Institution); - ResultSet rs = prest.executeQuery(); + prest.executeUpdate(); + con.commit(); sql = "SELECT userID FROM bwLehrpool.m_user where Nachname like " @@ -296,8 +297,8 @@ public class SQL { prest.setString(1, lastname); prest.setString(2, firstname); - rs = prest.executeQuery(); - con.commit(); + ResultSet rs = prest.executeQuery(); + con.commit(); rs.next(); String userid = rs.getString("userID"); con.close(); -- cgit v1.2.3-55-g7522