Newbie having problems with StrutsMocktestCase

[Vidya Moorthy]

Hi all
I was trying to practice a Struts tutorial of testing a UserRegistrationActionTest by extending MockStrutsTestCase in MyEclipse IDE. When I ran the Action class as a Junit, I get 3 errors.
This is the trace
junit.framework.AssertionFailedError
at servletunit.struts.MockStrutsTestCase.getActionServlet(MockStrutsTestCase.java:284)
at strutsTutorial.struts.UserRegistrationActionTest.setUp(UserRegistrationActionTest.java:28)
at junit.framework.TestCase.runBare(TestCase.java:128)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:120)
at junit.framework.TestSuite.runTest(TestSuite.java:230)
at junit.framework.TestSuite.run(TestSuite.java:225)
at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

Here is the code for the UserRegistrationActionTest

  
package strutsTutorial.struts;
 
import java.sql.Connection;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
 
import org.apache.struts.Globals;
import org.apache.struts.config.ModuleConfig;
import org.apache.struts.util.RequestUtils;
 
import servletunit.struts.MockStrutsTestCase;
import strutsTutorial.struts.testUtils.JDBCTestUtils;
 
public class UserRegistrationActionTest extends MockStrutsTestCase{
Connection connection;
    
    
public UserRegistrationActionTest(String testName) {
super(testName);
}

public void setUp() throws Exception { 

/* Always call the superclass setUp method! */
super.setUp(); 
*******The line below causes the error**********************
/* Get the Sevlet Context from the ActionServlet */
ServletContext context = this.getActionServlet().getServletContext();

/* Grab the moduleConfig from the ServletContext */
ModuleConfig moduleConfig = RequestUtils.getModuleConfig(this.getRequest(),context);

/* Create a Mock DataSource */
DataSource source = JDBCTestUtils.getMockedDataSource();

/* Get the connection from the DataSource */
connection = source.getConnection();

/* Create the database table for User */
JDBCTestUtils.createDB(connection);

/* Put the datasource where Struts will find it and deliver it to the Action */
context.setAttribute("userDB" + moduleConfig.getPrefix(),source);
 
}
 

 
private void populateUserForm(String email) {
addRequestParameter("userName", "KingAdRock");
addRequestParameter("firstName", "Rick");
addRequestParameter("lastName", "Hightower");
addRequestParameter("email", email);
addRequestParameter("lastName", "Hightower");
addRequestParameter("phone", "555-1212");
addRequestParameter("fax", "555-1212");
addRequestParameter("password", "555-1212");
addRequestParameter("passwordCheck", "555-1212");
}
 
public void testUserRegistration() {
/* Primary key */
String email = "[e-mail]";
 
/* Set the action path */
setRequestPathInfo("/userRegistration");
 
populateUserForm(email);
 
/* Run the action through the ActionServlet */
actionPerform();
 
/* Make sure that the user was created in the system*/
assertTrue(JDBCTestUtils.userExists(connection, email));
 
/* Verify that the action forwared to success */
verifyForward("success");
 
/* Verify that there were no exceptions */
verifyNoActionErrors();
}

public void testDuplicateUserRegistrations(){

/* Create the first registration */
String email = "[e-mail]";
JDBCTestUtils.createUser(connection, email);
 
/* Set the action path */
setRequestPathInfo("/userRegistration");
populateUserForm(email);

/* Run the action through the ActionServlet */
actionPerform();

/* Make sure that the Exception Handler error message is present */
verifyActionErrors(new String[]{"userRegistration.sql.exception"});

/* Make sure the Exception object got put into request scope */
Exception e = (Exception) getRequest().getAttribute(Globals.EXCEPTION_KEY);
assertNotNull(e);

}

public void testCancelUserRegistration(){


/* Primary key */
String email = "[e-mail]";

/* Set the action path */
setRequestPathInfo("/userRegistration");


populateUserForm(email);

/* Simulate hitting the cancel key */
getRequest().setAttribute(Globals.CANCEL_KEY,"CANCEL");

/* Run the action through the ActionServlet */
actionPerform();

/* Make sure the user was not created */
assertFalse(JDBCTestUtils.userExists(connection, email));

/* Verify we were forwarded to the right place */
verifyForward("welcome");


verifyNoActionErrors();
}
public void tearDown() throws Exception {
/* Always call the super class method*/
super.tearDown();
/* Clear users is needed for non-in-memory
databases */
JDBCTestUtils.clearUsers(connection);
/* Close the database connection */
connection.close();
}
 
}
 
 

Please help me figure out the problem!
Thanks in advance
Vidya moorthy

[Christophe Verré]

Did you follow the API's note :
NOTE: By default, the Struts ActionServlet will look for the file WEB-INF/struts-config.xml, so you must place the directory that contains WEB-INF in your CLASSPATH. If you would like to use an alternate configuration file, please see the setConfigFile() method for details on how this file is located.

[Hannibal Ou]

Vidya Moorthy:
Are you studing struts by the book "JakartaStrutsLive"?
I do it.But I also have many issues .Can you show me the code of class "JDBCTestUtils".
I really can't find the code in the book.

Thanks

[Vidya Moorthy]

Here it is

 
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import java.util.List;
 
import javax.sql.DataSource;
 
import strutsTutorial.struts.dao.DAOFactory;
import strutsTutorial.struts.dao.UserDAO;
import strutsTutorial.struts.user.User;
 
public class JDBCTestUtils {
static Connection conn = null;
    static String url = "jdbc:mysql://localhost:3306/";
    static String dbName = "jdbctutorial";
    static String driver = "com.mysql.jdbc.Driver";
    static String userName = "root";
    static String password = "graf1234";
    JDBCTestUtils j = new JDBCTestUtils();
static {
try {
/* Using HyperSonic SQL */
Class.forName(driver).newInstance();
      
} catch (Exception e) {
}
}
 
/**
 * @return
 */
public static Connection getConnection() throws SQLException {
/* Tell MySQL to use the in memory database. 
 * When the connection closes, the data goes away.
 * */
conn = DriverManager.getConnection(url+dbName,userName,password);
System.out.println("Got a connection");
return conn;
}
 
private static boolean createdDB = false;
    
public static void createDB(Connection connection) throws SQLException {

//if (createdDB==true)return;

String ddl =
"CREATE TABLE USERS4"
+ "(EMAIL VARCHAR(80),"
+ "FIRST_NAME VARCHAR(80),"
+ "LAST_NAME VARCHAR(80), "
+ "PASSWORD VARCHAR(11), "
+ "PHONE VARCHAR(11), "
+ "FAX VARCHAR(11), "
+ "CONSTRAINT USER_PK PRIMARY KEY (EMAIL));";
 
Statement statement = connection.createStatement();
statement.execute(ddl);
createdDB=true;
 
}
 
public static void clearUsers(Connection connection) throws SQLException {

String sql =
"DELETE FROM USERS4";
 
Statement statement = connection.createStatement();
statement.execute(sql);

 
}
public static void createUser(Connection connection, String email) {
UserDAO dao = DAOFactory.createUserDAO(connection);
 
User user = new User();
user.setEmail(email);
user.setFirstName("Kiley");
user.setLastName("Mackeon");
user.setPhone("520 290 6855 ext. 101");
 
dao.createUser(user);
}
 
public static DataSource getMockedDataSource() throws SQLException {
/* Tell MySQL to use the in memory database. 
 * When the connection closes, the data goes away.
 * */
Connection connection = getConnection();
return new MockDataSource(connection);
}
 
public static boolean userExists(Connection connection, String email) {
UserDAO dao = DAOFactory.createUserDAO(connection);
List<User> users = dao.listUsers();
 
boolean found = false;
for (Iterator<User> iter = users.iterator(); iter.hasNext() :wink:  {
User user = (User) iter.next();
if (user.getEmail().equals(email)) {
found = true;
}
}
 
return found;
 
}
 
static class MockDataSource implements DataSource {
 
private Connection connection;
 
public Connection getConnection() throws SQLException {
return connection;
}
 
/**
 * @param connection
 */
public MockDataSource(Connection connection) {
 
this.connection = connection;
}
 
/* (non-Javadoc)
 * @see javax.sql.DataSource#getConnection(java.lang.String, java.lang.String)
 */
public Connection getConnection(String username, String password)
throws SQLException {
return null;
}
 
/* (non-Javadoc)
 * @see javax.sql.DataSource#getLoginTimeout()
 */
public int getLoginTimeout() throws SQLException {
return 0;
}
 
/* (non-Javadoc)
 * @see javax.sql.DataSource#getLogWriter()
 */
public PrintWriter getLogWriter1() throws SQLException {
return null;
}
 
/* (non-Javadoc)
 * @see javax.sql.DataSource#setLoginTimeout(int)
 */
public void setLoginTimeout(int seconds) throws SQLException {
 
}
 
/* (non-Javadoc)
 * @see javax.sql.DataSource#setLogWriter(java.io.PrintWriter)
 */
public void setLogWriter1(PrintWriter out) throws SQLException {
}
 
public PrintWriter getLogWriter() throws SQLException {
// TODO Auto-generated method stub
return null;
}
 
public void setLogWriter(PrintWriter out) throws SQLException {
// TODO Auto-generated method stub

}
 
}
 
}
 

   

I have lot of problems too because that book is based on Struts 1.1 and many methods are deprecated now.
I am not able to finish it only

[Hannibal Ou]

Thanks for your code!
I also feel it is so hard that when you have a book which using Struts1.1 but you work environment is based on struts 1.2x.
Because my struts is version 1.2.15. So I reading the book with google!When the compiler throws a warning that I used a deprecated method I will search in google to check which method we should used to instead of the deprecated method.
So if any question you have maybe I also have,I hope can study this books together and can I have your MSN or Skype?