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

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);