File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Help with mapping strange table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Help with mapping strange table" Watch "Help with mapping strange table" New topic

Help with mapping strange table

Martin Podrouzek

Joined: Sep 09, 2004
Posts: 10

recently I'm making an application with legacy MySQL database. I'm using Hibernate along with JBoss. Everything works fine, but one table in the DB is "strange"

As you can guess bu running SELECT you'll get something like
5 John name
5 B surname
5 Mr. title
5 32 age

when running session.createQuery(...).list(); I get 4 times 'name' collumn.
Running session.createQuery(...).scroll() I get empty ScrollableResult (not much surprise here)
I'm not even capable of mappging User using either @hibernate.bag, or @hibernate.set (I can't use List or map since I can't add index collumn to the DB), as this gives me errror.

XDoclet code:

Error it gives:
12:15:02,468 ERROR [Configuration]
Could not configure datastore from input stream
at net.sf.hibernate.util.StringHelper.qualify(

I have doubts, whether it is even possible solve this with Hibernate. I could get the data with JDBC, but I'd like to have my code as clean as possible.

Thank you for any advise.

I agree. Here's the link:
subject: Help with mapping strange table
jQuery in Action, 3rd edition