File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes EJB + JPA Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "EJB + JPA" Watch "EJB + JPA" New topic


Jaderson Araújo

Joined: Apr 29, 2009
Posts: 2
I'm trying to run a MDB that will persist an simple entity that I've already got to persist in a standalone application, using exactly the same entities, but when I try to persist I got an error message, the message say:

java.sql.SQLSyntaxErrorException: 'DTYPE' is not a column in table or VTI 'APP.POSITION'.
Error Code: -1
bind => [coordinates]
Query: InsertObjectQuery(Coordinates[Position[id=null], latitude=56.7765, longitude=23.4545, altitude=0.0])

I'm sure the problem can't be the code of entity, I think is some feature in EJB project, but I don't know what to do, if someone already had a similar problem please help me
I'm going mad

Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968

Does the object that you are mapping use inheritance? It looks to me like there's some inheritance or interface mapping that isn't happening correctly against your database.

Just a hunch though.

-Cameron McKenzie
Jaderson Araújo

Joined: Apr 29, 2009
Posts: 2
How I've said I got to persist if I try to run out of the conteiner, then I' m not sure if the problem is the JPA code I've writen, I think must be anything more particular from that context
I agree. Here's the link:
subject: EJB + JPA
It's not a secret anymore!