This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Servlets with JDBC -Driver problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Servlets with JDBC -Driver problem" Watch "Servlets with JDBC -Driver problem" New topic

Servlets with JDBC -Driver problem

kiran bayyana

Joined: Aug 15, 2000
Posts: 17
Hi all,
I am working with Servlets and JDBC right now. I am facing a problem. I hope any of you people can help me out. I worked with Servlets program and JDBC program. Both r working fine. When I club the JDBC program into the Servlets program appropriately and run the servlet in a web browser, I am getting an error saying that "No Suitable Driver". Do I need to register my driver with the webbrowser? I mean do I need to do any browser settings for the driver? I am using I-net Sprinta2000 type-4 JDBC driver. And I am using SQL-Server 7 for back-end. Hope I will get around with my problem with all of ur help. Thank you.
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
The browser has nothing to do with JDBC since the JDBC is running on the server. Check the code and make sure that you are properly loading the driver and properly specifying the correct URL in the getConnection.

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
kiran bayyana

Joined: Aug 15, 2000
Posts: 17
Thank u very much for ur reply. I think the problem is not with my code because I did everything properly. I got the answer for my previous problem. I am using JavaWebServer2.0. Because it has it's own classpath settings, the problem originated. It is not recognizing the driver. I copied all the driver classes in the servlets directory of the server where it can recognize. Now the message is changed saying that Inet Sprinta 2000 driver need JVM1.2 or higher. I am using JDK1.2. How to know the JVM version and how to solve this problem? Thanks again.
Have you checked out Aspose?
subject: Servlets with JDBC -Driver problem
jQuery in Action, 3rd edition