异常javax.Transaction.rollbackException：用GlassFish 4标记为回滚的事务-堆栈跟踪中没有信息

Question

我正在使用GlassFish4、Spring和PostgreSQL。我想将一个实体保存到数据库中,但当我尝试时,我得到了一个异常：

其实这对我来说毫无意义。我甚至不知道去哪里看，因为消息的描述性不是很强。您知道如何检索有关此异常的更多信息吗？或者援引它的理由是什么？

persistence.xml：

<?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="amleto-server-model" transaction-type="JTA">
    <jta-data-source>jdbc/amleto</jta-data-source>
    <class>com.amleto.server.model.entities.FacebookDebug</class>
    <properties>
        <property name="openjpa.jdbc.Schema" value="public"/>
        <property name="openjpa.TransactionMode" value="managed" />
        <property name="openjpa.ConnectionFactoryMode" value="managed" />
        <property name="openjpa.jdbc.DBDictionary" value="postgres" />
        <!-- Log all queries performed against the database. -->
        <!-- Do not use in production, this will generate a lot of output. -->
        <property name="openjpa.Log" value="SQL=TRACE"/>
    </properties>
</persistence-unit>

amletoController.java：

package com.amleto.server.services.controllers;

import java.sql.Timestamp;
import java.util.GregorianCalendar;

import javax.persistence.Query;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import com.amleto.server.model.entities.FacebookDebug;
import com.amleto.server.services.utils.SharedEntityManager;

@Controller
public class AmletoController {

    @Autowired
    SharedEntityManager entityManager;

    @Transactional
    @ResponseBody
    @RequestMapping(value = "/facebookDebug", method=RequestMethod.GET)
    public String facebookDebug(@RequestParam(value="action", required=true) String action, 
                                @RequestParam(value="userId", required=true) String userId) {

            FacebookDebug fb = new FacebookDebug();
            fb.setAction(action);
            fb.setUserId(userId);
            GregorianCalendar dateCreate = new GregorianCalendar();
            fb.setDateCreate(new Timestamp(dateCreate.getTimeInMillis()));
            entityManager.getEntityManager().persist(fb);

            /*
            int returnValue = entityManager.getEntityManager().createNativeQuery("insert into facebook_debug (action, user_id, date_create) values(?,?,current_timestamp)")
                    .setParameter("1", action)
                    .setParameter("2", userId)
                    .executeUpdate();       
            */

            return "why it doesn't work?";
    }
}

facebookdebug.java：

package com.amleto.server.model.entities;

import java.io.Serializable;
import javax.persistence.*;
import java.sql.Timestamp;


/**
 * The persistent class for the facebook_debug database table.
 * 
 */
@Entity
@Table(name="facebook_debug")
@NamedQuery(name="FacebookDebug.findAll", query="SELECT f FROM FacebookDebug f")
public class FacebookDebug implements Serializable {
    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name="facebook_debug_id")
    private Integer facebookDebugId;

    private String action;

    @Column(name="date_create")
    private Timestamp dateCreate;

    @Column(name="user_id")
    private String userId;

    public FacebookDebug() {
    }

    public Integer getFacebookDebugId() {
        return this.facebookDebugId;
    }

    public void setFacebookDebugId(Integer facebookDebugId) {
        this.facebookDebugId = facebookDebugId;
    }

    public String getAction() {
        return this.action;
    }

    public void setAction(String action) {
        this.action = action;
    }

    public Timestamp getDateCreate() {
        return this.dateCreate;
    }

    public void setDateCreate(Timestamp dateCreate) {
        this.dateCreate = dateCreate;
    }

    public String getUserId() {
        return this.userId;
    }

    public void setUserId(String userId) {
        this.userId = userId;
    }

}

SharedEntityManager.java：

package com.amleto.server.services.utils;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;

public class SharedEntityManager implements ApplicationContextAware {
    private static ApplicationContext _appCtx;

    @PersistenceContext(name="amleto-server-model")
    private EntityManager em;

    private static SharedEntityManager instance;

    public static SharedEntityManager getInstance() {
        if(instance == null) {
            instance = new SharedEntityManager();
        }
        return instance;
    }

    public EntityManager getEntityManager() {
        if(this.em == null) {
            this.em = _appCtx.getBean(EntityManager.class);
        }
        return this.em;
    }

    @Override
    public void setApplicationContext(ApplicationContext appCtx) throws BeansException {
        _appCtx = appCtx;
    }
}

<property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>

我回到事务回滚异常，只是在上面的堆栈跟踪中链接。在将附加配置添加到GlassFish日志配置之后，我在异常发生之前获得了以下堆栈跟踪：

[2015-09-21T18:36:15.256+0200][glassfish 4.1][CONFIG][org.eclipse.persistence.session.file:/c:/glassFish4/glassfish/domains/domain2/eclipseapps/amleto-server-ear/amleto-server-services-ws_war/web-inf/lib/amleto-server-model-0.1.0-snapshot.jar_amleto-server-model-0.1.0-snapshot.jar_amleto-server-model.connection]

[2015-09-21T18:36:15.261+0200][glassfishPostgreSQL版本：9.4.4驱动程序：PostgreSQL本机驱动程序版本：PostgreSQL 9.4 JDBC4（build 1202)]]

[2015-09-21T18:36:15.582+0200][glassfish 4.1][信息][org.eclipse.persistence.session.file:/c:/glassFish4/glassfish/domains/domain2/eclipseapps/amleto-server-ear/amleto-server-services-ws_war/web-inf/lib/amleto-server-model-0.1.0-Snapshot.jar_amleto-server-model.connection][tid:_threadid=27_threadname=http-listener-1(2)]

[2015-09-21T18:36:15.858+0200][glassfish 4.1][FINE][org.eclipse.persistence.session.file:/c:/glassFish4/glassfish/domains/domain2/eclipseapps/amleto-server-ear/amleto-server-services-ws_war/web-inf/lib/amleto-server-model-0.1.0-Snapshot.jar_amleto-server-model-0.1.0-Sql][tid:_thread=27_threadname=http-listener-1(2)]

Answer 1

我猜问题是由于找不到桌子造成的，但我现在还不知道确切的原因。

您可以尝试以下操作：

在persistence.xml中添加以下内容：

<property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>

更新#1:

您可以尝试打印嵌套异常stacktrace,如下所示：

    try {
        entityManager.getEntityManager().persist(fb);
    } catch (Exception x) {

        if (x.getCause() != null) {
            x.getCause().printStackTrace();

            if (x.getCause().getCause() != null) {
                x.getCause().getCause().printStackTrace();
            }
        }
    }