Ajuda JPA

Boa Tarde!

Galera sou iniciante em Java e to com uns problemas quanto a implementação do JPA será que algum pode me ajudar ?
Peguei um exemplo e comecei a estudar e me deparei com erro que não consigo entender qual o motivo

Classe Produto

[code]package br.com.persistencia.entidades;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

@Entity
@Table(name = “produto”)
@SequenceGenerator(name = “produto_id_produto_seq”, sequenceName = “produto_id_produto_seq”, allocationSize = 1)
public class Produto implements Serializable {

/**
 * 
 */
private static final long serialVersionUID = 1L;

@Id
@GeneratedValue(generator = "produto_id_produto_seq", strategy = GenerationType.IDENTITY)
@Column(name = "id_produto")
private String idProduto;

@Column(name = "nm_produto")
private String nomeProduto;

@Column(name = "quantidade")
private String quantidade;

@Column(name = "valor")
private String valor;

//Getter e Setters

}[/code]

Classe Conexao

[code]package br.com.persistencia.entidades;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.swing.JOptionPane;

public class Conexao {

// nome da unidade de persistencia definia no persistence.xml
private static final String UNIT_NAME = "Persistencia";

private EntityManagerFactory emf = null;

private EntityManager em = null;

public EntityManager getEntityManager() {

	if (emf == null) {
		emf = Persistence.createEntityManagerFactory(UNIT_NAME);
	}

	if (em == null) {
		em = emf.createEntityManager();

	}

	return em;
}

}[/code]

Classe Main

[code]package br.com.persistencia.entidades;

import javax.persistence.EntityManager;

public class Main {

public static void main(String... args) {

	Produto produto = new Produto();
	produto.setNomeProduto("produto");
	produto.setQuantidade("22");
	produto.setValor("33.99");

	EntityManager em = new Conexao().getEntityManager();

	em.getTransaction().begin();
	em.persist(produto);
	em.getTransaction().commit();
}

}[/code]

XML Persistence

<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.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_2_0.xsd"> <persistence-unit name="Persistencia"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <class>br.com.persistencia.entidades.Produto</class> <properties> <property name="javax.persistence.jdbc.driver" value="net.sourceforge.jtds.jdbc.Driver"></property> <property name="javax.persistence.jdbc.user" value="sa"></property> <property name="javax.persistence.jdbc.password" value="TECH"></property> <property name="javax.persistence.jdbc.url" value="jdbc:jtds:sqlserver://192.168.0.100:1433/HRPDV_CADA "></property> </properties> </persistence-unit> </persistence>

Console de Erro

