Re: [basex-talk] xquery sql module init driver

Hi Jarek,

And what about

java -cp pathto/mysql-connector-java-5.1.21-bin.jar:BaseX73.jar org.basex.BaseXGUI

?

quoting from:

http://stackoverflow.com/questions/945962/java-problem-running-a-jar-file-in...

"If you're running a jar file with java -jar, the -classpath argument is ignored."

-- Antoni Myłka Software Engineer

basis06 AG, Birkenweg 61, CH-3013 Bern - Fon +41 31 311 32 22 http://www.basis06.ch - source of smart business

----- Ursprüngliche Mail ----- Von: "Jarosław Kowalewski" jaroslaw.kowalewski@students.waw.pl An: basex-talk@mailman.uni-konstanz.de Gesendet: Mittwoch, 14. November 2012 13:16:37 Betreff: [basex-talk] xquery sql module init driver

Hi, I try to connect with my database directly by sql module.

sql:init("com.mysql.jdbc.Driver"),

let $conn := sql:connect("jdbc:mysql://dbhost:port/dbname") return sql:execute($conn, "SELECT * FROM coffees WHERE price < 10")

but I've problem with and I get error "[BXSQ0007] Could not initialize specified driver: 'com.mysql.jdbc.Driver'"

java -cp pathto/mysql-connector-java-5.1.21-bin.jar -jar BaseX73.jar

Thanks for a help

Jarek