0 Replies Latest reply on Feb 8, 2005 6:20 AM by Vicente Torrejon

    Unable to get connection, DataSource invalid: "java.sql.SQLE

    Vicente Torrejon Newbie

      Hi there! I have a J2EE application, using CMP beans, and a SQL Server DDBB. I've had no problems developing CMP beans for 1 month with my DDBB, but now I'm using jstl, and I can not access the DDBB.

      I have the next message:

      Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"

      And my code is:

      <sql:query var="user_balance" dataSource="java:/MSSQLDS">
      SELECT top 1 status_date, start_bal, end_bal, (select max (status_date) from ReportUserDaily) as 'max_date' FROM ReportUserDaily
      </sql:query>

      java:/MSSQLDS is the JNDI name of the DDBB, giving no problems with CMP beans, and properly defined(I think) in JBOSS. Do I need to duplicate the definitions for Tomcat???!!

      jlst tld are properly defined, as I've noticed it corrects me when I don't follow the right syntax.

      I'm lost. Any suggestions????

      Thanks everybody for read that.