Dez 03, 2012 2:33:06 PM org.hibernate.annotations.common.Version <clinit> INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final} Dez 03, 2012 2:33:06 PM org.hibernate.Version logVersion INFO: HHH000412: Hibernate Core {4.1.8.Final} Dez 03, 2012 2:33:06 PM org.hibernate.cfg.Environment <clinit> INFO: HHH000205: Loaded properties from resource hibernate.properties: {hibernate.connection.driver_class=org.h2.Driver, hibernate.dialect=org.hibernate.dialect.H2Dialect, hibernate.max_fetch_depth=5, hibernate.format_sql=true, hibernate.generate_statistics=true, hibernate.connection.username=sa, hibernate.connection.url=jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE, hibernate.bytecode.use_reflection_optimizer=false, hibernate.jdbc.batch_versioned_data=true, hibernate.connection.pool_size=5} Dez 03, 2012 2:33:06 PM org.hibernate.cfg.Environment buildBytecodeProvider INFO: HHH000021: Bytecode provider name : javassist Dez 03, 2012 2:33:06 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!) Dez 03, 2012 2:33:06 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure INFO: HHH000115: Hibernate connection pool size: 5 Dez 03, 2012 2:33:06 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure INFO: HHH000006: Autocommit mode: true Dez 03, 2012 2:33:06 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure INFO: HHH000401: using driver [net.sourceforge.jtds.jdbc.Driver] at URL [jdbc:jtds:sqlserver://192.168.0.100:1433/HRPDV_CADA] Dez 03, 2012 2:33:06 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure INFO: HHH000046: Connection properties: {user=sa, password=****, autocommit=true, release_mode=auto} Dez 03, 2012 2:33:07 PM org.hibernate.dialect.Dialect <init> INFO: HHH000400: Using dialect: org.hibernate.dialect.H2Dialect Dez 03, 2012 2:33:07 PM org.hibernate.dialect.H2Dialect <init> WARN: HHH000431: Unable to determine H2 database version, certain features may not work Dez 03, 2012 2:33:07 PM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation INFO: HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4 Dez 03, 2012 2:33:07 PM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory Dez 03, 2012 2:33:07 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init> INFO: HHH000397: Using ASTQueryTranslatorFactory Dez 03, 2012 2:33:09 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions WARN: SQL Error: 102, SQLState: 42000 Dez 03, 2012 2:33:09 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions ERROR: Incorrect syntax near 'value'. Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Incorrect syntax near 'value'. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1306) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:871) at br.com.persistencia.entidades.Main.main(Main.java:17) Caused by: org.hibernate.exception.SQLGrammarException: Incorrect syntax near 'value'. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) at $Proxy11.executeQuery(Unknown Source) at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:123) at org.hibernate.id.SequenceHiLoGenerator.generate(SequenceHiLoGenerator.java:77) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:118) at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:843) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:818) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:822) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:865) ... 1 more Caused by: java.sql.SQLException: Incorrect syntax near 'value'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ... 14 more

Obrigado!

Cara, só como tira-teima, tenta trocar o final das suas tags no XML de:

<property name="javax.persistence.jdbc.url" value="jdbc:jtds:sqlserver://192.168.0.100:1433/HRPDV_CADA "></property> 

para

<property name="javax.persistence.jdbc.url" value="jdbc:jtds:sqlserver://192.168.0.100:1433/HRPDV_CADA " />

//tira o </property>  do final e fecha a tag com />

Opaa beleza ?

Mesmo segue o erro após a alteração

INFO: HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4 Dez 03, 2012 3:46:38 PM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory Dez 03, 2012 3:46:38 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init> INFO: HHH000397: Using ASTQueryTranslatorFactory Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.PersistentObjectException: detached entity passed to persist: br.com.persistencia.entidades.Produto at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1306) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:871) at br.com.persistencia.entidades.Main.main(Main.java:18) Caused by: org.hibernate.PersistentObjectException: detached entity passed to persist: br.com.persistencia.entidades.Produto at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:141) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:843) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:818) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:822) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:865) ... 1 more

Minha classe Main novamente

[code]package br.com.persistencia.entidades;

import javax.persistence.EntityManager;

public class Main {

public static void main(String... args) {  

    Produto produto = new Produto();  
    produto.setNomeProduto("produto");  
    produto.setQuantidade("22");  
    produto.setValor("33.99");  
    produto.setIdProduto("1");

    EntityManager em = new Conexao().getEntityManager();  

    em.getTransaction().begin();  
    em.persist(produto);  
    em.getTransaction().commit();  
}  

} [/code]

O erro esta na linha 18, na hora de persistir a entidade.

Opa cara desculpa tinha mexido mais em algumas coisa no código por isso gerou esse erro diferente aee, na verdade depois da alteração que você me pediu pra fazer o mesmo erro persistiu:

Dez 03, 2012 3:52:18 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions WARN: SQL Error: 102, SQLState: 42000 Dez 03, 2012 3:52:18 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions ERROR: Incorrect syntax near 'value'. Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Incorrect syntax near 'value'. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1306) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:871) at br.com.persistencia.entidades.Main.main(Main.java:18) Caused by: org.hibernate.exception.SQLGrammarException: Incorrect syntax near 'value'. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) at $Proxy11.executeQuery(Unknown Source) at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:123) at org.hibernate.id.SequenceHiLoGenerator.generate(SequenceHiLoGenerator.java:77) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:118) at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:843) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:818) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:822) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:865) ... 1 more Caused by: java.sql.SQLException: Incorrect syntax near 'value'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ... 14 more

