Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PowerServer and SelectBlob - Oracle

  1. How-to
0
Votes
Undo
  1. Geir Magne Vangen
    Geir Magne Vangen
  2. PowerServer
  3. Tuesday, 17 January 2023 09:57 AM UTC

Hi,

We have started looking into the possibilities on using PowerServer for our main PowerBuilder application.

The first steps to build the powerserver application has been successful.

We are using the latest Powerbuilder 2022-version, connected to Oracle using the database driver from nuget.org.

 

The application mostly runs fine, there is however a problem with SelectBlob which doesn't return the expected result.
The only thing I find in the documentation about this is for ASE;  Text size option in the ODBC driver is 32KB by default.

Is there a similar limit for this oracle driver?

Hope you can help me out here.

 

Best regards,

Geir Vangen

  1. Oracle
  2. PowerServer
Getting an Error while running the powerserver pro...
Client acces from remote deploy
Responses (2)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 17 January 2023 12:00 PM UTC
  2. PowerServer
  3. # 1

Hi,

Not sure, but maybe this is the problem? https://docs.appeon.com/ps2022/SelectBlob_UpdateBlob_supports_UTF8_only.html 

regards.

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 17 January 2023 12:02 PM UTC
What happens if you try to use a normal SELECT instead of SELECTBLOB? (only if that statement is running on your powerserver).
  1. Helpful
Geir Magne Vangen
  1. Geir Magne Vangen
  2. Wednesday, 8 February 2023 07:34 AM UTC
Thanks Miguel,

I have finally found time to test this. The example in https://docs.appeon.com/ps2022/SelectBlob_UpdateBlob_supports_UTF8_only.html seem to solve the problem. Updating and selecting data now gives the same result both in the client and on PowerServer for Oracle clobs.
  1. Helpful 1
There are no comments made yet.
Geir Magne Vangen
Geir Magne Vangen Accepted Answer Pending Moderation
  1. Wednesday, 18 January 2023 07:59 AM UTC
  2. PowerServer
  3. # 2

Thanks Miguel, you're probably correct. 

(Changing SELECTBLOB to SELECT gives an error - SQL sqlHandle_01_500C4977 was not found.)

 

It's the data coming from the RTE-editor we're storing in a clob.

Did now store data (with updateclob) produced by the RTE-editor using the PowerServer-app. This clob's was possible to read (with selectclob) using the PowerServer-app, but not the stand-alone client.

 

The challenge now is to make this work for both PowerServer-users and the stand-alone client at the same time.

 

Need to spend some more time on this, any suggestion is welcome...

 

Geir

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 18 January 2023 14:50 PM UTC
Have you tried storing the blob in UTF8 encoding?
  1. Helpful
Geir Magne Vangen
  1. Geir Magne Vangen
  2. Wednesday, 18 January 2023 14:53 PM UTC
aah, updateBlob and selectBlob is correct!
  1. Helpful 1
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 18 January 2023 15:25 PM UTC
You can use IsPowerServerApp() to execute certain code when in PowerServer environment and other code is client/server. This is useful when you want to have 1 set of code deploying simultaneously to both PowerServer and client/server. ~99% of code can be shared, but there is that 1% that PowerServer and client/server behave differently so this function is necessary. https://docs.appeon.com/pb2022/powerscript_reference/IsPowerServerApp_func.html
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.