Olá Pessoal, estou tendo um problema desenvolvi uma aplicação em JSP com Banco PostgreSQL, estão em dois servidores um de aplicação e outros de banco de dados ambos Windows 2008 64-bits fiz a conexão ODBC e funcionou corretamente, mas ao utilizar a aplicação apresenta o seguinte error:
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Exception in JSP: /index.jsp:110
107: if (!MM_abortEdit) {
108: // finish the sql and execute it
109: Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
110: Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);
111: PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString());
112: MM_editStatement.executeUpdate();
113: MM_connection.close();
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.index_jsp._jspService(index_jsp.java:219)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.index_jsp._jspService(index_jsp.java:177)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.25 logs.
Ações já feitas:
Variáveis de ambiente “setadas”:
CLASSPATH = C:\Java\jdk1.5.0_16\lib\postgresql-8.3-604.jdbc3.jar
JAVA_HOME = C:\Java\jdk1.5.0_16
Path = C:\Program Files\HP\NCU;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Java\jdk1.5.0_16\bin
[Odbc Dsn] está Ok ao testar a conexão está dando sucesso.
Não sei o que pode ser se é incompatibilidade pois o driver de [Odbc Dsn] é um baixado deste site [http://www.geocities.jp/inocchichichi/psqlodbc/index.html] foi o único que funcionou com o win2008 64bits.
Segue abaixo meu arquivo de conexão:
<%
// FileName="sun_jdbc_odbc_conn.htm"
// Type="JDBC" ""
// DesigntimeType="JDBC"
// HTTP="false"
// Catalog=""
// Schema=""
String MM_jsp_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
String MM_jsp_USERNAME = "jsp";
String MM_jsp_PASSWORD = "jsp";
String MM_jsp_STRING = "jdbc:odbc:jsp";
%>
Até mais