Hi,
I made some changes since the last time. Now, got a new error. Here is the latest code:
<%
Statement sqlStatement = conn.createStatement();
String qrycerts = "select convert((hex(certificate)) using ascii) as certificate from dbtable where record_id=1";
ResultSet rs = sqlStatement.executeQuery(qrycerts);
while (rs.next()) {
byte[] certEntryBytes = rs.getBytes("certificate");
InputStream in = new ByteArrayInputStream(certEntryBytes);
CertificateFactory certFactory = CertificateFactory.getInstance("X509");
X509Certificate certs = (X509Certificate)certFactory.generateCertificate(in);
}
%>
===================== 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: An exception occurred processing JSP page test.jsp at line 40
40: X509Certificate certs = (X509Certificate)certFactory.generateCertificate(in);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510
)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.servlet.ServletException: java.security.cert.CertificateException: Could not parse
certificate: java.io.IOException: Empty input
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.files.testing_jsp._jspService(testing_jsp.java:115)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.security.cert.CertificateException: Could not parse certificate:
java.io.IOException: Empty input
sun.security.provider.X509Factory.engineGenerateCertificate(X509Factory.java:104)
java.security.cert.CertificateFactory.generateCertificate(CertificateFactory.java:339)
org.apache.jsp.files.testing_jsp._jspService(testing_jsp.java:99)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)