How to pass parameters to Jaybird, the Firebird JDBC driver

[spence]

I'm trying to define a datasource that refers to Jaybird, the Firebird JDBC driver, using the Address Source wizard. I need to pass values for the userName, password and roleName (all specific to Jaybird). I tried adding them on to the end of the Datasource URL like this:

jdbc:firebirdsql:somenode:somedb?userName=MAILLIST?password=pass?roleName=ML1

but this doesn't have any effect one way or the other, because I still have to provide a username and password in the user authentication field. Also, I can tell the roleName is not being sent, because if I go ahead and fill in the user authentication stuff, the connection succeeds but nothing can be viewed because the user isn't authorized to do so without specifying the role.

How can I get this to work?

Michael D. Spence
Mockingbird Data Systems, Inc.

[Villeroy]

jdbc:firebirdsql:somenode:somedb?userName=MAILLIST?password=pass?roleName=ML1
seems to be an invalid url. The "?" starts a list of arguments. The susequent arguments are separated by "&". See the url in your current browser window.
jdbc:firebirdsql:somenode:somedb?userName=MAILLIST&password=pass&roleName=ML1
Not shure about the subsequent colons.