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.
javax.servlet.ServletException: javax.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for jdbc/affablebean"
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.
It looks like your application server can't find the JDBC driver for you DataSource, you must read the documentation of your application server to determine the location of the libs, for example for oracle DataBase you need the ojdbc.jar that contains the necessary class to connect to oracle, and with glassfish you must put the ojdbc.jar in glassfish/domains/domain1/lib/ext so you application server can find the correct driver for you DataSource.
Or try to put your jdbc driver jar, on the lib folder of your web application, example WEB-INF/lib/ojdbc.jar
When a dream is ending because to come true - OCPJP 6,7. OCE JPA EE6. MCTS