Hibernate + Tomcat org/hibernate/exception/SQLGrammarException java.lang.reflect.InvocationTargetException


HOME ยป Java

Hi I'm trying to make application which will use webservice
deployed on tomcat/axis2 to make some MySQL query and get for example
user.


It's all working fine until I connected my project
with hibernate and database. When I make sql query without tomcat it's
all works. But when I deployed webservice I got this error when
calling webservice:


[ERROR]
org/hibernate/exception/SQLGrammarException />java.lang.reflect.InvocationTargetException
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) /> at sun.reflect.DelegatingMethodAcce

I use play framework !! But when I run my project it give me this


org.hibernate.exception.SQLGrammarException: could not
execute query


who can help me ?


this is my
model:


package models;
import java.util.*; />import javax.persistence.*;
import play.db.jpa.*;
import
play.db.jpa.Model;
@Entity
@Table(name="GxkAccount") />public class GxkAccount extends Model {
private String
Account;
private String Psw;
public String
getAccount() {
return Account;
}
public
void setAccount(String account)
Programming Languages

Hi Im running example using hibernate with postgresql 8.4, when i
try to add it will dispay following error

/>org.hibernate.exception.SQLGrammarException: could not insert:
[com.claystone.db.OrWorkgroup]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) /> at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) /> at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267) /> at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660) /> at org.hibernate.action.EntityInsertAction.execute(EntityI
Databases

when i try to run my code it generate the follwing exception.


INFO: HHH000397: Using ASTQueryTranslatorFactory />Hibernate: select sequence_next_hi_value from hibernate_sequences
where sequence_name = 'Ancestor' for update
Hibernate: insert
into hibernate_sequences(sequence_name, sequence_next_hi_value)
values('Ancestor', ?)
Hibernate: update hibernate_sequences set
sequence_next_hi_value = ? where sequence_next_hi_value = ? and
sequence_name = 'Ancestor'
Hibernate: insert into Ancestor
(nationality, DTYPE, id) values (?, 'Ancestor', ?)
Dec 05, 2012
1:14:43 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper
logExceptions <
Programming Languages

Hi I'm trying to make application which will use webservice
deployed on tomcat/axis2 to make some MySQL query and get for example
user.


It's all working fine until I connected my project
with hibernate and database. When I make sql query without tomcat it's
all works. But when I deployed webservice I got this error when
calling webservice:


[ERROR]
org/hibernate/exception/SQLGrammarException />java.lang.reflect.InvocationTargetException
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) /> at sun.reflect.DelegatingMethodAcce
Java

My DAO layer code is as follows:


package
com.app.dao;
import javax.annotation.Resource;
import
org.hibernate.Session;
import org.hibernate.SessionFactory; />import org.hibernate.Transaction;
import
org.springframework.orm.hibernate3.HibernateTemplate;
import
org.springframework.orm.hibernate3.support.HibernateDaoSupport; />import org.springframework.stereotype.Repository;
import
com.app.pojo.InterviewerPojo; />@Repository("interviewer_details_dao")
public class
InterviewerDetailsDaoImpl implements InterviewerDetailsDao {

@Resource(name="sessionFactory")
private SessionFactory fac
Programming Languages
I tried easy program at Hibernate and caught bunch of exception.I
couldn't figure out what exactly is wrong.I have three classes - Book,
Reader and Using. The last is binding first two with dependency one to
many.Here is my main():public class Appl { public static void
main(String[] args) { Book book = new Book();
book.setTitle("book01155"); // Reader reader = new
Reader(); reader.setName("reader2"); // Using
using = new Using()
Programming Languages

- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow