Scratch with alias in MySQL

[Programador3 - Alexis Gu�dez L�pez]

Hi People!!

I'm have something so curious:
        In my application on Java I defined a Statement like this:
                stmt =
con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATAB
LE);
        and execute this query:
                stmt.executeQuery("select * from users as usr where (usr.id = 34)");

So this throw a SQLException:
        SQLException: General error,  message from server: "Table 'db.usr' doesn't
exist"

The application doesn't throw the SQLException if I define a statement by
default, like this:
        stmt = con.createStatement();

Alternatively I execute this query in MySQLFront and it's work fine,
obviously the statement is not UPDATABLE!!

I think: the answer is that RecordSet UPDATABLES or SCROLL_SENSITIVE doesn�t
work with alias, is that correct?? Any coments...

Thanks in advanced!!!

Atte.
Alexis Gu�dez L�pez
Sistemas EPA, ext. 308