I have a query line like ...
SELECT * FROM Nodes, Accounts WHERE Nodes.name = 'dyn0011' AND
Nodes.id = Accounts.node_id AND Accounts.name = 'dude'
After I get my resultsets, I do a rs.getInt("Nodes.id"), but then I get
the following error ...
17:52:35,693 ERROR [ConfigAccountBean] The column name Nodes.id not
found.
My problem is that both the nodes and accounts tables have an 'id'
column, so thats why I look for "Nodes.id" in the result set.
Any help much appreciated.
