| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Password issue when calling database from JCN node |
« View previous topic :: View next topic » |
| Author |
Message
|
| Bartez75 |
 Posted: Mon Jun 22, 2009 4:56 am Post subject: Password issue when calling database from JCN node |
 |
|
Voyager
Joined: 26 Oct 2006
Posts: 80
Location: Poland, Wroclaw
|
Hi
When I connect to oracle database from compute node I just specify data source name in compute node and then I can connect to database. Data Source is created on server. So I don't care about user and password.
I'm doing it right now from JCN node with jdbc.
Password for connection is fixed in the code.
It could be defined in the UserDefinedProperties and configured on the bar file level but it will be still visible for those who has access to source. So it is not that good for production server.
I don't know that much about java databases connection.
Do you know a way to call datasource from JCN node like it is in Compute node? Or, a why to store a password on server so it can be easily reached from JCN node?
I guess I can read from file from server.
Please just point me in the right direction and I will investigate it. |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon Jun 22, 2009 5:21 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| If you are using 6.1, you can associate a JDBC datasource with a security profile. |
|
| Back to top |
|
|
| Bartez75 |
| Posted: Mon Jun 22, 2009 6:39 am Post subject: |
|
|
Voyager
Joined: 26 Oct 2006
Posts: 80
Location: Poland, Wroclaw
|
| Sorry, I haven't mentioned. I'm using broker 6.0. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Jun 22, 2009 6:44 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Then upgrade to 6.1.
Then you can create a JDBC datasource and use that from your JCN and associate a security profile with a secure password with it.
Otherwise you have to jump through a bunch of hoops and do it all manually. |
|
| Back to top |
|
|
| ovasquez |
| Posted: Mon Jun 22, 2009 9:59 pm Post subject: |
|
|
Centurion
Joined: 09 Dec 2005
Posts: 141
Location: Lima, Peru
|
No problem, encrypt password, can you use AES algorith for example.
_________________
Oscar Vásquez Flores |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
