• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

EJB + JPA

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Call: INSERT INTO POSITION (DTYPE) VALUES (?)
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

thanks
 
author and cow tipper
Posts: 5009
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Thanks
 
reply
    Bookmark Topic Watch Topic
  • New Topic