ms access jdbc query problem

[Fleur]

Dear Forum,
I'm a complete java newby so please bear with me :/

I'm trying some things out with java and ms access.
I manage to connect to my db, and get data from a table. However I'm running into problems when I need data from 2 related tables.
The following query works fine in access

Code:

select * from table1 t1, table2 t2

i get a column not found error when trying to get the data in java using

Code:

table1id = rs.getInt("t1.Id");

rs is a resultset from the executed query and works fine when i use

Code:

select * from table1

I can't seem to find an example with google of a 2 table query

Can anyone point me in the right direction?

Cheers!

f.

[danielstoner]

Try to use rs.getMetaData() to see what are the column names. I don't think you will get the column names prefixed with table names. On the other hand "select *" is not such a good idea. It is way better to specify what columns you want exactly and in what order and to specify your own names in case of duplication.
One thing I don't understand is the purpose of your query. I don't know Access but it looks like you are gonna get a cartesian product of all the rows in the two tables. Is this what you want?

[Fleur]

2WIMC: the error was in the following line:

Quote:

Originally Posted by Fleur

Code:

table1id = rs.getInt("t1.Id");

The name of the column in the rs is "Id" and NOT "t1.Id"