JPA-TopLink-MySQL

[shalabhvyas]

I created a NetBeans Web Project. I coded an annotated entity class.MySQL was connected and I created a database there. I then created a persistence unit with Drop and Create Strategy. When I run the project, I am surprised no tables are created.The first time I ran the project, I did get an exception regarding the syntax of NamedQuery.After rectifying that error,I did not get any exceptions.But still no tables are created.Moreover, I am not getting any exceptions (I couldn't find one) in the server log. I am using GlassFish V2.1.

Persistence.xml

[michael]

Some JPA annotations do "lazy" creation - they create the tables on the first usage of an entity class. Give your app a go, this might be the case here.

Michael

-----Original Message-----
From: shalabhvyas [mailto:address-removed]
Sent: Tuesday, August 18, 2009 2:09 PM
To: address-removed
Subject: [nbj2ee] JPA-TopLink-MySQL


I created a NetBeans Web Project. I coded an annotated entity class.MySQL was connected and I created a database there. I then created a persistence unit with Drop and Create Strategy. When I run the project, I am surprised no tables are created.The first time I ran the project, I did get an exception regarding the syntax of NamedQuery.After rectifying that error,I did not get any exceptions.But still no tables are created.Moreover, I am not getting any exceptions (I couldn't find one) in the server log. I am using GlassFish V2.1.



Persistence.xml


Code:
<?xml version="1.0" encoding="UTF-8"?>

<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">

<persistence-unit name="SaarthiPU" transaction-type="JTA">

<provider>oracle.toplink.essentials.PersistenceProvider</provider>

<jta-data-source>psmdb_datasource</jta-data-source>

<properties>

<property name="toplink.ddl-generation" value="drop-and-create-tables"/>

<property name="toplink.logging.level" value="FINE"></property>

<property name="toplink.logging.timestamp" value="true"></property>

<property name="toplink.ddl-generation.output-mode" value="both"/>

<property name="toplink.logging.level" value="finest" />

</properties>

</persistence-unit>

</persistence>







server log


Code:
Aug 18, 2009 3:09:26 PM com.sun.enterprise.admin.servermgmt.launch.ASLauncher buildCommand

INFO:

C:/Program Files/Java/jdk1.6.0_12\bin\java

-Dcom.sun.aas.instanceRoot=C:/Sun/AppServer/domains/domain1

-Dcom.sun.aas.ClassPathPrefix=

-Dcom.sun.aas.ClassPathSuffix=

-Dcom.sun.aas.ServerClassPath=

-Dcom.sun.aas.classloader.appserverChainJars.ee=

-Dcom.sun.aas.classloader.appserverChainJars=admin-cli.jar,admin-cli-ee.jar,j2ee-svc.jar

-Dcom.sun.aas.classloader.excludesList=admin-cli.jar,appserv-upgrade.jar,sun-appserv-ant.jar

-Dcom.sun.aas.classloader.optionalOverrideableChain.ee=

-Dcom.sun.aas.classloader.optionalOverrideableChain=webservices-rt.jar,webservices-tools.jar

-Dcom.sun.aas.classloader.serverClassPath.ee=Does not exist/lib/hadbjdbc4.jar,C:/Sun/AppServer/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,Does not exist/lib/dbstate.jar,Does not exist/lib/hadbm.jar,Does not exist/lib/hadbmgt.jar,C:/Sun/AppServer/lib/SUNWmfwk/lib/mfwk_instrum_tk.jar

-Dcom.sun.aas.classloader.serverClassPath=C:/Sun/AppServer/lib/install/applications/jmsra/imqjmsra.jar,C:/Sun/AppServer/imq/lib/jaxm-api.jar,C:/Sun/AppServer/imq/lib/fscontext.jar,C:/Sun/AppServer/imq/lib/imqbroker.jar,C:/Sun/AppServer/imq/lib/imqjmx.jar,C:/Sun/AppServer/lib/ant/lib/ant.jar,C:/Sun/AppServer/lib/SUNWjdmk/5.1/lib/jdmkrt.jar

-Dcom.sun.aas.classloader.sharedChainJars.ee=appserv-se.jar,appserv-ee.jar,jesmf-plugin.jar,Does not exist/lib/dbstate.jar,Does not exist/lib/hadbjdbc4.jar,jgroups-all.jar,C:/Sun/AppServer/lib/SUNWmfwk/lib/mfwk_instrum_tk.jar

-Dcom.sun.aas.classloader.sharedChainJars=javaee.jar,C:/Program Files/Java/jdk1.6.0_12/lib/tools.jar,install/applications/jmsra/imqjmsra.jar,com-sun-commons-launcher.jar,com-sun-commons-logging.jar,C:/Sun/AppServer/imq/lib/jaxm-api.jar,C:/Sun/AppServer/imq/lib/fscontext.jar,C:/Sun/AppServer/imq/lib/imqbroker.jar,C:/Sun/AppServer/imq/lib/imqjmx.jar,C:/Sun/AppServer/imq/lib/imqxm.jar,webservices-rt.jar,webservices-tools.jar,mail.jar,appserv-jstl.jar,jmxremote_optional.jar,C:/Sun/AppServer/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,activation.jar,appserv-rt.jar,appserv-admin.jar,appserv-cmp.jar,C:/Sun/AppServer/updatecenter/lib/updatecenter.jar,C:/Sun/AppServer/jbi/lib/jbi.jar,C:/Sun/AppServer/imq/lib/imqjmx.jar,C:/Sun/AppServer/lib/ant/lib/ant.jar,dbschema.jar

-Dcom.sun.aas.configName=server-config

-Dcom.sun.aas.configRoot=C:/Sun/AppServer/config

-Dcom.sun.aas.defaultLogFile=C:/Sun/AppServer/domains/domain1/logs/server.log

-Dcom.sun.aas.domainName=domain1

-Dcom.sun.aas.installRoot=C:/Sun/AppServer

-Dcom.sun.aas.instanceName=server

-Dcom.sun.aas.processLauncher=SE

-Dcom.sun.aas.promptForIdentity=true

-Dcom.sun.enterprise.config.config_environment_factory_class=com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory

-Dcom.sun.enterprise.overrideablejavaxpackages=javax.help,javax.portlet

-Dcom.sun.enterprise.taglibs=appserv-jstl.jar,jsf-impl.jar

-Dcom.sun.enterprise.taglisteners=jsf-impl.jar

-Dcom.sun.updatecenter.home=C:/Sun/AppServer/updatecenter

-Ddomain.name=domain1

-Djava.endorsed.dirs=C:/Sun/AppServer/lib/endorsed

-Djava.ext.dirs=C:/Program Files/Java/jdk1.6.0_12/lib/ext;C:/Program Files/Java/jdk1.6.0_12/jre/lib/ext;C:/Sun/AppServer/domains/domain1/lib/ext;C:/Sun/AppServer/javadb/lib

-Djava.library.path=C:\Sun\AppServer\lib;C:\Sun\AppServer\lib;C:\Sun\AppServer\bin;C:\Sun\AppServer\bin

-Djava.security.auth.login.config=C:/Sun/AppServer/domains/domain1/config/login.conf

-Djava.security.policy=C:/Sun/AppServer/domains/domain1/config/server.policy

-Djava.util.logging.manager=com.sun.enterprise.server.logging.ServerLogManager

-Djavax.management.builder.initial=com.sun.enterprise.admin.server.core.jmx.AppServerMBeanServerBuilder

-Djavax.net.ssl.keyStore=C:/Sun/AppServer/domains/domain1/config/keystore.jks

-Djavax.net.ssl.trustStore=C:/Sun/AppServer/domains/domain1/config/cacerts.jks

-Djdbc.drivers=org.apache.derby.jdbc.ClientDriver

-Djmx.invoke.getters=true

-Dsun.rmi.dgc.client.gcInterval=3600000

-Dsun.rmi.dgc.server.gcInterval=3600000

-client

-XX:+UnlockDiagnosticVMOptions

-XX:MaxPermSize=192m

-Xmx512m

-XX:NewRatio=2

-XX:+LogVMOutput

-XX:LogFile=C:/Sun/AppServer/domains/domain1/logs/jvm.log

-cp

C:/Sun/AppServer/lib/jhall.jar;C:\Sun\AppServer\lib\appserv-launch.jar

com.sun.enterprise.server.PELaunch

start

CORE5076: Using [Java HotSpot(TM) Client VM, Version 1.6.0_12] from [Sun Microsystems Inc.]

SEC1002: Security Manager is OFF.

Using MQ RA for Broker lifecycle control

SEC1143: Loading policy provider com.sun.enterprise.security.provider.PolicyWrapper.

WEB0114: SSO is disabled in virtual server [server]

WEB0114: SSO is disabled in virtual server [__asadmin]

REgistering Custom ContextConfig

REgistering Custom Context

JTS5014: Recoverable JTS instance, serverId = [3700]

ADM1079: Initialization of AMX MBeans started

ADM1504: Here is the JMXServiceURL for the Standard JMXConnectorServer: [service:jmx:rmi:///jndi/rmi://sage-c7a5abcebe:8686/jmxrmi]. This is where the remote administrative clients should connect using the standard JMX connectors

ADM1506: Status of Standard JMX Connector: Active = [true]

JMS Service Connection URL is :mq://sage-c7a5abcebe:7676/

MQJMSRA_RA1101: SJSMQ JMS Resource Adapter starting...

MQJMSRA_EB1101: EMBEDDED broker started with code =0

MQJMSRA_RA1101: SJSMQ JMSRA Started:DIRECT

LDR5010: All ejb(s) of [MEjbApp] loaded successfully!

EJB5109:EJB Timer Service started successfully for datasource [jdbc/__TimerPool]

LDR5010: All ejb(s) of [__ejb_container_timer_app] loaded successfully!

JBIFW0010: JBI framework ready to accept requests.

Not registering AMX MBean against old MBean "com.sun.appserv:j2eeType=WebModule,name=Saarthi,J2EEServer=server,J2EEApplication=null,category=runtime" due to malformed composite WebModule name.

WEB0302: Starting Sun-Java-System/Application-Server.

WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 8080

WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 8181

WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 4848

SMGT0007: Self Management Rules service is enabled

Application server startup complete.

Initializing Sun's JavaServer Faces implementation (1.2_04-b22-p05) for context ''

JBIFW0012: JBI framework startup complete.

ADM1041:Sent the event to instance:[ResourceDeployEvent -- redeploy jdbc/psmdb_datasource]

CORE5008: Resource Redeployed: [jdbc:psmdb_datasource].

ADM1041:Sent the event to instance:[ResourceDeployEvent -- redeploy jdbc/psmdb_datasource]

CORE5008: Resource Redeployed: [jdbc:psmdb_datasource].

classLoader = WebappClassLoader

delegate: true

repositories:

/WEB-INF/classes/

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

deployed with moduleid = Saarthi

classLoader = WebappClassLoader

delegate: true

repositories:

/WEB-INF/classes/

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

deployed with moduleid = Saarthi

classLoader = WebappClassLoader

delegate: true

repositories:

/WEB-INF/classes/

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

deployed with moduleid = Saarthi

classLoader = WebappClassLoader

delegate: true

repositories:

/WEB-INF/classes/

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

WEB0303: Stopping Sun-Java-System/Application-Server.

WEB0713: Stopping Sun-Java-System/Application-Server HTTP/1.1 on 8080

WEB0713: Stopping Sun-Java-System/Application-Server HTTP/1.1 on 8181

WEB0713: Stopping Sun-Java-System/Application-Server HTTP/1.1 on 4848

classLoader = WebappClassLoader

delegate: false

repositories:

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

classLoader = WebappClassLoader

delegate: true

repositories:

/WEB-INF/classes/

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

classLoader = WebappClassLoader

delegate: true

repositories:

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

classLoader = WebappClassLoader

delegate: true

repositories:

----------> Parent Classloader:

EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

classLoader = WebappClassLoader

delegate: true

repositories:

----------> Parent Classloader:

EJBClassLoader :

urlSet = [URLEntry : file:/C:/Sun/AppServer/domains/domain1/generated/ejb/j2ee-apps/__JWSappclients/]

doneCalled = false

Parent -> EJBClassLoader :

urlSet = []

doneCalled = false

Parent -> java.net.URLClassLoader@1815338

SharedSecrets.getJavaNetAccess()=java.net.URLClassLoader$7@6d05ee

CORE5051: Shutting down all J2EE applications ...

EJB5122:EJB Timer Service shutdown at [2009/08/18 16:01:45]

CORE5068 : Stopping all J2EE Connector 1.5 Compliant resource adapters ...

MQJMSRA_RA1101: SJSMQ JMSRA stopping...

MQJMSRA_RA1101: SJSMQ JMSRA stopped.

RAR7094: jmsra shutdown successful.

RAR7094: __ds shutdown successful.

RAR7094: __xa shutdown successful.

CORE 5061 : Resource adapters Stop() Complete

CORE5052: Application shutdown complete.

[AutoDeploy] Disabling AutoDeployment service.

JBIFW0042: JBI framework termination complete.

Aug 18, 2009 4:05:55 PM com.sun.enterprise.admin.servermgmt.launch.ASLauncher buildCommand

INFO:

C:/Program Files/Java/jdk1.6.0_12\bin\java

-Dcom.sun.aas.instanceRoot=C:/Sun/AppServer/domains/domain1

-Dcom.sun.aas.ClassPathPrefix=

-Dcom.sun.aas.ClassPathSuffix=

-Dcom.sun.aas.ServerClassPath=

-Dcom.sun.aas.classloader.appserverChainJars.ee=

-Dcom.sun.aas.classloader.appserverChainJars=admin-cli.jar,admin-cli-ee.jar,j2ee-svc.jar

-Dcom.sun.aas.classloader.excludesList=admin-cli.jar,appserv-upgrade.jar,sun-appserv-ant.jar

-Dcom.sun.aas.classloader.optionalOverrideableChain.ee=

-Dcom.sun.aas.classloader.optionalOverrideableChain=webservices-rt.jar,webservices-tools.jar

-Dcom.sun.aas.classloader.serverClassPath.ee=Does not exist/lib/hadbjdbc4.jar,C:/Sun/AppServer/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,Does not exist/lib/dbstate.jar,Does not exist/lib/hadbm.jar,Does not exist/lib/hadbmgt.jar,C:/Sun/AppServer/lib/SUNWmfwk/lib/mfwk_instrum_tk.jar

-Dcom.sun.aas.classloader.serverClassPath=C:/Sun/AppServer/lib/install/applications/jmsra/imqjmsra.jar,C:/Sun/AppServer/imq/lib/jaxm-api.jar,C:/Sun/AppServer/imq/lib/fscontext.jar,C:/Sun/AppServer/imq/lib/imqbroker.jar,C:/Sun/AppServer/imq/lib/imqjmx.jar,C:/Sun/AppServer/lib/ant/lib/ant.jar,C:/Sun/AppServer/lib/SUNWjdmk/5.1/lib/jdmkrt.jar

-Dcom.sun.aas.classloader.sharedChainJars.ee=appserv-se.jar,appserv-ee.jar,jesmf-plugin.jar,Does not exist/lib/dbstate.jar,Does not exist/lib/hadbjdbc4.jar,jgroups-all.jar,C:/Sun/AppServer/lib/SUNWmfwk/lib/mfwk_instrum_tk.jar

-Dcom.sun.aas.classloader.sharedChainJars=javaee.jar,C:/Program Files/Java/jdk1.6.0_12/lib/tools.jar,install/applications/jmsra/imqjmsra.jar,com-sun-commons-launcher.jar,com-sun-commons-logging.jar,C:/Sun/AppServer/imq/lib/jaxm-api.jar,C:/Sun/AppServer/imq/lib/fscontext.jar,C:/Sun/AppServer/imq/lib/imqbroker.jar,C:/Sun/AppServer/imq/lib/imqjmx.jar,C:/Sun/AppServer/imq/lib/imqxm.jar,webservices-rt.jar,webservices-tools.jar,mail.jar,appserv-jstl.jar,jmxremote_optional.jar,C:/Sun/AppServer/lib/SUNWjdmk/5.1/lib/jdmkrt.jar,activation.jar,appserv-rt.jar,appserv-admin.jar,appserv-cmp.jar,C:/Sun/AppServer/updatecenter/lib/updatecenter.jar,C:/Sun/AppServer/jbi/lib/jbi.jar,C:/Sun/AppServer/imq/lib/imqjmx.jar,C:/Sun/AppServer/lib/ant/lib/ant.jar,dbschema.jar

-Dcom.sun.aas.configName=server-config

-Dcom.sun.aas.configRoot=C:/Sun/AppServer/config

-Dcom.sun.aas.defaultLogFile=C:/Sun/AppServer/domains/domain1/logs/server.log

-Dcom.sun.aas.domainName=domain1

-Dcom.sun.aas.installRoot=C:/Sun/AppServer

-Dcom.sun.aas.instanceName=server

-Dcom.sun.aas.processLauncher=SE

-Dcom.sun.aas.promptForIdentity=true

-Dcom.sun.enterprise.config.config_environment_factory_class=com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory

-Dcom.sun.enterprise.overrideablejavaxpackages=javax.help,javax.portlet

-Dcom.sun.enterprise.taglibs=appserv-jstl.jar,jsf-impl.jar

-Dcom.sun.enterprise.taglisteners=jsf-impl.jar

-Dcom.sun.updatecenter.home=C:/Sun/AppServer/updatecenter

-Ddomain.name=domain1

-Djava.endorsed.dirs=C:/Sun/AppServer/lib/endorsed

-Djava.ext.dirs=C:/Program Files/Java/jdk1.6.0_12/lib/ext;C:/Program Files/Java/jdk1.6.0_12/jre/lib/ext;C:/Sun/AppServer/domains/domain1/lib/ext;C:/Sun/AppServer/javadb/lib

-Djava.library.path=C:\Sun\AppServer\lib;C:\Sun\AppServer\lib;C:\Sun\AppServer\bin;C:\Sun\AppServer\bin

-Djava.security.auth.login.config=C:/Sun/AppServer/domains/domain1/config/login.conf

-Djava.security.policy=C:/Sun/AppServer/domains/domain1/config/server.policy

-Djava.util.logging.manager=com.sun.enterprise.server.logging.ServerLogManager

-Djavax.management.builder.initial=com.sun.enterprise.admin.server.core.jmx.AppServerMBeanServerBuilder

-Djavax.net.ssl.keyStore=C:/Sun/AppServer/domains/domain1/config/keystore.jks

-Djavax.net.ssl.trustStore=C:/Sun/AppServer/domains/domain1/config/cacerts.jks

-Djdbc.drivers=org.apache.derby.jdbc.ClientDriver

-Djmx.invoke.getters=true

-Dsun.rmi.dgc.client.gcInterval=3600000

-Dsun.rmi.dgc.server.gcInterval=3600000

-client

-XX:+UnlockDiagnosticVMOptions

-XX:MaxPermSize=192m

-Xmx512m

-XX:NewRatio=2

-XX:+LogVMOutput

-XX:LogFile=C:/Sun/AppServer/domains/domain1/logs/jvm.log

-cp

C:/Sun/AppServer/lib/jhall.jar;C:\Sun\AppServer\lib\appserv-launch.jar

com.sun.enterprise.server.PELaunch

start

CORE5076: Using [Java HotSpot(TM) Client VM, Version 1.6.0_12] from [Sun Microsystems Inc.]

SEC1002: Security Manager is OFF.

Using MQ RA for Broker lifecycle control

SEC1143: Loading policy provider com.sun.enterprise.security.provider.PolicyWrapper.

WEB0114: SSO is disabled in virtual server [server]

WEB0114: SSO is disabled in virtual server [__asadmin]

REgistering Custom ContextConfig

REgistering Custom Context

JTS5014: Recoverable JTS instance, serverId = [3700]

ADM1079: Initialization of AMX MBeans started

ADM1504: Here is the JMXServiceURL for the Standard JMXConnectorServer: [service:jmx:rmi:///jndi/rmi://sage-c7a5abcebe:8686/jmxrmi]. This is where the remote administrative clients should connect using the standard JMX connectors

ADM1506: Status of Standard JMX Connector: Active = [true]

JMS Service Connection URL is :mq://sage-c7a5abcebe:7676/

MQJMSRA_RA1101: SJSMQ JMS Resource Adapter starting...

MQJMSRA_EB1101: EMBEDDED broker started with code =0

MQJMSRA_RA1101: SJSMQ JMSRA Started:DIRECT

LDR5010: All ejb(s) of [MEjbApp] loaded successfully!

EJB5109:EJB Timer Service started successfully for datasource [jdbc/__TimerPool]

LDR5010: All ejb(s) of [__ejb_container_timer_app] loaded successfully!

JBIFW0010: JBI framework ready to accept requests.

WEB0302: Starting Sun-Java-System/Application-Server.

WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 8080

WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 8181

WEB0712: Starting Sun-Java-System/Application-Server HTTP/1.1 on 4848

SMGT0007: Self Management Rules service is enabled

Application server startup complete.

[shalabhvyas]

Thank Michael.That helped. I have one more question. I have an entity which uses GenerationType.AUTO for primary key. How do I create a new instance of this entity and persist it using an Entity Manager as I manually cannot set the ID of the instance?

[Melongo Annabel]

If it's an auto generated primary key, then the db will create it for you. You can't create the key yourself. Some db with auto generated keys create the key before inserting while others create it after inserting. The best way to handle this would be for insertion don't set the primary but for update or delete set on based on the info in the db.


From: shalabhvyas <address-removed>
To: address-removed
Sent: Tuesday, August 18, 2009 9:42:45 AM
Subject: [nbj2ee] JPA-TopLink-MySQL

Thank Michael.That helped. I have one more question. I have an entity which uses GenerationType.AUTO for primary key. How do I create a new instance of this entity and persist it using an Entity Manager as I manually cannot set the ID of the instance?

[shalabhvyas]

Thanks Melongo. I just created an instance of the entity and populated all the fields except for the key and persisted it. That worked. Thanks once again !

[michael]

The answer is you don't worry about it - it will be auto generated when the object will be persisted:
Say that Person is an entity, and em is an EntityManager:

Person george = new Person()
gerorge.setName( "Georgy"); <-- george.getId() == null
em.persist(geroge); <-- george.getId() == null might still hold, but when em's transaction is comitted he'll be in the DB with an id


To get the id of a newly persisted entity, call em.flush(). The id field of the entity should be filled now.

Michael


--------
Michael Bar-Sinai
Software Architect
Beeriprint.co.il

-----Original Message-----
From: shalabhvyas [mailto:address-removed]
Sent: Tuesday, August 18, 2009 5:43 PM
To: address-removed
Subject: [nbj2ee] JPA-TopLink-MySQL


Thank Michael.That helped. I have one more question. I have an entity which uses GenerationType.AUTO for primary key. How do I create a new instance of this entity and persist it using an Entity Manager as I manually cannot set the ID of the instance?