JDBC Error with Servlets not with Application

[Scott Layne]

I am having a problem that I simply cannot figure out.
I have a MS Access database defined through ODBC, and when I connect through an appliation, no problem. but when my servlet tries to connect to the same db, it can not do it, and it throws an exception.
Here is the offending code:

    private String jdbcDriverName = "sun.jdbc.odbc.JdbcOdbcDriver";
    private static String url = "jdbc :-o	 dbc:ETC";
        try
{
    Class.forName(jdbcDriverName).newInstance();
            DriverManager.setLogStream(System.out);
    _conn = DriverManager.getConnection(url,"","");
}

I turned on JDBC logging, and this is the output.

DriverManager.getConnection("jdbc :-o	 dbc:ETC")
    trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@4e3f41]
*Driver.connect (jdbc :-o	 dbc:ETC)
JDBC to ODBC Bridge: Checking security
No SecurityManager present, assuming trusted application/applet
Allocating Environment handle (SQLAllocEnv)
hEnv=5378720
Allocating Connection handle (SQLAllocConnect)
hDbc=5378888
Connecting (SQLDriverConnect), hDbc=5378888, szConnStrIn=DSN=ETC
RETCODE = -1
ERROR - Generating SQLException...
ERROR - S1000 General error
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6060)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at dbconnection.DBConnPoolMgr.getConnection(DBConnPoolMgr.java:74)
at dbconnection.DBConnector.getProductIDs(DBConnector.java:146)
at dbconnection.DBServlet.doGet(DBServlet.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:429)
at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:495)
at java.lang.Thread.run(Thread.java:484)
SQLException: SQLState(S1000)
Closing connection (SQLFreeConnect), hDbc=5378888
Closing environment (SQLFreeEnv), hEnv=5378720
getConnection failed: java.sql.SQLException: General error
  

[Mike Curwen]

try  {
   Class.forName(jdbcDriverName).newInstance();
   DriverManager.setLogStream(System.out);
   _conn = DriverManager.getConnection(url,"","");
} catch (SQLException se) {
   System.err.println("sqlerror = " + se.getErrorCode());
}

Perhaps the MSAccess error code could provide some insight. If it prints out a nice 'sql error' number, you can search for that on MSDN.

[Scott Layne]

I put in the system.out statement and got:
sqlerror = 0

[Ivan Tamayo]

Inside try{...}catch block, put the following statement:
Class.forName(xxxxxx)
xxxx: driver jdbc-odbc driver
without the ".newInstance" part.