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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
String ls_path, ls_classpath Boolean lb_jvm_started, lb_debug javavm ljvm ls_path = GetCurrentDirectory ( ) // set classpath or you can environment variables of window ls_classpath = ls_path + "\mysql-connector-java-8.0.22.jar" If Not FileExists(ls_classpath) Then MessageBox('Warning',"driver class file not exists") Return End If If Not lb_jvm_started Then ljvm = Create javavm //using pbejbclientXXX.pbd Choose Case ljvm.createJavaVM(ls_classpath, lb_debug) Case 0 lb_jvm_started = True Case -1 MessageBox('Warning',"Failed to load JavaVM") Return Case -2 MessageBox('Warning',"Failed to load EJBLocator") Return End Choose End If // get infor String ls_url, ls_database, ls_servername, ls_port, ls_user, ls_pass ls_user = "user" ls_pass = "password" ls_database = "database" ls_servername = "servername.com" ls_port = "port" ls_url = "jdbc:mysql://"+ls_servername+":"+ls_port+"/" + ls_database //connect Transaction ltran_conn ltran_conn = Create Transaction ltran_conn.DBMS = "JDBC" ltran_conn.LogPass = ls_pass ltran_conn.LogID = ls_user ltran_conn.AutoCommit = False ltran_conn.DBParm = "Driver='com.mysql.jdbc.Driver',URL='"+ls_url+"'" Connect Using ltran_conn ; If ltran_conn.SQLCode = -1 Then MessageBox('Warning','Connect Database Error' + ltran_conn.SQLErrText) Else MessageBox('Warning',"Connect Success!") End If Disconnect Using ltran_conn ; |
Find Projects On Github click here
Good Luck!
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
– Change java version 1.8. and add mysql-connector-java-8.0.22.jar to Powerbuilder/Tools/System Option/Java Classpath for run on powerbuilder. mysql-connector-java-8.0.22.jar need JRE versions: Connector/J 8.0 supports JRE 8 or higher. https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-versions.html
– Run on build copy jre of java to folder build of PB
p/s: change java version need PB run as admintrator and restart PB