首页 文章

在PyCharm的数据源无法连接到sqlite3数据库

提问于
浏览
0

在我的Windows 7机器上的PyCharm(2.0 Beta 2)中,但是我无法加载sqlite3数据库的内容和架构 .

我下载了两个sqlite驱动程序的目录:来自Zentus的sqlitejdbc-v056.jar,以及安全方面来自Xerial sqlitejdbc-3.7.2的安全端 .

  • JDBC驱动程序类设置为org.sqlite.JDBC

  • 数据库URL设置为:jbdc:sqlite:c:/Users/Myself/path/to/db.db

  • 没有用户名或密码 .

当我点击“测试连接”时,一切都很顺利,“连接成功”,当我点击“刷新模式”时,它会显示“0表可用” .

我想错误是:从磁盘或URL加载JDBC驱动程序,但两者都可以通过“连接成功”语句来缓解 .

数据库是可加载的,并且在我的Mozilla Firefox SQLite Manager扩展中包含内容 .

idea.log输出:

Zentus

2011-12-07 14:06:14,367 [ 783461]   INFO - ution.rmi.RemoteProcessSupport - "c:\program files (x86)\jetbrains\pycharm 111.33\jre\jre\bin\java" -Dfile.encoding=UTF-8 -classpath "C:\Program Files (x86)\JetBrains\PyCharm 111.33\plugins\DatabaseSupport\lib\jdbc-console.jar;C:\Program Files (x86)\JetBrains\PyCharm 111.33\lib\util.jar;C:\Program Files (x86)\JetBrains\PyCharm 111.33\lib\annotations.jar;C:\SENSORED\shared-development\jdbc-drivers-pycharm\sqlitejdbc-v056.jar" com.intellij.persistence.database.console.RemoteJdbcServer org.sqlite.JDBC 
2011-12-07 14:06:14,537 [ 783631]   INFO - ution.rmi.RemoteProcessSupport - Port/ID:8205/RemoteDriverImplfd8de8cc 
2011-12-07 14:06:14,720 [ 783814]   INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 1 `

Xerial

2011-12-07 14:02:19,768 [ 548862]   INFO - ution.rmi.RemoteProcessSupport - "c:\program files (x86)\jetbrains\pycharm 111.33\jre\jre\bin\java" -Dfile.encoding=UTF-8 -classpath "C:\Program Files (x86)\JetBrains\PyCharm 111.33\plugins\DatabaseSupport\lib\jdbc-console.jar;C:\Program Files (x86)\JetBrains\PyCharm 111.33\lib\util.jar;C:\Program Files (x86)\JetBrains\PyCharm 111.33\lib\annotations.jar;C:\SENSORED\shared-development\jdbc-drivers-pycharm\sqlite-jdbc-3.7.2.jar" com.intellij.persistence.database.console.RemoteJdbcServer org.sqlite.JDBC 
2011-12-07 14:02:19,967 [ 549061]   INFO - ution.rmi.RemoteProcessSupport - Port/ID:47142/RemoteDriverImpl2975ea52 
2011-12-07 14:02:20,445 [ 549539]   INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 1 
2011-12-07 14:02:22,823 [ 551917]   INFO - ution.rmi.RemoteProcessSupport - "c:\program files (x86)\jetbrains\pycharm 111.33\jre\jre\bin\java" -Dfile.encoding=UTF-8 -classpath "C:\Program Files (x86)\JetBrains\PyCharm 111.33\plugins\DatabaseSupport\lib\jdbc-console.jar;C:\Program Files (x86)\JetBrains\PyCharm 111.33\lib\util.jar;C:\Program Files (x86)\JetBrains\PyCharm 111.33\lib\annotations.jar;C:\SENSORED\shared-development\jdbc-drivers-pycharm\sqlite-jdbc-3.7.2.jar" com.intellij.persistence.database.console.RemoteJdbcServer org.sqlite.JDBC 
2011-12-07 14:02:23,006 [ 552100]   INFO - ution.rmi.RemoteProcessSupport - Port/ID:37172/RemoteDriverImpl304666a8 
2011-12-07 14:02:23,305 [ 552399]   INFO - ution.rmi.RemoteProcessSupport - Process finished with exit code 1`

1 回答

  • 2

    它实际上是测试中的known bug已经修复 . 该修复程序应该在下一个版本中可用(报告了SQL Server的链接错误,但该问题也影响了SQLite) .

相关问题