EJB and mysql

joseluisherrero Apr 16, 2005 2:57 PM

Hi everybody

Something is wrong in my JBOSS server.

I've developed a program that uses a mySQL database as follows:

public class C1Bean implements SessionBean {
.........
public int activate(){
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception ex) {
return ( -1);
}
return (0);
}
..........

The imported library is : mysql-connector-java-3.1.7.bin.jar

The program is deployed ok, but when the method is invoked, always returns -1.

If the program is used locally, that is, calling this method locally (no Jboss), the program runs ok.

Does JBOSS run Ok if a database connector is needed?. Do I need to add something else to the JBOSS configuration?

Regards
Pepe

1. Re: EJB and mysql

darranl Apr 17, 2005 6:52 AM (in response to joseluisherrero)

When programming using Java the exceptions contain a lot of information about what the problem is, instead of converting it to an int you should either rethrow the exception or at the very least log the details i.e. Message, exception classname and stack trace.

Is there a reason why you are avoiding the connection pool mechanism provided by the application server i.e. You configure a pool of connections and the session bean uses JNDI to get a connection.
Actions