jdbc is using server side prepared statements.
As such the server won't allow this particular construct.
You can put the ? in for where something = ?
Dave
On 25-Apr-07, at 7:30 AM, Djordje Nikolic wrote:
> I had a problem with PreparedStatement which uses ? after FROM clause.
> Server reported org.postgresql.util.PSQLException: ERROR: syntax
> error at or near "$1"
>
> This is simplified example.
>
> PreparedStatement pstmt;
> try {
> pstmt = conn.prepareStatement("SELECT * FROM ?");
> pstmt.setString(1, "ps_nalog");
> pstmt.executeQuery();
> } catch (SQLException ex) {
> ex.printStackTrace();
> }
>
> Can anybody tell me where is posibble to put ? in a SELECT statement !
>
> best regards,
> Djordje Nikolic
>
> www.abanka.co.yu
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster