Hi
I have written a simple servlet that should connect to MS Access database
using the jdbc-odbc bridge. This is the code that I give in the init() of
the servlet.
init(){
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String connectionURL = "jdbc:obdc:webauctioneer";
String username = "admin";
String password = "pass";
Connection con = null;
try{
System.out.println("Registering " + driver);
//creating an instance of the jdbc driver so that it has a
//chance to register itself
Class.forName(driver);
System.out.println("Driver found");
//chekcing if the driver was registered or not
java.util.Enumeration temp = DriverManager.getDrivers();
while(temp.hasMoreElements()){
System.out.println("Driver :" + temp.nextElement());
}
System.out.println("Driver got");
con = DriverManager.getConnection(connectionURL,username,password);
System.out.println("Got connection");
}catch(java.sql.SQLException sqle){
System.out.println("Error : " + sqle);
getServletContext().log("Error :" + sqle);
connectionPool=null;
}catch(java.lang.ClassNotFoundException clnf){
System.out.println("Error finding class: " + clnf);
getServletContext().log("Error finding class:" + clnf);
connectionPool=null;
}
I get the following "no suitable driver" exception on the output window:
-------------------------------------------------------------------
C:\JDK13~1.1_0\jre\bin\java -cp
"C:\MyWebModules\WebAucitoneer\WEB-INF\classes;C:\MyWebModules\WebAucitoneer;C:\MyWebModules\WebAucitoneer\WEB-INF\classes;C:\forte4j\beans\TimerBean.jar;C:\forte4j\lib\ext\servlet.jar;C:\forte4j\system;C:\java
projects\beans\TimerBean.jar;C:\java projects\lib\ext\jdbc20x.zip;C:\java
projects\modules\ext\AbsoluteLayout.jar;C:\java
projects\modules\ext\persistence-rt.jar;C:\java
projects\modules\ext\rowset.jar;C:\java projects\modules\ext\sql.jar;c:\java
projects\jspwork\Tomcat+3.2\1cce74ad;c:\java
projects\jspwork\Tomcat+3.2\25658b35;c:\java
projects\jspwork\Tomcat+3.2\3221089b;c:\java
projects\jspwork\Tomcat+3.2\6b435f4d;c:\java projects\system";"c:\java
projects\lib\patches\core_patch.jar;c:\java
projects\lib\patches\openide_patch.jar;c:\java
projects\lib\locale\updater_ja.jar;c:\java
projects\lib\ext\locale\ddl_ja.jar;c:\java
projects\lib\ext\locale\rmi-ext_ja.jar;c:\java
projects\lib\ext\ddl.jar;c:\java projects\lib\ext\flute.jar;c:\java
projects\lib\ext\idlcompilers.jar;c:\java
projects\lib\ext\jdbc2_0-stdext.jar;c:\java
projects\lib\ext\openorb-1.0.2.jar;c:\java
projects\lib\ext\rmi-ext.jar;c:\java projects\lib\ext\sac.jar;c:\java
projects\lib\ext\jdbc20x.zip;C:\forte4j\lib\locale\core_f4j.jar;C:\forte4j\lib\locale\core_f4j_ce.jar;C:\forte4j\lib\locale\core_f4j_ce_ja.jar;C:\forte4j\lib\locale\core_f4j_ja.jar;C:\forte4j\lib\locale\core_ja.jar;C:\forte4j\lib\locale\openide_f4j.jar;C:\forte4j\lib\locale\openide_ja.jar;C:\forte4j\lib\locale\updater_ja.jar;C:\forte4j\lib\core.jar;C:\forte4j\lib\openide-fs.jar;C:\forte4j\lib\openide-nodes.jar;C:\forte4j\lib\openide-util.jar;C:\forte4j\lib\openide.jar;C:\forte4j\lib\ext\locale\ddl_ja.jar;C:\forte4j\lib\ext\locale\logger_ja.jar;C:\forte4j\lib\ext\locale\rmi-ext_ja.jar;C:\forte4j\lib\ext\bsh-1_0-fj.jar;C:\forte4j\lib\ext\cmd.jar;C:\forte4j\lib\ext\cosnaming.jar;C:\forte4j\lib\ext\ddl.jar;C:\forte4j\lib\ext\fjscript.jar;C:\forte4j\lib\ext\flute.jar;C:\forte4j\lib\ext\fscontext.jar;C:\forte4j\lib\ext\idlcompilers.jar;C:\forte4j\lib\ext\jaas.jar;C:\forte4j\lib\ext\jaxp.jar;C:
\forte4j\lib\ext\jh.jar;C:\forte4j\lib\ext\jndi.jar;C:\forte4j\lib\ext\ldap.jar;C:\forte4j\lib\ext\ldapbp.jar;C:\forte4j\lib\ext\logger.jar;C:\forte4j\lib\ext\nis.jar;C:\forte4j\lib\ext\openorb-1.0.2.jar;C:\forte4j\lib\ext\parser.jar;C:\forte4j\lib\ext\pbclient.jar;C:\forte4j\lib\ext\providerutil.jar;C:\forte4j\lib\ext\regexp.jar;C:\forte4j\lib\ext\rmi-ext.jar;C:\forte4j\lib\ext\rmiregistry.jar;C:\forte4j\lib\ext\sac.jar;C:\forte4j\lib\ext\sax2.jar;C:\forte4j\lib\ext\servlet.jar;C:\forte4j\lib\ext\xerces.jar;C:\forte4j\lib\ext\jdbc20x.zip;C:\JDK13~1.1_0\lib\dt.jar;C:\JDK13~1.1_0\lib\tools.jar";"C:\forte4j\modules\registration.jar;C:\forte4j\modules\pointbase.jar;C:\forte4j\modules\ant.jar;C:\forte4j\modules\ext\ant.jar;C:\forte4j\modules\ext\ant-optional.jar;C:\forte4j\modules\docs\ant-manual.zip;C:\forte4j\modules\clazz.jar;C:\forte4j\modules\debuggerCore.jar;C:\forte4j\modules\applet.j
ar;C:\forte4j\modules\toolsDebugger.jar;C:\forte4j\modules\filecopy.jar;C:\forte4j\modules\ext\ftpclient.jar;C:\forte4j\modules\html.jar;C:\forte4j\modules\extbrowser.jar;C:\forte4j\modules\image.jar;C:\forte4j\modules\jarpackager.jar;C:\forte4j\modules\beans.jar;C:\forte4j\modules\jndi.jar;C:\forte4j\modules\loggerModule.jar;C:\forte4j\modules\classfile.jar;C:\forte4j\modules\projects.jar;C:\forte4j\modules\properties.jar;C:\forte4j\modules\i18n-form.jar;C:\forte4j\modules\properties-syntax.jar;C:\forte4j\modules\text.jar;C:\forte4j\modules\usersguide.jar;C:\forte4j\modules\openidex.jar;C:\forte4j\modules\j2eeserver.jar;C:\forte4j\modules\utilities.jar;C:\forte4j\modules\locale\utilities_f4j.jar;C:\forte4j\modules\apisupport-lite.jar;C:\forte4j\modules\javacvs.jar;C:\forte4j\modules\ext\cvslib.jar;C:\forte4j\modules\vcsgen.jar;C:\forte4j\modules\jsp-syntax.jar;C:\forte4j\modules\jsp-tom
cat.jar;C:\forte4j\modules\ext\tomcat-monitor.jar;C:\forte4j\modules\iplanet_wsae.jar;c:\java
projects\modules\db.jar;c:\java projects\modules\java.jar;c:\java
projects\modules\ext\javac.jar;c:\java
projects\modules\ext\java-gj.jar;c:\java projects\modules\jdbc.jar;c:\java
projects\modules\ext\sql.jar;c:\java projects\modules\ext\rowset.jar;c:\java
projects\modules\jsp.jar;c:\java projects\modules\ext\jasper.jar;c:\java
projects\modules\jspie.jar;c:\java projects\modules\autoupdate.jar;c:\java
projects\modules\browser.jar;c:\java
projects\modules\ext\infobus.jar;c:\java projects\modules\corba.jar;c:\java
projects\modules\cvs.jar;c:\java projects\modules\dbschema.jar;c:\java
projects\modules\dd2beans.jar;c:\java projects\modules\editor.jar;c:\java
projects\modules\ext\nb-editor.jar;c:\java projects\modules\form.jar;c:\java
projects\modules\ext\AbsoluteLayout.jar;c:\java
projects\modules\httpserver.jar;c:\java
projects\modules\ext\webserver.jar;c:\java projects\modules\i18n.jar;c:\java
projects\modules\idl-syntax.jar;c:\java projects\modules\j2eelib.jar;c:\java
projects\modules\javadoc.jar;c:\java
projects\modules\jpdaDebugger.jar;c:\java
projects\modules\persistence-ui.jar;c:\java
projects\modules\ext\persistence-rt.jar;c:\java
projects\modules\rmi.jar;c:\java projects\modules\vcscore.jar;c:\java
projects\modules\xml-syntax.jar;c:\java projects\modules\xml.jar"
org.netbeans.modules.web.tomcat.WebAppMain "c:\java
projects\system\tomcat\server.xml" "c:\java projects\system\tomcat"
Starting tomcat. Check logs/tomcat.log for error messages
Registering sun.jdbc.odbc.JdbcOdbcDriver
Driver found
Driver :sun.jdbc.odbc.JdbcOdbcDriver@341960
Driver got
Error : java.sql.SQLException: No suitable driver
--------------------------------------------------------
Other relevent information is this:
Developiing using : Forte CE on Windows 2000
Testing on the inbuilt Tomcat 3.2 server
Also in forte i succesfully created a database schema for the same driver
using the same URL and driver name. There it seems to be working fine. Also
if try to test the jdbc-odbc bridge driver by using the test drive function
in the forte runtime drivers list window. it says that the drive is
incomplte and cannot run some of the meta methods.
I even tried running the servlet seperately on the Tomcat server but alas it
gives the same error.
Can somebody throw some light on this?
Ishank
ps: thanks to hirish and jp saxe for their earlier postings. they reallu
helped.
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
