<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: Persistence provider creating new table even with update option
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/mtshpandey">Mitesh pandey</a> in <i>EJB3</i> - <a href="http://community.jboss.org/message/620681#620681">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi All,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>On running jboss server i have a message</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>................</p><p>................</p><p>[AnnotationBinder] Binding entity from annotated class: com.domain.Cabin</p><p>[EntityBinder] Bind entity com.domain.Cabin on table Cabin</p><p>[AnnotationBinder] Binding entity from annotated class: com.domain.Address</p><p>[EntityBinder] Bind entity com.domain.Address on table Address</p><p>[AnnotationBinder] Binding entity from annotated class: com.domain.Customer</p><p>[EntityBinder] Bind entity com.domain.Customer on table Customer</p><p>.......................</p><p>.......................</p><p>[SchemaUpdate] Running hbm2ddl schema update</p><p>  [SchemaUpdate] fetching database metadata</p><p>  [SchemaUpdate] updating schema</p><p>  [TableMetadata] table found: public.address</p><p>  [TableMetadata] columns: [zip, address_id, street, state, city]</p><p> [TableMetadata] foreign keys: []</p><p>  [TableMetadata] indexes: [address_pkey]</p><p> [TableMetadata] table found: public.cabin</p><p>  [TableMetadata] columns: [id, ship_id, bed_count, name, deck_level]</p><p> [TableMetadata] foreign keys: []</p><p>  [TableMetadata] indexes: [cabin_pkey]</p><p>  [TableMetadata] table found: public.customer</p><p>  [TableMetadata] foreign keys: [fk27fbe3fe861439fd]</p><p>  [TableMetadata] indexes: [customer_pkey]</p><p>  [SchemaUpdate] schema update complete</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I googled and learnt that the update option basically update the DB schema. At one place it is binding my entity classes with the table in my DB and then while updating schema it has created new table.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>And when i tried running the test application by commenting </p><p><property name="<strong style="font-size: 12px; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">hibernate.hbm2ddl.auto</strong>" value="<strong style="font-size: 12px; font-family: 'Lucida Sans', 'Lucida Sans Unicode', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">update</strong>" /> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>my jboss was up with entity binding successfull but updation failed with below error</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update which was expected.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I m clueless.</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/620681#620681">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in EJB3 at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>