> String connectionURL = "jdbc:obdc:webauctioneer";
you have spelling mistake in above statement. it s'd be
"jdbc:odbc:webautioneer" instead of "jdbc:obdc:webauctioneer".
----- Original Message -----
From: "Ishank Jain" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 24, 2002 12:10 AM
Subject: jdbc-odbc bridge problem
> 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.ja
r;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\l
ib\locale\core_f4j_ce.jar;C:\forte4j\lib\locale\core_f4j_ce_ja.jar;C:\forte4
j\lib\locale\core_f4j_ja.jar;C:\forte4j\lib\locale\core_ja.jar;C:\forte4j\li
b\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\loc
ale\logger_ja.jar;C:\forte4j\lib\ext\locale\rmi-ext_ja.jar;C:\forte4j\lib\ex
t\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\e
xt\flute.jar;C:\forte4j\lib\ext\fscontext.jar;C:\forte4j\lib\ext\idlcompiler
s.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\l
ib\ext\nis.jar;C:\forte4j\lib\ext\openorb-1.0.2.jar;C:\forte4j\lib\ext\parse
r.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\ex
t\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:\for
te4j\modules\registration.jar;C:\forte4j\modules\pointbase.jar;C:\forte4j\mo
dules\ant.jar;C:\forte4j\modules\ext\ant.jar;C:\forte4j\modules\ext\ant-opti
onal.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:\f
orte4j\modules\ext\ftpclient.jar;C:\forte4j\modules\html.jar;C:\forte4j\modu
les\extbrowser.jar;C:\forte4j\modules\image.jar;C:\forte4j\modules\jarpackag
er.jar;C:\forte4j\modules\beans.jar;C:\forte4j\modules\jndi.jar;C:\forte4j\m
odules\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\mo
dules\j2eeserver.jar;C:\forte4j\modules\utilities.jar;C:\forte4j\modules\loc
ale\utilities_f4j.jar;C:\forte4j\modules\apisupport-lite.jar;C:\forte4j\modu
les\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
___________________________________________________________________________
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
