Hi,

Here at the lab, a co-worker friend created a program that read csv files (excel tables), compared the data with data from a meta-data table that Oracle creates automatically for every base (in this case, a specific one) and created scripts to populate another base.

Everything done using SQL queries.

Now, I'm trying to replace the SQL stuff with Hibernate and I'm having a problem.

Every search for a table in this meta-data table from oracle returns, instead of all colunms from the table (like every returned object is a colunm) I get a load of the same colunm.

Explaining better: If a table has 16 colunms, it will return 16 times the same colunm.

The SQL generated by hibernate (on the console) is right (we tested it in SQL Developer and got a correct result).

We couldn't locate mapping errors, so, what may be the problem?

Good to know nobody lost his time with this.

I figured the problem out when writing the post down (but as I wasn't exactly sure, I posted anyway)

It was, indeed, a mapping problem. We mapped the table wrongly. We should have used 2 certain columns as PKs when we used only one of them.

Now it works.