java.sql.SQLException: Unknown system variable 'language'
来源:互联网 发布:网络言论自由的利弊 编辑:程序博客网 时间:2024/05/17 01:13
报错内容:
public class DBTool{
public static void main(String[] args) throws ClassNotFoundException
{
Class.forName("com.mysql.jdbc.Driver");
try
{
Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/e491","root","root");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select bi.*,bs.Storage from bookInfo bi,BookStorage bs where bi.bId=bs.bId");
while(rs.next())
{
System.out.println(rs.getString(1)+"\t"
+rs.getString(2)+"\t"
+rs.getString(3)+"\t"
+rs.getString(4)+"\t"
+rs.getInt(5));
}
} catch (SQLException e)
{
e.printStackTrace();
}
}
今天使用jdbc连接数据库提示以上错误,上网查了问题大部分都说是jdbc驱动和mysql版本不匹配,目前我mysql版本为5.1.30,jdbc版本是5.1.40,将jdbc版本改为5.0.8,数据显示正确!!!!
0 0
- java.sql.SQLException: Unknown system variable 'language'
- java.sql.SQLException: Unknown system variable 'language'
- java.sql.SQLException: Unknown system variable 'language'
- mysql java.sql.SQLException: Unknown system variable 'language'
- mysql连接错误java.sql.SQLException: Unknown system variable 'language'
- mysql java.sql.SQLException: Unknown system variable 'language
- mysql java.sql.SQLException: Unknown system variable 'language'
- mysql java.sql.SQLException: Unknown system variable 'language
- java.sql.SQLException: Unknown system variable 'tx_read_only'
- Unknown system variable 'language'
- Unknown system variable 'language'
- mysql Unknown system variable 'language'
- Error: Unknown system variable 'language'
- Mysql连接报错:Unknown system variable 'language'
- java.sql.SQLException: Unknown server host name
- Unknown system variable 'lower_case_table_names'”
- Unknown system variable 'tx_read_only'
- Unknown system variable 'tx_read_only'
- 课程设计实训报告-1 小学生考试系统
- URLConnection发送http请求
- java Serializable和Externalizable序列化反序列化详解
- iMX283编译linux源码
- unity3d 回放机制
- java.sql.SQLException: Unknown system variable 'language'
- jQuery UI Datepicker 选择时分秒
- mybatis批量操作
- BZOJ 1391 网络流
- 最适合初学者的 IntelliJ IDEA 教程 - HelloWorld 和相关设置
- CSS3动画样式记录
- 拆分贴图的Alpha通道 --对抗ETC1的原罪
- linux知识点
- 使用Angular2及WebApi开发SPA类型的企业应用 - Part 4- 多语言