You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by ANA JUNQUERA FERREIRAS <an...@tid.es> on 2003/11/24 21:26:29 UTC
Problem with JDBC and Tomcat
Hi,
I have a problem with JDBC. I am using JDK1.3.1, tomcat 4.1.24 with
Microsoft Access 2000 and when I am trying to close an opened connection I
get the following message:
EXCEPCION: java.sql.SQLException: General error
at
sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6160)
at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:2742)
at
sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:842)
at
sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:736)
at
es.tid.teledomo.asistel.FormularioTeleasistencia.liberarConexionTelea
sistencia(FormularioTeleasistencia.java:3431)
at
es.tid.teledomo.asistel.FormularioTeleasistencia.listaConfiguracion(F
ormularioTeleasistencia.java:3604)
at org.apache.jsp.menu_jsp._jspService(menu_jsp.java:106)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:210)
I have the same problem with tomcat 3.2 ...
java.sql.SQLException: General error
at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6155)
at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:2737)
at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:837)
at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:731)
at
es.tid.teledomo.avisos.ConexionBaseDatos.liberarConexionAvisos(ConexionBaseD
atos.java)
at
es.tid.teledomo.avisos.ConexionBaseDatos.leerTablaAvisos(ConexionBaseDatos.j
ava)
at
jsps.avisos._0002fjsps_0002favisos_0002fdejar_0005favisos_0002ejspdejar_0005
favisos_jsp_0._jspService(_0002fjsps_0002favisos_0002fdejar_0005favisos_0002
ejspdejar_0005favisos_jsp_0.java:1147)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.ja
va:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
Thanks for your help
Ana
---
Ana Junquera Ferreras
Control en el Entorno Móvil
Telefónica Investigación y Desarrollo
Parque Tecnológico de Boecillo
47151 Boecillo (Valladolid)
Tel.: 983 36 76 36
Fax.: 983 36 75 64
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Problem with JDBC and Tomcat
Posted by Ben Souther <bs...@fwdco.com>.
> es.tid.teledomo.asistel.FormularioTeleasistencia.listaConfiguracion(F
> ormularioTeleasistencia.java:3604)
Can you post your code? The driver is throwing a generalSQLException. It's
hard for us to see what the problem is from this.
Have you tested the ODBC data source?
Do you have other pages working with that ODBC database source?
On Monday 24 November 2003 03:26 pm, ANA JUNQUERA FERREIRAS wrote:
> Hi,
> I have a problem with JDBC. I am using JDK1.3.1, tomcat 4.1.24 with
> Microsoft Access 2000 and when I am trying to close an opened connection I
> get the following message:
>
> EXCEPCION: java.sql.SQLException: General error
> at
> sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6160)
> at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:2742)
> at
> sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:842)
> at
> sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:736)
> at
> es.tid.teledomo.asistel.FormularioTeleasistencia.liberarConexionTelea
> sistencia(FormularioTeleasistencia.java:3431)
> at
> es.tid.teledomo.asistel.FormularioTeleasistencia.listaConfiguracion(F
> ormularioTeleasistencia.java:3604)
> at org.apache.jsp.menu_jsp._jspService(menu_jsp.java:106)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
> .java:210)
>
>
> I have the same problem with tomcat 3.2 ...
>
> java.sql.SQLException: General error
> at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:6155)
> at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:2737)
> at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:837)
> at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:731)
> at
> es.tid.teledomo.avisos.ConexionBaseDatos.liberarConexionAvisos(ConexionBase
>D atos.java)
> at
> es.tid.teledomo.avisos.ConexionBaseDatos.leerTablaAvisos(ConexionBaseDatos.
>j ava)
> at
> jsps.avisos._0002fjsps_0002favisos_0002fdejar_0005favisos_0002ejspdejar_000
>5
> favisos_jsp_0._jspService(_0002fjsps_0002favisos_0002fdejar_0005favisos_000
>2 ejspdejar_0005favisos_jsp_0.java:1147)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.j
>a va:130)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>
> Thanks for your help
> Ana
>
> ---
> Ana Junquera Ferreras
> Control en el Entorno Móvil
> Telefónica Investigación y Desarrollo
> Parque Tecnológico de Boecillo
> 47151 Boecillo (Valladolid)
> Tel.: 983 36 76 36
> Fax.: 983 36 75 64
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
--
Ben Souther
F.W. Davison & Company, Inc.
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org