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.