PowerBuilder Connect MySQL Using JDBC

PowerBuilder Connect MySQL Using JDBC

Step 1: Get driver JDBC MySQL mysql-connector-java–X.X.X.jar from page : https://mvnrepository.com/artifact/mysql/mysql-connector-java or https://www.mysql.com/products/connector/
Step 2: Set Class Path driver to environment variables or set class path to runtime of java
Step 3: Test Connect
Step 4: Copy jre current version of java to your pbapp runtime

PowerBuilder Connect MySQL Using JDBC
PowerBuilder Connect MySQL Using JDBC

PowerBuilder Connect MySQL Using JDBC

Find Projects On Github click here

Good Luck!

Was this article helpful?

Related Articles

0 0 votes
Article Rating
Subscribe
Notify of
guest
2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Prashant
Prashant
2 years ago

I upgrade my mysql 5.5 to Mysql 8 but now the was not able to connect to eighter JDBC nor ODBC driver I am using PowerBuilder 12.5 version JVM 1.6.0.22 I added your 8.0.22 jar file in classpath but it was showing error Faile to Load Java VM
no my JVM class path is as under
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\jdk1.6.0_24\JRE\LIB\rt.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\jdk1.6.0_24\LIB\tools.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\build\fop.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\lib\batik.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\lib\xalan-2.4.1.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\lib\xercesImpl-2.2.1.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\lib\xml-apis.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\lib\avalon-framework-cvs-20020806.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\lib\logkit-1.0.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\fop-0.20.5\lib\jimi-1.0.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\pbejbclient125.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\pbjdbc12125.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\eas-japi.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\pbuddi125.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\pbwst125.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\classes;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\easj2ee.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\commons-discovery.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\jdk1.6.0_24\lib\tools.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\commons-logging.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\dom.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\jaxp-api.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\jaxrpc.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\log4j-1.2.8.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\saaj.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\servlet.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\commons-httpclient.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\sybasewst.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\uddi4j.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\wsdl4j.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\xercesImpl-2.1.0.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\xml-apis.jar;
C:\Program Files (x86)\Sybase\Shared\PowerBuilder\WEB-INF\lib\axis.jar;
D:\tss\Bin\PowerBuilder-Connect-MySQL-main\PB10.5\mysql-connector-java-8.0.22.jar;
.
.
JDK & JRE location = C:\Program Files (x86)\Sybase\Shared\PowerBuilder\jdk1.6.0_24