在monkeyrunner / jython中找不到JDBC驱动程序错误 [英] JDBC driver not found error in monkeyrunner/jython

问题描述

我需要在 DB 中插入一些东西。 im使用 JDBC 作为连接器，jython脚本， mysql 数据库和脚本运行在 CentOS 中。

我的代码看起来像这样：

从 com.android.monkeyrunner导入MonkeyRunner，MonkeyDevice，MonkeyImage

从 com.ziclix.python.sql import zxJDBC

  db = zxJDBC.connect（jdbc：mysql：//XXX.XXX.XXX。 XXX：3306 / dbname，USER，PASSWORD，org.gjt.mm.mysql.Driver）
  

c = db.cursor（）c.execute（INSERT INTO tablename values（'X'，'X'，'X'） ）

$ b < connector / j /rel =nofollow>此处（在桌面上）

我通过执行此操作将路径添加到classpath

  export PATH = / home / XX / Desktop / mysql-connector-java-5.1.22 
  / pre> 
 
 
当我运行脚本时，它给我这个错误
 
 
  zxJDBC.DatabaseError.driver [org.gjt.mm.mysql.Driver] 未找到
 
 
我做错了什么？是驱动程序名称的正确吗？因为我只是把它复制在我看过的教程之一。或者我可能正确安装了驱动程序？
 
 
 
谢谢。
解决方案
这是我设法解决错误：
 
 
 
下载JDBC驱动程序此处 
 
 
 
 
将tar.gz文件解压缩到任何位置
 
 
 
 
您会在该文件夹中找到mysql-connector-java-5.1.22-bin.jar。复制并粘贴到（在我的情况下）/％android-sdk％/ tools / lib 
  
 
添加mysql-connector-java-5.1 .22-bin.jar到classpath 
 
 
  
  b 
 
 
 
从com.android.monkeyrunner导入MonkeyRunner，MonkeyDevice，
 MonkeyImage 
 
 
 
来自com.ziclix .python.sql import zxJDBC 
 
 
 
 db = zxJDBC.connect（jdbc：mysql：//XXX.XXX.XXX.XXX：3306 / dbname，USER ，PASSWORD，com.mysql.jdbc.Driver）
 
 
 
 c = db.cursor（）
 
 
 
 c.execute（INSERT INTO tablename values（'X'，'X'，'X'））
 
 
 
 db.commit 
 
希望这有助于那些将来需要它的人。 ：）
 
I need to Insert something in the DB. im using JDBC as a connector, jython the script, mysql the DB and the script is running in CentOS. 

my code looks something like this:

  
from com.android.monkeyrunner import MonkeyRunner, MonkeyDevice, MonkeyImage 
  
  
from com.ziclix.python.sql import zxJDBC
  db=zxJDBC.connect("jdbc:mysql://XXX.XXX.XXX.XXX:3306/dbname","USER","PASSWORD","org.gjt.mm.mysql.Driver")

c=db.cursor() c.execute("INSERT INTO tablename values ('X','X','X')")

before that, I downloaded and decompressed the file from here (in the desktop)

I added the path to classpath by doing this
 export PATH=/home/XX/Desktop/mysql-connector-java-5.1.22
and when I ran the script, it gave me this error 

  
zxJDBC.DatabaseError.driver [org.gjt.mm.mysql.Driver] not found
what have I done wrong? is the name of the driver name correct? because I just copied it in one of the tutorials that I've seen. or probably did I install the driver correctly?

Thanks.
解决方案
this is how I managed to solve the error:

Download the JDBC driver here 
Extract the tar.gz file anywhere you want.
You will find mysql-connector-java-5.1.22-bin.jar inside that folder. Copy that and paste to (in my case) /%android-sdk%/tools/lib
Add the new location of mysql-connector-java-5.1.22-bin.jar to classpath
do the script like this



  
from com.android.monkeyrunner import MonkeyRunner, MonkeyDevice,
  MonkeyImage
  
  
from com.ziclix.python.sql import zxJDBC
  
  
db=zxJDBC.connect("jdbc:mysql://XXX.XXX.XXX.XXX:3306/dbname","USER","PASSWORD","com.mysql.jdbc.Driver")
  
  
c=db.cursor() 
  
  
c.execute("INSERT INTO tablename values ('X','X','X')")
  
  
db.commit()
Hope this helps to those who will need it in the future. :)

                        
这篇关于在monkeyrunner / jython中找不到JDBC驱动程序错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！