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
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
participants (2)
-
Antoni Mylka -
Jarosław Kowalewski