X-Git-Url: http://jaekl.net/gitweb/?a=blobdiff_plain;f=prod%2Fnet%2Fjaekl%2Fcfb%2Fdb%2Fdriver%2FPostgresqlDriver.java;h=ce4a802fe39c7cb12dde8db661d8adb8e26796ee;hb=a1378c84c773511e4ffe99fb419da67af188aff7;hp=a828d7fc651a84f3d034b6aa8e6452ab3f17cbfc;hpb=01f0bef1b13c6b9f5b370372d36ad4d6149ff2c3;p=cfb.git

diff --git a/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java b/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java
index a828d7f..ce4a802 100644
--- a/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java
+++ b/prod/net/jaekl/cfb/db/driver/PostgresqlDriver.java
@@ -35,10 +35,12 @@ public class PostgresqlDriver extends DbDriver {
 	@Override 
 	public long nextVal(Connection con, Sequence seq) throws SQLException
 	{
-		String sql = " SELECT NEXTVAL('" + seq.getName() + "') ";
+		String sql = " SELECT NEXTVAL(?) ";
 		
 		try (PreparedStatement ps = con.prepareStatement(sql)) 
 		{
+			ps.setString(1, seq.getName());
+			
 			try (ResultSet rs = ps.executeQuery()) {
 				if (rs.next()) {
 					return rs.getLong(1);