java - Dropwizard :"error processing your request"用于从数据库中检索数据

Question

当我尝试打开时

http://localhost:8080/tailor/orders 

它应该返回数据库中的所有订单。但是它产生了错误

{"message":"There was an error processing your request. It has been logged (ID fe49a13e76c59894)."}

我无法追踪导致此问题的原因。

我将 dropwizard 用于 restful web 服务，并将 dropwizard 的 hibernate 用于 sqllight 数据库。

类:

资源类:

@Path("/tailor")
@Produces(MediaType.APPLICATION_JSON)
public class TailorResource {

OrderDAO orderdao;

public TailorResource(OrderDAO odao) {
    this.orderdao = odao;
}


@GET
@Path("/orders")
@Produces(MediaType.APPLICATION_JSON)
public List<OrderModel> getAllOrders() {
    return orderdao.findAll();
}

@GET
@Path("/orders/{id}")
@Produces(MediaType.APPLICATION_JSON)
public OrderModel getOrderById(@PathParam("id") int id) {
    return orderdao.findById(id);
}
}

OrderDAO 类:

public class OrderDAO extends AbstractDAO<OrderModel>{


 public OrderDAO(SessionFactory sessionFactory) {
    super(sessionFactory);
}

  public OrderModel findById(int id) {
   return get(id);
}

public OrderModel create(OrderModel o) {
    return persist(o);
}

public List<OrderModel> findAll() {
    return list(namedQuery("com.yammer.dropwizard.tailor.model.OrderModel.findAll"));
}}

订单类别:

@NamedQueries({
@NamedQuery(
    name = "com.yammer.dropwizard.tailor.model.OrderModel.findAll",
    query = "SELECT o FROM OrderModel o"
),
@NamedQuery(
    name = "com.yammer.dropwizard.tailor.model.OrderModel.findById",
    query = "SELECT o FROM OrderModel o WHERE o.ID = :ID"
)
})
@Entity
@Table(name = "Order")
public class OrderModel {

@Id
@GeneratedValue
@Column(name = "o_id")
int ID;

@Column(name = "o_shirt_quantity")
int shirtQuantity;
@Column(name = "o_longshirt_quantity")
int longshirtQuantity;
@Column(name = "o_trouser_quantity")
int trouserQuantity;
@Column(name = "o_coat_quantity")
int coatQuantity;
@Column(name = "o_deliverydate")
Date deliveryDate;
@Column(name = "o_orderdate")
Date orderDate;
@Column(name = "o_shirt_price")
Double shirtPrice;
@Column(name = "o_longshirt_price")
Double longshirtPrice;
@Column(name = "o_trouser_price")
Double trouserPrice;
 @Column(name = "o_coat_price")
Double coatPrice;
@Column(name = "o_totalamount")
Double totalAmount;
@Column(name = "o_discount")
Double discount;
@Column(name = "o_advancedpayment")
Double advancedPayment;
@Column(name = "o_remainingpayment")
Double remainingPayment;
@Column(name = "o_orderstatus")
int orderStatus;
}

数据库配置类:

public class databaseConfiguration extends Configuration {

@Valid
@NotNull
@JsonProperty
DataSourceFactory dbconfigurations = new DataSourceFactory();

public DataSourceFactory getDataSourceFactory() {
    //return dbconfigurations;
    Map<String,String> s=new HashMap<String,String>();
    s.put("hibernate.dialect","Hibernate.SQLightDialect.SQLiteDialect");
    dbconfigurations.setProperties(s);
    return dbconfigurations;
}
}

主要服务类:

public class TailorApplication extends Application<databaseConfiguration> {

public static void main(String[] args) throws Exception {
    new TailorApplication().run(args);
}

private final HibernateBundle<databaseConfiguration> hibernate = new HibernateBundle<databaseConfiguration>(CustomerModel.class) {
     {
    @Override
    public DataSourceFactory getDataSourceFactory(databaseConfiguration configuration) {
        return configuration.getDataSourceFactory();
    }
};

@Override
public void initialize(Bootstrap<databaseConfiguration> bootstrap) {
    // TODO Auto-generated method stub
    bootstrap.addBundle(hibernate);

}

@Override
public void run(databaseConfiguration configuration, Environment environment)
        throws Exception {

      final OrderDAO odao = new OrderDAO(hibernate.getSessionFactory());

    environment.jersey().register(new TailorResource(odao));
}

}

YML 文件:

dbconfigurations:
# the name of your JDBC driver
driverClass: org.sqlite.JDBC

# the username
user:

# the password
password:

url: jdbc:sqlite:TailorDB.db

请帮忙？

Answer 1

确保您用实体填充了应用程序类:

private final HibernateBundle<AppConfiguration> hibernateBundle = new HibernateBundle<AppConfiguration>(
            //
            //
            //ADD ENTITIES HERE
            //
            //
            Person.class
            ,Product.class
            ) {
        @Override
        public DataSourceFactory getDataSourceFactory(
                AppConfiguration configuration) {
            return configuration.getDataSourceFactory();
        }
    };