Subject | Several novice type questions re Jaybird and Debian |
---|---|
Author | Peter Welch |
Post date | 2007-04-02T16:39:39Z |
Preface
I am trying to setup a JDBC connection to a Firebird 2.1 alpha
database on Debian amd64 using Jaybird 2.1.1. I have installed JDK
1.5, placed the libjaybird21.so in the /usr/sbin/ directory, have
Firebird up and running (verified via Flamerobin). The goal for using
Jaybird is to allow inserts into a database via a stored procedure.
The inserting application is an interface engine and has a hook to
allow connection/SQL to any RDBMS via an XML file that references a
JDBC datasource.
Questions:
1) What more do I need to do on the Linux side to make sure that
Jaybird is up and running?
2) How do I structure the stored procedure call statement in the XML
file -- that is, what is the syntax for calling a Firebird stored
procedure with input and output parameters in XML?
3) Are there any simple test programs, either windows or linux, to
test the JDBC driver and perhaps the XML calling file?
Pete
I am trying to setup a JDBC connection to a Firebird 2.1 alpha
database on Debian amd64 using Jaybird 2.1.1. I have installed JDK
1.5, placed the libjaybird21.so in the /usr/sbin/ directory, have
Firebird up and running (verified via Flamerobin). The goal for using
Jaybird is to allow inserts into a database via a stored procedure.
The inserting application is an interface engine and has a hook to
allow connection/SQL to any RDBMS via an XML file that references a
JDBC datasource.
Questions:
1) What more do I need to do on the Linux side to make sure that
Jaybird is up and running?
2) How do I structure the stored procedure call statement in the XML
file -- that is, what is the syntax for calling a Firebird stored
procedure with input and output parameters in XML?
3) Are there any simple test programs, either windows or linux, to
test the JDBC driver and perhaps the XML calling file?
Pete