[quote=douglas.santosreis]Opaa beleza ?

Mesmo segue o erro após a alteração

INFO: HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4 Dez 03, 2012 3:46:38 PM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory Dez 03, 2012 3:46:38 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init> INFO: HHH000397: Using ASTQueryTranslatorFactory Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.PersistentObjectException: detached entity passed to persist: br.com.persistencia.entidades.Produto at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1306) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:871) at br.com.persistencia.entidades.Main.main(Main.java:18) Caused by: org.hibernate.PersistentObjectException: detached entity passed to persist: br.com.persistencia.entidades.Produto at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:141) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:843) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:818) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:822) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:865) ... 1 more

Minha classe Main novamente

[code]package br.com.persistencia.entidades;

import javax.persistence.EntityManager;

public class Main {

public static void main(String... args) {  

    Produto produto = new Produto();  
    produto.setNomeProduto("produto");  
    produto.setQuantidade("22");  
    produto.setValor("33.99");  
    produto.setIdProduto("1");

    EntityManager em = new Conexao().getEntityManager();  

    em.getTransaction().begin();  
    em.persist(produto);  
    em.getTransaction().commit();  
}  

} [/code]

O erro esta na linha 18, na hora de persistir a entidade.[/quote]

Não é o mesmo erro não …

O erro anterior era causado porque o Hibernate não conseguia parsear o XML de configuração. Provavelmente, o conteúdo da tag tem precedência sobre o atributo value, nas tags properties.

O segundo erro acontece porque você tentar persistir um objeto com id atribuído, mas que não está “amarrado” à sessão. Como você especificou que o id deve ser atribuído na criação do objeto, o Hibernate acusa erro. Além disso, você vai obter outro erro provavelmente, por tentar usar um atributo do tipo String com @Id gerado com IDENTITY.

opa, seu generator das chaves primarias nao deveria ser um sequence ao inves de identity?

abrasss

Beleza pessoal. realmente vacilei quanto aos erros sobre o IDENTITY e sobre a atribuição do ID.

Até corrigi isso agora porém o primeiro erro o qual você mencionou rmendes08 sobre o Hibernate não conseguia parsear o XML de configuração ainda continua, queria entender um pouco melhor que pode estar acontecendo com o meu XML

Segue ele novamente

<?xml version="1.0" encoding="UTF-8"?> <persistence version="2.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_2_0.xsd"> <persistence-unit name="Persistencia"> <provider>org.hibernate.ejb.HibernatePersistence</provider> <class>br.com.persistencia.entidades.Produto</class> <properties> <property name="javax.persistence.jdbc.driver" value="net.sourceforge.jtds.jdbc.Driver"/> <property name="javax.persistence.jdbc.user" value="aaaaa"/> <property name="javax.persistence.jdbc.password" value="aaaa"/> <property name="javax.persistence.jdbc.url" value="jdbc:jtds:sqlserver://192.145.0.100:1433/HRPDV_CADA "/> </properties> </persistence-unit> </persistence>

Desculpa mais não consegui intender o que pode esta acontecendo com ele… Muito Obrigado!

Segue o console de erros novamente

Dez 03, 2012 4:09:56 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions WARN: SQL Error: 102, SQLState: 42000 Dez 03, 2012 4:09:56 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions ERROR: Incorrect syntax near 'value'. Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: Incorrect syntax near 'value'. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1306) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:871) at br.com.persistencia.entidades.Main.main(Main.java:18) Caused by: org.hibernate.exception.SQLGrammarException: Incorrect syntax near 'value'. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) at $Proxy11.executeQuery(Unknown Source) at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:123) at org.hibernate.id.SequenceHiLoGenerator.generate(SequenceHiLoGenerator.java:77) at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:118) at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:843) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:818) at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:822) at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:865) ... 1 more Caused by: java.sql.SQLException: Incorrect syntax near 'value'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) ... 14 more