powerbuilder 12.5 & JDBC connection

[Former Member]

hello there,

we recently shifted to powerbuilder 12.5 just to check if our application can run cooorectly under its platform (we used PB9.0).

in our application we connect to the database using JDBC driver, and we run the application from an external batch file. however we get the error "powerbuilder JDBC internal error" whenever we want to connect to the database in the code, but sometimes from the db profile we can connect normally..

so how can we connect using jdbc in the code?

[Former Member]

I recently changed two PB12.5 apps from ODBC to JDBC connection. Below are the 2 powerscript code changes that I changed to do this. Let me know if this is helpful.

//SQLCA.DBMS = "ODBC"

became

SQLCA.DBMS = "JDBC"

and

//SQLCA.dbparm = "ConnectString='DSN=" + ls_server + ";UID=" + trim(sle_userid.text) + &
                 ";PWD=" + string(ls_dbpassword)  + "'"

became

SQLCA.dbparm = "URL='jdbc:sqlanywhere:DBN=" + ls_server + ";UID=" + trim(sle_userid.text) + ";PWD=" + string(ls_dbpassword)  +  ";ServerName=test_sqlanywhere12;ASTART=NO;Host=dhhbgbfhsql101:2638',Driver='sybase.jdbc4.sqlanywhere.IDriver'"

[Former Member]

thats exactly what am using...i think am missing a dll or a jar file in this application, since i already created a test application with the same code and it connected fine

[chris_keating]

A missing class is not likely the cause of the error that you are seeing. Since it is an internal error, I think it would be best to raise this question in a forum (or via a technical support case) focused on PowerBuilder.

[Former Member]

thnks Chris maybe ur right, I traced the issue using JDBC Driver Manager Trace and got this error: (4.701 MS / 4.701 MS) (6d465b4): ERROR 999 (rc -1) : PowerBuilder JDBC Internal Error (6d465b4): SHUTDOWN DATABASE INTERFACE:(DBI_SHUTDOWN_INTERFACE) (0.005 MS / 4.706 MS)