Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Hibernate hibernate sql error
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


sateesh
hibernate sql error
1 Answer(s)      4 years and 7 months ago
Posted in : Hibernate


Hibernate: insert into EMPLOYE1 (firstName, lastName, age, p-type, EMP_ID) values (?, ?, ?, 'e', ?)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:366)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at com.sat.Employee.main(Employee.java:29)
Caused by: java.sql.BatchUpdateException: ORA-00917: missing comma

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10657)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 15 more

*)how to use polymorphiuc mapping in type2 using subclasses?

Advertisement
View Answers

June 7, 2010 at 10:53 AM


Hi Friend,

Please visit the following links:

http://www.roseindia.net/hibernate/index.shtml
http://www.roseindia.net/hibernate/insert-data-database.shtml

Hope that it will be helpful for you.
Thanks


Related Tutorials/Questions & Answers:
hibernate sql error - Hibernate
hibernate sql error  Hibernate: insert into EMPLOYE1 (firstName..., Please visit the following links: http://www.roseindia.net/hibernate/index.shtml http://www.roseindia.net/hibernate/insert-data-database.shtml Hope
SQL Error - SQL
SQL Error  Invalid character value for cast specification on column number 5 (Designation) Whats this error about this if the field i specified in programming error. ie DB fields in above question
Advertisements
SQL Error Version 5.5.15
SQL Error Version 5.5.15  SQL Error Version 5.5.15
Hibernate error - Hibernate
Hibernate error  I had run hibernate first example but it an error appeared. Error is java.lang.NullPointerException.  Hi Friend... want more examples of Hibernate please visit the following link. http
Error java.lang.NullPointerException hibernate - Hibernate
Error java.lang.NullPointerException hibernate  hello everybody; I'm developping a web application using Struts 1.1 , Hibernate 3.1 and Mysql , and I've got this message error: Etat HTTP 500
Hibernate error - Hibernate
Hibernate error  I hava following error while running hibernate example in eclipse. I placed hibernate.cfg.xml and contact.hbm.xml in bin/roseindia/tutorial/hibernate. But I have following error. log4j:WARN No appenders
jsp-Hibernate Error - Hibernate
jsp-Hibernate Error  hi, my problem is, I designed an Interface where i am tring to listing the all rows of a table using Iterator and putted a link for deleting each row. I am deleteing row using row id of that record.it delete
display sql query in hibernate
display sql query in hibernate  If you want to see the Hibernate generated SQL statements on console, what should we do
sql script generation - Hibernate
?? is there any way to do that in hibernate? Generate the sql script for tables creation ?and if this available can i do it - generate the sql creation table...sql script generation  he show_sql shows the sql statements
sql syntax error help
sql syntax error help  this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount...') where is the error ?   Please send the error details and the datatype
SQL connection error in android
SQL connection error in android  hi, i am android developer . recently i made one application connect with sql server 2005 using jtds...:sql:Exception : BUFFERDIR connection property invalid. if you have any answer
error : not an sql expression statement
error : not an sql expression statement  hii I am gettin followin error in connecting to database SQLserver 2005 in Jdeveloper,i m usin struts and jsp my pogram: import java.sql.*; public class TaskBO { public TaskBO
connection proxy error in hibernate
connection proxy error in hibernate  while we get connection through hibernate we arise an error connection proxy error while we are using multiple connection's
correct the sql error
correct the sql error  i am getting a SQL Error while retriving data from access to jframe called "datatype mismatch in criteria expression" plez do...(null,"Please enter the Student ID to Search","Error",0); } else { try
JSP SQL Error
JSP SQL Error  Hi While trying to execute the below code i'm getting the following error "java.sql.SQLException: Io exception: Got minus one from a read call ". please help me out. <% try{ String Username
Hibernate delete a row error - Hibernate
Hibernate delete a row error  Hello, I been try with the hibernate delete example (http://www.roseindia.net/hibernate/hibernate-delete.shtml... - Hibernate 3.0rc1 10:46:41,397 INFO Environment:469 - hibernate.properties
Named ? SQL query in hibernate
Named ? SQL query in hibernate  What is Named SQL query in hibernate... putting the sql queries to various places in between code. sample.hbm.xml <hibernate-mapping> <class name="com.test.Product" table="product">
SQL QUERY ERROR
SQL QUERY ERROR  Im writing a query which shows error of INVALID... THE FORM IS THROWING THE ERROR OF INVALID CHARACTER BUT THE SAME QUERY IS RUNNING..._value'. . .); For more information, visit the following link: SQL Queries
Compilation error. Hibernate code - Hibernate
Compilation error. Hibernate code   Exception in thread "main" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory...) how to rectify that error in hibernate  Hi Friend, You have
SQL error - JSP-Servlet
SQL error  Hello friends, Can we update a column with referrence to that column value. For example, the query...){ System.out.println("Error occured while updating!!!"); } con.close
error in hibernate example
error in hibernate example  i am getting error in this.... log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment). log4j:WARN Please initialize the log4j system properly. Resource: Contact.hbm.xml
Hibernate Native SQL Query Introduction
In this section, you will learn Hibernate Native SQL query
foreign key error in sql
foreign key error in sql  create table matchdetails(mid varchar2(10),mdate date,team1 varchar2(10),team2 varchar2(10...) references matchdetails(mid)); ->for the above batsman table it shows error
Hibernate criteria to sql.
Hibernate criteria to sql. In this tutorial, you will see the use of sql() method of Expression class. The Expression class is available...: Hibernate: select this_.id as id0_0_, this_.name as name0_0
Hibernate error in eclipse
Hibernate error in eclipse   Hi... while running my application i got these type errors...can youme please? Exception in thread "main" java.lang.ExceptionInInitializerError at com.StoreData.main(StoreData.java:11) Caused
Hibernate error in eclipse
Hibernate error in eclipse   Hi... while running my application i got these type errors...can youme please? Exception in thread "main" java.lang.ExceptionInInitializerError at com.StoreData.main(StoreData.java:11) Caused
Hibernate error in eclipse
Hibernate error in eclipse   Hi... while running my application i got these type errors...can youme please? Exception in thread "main" java.lang.ExceptionInInitializerError at com.StoreData.main(StoreData.java:11) Caused
Hibernate error in eclipse
Hibernate error in eclipse   Hi... while running my application i got these type errors...can youme please? Exception in thread "main" java.lang.ExceptionInInitializerError at com.StoreData.main(StoreData.java:11) Caused
java compilation error - Hibernate
java compilation error  hi, i have made an registration page whosevalues should be inserted into database. i have used hibernate and eclipse... the corresponding database in the sql(of course u should install your sql setup
Hibernate generated SQL statements on console
Hibernate generated SQL statements on console  If you want to see the Hibernate generated SQL statements on console, what should we do?   If you want to see the Hibernate generated SQL statements on console just add
Hibernate error in eclipse
Hibernate error in eclipse   Hi... while running my application i got these type errors...can youme please? Exception in thread "main" java.lang.ExceptionInInitializerError at com.StoreData.main(StoreData.java:11) Caused
 

 

 

DMCA.com