OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to pass parameters to Jaybird, the Firebird JDBC driver

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
spence
Newbie
Newbie


Joined: 30 Aug 2007
Posts: 3

PostPosted: Fri Aug 31, 2007 9:56 am    Post subject: How to pass parameters to Jaybird, the Firebird JDBC driver Reply with quote

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.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Sep 01, 2007 1:31 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group