我正在尝试使用Hibernate和HSQLDB。我试图调整教程以适应更多的当前版本,所以可能会有问题。当我使用JUnit运行单元测试时,就会发生这种情况。
我使用HSQLDB 2.3.2和Hibernate(JPA)4.3.5。
我得到的错误是:
16:40:16,802 DEBUG sql:109-从DEVICES device0_中选择device0_.device_id作为DEVICE_I1_0_,device0_.device_firmware_version作为DEVICE_F2_0_,device0_.device_image作为DEVICE_I3_0_?16:40:16,802 DEBUG sql:109-从DEVICES device0_中选择device0_.device_id作为DEVICE_I1_0_,device0_.device_firmware_version作为DEVICE_F2_0_,device0_.device_image作为DEVICE_I3_0_?16:40:16,802 DEBUG sql:109-从DEVICES device0_中选择device0_.device_id作为DEVICE_I1_0_,device0_.device_firmware_version作为DEVICE_F2_0_,device0_.device_image作为DEVICE_I3_0_?16:40:16,803警告SQLExceptionHelper:144-SQL错误:-5501,SQLState:42501 16:40:16,803警告SQLExceptionHelper:144-SQL错误:-5501,SQLState:42501 16:40:16,803错误SQLExceptionHelper:146-用户缺乏特权或未找到对象:设备16:40:16,803错误SQLExceptionHelper:146-用户缺乏特权或未找到对象:设备16:40:16,804错误nate.exception.sqlgrammareXception:无法准备语句...由:org.hibernate.exception.sqlgrammareXception:无法准备语句...由:java.SQL.sqlsyntaxerrorexception:用户缺乏特权或未找到对象:设备...由:org.hsqldb.hsqlexception:用户缺乏特权或未找到对象:设备...
我的persistence.xml如下所示:
<persistence 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"
version="2.0">
<persistence-unit name="testproject" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
<class>testproject.server.domain.Device</class>
<exclude-unlisted-classes/>
<properties>
<!-- Database connection settings -->
<property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver" />
<property name="hibernate.connection.url" value="jdbc:hsqldb:file:/db/testdb" />
<property name="hibernate.connection.username" value="sa" />
<property name="hibernate.connection.password" value="" />
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size" value="1" />
<!-- SQL dialect -->
<property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class" value="thread" />
<!-- Disable the second-level cache -->
<property name="cache.provider_class" value="org.hibernate.cache.NoCacheProvider" />
<!-- Echo all executed SQL to stdout -->
<!-- <property name="hibernate.show_sql" value="true" /> -->
<!-- <property name="hibernate.format_sql" value="true" /> -->
<!-- Drop and re-create the database schema on startup -->
<!-- This property should not be set in PRODUCTION environments -->
<!-- <property name="hibernate.hbm2ddl.auto" value="create" /> -->
<property name="hibernate.c3p0.min_size" value="5" />
<property name="hibernate.c3p0.max_size" value="20" />
<property name="hibernate.c3p0.timeout" value="300" />
<property name="hibernate.c3p0.max_statements" value="50" />
<property name="hibernate.c3p0.idle_test_period" value="3000" />
</properties>
</persistence-unit>
</persistence>
我的device.java如下所示:
package testproject.server.domain;
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.Table;
import testproject.shared.dto.DeviceDto;
@Entity
@Table(name = "DEVICES")
public class Device implements Serializable {
private static final long serialVersionUID = 8161681740825989132L;
@Id
@Column(name = "DEVICE_ID")
@GeneratedValue(strategy = GenerationType.IDENTITY)
protected Long deviceId;
@Column(name = "DEVICE_IMAGE")
protected String image;
@Column(name = "DEVICE_FIRMWARE_VERSION")
protected String firmwareVersion;
public Device() {
}
public Device(Long deviceId) {
setDeviceId(deviceId);
}
public Device(DeviceDto device) {
setDeviceId(device.getDeviceId());
setImage(device.getImage());
setFirmwareVersion(device.getFirmwareVersion());
}
public Long getDeviceId() {
return deviceId;
}
public void setDeviceId(Long deviceId) {
this.deviceId = deviceId;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}
public String getFirmwareVersion() {
return firmwareVersion;
}
public void setFirmwareVersion(String firmwareVersion) {
this.firmwareVersion = firmwareVersion;
}
@Override
public String toString() {
StringBuilder sb = new StringBuilder();
sb.append("Device Id: ").append(getDeviceId()).append(", ");
sb.append("Image: ").append(getImage()).append(", ");
sb.append("Firmware Version: ").append(getFirmwareVersion());
return sb.toString();
}
//TODO: Do we need that?
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result
+ ((deviceId == null) ? 0 : deviceId.hashCode());
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (!(obj instanceof Device))
return false;
Device other = (Device) obj;
if (deviceId == null) {
if (other.deviceId != null)
return false;
} else if (!deviceId.equals(other.deviceId))
return false;
return true;
}
}
而我的刀是这样的:
package testproject.server.dao;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.EntityTransaction;
import javax.persistence.Persistence;
import javax.persistence.TypedQuery;
import testproject.server.domain.Device;
public class DeviceDao extends BaseDao {
private static final EntityManagerFactory entityManagerFactory =
Persistence.createEntityManagerFactory("testproject");
public static EntityManager createEntityManager() {
return entityManagerFactory.createEntityManager();
}
public Long createObject(Object object) {
return createDevice((Device) object);
}
public List<Object> retrieveObjects(int maxResults, int firstResult) {
EntityManager em = createEntityManager();
List<Object> list = null;
try {
TypedQuery<Object> query = em.createQuery(
"select a from Device a", Object.class);
query.setMaxResults(maxResults);
query.setFirstResult(firstResult);
list = query.getResultList();
} finally {
em.close();
}
return list;
}
public Long createDevice(Device Device) {
// For an application-managed entity manager its best practice to create
// a
// new entity manager inside a method and close it before the method is
// finished.
EntityManager em = createEntityManager();
EntityTransaction tx = em.getTransaction();
Long DeviceId = -1L;
try {
tx.begin();
em.persist(Device);
DeviceId = Device.getDeviceId();
tx.commit();
} catch (Throwable t) {
t.printStackTrace();
tx.rollback();
} finally {
em.close();
}
return DeviceId;
}
public Device retrieveDevice(Long DeviceId) {
EntityManager em = createEntityManager();
Device Device = null;
try {
TypedQuery<Device> query = em.createQuery(
"select a from Device a where a.DeviceId = ?1",
Device.class);
query.setParameter(1, DeviceId);
Device = query.getSingleResult();
} finally {
em.close();
}
return Device;
}
public List<Device> retrieveDevices(int maxResults, int firstResult) {
EntityManager em = createEntityManager();
List<Device> list = null;
try {
TypedQuery<Device> query = em.createQuery(
"select a from Device a", Device.class);
query.setMaxResults(maxResults);
query.setFirstResult(firstResult);
list = query.getResultList();
} finally {
em.close();
}
return list;
}
public Device updateDevice(Device Device) {
EntityManager em = createEntityManager();
EntityTransaction tx = em.getTransaction();
Device Device2 = null;
try {
tx.begin();
Device2 = em.merge(Device);
tx.commit();
} catch (Throwable t) {
t.printStackTrace();
tx.rollback();
} finally {
em.close();
}
return Device2;
}
public void deleteDevice(Device Device) {
EntityManager em = createEntityManager();
EntityTransaction tx = em.getTransaction();
try {
tx.begin();
em.remove(em.merge(Device));
tx.commit();
} catch (Throwable t) {
t.printStackTrace();
tx.rollback();
} finally {
em.close();
}
}
}
最后,我的测试用例(它很糟糕,我只想看到它运行):
package testproject.server;
import java.util.List;
import org.apache.log4j.xml.DOMConfigurator;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import com.allen_sauer.gwt.log.client.Log;
import testproject.server.dao.DeviceDao;
import testproject.server.domain.Device;
public class DeviceTestCase {
private long startTimeMillis;
@Before
public void setUp() {
// The log4j configuration file must be in the Project's root directory
DOMConfigurator.configure("log4j.xml");
startTimeMillis = System.currentTimeMillis();
}
@Test
public void testDeviceDao() {
try {
Log.debug("testDeviceDao()");
createDevices();
}
catch (Exception e) {
Log.error("e: " + e);
e.printStackTrace();
}
}
public void createDevice() {
Device d1 = new Device();
d1.setFirmwareVersion("Firmware1");
d1.setImage("Image1");
DeviceDao deviceDao = new DeviceDao();
deviceDao.createDevice(d1);
}
public void createDevices() {
Device d1 = new Device();
d1.setFirmwareVersion("Firmware1");
d1.setImage("Image1");
Device d2 = new Device();
d1.setFirmwareVersion("Firmware2");
d1.setImage("Image2");
Device d3 = new Device();
d1.setFirmwareVersion("Firmware3");
d1.setImage("Image3");
DeviceDao deviceDao = new DeviceDao();
deviceDao.createDevice(d1);
deviceDao.createDevice(d2);
deviceDao.createDevice(d3);
List<Device> devices = deviceDao.retrieveDevices(100, 0);
for (Device device : devices) {
Log.debug(device.toString());
}
//TODO: Btw, this is not a really good test case ;)
}
@After
public void tearDown() {
long endTimeMillis = System.currentTimeMillis();
float durationSeconds = (endTimeMillis - startTimeMillis) / 1000F;
Log.debug("Duration: " + durationSeconds + " seconds");
}
}
如果有人对如何解决这个问题有建议,我会非常高兴,因为我现在真的被困住了。
您得到的消息是HSQLDB的某种神秘方式,它告诉您试图从中选择的DEVICES表不存在(或者与您连接的用户没有访问该表的权限)。创建它。
我正在测试的功能在生产环境中工作得很好,但我不知道为什么在测试时不是这样。 下面是引发错误的测试函数: 我的测试: null
我正在看一些旧代码,在运行一个单元测试时遇到了问题。 代码为: 但是,当试图准备语句时,它会抛出错误 用户缺少权限或找不到对象:CUSTOMERS_SEQ。下一个瓦尔。 我正在阅读错误本身,似乎找不到任何东西。奇怪的是,当我在本地运行查询选择CUSTOMERS_SEQ.NEXTVAL时,它工作正常。 任何和所有的帮助将不胜感激。
我正在使用和。每当我尝试执行insert语句时,我都会得到错误。 表clears存在于中,但是我遇到了这个错误。 offersdao.java
我正在尝试做一些Ucanaccess实践,用Java管理一些数据库。我得到了一个我不知道如何解决的错误。 我在Access中有一个名为USERS的表: 自动编号,短文本,短文本,数字。 代码继续,但只有一些条件和查询。
当我试图将数据放入数据库时,我出现了一个错误,这是我的注册函数