Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

PowerBuilder Connect MySQL Using JDBC – PowerBuilder Library

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?
Subscribe
Notify of
guest
2 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Prashant
Prashant
3 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

2
0
Would love your thoughts, please comment.x
()
x