Tilman Rassy <rassy 'at' math.TU-Berlin.DE> writes:
> Hello,
>
> I have the following problem: A certain query, i.e.,
>
> SELECT * FROM user_worksheet_grades WHERE user_id = 23 AND worksheet_id = 105;
>
> gives
>
> worksheet_id | user_id | num_edited | num_corrected | grade
> --------------+---------+------------+---------------+-------
> 105 | 23 | 1 | 1 | 4
> (1 row)
>
> when I issue it in psql. When I use the same query from JDBC in Java, the
> column "grade" is SQL NULL.
Can you show the Java code (to the list)?
Are you sure you connect to the database with the same
user/password with psql and JDBC?
--
Guillaume Cottenceau