The problem is that when I run the file with the methods I want to test, it cannot find the mysql driver.

I simply load the files I want to test in jEdit, compile them and run a particular file. It compiles fine, but it doesn't run for the reason mentioned before: it doesn't find the driver.

The very same code runs perfectly in a Netbean project, so I assume I'm missing something in jEdit regarding on how to set up the mysql driver.

K. You're still not being very clear as to your issue, but I think I get the gist of it.

You're using SQLPlugin to run sql queries against your database: Works

You're using XYZ Plugin to compile and run a particular file: Compile works, running doesn't.

Question 1: What XYZ Plugin are you using to compile and run?

Question 2: How are you using the mysql driver? Meaning, are you using the DriverManager, some dependency injection api like Spring, some database pooling api like dbcp, or something else?

Regardless, it sounds like it's a classpath issue. jEdit plugins use the JARClassLoader that comes with jEdit. If you're using the DriverManager, you won't be able to find the Driver unless it's in the System classpath - which NB sets up for you (through ant).

This might help explain better:
http://community.jedit.org/?q=node/view/3812

Depending on how you're using the Driver, and how you're compiling and running your files there might be solutions.

Thanks.

Learn from the past. Live in the present. Plan for the future.
11101000
Blog

To compile and run I'm just using the Console plugin.
This is my code. This may answer your second question:



package data;

import java.io.*;
import business.Member;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class IOMember {

/*
* Create a new member
*/
public void saveMember(Member m){

Connection connection = getConnection();

try {
// make the prepared statement
PreparedStatement create = connection.prepareStatement(
"INSERT INTO mytable SET " +
"title=?, " +
"forename=?, " +
"surname=?, " +
"postcode=?, " +
"email=?, " +
"age=?, " +
"ms_type=?; ");

// set the attributes
create.setString(1, m.getTitle());
create.setString(2, m.getForename());
create.setString(3, m.getSurname());
create.setString(4, m.getPostCode());
create.setString(5, m.getEmail());
create.setString(6, m.getAge());
create.setString(7, m.getMembershipType());

// execute the prepared statement
create.executeUpdate();

// close prepared statement
create.close();

// close connection
connection.close();
}
catch(SQLException sqle) {
System.out.println("Failed to create record: " + sqle);
}
}



/*
* private method to obtain a new connection
*/
private Connection getConnection() {

try {

Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/UHI";
String user = "user";
String pass = "pass";
Connection connection = DriverManager.getConnection(url,user,pass);
return(connection);
}
catch(ClassNotFoundException cnfe) {
System.out.println("Could not find DB driver: " + cnfe);
}
catch(SQLException sqle) {
System.out.println("SQL Exception in getConnection(): " + sqle);
}
return(null);

}



/*****************************************************
* UNIT TESTING
*****************************************************/

public static void main(String[] args) {

IOMember iom = new IOMember();

/*
* SAVE MEMBER
*/
Member member = new Member("Mr", "John", "Doe", "12345",
"john@doe.com", "34", "All inclusive");
iom.saveMember(member);
/**/
}


}