Hibernate Community • View topic - Create table in sql server using native query

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Create table in sql server using native query

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

hendhi_wen

Post subject: Create table in sql server using native query

Posted: Thu Jul 01, 2004 12:15 am

Newbie

Joined: Wed Jun 30, 2004 4:44 am
Posts: 5
Location: Indonesia

Dear friends,

I am using hibernate 2.1 and mssql 2000 as the db. Can i create new tables in db using hibernate native query ?

If i can do that, please give me some examples :)

Really thanx,

H

Top

Myk

Post subject:

Posted: Thu Jul 01, 2004 3:12 am

Senior

Joined: Sun Jan 04, 2004 2:46 pm
Posts: 147

If you're thinking about session.createSQLQuery() then you can't. You have to do session.connection() and use the returned JDBC connection to create your table.

eg.

Code:

Session session = factory.openSession();
Transaction tx = session.beginTransaction();

Connection conn = session.connection();

Statement stmt = conn.createStatement();
stmt.execute( "create table xxx ......" );

tx.commit();
session.close();

Remember to trap exceptions to do rollbacks and put session.close() in a finally block.

Top

hendhi_wen

Post subject: Create table from hibernate is very easy

Posted: Thu Jul 01, 2004 10:49 pm

Newbie

Joined: Wed Jun 30, 2004 4:44 am
Posts: 5
Location: Indonesia

Thank you it works smoothly :)

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum