I'm working in a new project to convert our Delphi + Firebird system to Java 8 / JavaFX / JPA (Hibernate) and Firebird. We are using the latest version of Jaybird and connecting to Firebird 1.5, Firebird 3.0 and InterBase XE3 databases. I have not found any documentation on connecting to the DB specifying a DB role. Is there a way to do this?
Asked
Active
Viewed 1,190 times
0
Mark Rotteveel
- 100,966
- 191
- 140
- 197
David Culbertson
- 11
- 3
-
Jaybird does not support InterBase XE3, and if it works that is by accident. – Mark Rotteveel Aug 10 '16 at 07:38
1 Answers
0
To specify the user role, you need to specify the roleName property in the connection string. See also Extended connection properties in Jaybird JDBC Driver Java Programmer's Manual.
Example of a connection string:
jdbc:firebirdsql://localhost/database?charSet=UTF-8&roleName=myrole
Mark Rotteveel
- 100,966
- 191
- 140
- 197
-
I was able to connect with:
jdbc:firebirdsql:cbcs2k8:/cw2db/test347.GDB?roleName=CWUSR; . But if I put in the charSet=UTF-8 it threw errors. Thanks for you help Mark. – David Culbertson Aug 10 '16 at 18:51 -
@DavidCulbertson What was the error? Which version of Jaybird & Firebird? – Mark Rotteveel Aug 11 '16 at 05:48
-
@DavidCulbertson Also note that the config file you use is XML, so `&` needs to be written as `&` (or you can use `;`) – Mark Rotteveel Aug 11 '16 at 11:17
-
"GDB" is obsolete extension and is not recommended starting with WinXP – Arioch 'The Aug 11 '16 at 15:32