weixin_39701793 2017-09-06 09:46 采纳率: 0%
浏览 1807

树莓派中安装的sqlite数据库,通过jdbc连接失败

代码相同,在windows平台运行可以通过,在树莓派中可以编译但运行报错,是不是因为arm板的原因
代码如下:
import java.sql.*;
import org.sqlite.JDBC;
public class Demo
{
public static void main(String[] args) {
try
{
Class.forName("org.sqlite.JDBC");

Connection conn = DriverManager.getConnection("jdbc:sqlite:bmdb.db");

Statement stat = conn.createStatement();

//stat.executeUpdate( "create table table1(name varchar(64), age int);" );

// stat.executeUpdate( "insert into item values(1,'a',1,'a',1);" );
// stat.executeUpdate( "insert into item values(2,'b',2,'b',2);" );
// stat.executeUpdate( "insert into item values(3,'c',3,'c',3);" );

     ResultSet rs = stat.executeQuery("select * from item;");  

     while (rs.next()) { 

         System.out.print("i_name = " + rs.getString("i_name") + " ");
         System.out.println("age = " + rs.getString("i_id")); 
     }
     rs.close();
    conn.close(); 
    }
    catch( Exception e )
    {
     e.printStackTrace ( );
    }
}

}
运行结果:
java.sql.SQLException: Error opening connection
at org.sqlite.core.CoreConnection.open(CoreConnection.java:140)
at org.sqlite.core.CoreConnection.(CoreConnection.java:66)
at org.sqlite.jdbc3.JDBC3Connection.(JDBC3Connection.java:21)
at org.sqlite.jdbc4.JDBC4Connection.(JDBC4Connection.java:23)
at org.sqlite.SQLiteConnection.(SQLiteConnection.java:45)
at org.sqlite.JDBC.createConnection(JDBC.java:114)
at org.sqlite.JDBC.connect(JDBC.java:88)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at Demo.main(Demo.java:9)
Caused by: java.lang.Exception: No native library is found for os.name=Linux and os.arch=arm
at org.sqlite.SQLiteJDBCLoader.loadSQLiteNativeLibrary(SQLiteJDBCLoader.java:284)
at org.sqlite.SQLiteJDBCLoader.initialize(SQLiteJDBCLoader.java:65)
at org.sqlite.core.NativeDB.load(NativeDB.java:53)
at org.sqlite.core.CoreConnection.open(CoreConnection.java:136)
... 9 more

  • 写回答

1条回答 默认 最新

  • oyljerry 2017-09-06 13:29
    关注

    jdbc的数据库引擎在树莓派上没有。

    评论

报告相同问题?

悬赏问题

  • ¥50 永磁型步进电机PID算法
  • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
  • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
  • ¥15 如何处理复杂数据表格的除法运算
  • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
  • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
  • ¥200 uniapp长期运行卡死问题解决
  • ¥15 latex怎么处理论文引理引用参考文献
  • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
  • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?