Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDBC-ODBC connectivity from JSP page

843859Apr 28 2010 — edited Apr 29 2010

hi

i am trying to connect a jsp page with database using jdbc-odbc driver. i have created a dsn with the name 'test' that connects to a database 'test' in SQL server. the following lines has been added to the web.xml file placed in the \WEB-INF folder

<context-param>

<param-name>

javax.servlet.jsp.jstl.sql.dataSource
</param-name>
<param-value>
jdbc:odbc:text, sun.jdbc.odbc.JdbcOdbcDriver

</context-param>

i have also placed the rt.jar file in the \WEB-INF\lib folder. but, when i run the jsp page and ty to make any database interaction, an expection occurs
java.lang.ClassNotFoundException : sun.jdbc.odbc.JdbcOdbcDriver

please help

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2010

Added on Apr 28 2010

#java-database-connectivity-jdbc

4 comments

921 views