Hibernate multiple native SQL statements

Question

I want to run a native SQL from a file using Hibernate. The SQL can contain several statements creating the database structure (i.e. tables, constraints but no insert/update/delete statements).

Example, very simple query is below (which contains the following two SQL statements)

CREATE DATABASE test;
CREATE TABLE test.testtbl( id int(5));

I am using MySQL db, and when I run the above query I am gettng syntax error returned. When I run them one by one, its ok.

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
You have an error in your SQL syntax; check the manual that corresponds to your 
MySQL server version for the right syntax to use near 
'CREATE TABLE test.testtbl( id int(5))' at line 1

The code to run the query is below (above statement is assigned to 'sql' variable):

session = sf.openSession();
session.beginTransaction();
Query qry = session.createSQLQuery(sql);
qry.executeUpdate();
session.getTransaction().commit();

Any help would be appreciated.

You need to run them one by one, that is how JDBC works.

Boris the Spider
– Boris the Spider

2013-03-09 15:58:32 +00:00
Commented Mar 9, 2013 at 15:58 — Boris the Spider
– Boris the Spider, Commented Mar 9, 2013 at 15:58

Yair Zaslavsky · Accepted Answer · 2013-03-09 16:30:44Z

1

As others have explained
You must run these queries one by one.
The hibernate code gets translated into running one update statement on JDBC.
But you provided two update statements.
In addition,
I personally prefer to have the code that creates tables outside of the Java application, in some DB scripts.

answered Mar 9, 2013 at 16:30

Yair Zaslavsky

4,1374 gold badges22 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

demo · Accepted Answer · 2013-03-11 09:15:57Z

0

The parameters of the method createSQLQuery is t-sql code; t-sql code to ensure that in the mysql interface analyzer correctly. You can try changed the sql :'CREATE TABLE testtbl(id int(5));' by the way you can use JDBC Connection api (Don't recommend to do so) Such as: java.sql.Connection conn=session.connection();

answered Mar 11, 2013 at 9:15

demo

1113 bronze badges

Collectives™ on Stack Overflow

Hibernate multiple native SQL statements

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related