xquery sql module init driver
Wednesday, 14 November 2012 · 3 messages · last reply 15 Nov 2012
JK
Jarosław Kowalewski14 Nov 2012 13:16 #
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.jarThanks for a help
Jarek
AM
Antoni Mylka14 Nov 2012 15:55 #
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-command-line
"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 -----
Quoted text · Jarosław Kowalewski · 14 lines
Von: "Jarosław Kowalewski" <jaroslaw.kowalewski at students.waw.pl> An: basex-talk at 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
JK
Jarosław Kowalewski15 Nov 2012 11:22 #
Thanks a lot. That works!:)
Mayby it's a good idea to write about that in manual or FAQ?
Jarek
2012/11/15 <basex-talk-request at mailman.uni-konstanz.de>:
Quoted text · Antoni Mylka · 52 lines
> Message: 4 > Date: Wed, 14 Nov 2012 15:55:34 +0100 (CET) > From: Antoni Mylka <amy at basis06.ch> > To: basex-talk <basex-talk at mailman.uni-konstanz.de> > Subject: Re: [basex-talk] xquery sql module init driver > Message-ID: <701444465.74583.1352904934339.JavaMail.root at basis06.ch> > Content-Type: text/plain; charset=utf-8 > > 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-command-line > > "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 at students.waw.pl> > An: basex-talk at 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 >
Written for BaseX 7.3. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery