java - IDEA tomcat連接數(shù)據(jù)庫出現(xiàn)問題？
問題描述
Javaweb新手,配置jndi后連接數(shù)據(jù)后總出現(xiàn)異常報(bào)錯(cuò)出現(xiàn)在 myConn = ds.getConnection();
修改my.ini后還是會(huì)出現(xiàn)這種問題
配置jndi的context.xml文件
<?xml version='1.0' encoding='UTF-8'?><Context path='/' reloadable='true'> <Resource name='jdbc/studentinfo' auth='Container' type='javax.sql.DataSource' maxActive='100' maxIdle='30' maxWait='10000' username='root' password='000000' driverClassName='com.mysql.jdbc.Driver' url='jdbc:mysql://localhost:3306/studentinfo?'> </Resource></Context>
web.xml文件
<?xml version='1.0' encoding='UTF-8'?><web-app xmlns='http://xmlns.jcp.org/xml/ns/javaee' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd' version='3.1'> <resource-ref><res-ref-name>jdbc/studentinfo</res-ref-name><res-type>javax.sql.DataSource</res-type><res-auth>Container</res-auth> </resource-ref><servlet><servlet-name>StudentServlet</servlet-name><servlet-class>init.StudentServlet</servlet-class> </servlet> <servlet-mapping><servlet-name>StudentServlet</servlet-name><url-pattern>/StudentServlet</url-pattern> </servlet-mapping></web-app>
java文件
public class StudentServlet extends HttpServlet{ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {response.setContentType('text/html;charset=GB2312');PrintWriter out = response.getWriter();out.println('<html>');out.println('<head><title>StudentInfo</title></head>');if((request.getParameter('sno') == null || request.getParameter('sno').equals('input number'))){ out.println('<form method=’post’ action=’/Servlet/StudentServlet’ >'); out.println(''); out.println('學(xué)號查詢：<input type=’text’ name=’sno’ value=’input number’ />'); out.println('<input type=’submit’ value=’查詢’ /><br>'); out.println('</form>');}else if (!(request.getParameter('sno').equals('input number'))){ Vector vc = new Vector(); out.println('<form method=’post’ action=’/Servlet/StudentServlet’ >'); out.println(''); out.println('學(xué)生學(xué)號：<input type’text’ name=’sno’ />'); out.println('</form>'); out.println('<br>'); out.println('<table border=’1’>'); out.println('<tr><th>學(xué)號</th><th>姓名</th><th>語文</th><th>數(shù)學(xué)</th></tr>'); try {if((vc = accessDB(Integer.parseInt((String)request.getParameter('sno')))) != null){ out.println('<tr>'); out.println('<td>' + vc.elementAt(0) + '</td>'); out.println('<td>' + vc.elementAt(1) + '</td>'); out.println('<td>' + vc.elementAt(2) + '</td>'); out.println('<td>' + vc.elementAt(3) + '</td>'); out.println('</tr>');} }catch (Exception e){out.println('<tr>');out.println('<td>沒有記錄：</td>');out.println('</tr>');out.println('數(shù)據(jù)庫里沒有你要查詢得記錄');e.printStackTrace(); } out.println('</table>');}out.println('</body>');out.println('</html>');out.flush();out.close(); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request, response); } @Override public void init() throws ServletException { } public Vector accessDB(int id){Vector vc = new Vector();DataSource ds = null;Context ctx;Connection myConn = null;try { ctx = new InitialContext(); ds = (DataSource) ctx.lookup('java:comp/env/jdbc/studentinfo');}catch (Exception e){ e.printStackTrace();}if (ds == null){ System.out.println('Error');}else { System.out.println('Connection is OK!');}PreparedStatement statement = null;ResultSet mySet = null;try { myConn = ds.getConnection(); statement = myConn.prepareStatement('SELECT * FROM info WHERE sno=?'); statement.setInt(1,id); mySet = statement.executeQuery(); while (mySet.next()){vc.add(Integer.toString(mySet.getInt('sno')));vc.add(mySet.getString('sname'));vc.add(Integer.toString(mySet.getInt('chinese')));vc.add(Integer.toString(mySet.getInt('math'))); } statement.close(); mySet.close(); myConn.close(); return vc;}catch (Exception e){ e.printStackTrace();}return vc; } public static void main(String[] args) {StudentServlet aa = new StudentServlet();System.out.println(aa.accessDB(100).elementAt(1)); }}
修改context.xml的urlurl='jdbc:mysql://localhost:3306/studentinfo?useSSL=true'
還是會(huì)出現(xiàn)異常如下：java.sql.SQLException: Cannot create PoolableConnectionFactory (Unknown system variable ’lower_case_table_names’)
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2303)at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2043)at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543)at init.StudentServlet.accessDB(StudentServlet.java:102)at init.StudentServlet.doGet(StudentServlet.java:47)
問題解答
回答1：原因:MySQL在高版本需要指明是否進(jìn)行SSL連接解決:jdbc:mysql://localhost:3306/studentinfo?characterEncoding=utf8&useSSL=true問題:Unknown system variable ’lower_case_table_names’降低 mysql-connector-java jar版本試試
相關(guān)文章：
1. java固定鍵值轉(zhuǎn)換，使用枚舉實(shí)現(xiàn)字典？2. javascript - 移動(dòng)端開發(fā) H5 頁面在 iOS手機(jī)上無法實(shí)現(xiàn) 長按復(fù)制文本 求解決3. 如何解決tp6在zend中無代碼提示4. java - HTTPS雙向認(rèn)證基礎(chǔ)上有無必要再進(jìn)行加簽驗(yàn)簽？5. vim - win10無法打開markdown編輯器6. html - 如何使用用戶輸入的數(shù)據(jù)去運(yùn)行一個(gè)數(shù)學(xué)公式，最后怎么返回。7. python - flask學(xué)習(xí)，user_syy添加報(bào)role is invalid keyword for User.8. 這是什么情況？？？9. css3 - less或者scss 顏色計(jì)算的知識應(yīng)該怎么學(xué)?或者在哪里學(xué)?10. javascript - 有沒有類似高鐵管家的時(shí)間選擇插件
網(wǎng)公網(wǎng)安備