> > And then declare "Firebird" in my config, using the JCA-JDBC driver.
>
> Would this be right?
>
> <jdbc-connection-descriptor
> jcd-alias="default"
> default-connection="true"
> platform="Default"
> jdbc-level="2.0"
> driver="org.firebirdsql.jdbc.FBDriver"
> protocol="jdbc"
> dbalias="/path/to/database/test.gdb"
> username="sysdba"
> password="masterkey"
> batch-mode="false"
> >
Pretty much, yes. We actually set jdbc-level to 1.0 (see below). Is it a
good idea for us to change that?
<jdbc-connection-descriptor
platform = "Firebird"
jdbc-level = "1.0"
driver = "org.firebirdsql.jdbc.FBDriver"
protocol = "jdbc"
subprotocol = "firebirdsql"
dbalias =
"localhost/3050:D:\\workspace\\voicerunner\\development\\db\\VR.GDB"
username = "SYSDBA"
password = "masterkey"
/>
>
>
> > The app is fairly straightforward and uses no complex
> queries, so it may be
> > that more work is needed for full compatibility. Certainly
> for inserts and
> > simple queries (I think including some simple 1-1
> relationships) everything
> > worked just fine.
>
> Which method did you use for primary keys (I would like to
> use firebird
> generators).
No, we generated our own IDs (a session id). I guess you'll need to extend
OJB a little to use Firebird generators?
>
> > Firebird is an excellent database: ...
>
> Yep, been using it for 4 years (well Interbase first). Like it lots.
Ah! :-)
I came across it only a few months ago... seems little known... deserves
much better.
>
> Dave
> --
> David Warnock, Sundayta Ltd. http://www.sundayta.com
> iDocSys for Document Management. VisibleResults for Fundraising.
> Development and Hosting of Web Applications and Sites.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
