Hi everyone,
i have a problem with the executeUpdate method that is converting a
value of my sql query to null.
When i create an entry in my table it's setting the id field to null. I
debugged it and saw that the "conversion" took place when i come in the
executeUpdate method and i don't really know why and how to manage it.

Here is a sample of the code :
-----------------------------------------------------------------
private static final String TABLE = "T_CATEGORY";
private static final String COLUMNS = "ID, NAME, DESCRIPTION";
...
   public void insert(final PersistentObject object) throws
DuplicateKeyException {
        Connection connection = null;
        Statement statement = null;
        final Category category = (Category) object;

        try {
            // Gets a database connection
            connection = getConnection();
            statement = connection.createStatement();

            // Inserts a Row
            final String sql = "INSERT INTO " + TABLE + "(" + COLUMNS +
") VALUES ('" + category.getId() + "', '" + category.getName() + "','" +
category.getDescription()+"' )";
            statement.executeUpdate(sql);

        } catch (SQLException e) {
            // The data already exists in the database
            if (e.getErrorCode() == DATA_ALREADY_EXIST) {
                throw new DuplicateKeyException();
            } else {
                // A Severe SQL Exception is caught
                displaySqlException(e);
                throw new DataAccessException("Cannot insert data into
the database", e);
            }
        } finally {
            // Close
            try {
                if (statement != null) statement.close();
                if (connection != null) connection.close();
            } catch (SQLException e) {
                displaySqlException("Cannot close connection", e);
                throw new DataAccessException("Cannot close the
database connection", e);
            }
        }
    }

------------------------------------------------------------------------------
Thanks for your help.
Tomislav