• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JPA native query problem

 
Shridhar Raghavan
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am executing a native SQL query in JPA. No entities involved



The problem i am facing is when the query string is projecting a column of type TEXT in db, the code throws an exception

javax.persistence.PersistenceException: org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:637)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:74)

The same query works if i change the datatype of the column to VARCHAR. Is there a limitation of JPA with TEXT or is the problem altogether different.
 
Rob Spoor
Sheriff
Pie
Posts: 20744
68
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
-1 is the value of Types.LONGVARCHAR. Now I don't know JPA or Hibernate that well so I don't know its default mappings. I'll move this thread to our ORM forum where people probably do know.
 
Tanya Ruttenberg
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am having exactly the same problem. I am using org.hibernate.dialect.MySQL5InnoDBDialect.
The "config" column type MEDIUMTEXT. As you can see I'm trying to cast the result simply as a String.



Any idea on how to work around the problem?
 
Shridhar Raghavan
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I spent a couple of hours on this and moved on. Here's a few alternatives. Try using hibernate's implementation of the API. Or else use simple jdbc metadata. Both will mean a significant change in code. The simplest solution is change the column type in the database. Unfortunately, I had to write jdbc code as I didnt receive approval for schema modification. Hope someone sorts this out.
 
Tanya Ruttenberg
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks! Of course I scoured the web and didn't find the posting that would help me.

I followed the instructions in the stackoverflow posting exactly and it worked great. I've never extended a dialect before!

patting myself on the back....
TDR
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic