Junit test: cannot find test Method although that it is already defined in the test class

[ashley Jug]

Hello,

I have never used junit before and have a question regarding junit test:

I have the following method in my class SQLUtils:

package com.training.perso
import java.sql.Connection;
public class SQLUtils {
public boolean queryNamePassword(String userName,String passwrd)throws Exception{
		//locate jdbc jar the driver
		Class.forName("com.mysql.jdbc.Driver");

				Connection con = DriverManager
		.getConnection("jdbc:mysql://:3306/mydb","random",
		"22222");
		
		StringBuffer sb = new StringBuffer("select name,password from guesttbl where name =" +"'"+userName+"'" +"and password ="+"'" +passwrd+"'");

		PreparedStatement statement = con.prepareStatement(sb.toString());
		ResultSet result = statement.executeQuery();
		logger.info(sb.toString());

		
		while (result.next()){

			logger.info("name "+result.getString("name"));
			logger.info("password "+result.getString("password"));

			return true;
		}
		return false;

	}
}

I have created a unit test class in a new package for the method above:

import com.training.perso.SQLUtils;

import junit.framework.TestCase;

public class Junit_TestSQL extends TestCase {
	
	public void TestLogIn() throws Exception{
		
		SQLUtils sql = new SQLUtils();
		assertTrue(sql.queryNamePassword("random", "password"));
		
			
	}

}

However when i run the unit test i get the following error message:

junit.framework.AssertionFailedError: No tests found in com.training.JUnittest.Junit_TestSQL
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.TestSuite$1.runTest(TestSuite.java:263)
at junit.framework.TestCase.runBare(TestCase.java:127)
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:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
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:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

Can anybody advice me how i can solve the problem please?

Thanks a lot in advance.

[Ganesan Ponnusamy]

Please let me know the package name of Junit_TestSQL class.

[ashley Jug]

Hello,

the package name is :

package com.training.JUnittest;

Thanks for your quick response.

[Jesper de Jong]

The name of the method should start with "test" with lower-case letters. So it should be: testLogIn instead of TestLogIn.

Note that you are using JUnit's old API, from before generics were introduced (Java 5). If you're using JUnit 4 or newer, you don't have to make your test class extend TestCase and you can name your test method whatever you like, as long as you put an @Test annotation above it:

public class Junit_TestSQL {
    @Test
    public void doSomethingToTestLogin throws Exception {
        // perform test
    }
}

[ashley Jug]

Thanks it is working fine and i will update my junit to a newer version. Thanks again ;)

[ashley Jug]

Hello,

a quick question for the unit test, i am using maven to buld my project,

when i run the unit test manually from eclipse IDE it works fine but when i run the command mvn clean install it displays the following error msg:

[INFO] Compiling 5 source files to C:\MavPro\MyFirstServletTuto\target\classes
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 2.782s
[INFO] Finished at: Sat Sep 03 13:02:54 GST 2011
[INFO] Final Memory: 6M/12M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:2.0.2:compile (default-compile) on project MyFirstServletTuto: Compilation failure: Compilation failure:
[ERROR] C:\MavPro\MyFirstServletTuto\src\main\java\com\training\JUnittest\Junit_TestSQL.java:[5,22] package junit.framework does not exist
[ERROR] 
[ERROR] C:\MavPro\MyFirstServletTuto\src\main\java\com\training\JUnittest\Junit_TestSQL.java:[7,35] cannot find symbol
[ERROR] symbol: class TestCase
[ERROR] public class Junit_TestSQL extends TestCase {
[ERROR] 
[ERROR] C:\MavPro\MyFirstServletTuto\src\main\java\com\training\JUnittest\Junit_TestSQL.java:[11,2] cannot find symbol
[ERROR] symbol  : method assertTrue(boolean)
[ERROR] location: class com.training.JUnittest.Junit_TestSQL
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException

However have the jar junit-3.8.1.jar in Referenced libraries and it contains the pakage junit.framework.

Any idea how i can resolve this issue?

Thanks again.

[J J Singh]

Have you added junit to maven dependency list ?

Something like

<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.0</version>
<type>jar</type>
<scope>test</scope>
<optional>true</optional>
</dependency>


Please check it once