java - IDEA tomcat連接數(shù)據(jù)庫(kù)出現(xiàn)問(wèn)題？
問(wèn)題描述
Javaweb新手,配置jndi后連接數(shù)據(jù)后總出現(xiàn)異常報(bào)錯(cuò)出現(xiàn)在 myConn = ds.getConnection();
修改my.ini后還是會(huì)出現(xiàn)這種問(wè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é)號(hào)查詢：<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é)號(hào)：<input type’text’ name=’sno’ />'); out.println('</form>'); out.println('<br>'); out.println('<table border=’1’>'); out.println('<tr><th>學(xué)號(hào)</th><th>姓名</th><th>語(yǔ)文</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ù)庫(kù)里沒有你要查詢得記錄');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)
問(wèn)題解答
回答1：原因:MySQL在高版本需要指明是否進(jìn)行SSL連接解決:jdbc:mysql://localhost:3306/studentinfo?characterEncoding=utf8&useSSL=true問(wèn)題:Unknown system variable ’lower_case_table_names’降低 mysql-connector-java jar版本試試
相關(guān)文章：
1. 人工智能 - python 機(jī)器學(xué)習(xí) 醫(yī)療數(shù)據(jù) 怎么學(xué)2. python - oslo_config3. 請(qǐng)教一個(gè)mysql去重取最新記錄4. python - 請(qǐng)問(wèn)這兩個(gè)地方是為什么呢？5. Python處理Dict生成json6. 急急急！！！求大神解答網(wǎng)站評(píng)論問(wèn)題，有大神幫幫小弟嗎7. javascript - 按鈕鏈接到另一個(gè)網(wǎng)址 怎么通過(guò)百度統(tǒng)計(jì)計(jì)算按鈕的點(diǎn)擊數(shù)量8. python2.7 - python 正則前瞻 后瞻 無(wú)法匹配到正確的內(nèi)容9. 大家都用什么工具管理mysql數(shù)據(jù)庫(kù)？10. mysql - Sql union 操作
網(wǎng)公網(wǎng)安備