Re: Java drivers

Hi Doug,

The best answer would be to determine the parameters needed so all programs could use the same driver.  As to using both, Java loads from the classpath, so you could put the drivers in different locations and add each to the specific classpath for the programs running. We probably can't give you any more info without a lot of digging unless someone here is in the same situation. 

However, you might post the MYSQL driver version and ask anyone running that for parameters.  HTH,



                                                    Joe Sam

Joe Sam Shirah -        www.conceptgo.com  (904) 302-6870
conceptGO       -         Consulting/Development/Outsourcing
Java Filter Forum:       www.ibm.com/developerworks/java
Just the JDBC FAQs:  www.jguru.com/faq/JDBC
Going International?   www.jguru.com/faq/I18N
Que Java400?            www.jguru.com/faq/Java400



On Monday, April 4, 2022, 09:36:34 AM EDT, DOUGLAS ENGLANDER via JAVA400-L <java400-l@xxxxxxxxxxxxxxxxxx> wrote:

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."