Java drivers

I am new to java. I have a need to use java to communicate with a remote 
server that hosts a MYSQL database.

There are existing Java programs that communicate with this server fine 
and have been working for years.

I need to have an RPG program connect to the MYSQL database also. I 
downloaded Scott Klement's JDBC4R and incorporated that into my RPG 
program, and it works fine. However, this solution has a different driver 
[i.e. newer] for MYSQL than the existing Java programs use. When I user 
the newer driver, the RPG program works fine but the existing Java 
programs do not connect, and it appears from the error message they do not 
have the correct parameters for the new driver. Then, when I delete the 
new driver, the old programs work again, but the new RPG program does not.

Isn't there a way to have both drivers loaded and each application uses 
the one it needs?

We are on V7R3 is IBM i

I am also posting this on the RPG list since I am not sure which one it 
would belong to.

Thank you,

Doug



"CONFIDENTIALITY NOTICE:  This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender.  The information is intended only for the use of the intended recipient.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited.  Any unauthorized interception of this transmission is illegal under the law.  If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
-- 
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com