在Netbeans中使用Maven项目的jUnit测试检查JDBC查找时出错

Question

我正试图为使用jdbc资源的文件创建一个测试。定期测试在整个项目中都能很好地工作，除非我试图测试使用实体管理器的东西。我想我错过了一些简单的东西，如果有任何帮助，我将不胜感激。

这是错误。

Feb 27, 2012 3:04:44 PM com.sun.enterprise.v3.server.ApplicationLifecycle deploy
SEVERE: javax.naming.NamingException: Lookup failed for 'jdbc/foundation' in SerialContext[myEnv={com.sun.enterprise.connectors.jndisuffix=__pm, java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory, java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming} [Root exception is javax.naming.NameNotFoundException: foundation not found]
java.lang.RuntimeException: javax.naming.NamingException: Lookup failed for 'jdbc/foundation' in SerialContext[myEnv={com.sun.enterprise.connectors.jndisuffix=__pm, java.naming.factory.initial=com.sun.enterprise.naming.impl.SerialInitContextFactory, java.naming.factory.state=com.sun.corba.ee.impl.presentation.rmi.JNDIStateFactoryImpl, java.naming.factory.url.pkgs=com.sun.enterprise.naming} [Root exception is javax.naming.NameNotFoundException: foundation not found]

以下是我采取的一些故障排除步骤：

• 在maven POM中添加了额外的玻璃鱼
• 我已经将持久性文件放在/main/resources和/test/resources文件夹中
• 我已经尝试在DonatesFacadeTest文件中的@BeforeClass方法中向上下文对象添加特性，以及大约一百万个类似于下面的配置

环境信息：

• 使用Netbeans 7.0.1
• Maven项目
• 玻璃鱼3.1

DonatesFacade.java-这个类使用facade模式来提供对JPA实体的间接访问。

@Stateless
public class DonationsFacade extends AbstractFacade<Donations> {
@PersistenceContext(unitName = "FoundationPU")
private EntityManager em;
protected EntityManager getEntityManager() {
    return em;
}
public DonationsFacade() {
    super(Donations.class);
}
public boolean setPaid(int id, String transId)
{
    try{
        Donations don = em.find(Donations.class, id);
        don.setStatus("Paid");
        don.setConfirmationnumber(transId);
        em.persist(don);
        em.flush(); 
        return true;
    }
    catch(Exception ex)
    {
        return false;
    }
}

测试文件-只是试图编写一个简单的测试来验证数据。

public class DonationsFacadeTest {
@Test
public void testSetPaid() throws Exception {
    int id = 1;
    String transId = "123";
    EJBContainer ejbC = EJBContainer.createEJBContainer();
    Context ctx = ejbC.getContext();      
    DonationsFacade instance = (DonationsFacade)ctx.lookup("java:global/classes/DonationsFacade");
    boolean expResult = false;
    boolean result = instance.setPaid(id, transId);
    assertEquals(expResult, result);
    ejbC.close();
}
}

persistence.xml

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"...>
  <persistence-unit name="FoundationPU" transaction-type="JTA">
   <jta-data-source>jdbc/foundation</jta-data-source>
   <properties/>
  </persistence-unit>
</persistence>

glassfish-resources.xml

<resources>
<jdbc-resource enabled="true" jndi-name="jdbc/foundation" object-type="user"   pool-name="mysql_foundation_rootPool">
<description/>
</jdbc-resource>
<jdbc-connection-pool allow-non-component-callers="false" 
              associate-with-thread="false" 
              connection-creation-retry-attempts="0" 
              connection-creation-retry-interval-in-seconds="10" 
              connection-leak-reclaim="false" 
              connection-leak-timeout-in-seconds="0" 
              connection-validation-method="table" 
              datasource-classname="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" 
              fail-all-connections="false" idle-timeout-in-seconds="300" 
              is-connection-validation-required="false" 
              is-isolation-level-guaranteed="true" 
              lazy-connection-association="false" 
              lazy-connection-enlistment="false" 
              match-connections="false" 
              max-connection-usage-count="0" 
              max-pool-size="32" 
              max-wait-time-in-millis="60000" 
              name="connectionPool" 
              non-transactional-connections="false" 
              ping="false" 
              pool-resize-quantity="2" 
              pooling="true" 
              res-type="javax.sql.DataSource" 
              statement-cache-size="0" 
              statement-leak-reclaim="false" 
              statement-leak-timeout-in-seconds="0" 
              statement-timeout-in-seconds="-1" 
              steady-pool-size="8" 
              validate-atmost-once-period-in-seconds="0" 
              wrap-jdbc-objects="true">
<property name="URL" value="jdbc:mysql://localhost:3306/foundation"/>
<property name="User" value="root"/>
<property name="Password" value="thepassword"/>
</jdbc-connection-pool>
</resources>

再次感谢您的帮助，非常感谢。

Answer 1

在这里找到了答案。我基本上给这个类注入了一个实体管理器。希望这对尝试做同样事情的人有帮助。

public class DonationsFacadeTest {

private EntityManager em; 
private EntityTransaction tx; 
DonationsFacade donations;
public DonationsFacadeTest() {
}
@Before
public void setUpClass() throws Exception {
    EntityManagerFactory emf = Persistence.createEntityManagerFactory("Foundation2");
    em = emf.createEntityManager();
    tx = em.getTransaction(); 
    this.donations = new DonationsFacade(); 
    this.donations.em = em;
}
/**
 * Test of setPaid method, of class DonationsFacade.
 */
@Test
public void testSetPaid() throws Exception {
    int id = 1;
    String transId = "123";
    boolean expResult = false;
    boolean result = donations.setPaid(id, transId);
    assertEquals(expResult, result);
}
}

适当地修改了persistence.xml文件。

<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" ... >
<persistence-unit name="Foundation2" transaction-type="RESOURCE_LOCAL">
    <class>org.scmc.foundation.session.DonationsFacadeTest</class>
    <exclude-unlisted-classes>true</exclude-unlisted-classes>
    <properties>
       <property name="javax.persistence.jdbc.driver"   value="com.mysql.jdbc.Driver" />
       <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/foundation"/>
       <property name="javax.persistence.jdbc.user" value="root"/>
       <property name="javax.persistence.jdbc.password" value="password"/>
    </properties>
</persistence-unit>

最后将适当的驱动程序添加到POM文件中。

   <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.18</version>
    </dependency>