Connecting to different Database from MAXIMO .

[c.madhav]

Hi All

I am working on Integration, i have to collect data from different DBs other than MAXIMO DB.From DBManger.getConnection() will always connects to MAXIMO DB.

How can i connect to different DB, without writing any standalone java class like (DriverManager.getConnection(),Class.forName() stuff), I feel this is not most efficient way.

So is there any way in MAXIMO where we can getConnection by supplying DB URL ,username and Password..to connect which ever db we want to connet.

Thanks Inadvance

[maurogrz]

A few time ago I made some classes that write data in an "external" SQL server database (my installation was on Oracle).
I developed an "utility" class to connect and execute statements on the DB and then I use it in my classes.
The configuration (user/pwd/DB) are stored on the properties function.,

if you need some suggestion, let me know and I will share some code....
Mauro

• PM Estimated Due Date whe... by canislupus [May 21, 2012, 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [May 21, 2012, 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [May 21, 2012, 12:26:23 pm]
• add user access by Sarbjeet.Jassal [May 21, 2012, 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [May 21, 2012, 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]
• Enabling Attachment on CL... by G Jeevan [May 11, 2012, 12:24:33 pm]