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

Resolved c# model generator Oracle

  1. How-to
0
Votes
Undo
  1. frederic roggemans
    frederic roggemans
  2. SnapDevelop
  3. Tuesday, 5 November 2019 12:56 PM UTC

Hello,
i am trying to test dw conversion via c # generator.
we use Oracle as database, I can connect on a base in TCP but not in TCPS ( DB in TCP IS Oracle 11 and we can't use this verion with C# generator ).
Can you help me configure the connection profile to use TCPS. We have a central sqlnet that reference a wallet.

Thanks for your help.

 

Database connection is ok in PowerBuilder IDE and in AEM.

Generate C# Model Syntax Issue (Oracle)
ASP.Net Web API, RetrieveOne method with string ID
Responses (5)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 5 November 2019 16:32 PM UTC
  2. SnapDevelop
  3. # 1

If I'm not wrong, oracle 11 is not supported for the Datamodel stuff. It has to be version 12c?

See: https://community.appeon.com/index.php/qna/q-a/powerbuilder-2019-c-model-generator

 

Comment
There are no comments made yet.
frederic roggemans
frederic roggemans Accepted Answer Pending Moderation
  1. Tuesday, 5 November 2019 16:38 PM UTC
  2. SnapDevelop
  3. # 2

The connexion in Oracle 11 is OK but the génération is KO.

The connexion in Oracle 12 tcps ik KO.

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 5 November 2019 17:02 PM UTC
  2. SnapDevelop
  3. # 3

I once figured out how to get SSL to work with Oracle. If that's what you mean with TCPS, then here's some useful snippets from old emails:

Google on:

SQLNET.ENCRYPTION_TYPES_SERVER

 

the simplest way for communication encryption for Oracle to work:

All I had to do was add these two lines to the sqlnet.ora on the server.

SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,3DES168)
SQLNET.ENCRYPTION_SERVER = required

  • Not sure yet if AES256 is better or not than the 3key Des168 encryption. There is contradictory information on this. (Having both the server will see what's available / best on the client's OS and make a choice AES256 seems to use TLS v1.2 as seen using WireShark).
  • Not sure about which one is faster.

 

We made the initial mistake of first trying to run it our server which had Oracle 11g v. 11.2.0, so that didn't work.

The MINIMUM required version of Oracle is 11g v. 11.2.4

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 5 November 2019 17:18 PM UTC
Correct myself: it's not the same as no wallet is involved in that case.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 5 November 2019 17:12 PM UTC
  2. SnapDevelop
  3. # 4

I think this link: https://rbikblog.wordpress.com/2018/02/21/tcps-listener-configuration-for-oracle-database-12c/

might help you a lot better as I can

Sorry.

Comment
There are no comments made yet.
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 6 November 2019 07:04 AM UTC
  2. SnapDevelop
  3. # 5

Hi Frederic,

As Miguel said, the model generator supports Oracle 12C and 18C. Please report your TCPS issue through our support ticket system to ensure that our technical support has received the issue correctly and tracked at: https://www.appeon.com/standardsupport/

Regards, Logan

Comment
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.