Subject | Re: Migrating from Interclient to JayBird |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-06-24T18:32:56Z |
hi,
"org.firebirdsql.jdbc.FBDriver".
jdbc URL is "jdbc:firebirdsql://hostname/path/to/database.gdb" or
"jdbc:firebirdsql:hostname/port:/path/to/database.gdb". Latter one is
Firebird's native URL, former is InterClient-like (we have translator).
user name property is called "user", password property is "password",
character set property is "lc_ctype" (in InterClient it was "charSet")
and its value is database encoding (like "WIN1252" or "UNICODE_FSS",
not Java encodings "Cp1252" or "UTF-8" in InterClient). You can
specify properties in JDBC URL using "standard" HTTP notation with
question mark ("?"), equals sign ("=") and ampersand ("&"):
jdbc:.../database.gdb?user=sysdba&password=masterkey&lc_ctype=UNICODE_FSS
you can put into properties any DPB parameter with or without
"isc_dpb_" prefix.
there are two examples in CVS (client-java/examples), they are pretty
old, but that's translation of InterClient examples, I kept
InterClient code there, so one can compare them.
best regards,
roman rokytskyy
> Do you know what are the exactly .jars I need in this case? Is thereyou can start with firebirdsql-full.jar, driver class name is
> any link where I could find some examples?
"org.firebirdsql.jdbc.FBDriver".
jdbc URL is "jdbc:firebirdsql://hostname/path/to/database.gdb" or
"jdbc:firebirdsql:hostname/port:/path/to/database.gdb". Latter one is
Firebird's native URL, former is InterClient-like (we have translator).
user name property is called "user", password property is "password",
character set property is "lc_ctype" (in InterClient it was "charSet")
and its value is database encoding (like "WIN1252" or "UNICODE_FSS",
not Java encodings "Cp1252" or "UTF-8" in InterClient). You can
specify properties in JDBC URL using "standard" HTTP notation with
question mark ("?"), equals sign ("=") and ampersand ("&"):
jdbc:.../database.gdb?user=sysdba&password=masterkey&lc_ctype=UNICODE_FSS
you can put into properties any DPB parameter with or without
"isc_dpb_" prefix.
there are two examples in CVS (client-java/examples), they are pretty
old, but that's translation of InterClient examples, I kept
InterClient code there, so one can compare them.
best regards,
roman rokytskyy