1 Reply Latest reply on Sep 28, 2009 7:21 PM by John Ament

    JBoss-5.0.0.GA runtime java.sql.Exception - Request help

    Lama Eejrenab Newbie

      Could some JBoss guru please kindly help me ? I am desperately trying to a simple JBoss-5.0.0.GA based application to work. Some details:
      1. I am using Eclipse Galileo along with JBoss IDE 1.5 for code compiling, jar building and I use a single WAR file and a few jar files
      2. I using Java JDK 1.6_11 on a RedHat EL 4 machine. I am using PostgreSQL 8.4, postgres-8.5_107.jdbc.jar, as downloaded from the official Postgres site at www.postgres.org
      3. I include the postgres**.jar file in both Eclipse's Java Build Path and in the final WAR file to be used for deployment
      4. I have modified JBoss's run.sh so that the JBoss runtime CLASSPATH can access the postgres***.jar file, and I have a simple 'echo' statement to verify that the runtime CLASSPATH includes this jar file

      Problem:
      I am getting java.sql.***Exception, with the error message that the suitable driver could not be found. In my source file, I have a very standard approach as:

      Class.forName("org.postgresql.Driver").newInstance();
      con = DriverManager.getConnection(....);

      Could someone please help ? I have tried to solve this problem for the last few weeks and tried all possible things, but nothing has worked. Any hints, suggestions would be greatly appreciated. Thanks in advance for your help.