Thread: JDBC Connection Error

I nee help please. I am trying to set up a jsp app on my new laptop but I keep running into the error below which I suspect is due to the connection string. The app works perfectly well on my former laptop. The named instance of the server on my new laptop is LAPTOPNAME\MSSQLSERVER but LAPTOPNAME\SQLEXPRESS on my old laptop.

org.apache.jasper.JasperException: An exception occurred processing [test.jsp] at line [37]

31: String MM_myConn_DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
32: String MM_myConn_USERNAME = "my_username";
33: String MM_myConn_PASSWORD = "my_password";
34: String MM_myConn_STRING = "jdbc:sqlserver://localhost:1433";
35: Class.forName(MM_myConn_DRIVER);
36: String dbURL = MM_myConn_STRING + ";user=" + MM_myConn_USERNAME + ";password=" + MM_myConn_PASSWORD;
37: Connection conn_up_tr = DriverManager.getConnection(dbURL);

Root Cause

javax.servlet.ServletException: java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:667)
org.apache.jsp.new_005fuser_jsp._jspService(new_00 5fuser_jsp.java:1183)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:741)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:444)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:385)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:329)
javax.servlet.http.HttpServlet.service(HttpServlet .java:741)
org.apache.tomcat.websocket.server.WsFilter.doFilt er(WsFilter.java:53)
org.apache.catalina.filters.SetCharacterEncodingFi lter.doFilter(SetCharacterEncodingFilter.java:108)

Originally Posted by trcooke

Is your new laptop using Java 9? Plenty of Google hits for "java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter", but you've already done that search yourself right?

Thanks Trcooke. The laptop is running Java 9. I uninstalled it and replaced with Java 8 and all is working fine now. I don't know precisely what changes in Java 9 that was responsible for the glitch but the problem is solved.