Data source problem

[Nikunj Aggarwal]

hi,
I am new to j2ee and i am doing netbeans E-commerce tutorial . But when i reach to "Connecting the Application to the Database" topic,i unable to connect project to database. I done all the things right but still when i am running "testDataSource.jsp" page it showing error in the browser.


exception

javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for jdbc/affablebean"

root cause

javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for jdbc/affablebean"


This exception is coming. I read troubleshoot also but still no help. I want to know to add "reference resource " because in the tutorial is done differently and i am using netbeans 6.9.1
Please help me, in order to solve this problem.

[Lucas Ratusznei]

Hello!

Try to remove a possible blank space after jdbc/affablebean reference in testDataSource.jsp

this:
<sql:query var="result" dataSource="jdbc/affablebean ">
SELECT * FROM category, product WHERE category.id = product.category_id
</sql:query>

should be:
<sql:query var="result" dataSource="jdbc/affablebean">
SELECT * FROM category, product WHERE category.id = product.category_id
</sql:query>

Thanks!

[Campbell Ritchie]

Welcome to the Ranch Lucas Ratusznei