protected long executeCreateWithAutoIncrement(String sql) throws SQLException{
		Connection connection= null;
		Statement statement= null;
		ResultSet rs = null;
		System.out.println(sql);
		long autoIncKey = -1;
		try{
			connection = getConnection();
			statement = connection.createStatement();
			statement.executeUpdate(sql, Statement.RETURN_GENERATED_KEYS);
			rs = statement.getGeneratedKeys();
			
			if (rs.next()) {
			    autoIncKey = rs.getInt(1);
			} else {
			    System.out.println("no key generated");
			}
			System.out.println(autoIncKey);
			
		}finally{
			if (rs != null) rs.close();
			if (statement != null) statement.close();
			if (connection != null) connection.close();
		}
		return autoIncKey;
	}