java - How to connect to Firebird using LibreOffice -
java - How to connect to Firebird using LibreOffice -
i have create reports using libreoffice. need connecto firebird database using jdbc. installed driver (adding classpath) , configured connection use
class="lang-none prettyprint-override">firebirdsql://server:alias org.firebirdsql.jdbc.fbdriver
when test class error:
class="lang-none prettyprint-override">"could not load driver class org.firebirdsql.jdbc.fbdriver" javax/resource/resourceexception
i tried in machine , got same message. there should added classpath? i´m missing here? have both jre , jdk installed , i´m using first located in c:\program files(x86)\java\jre7. there no classpath environment variable defined nor global or user
jaybird has required dependency on jca (java connector architecture), jca 1.5 (although newer should work well), documented in jaybird 2.2.5 releasenotes,
this means need include either connector-api-1.5.jar
(from lib
folder) on classpath, or need utilize jaybird-full-2.2.5.jar
includes classes connector-api-1.5.jar
.
also url wrong on 2 things: format of url
jdbc:firebirdsql[:<subprotocol>]://<host>[:<port>]/<path-or-alias>
which mean :alias
wrong (it should /alias
). , remarked gord thompson in comments, need utilize subprotocol oo
, need utilize protocol prefix jdbc:firebirdsql:oo
address difference in interpretation on jdbc, documented here. url should like:
jdbc:firebirdsql:oo://server/alias
java jdbc firebird libreoffice
Comments
Post a Comment