Forum Discussion

Debz's avatar
Debz
Contributor
7 years ago
Solved

Is there a way to define a DB role when creating a JDBC connection?

Hi,   We normally connect to our DB with a SysDBA role using SQL Developer. but when I try to set a JDBC connection, it seems that there is no Role field in there. Using the default login gives ...
  • Debz's avatar
    Debz
    7 years ago

    Hi, sorry I forgot to update this. In previous versions, you get a notification that a SYSDBA or SYSOPER role is required. On Ready!API 2.0, the error message you'll see is the one in the image above. I've asked my coworkers here who worked with JDBC steps and it seems that the role is auto-detect, so there is no more need to specify one in the connection string. The issue got fixed after I asked a guy in charge of the DBs to have an account with the said roles set :-)

Debz's avatar
Debz
Contributor

Thanks IgorG. I tried but I wasn't able to get away with it. The error still pops up. I will just post a feature request later and file the other issue I've seen.

 

Regards,

Debz

Debz's avatar
Debz
Contributor
7 years ago

Hi, sorry I forgot to update this. In previous versions, you get a notification that a SYSDBA or SYSOPER role is required. On Ready!API 2.0, the error message you'll see is the one in the image above. I've asked my coworkers here who worked with JDBC steps and it seems that the role is auto-detect, so there is no more need to specify one in the connection string. The issue got fixed after I asked a guy in charge of the DBs to have an account with the said roles set :-)

  • groovyguy's avatar
    groovyguy
    Champion Level 1
    7 years ago

    Debz: Thanks for coming back with the solution you found!

    • Debz's avatar
      Debz
      Contributor
      7 years ago

      I got this system generated mail yesterday from the SmartBear community, telling  me that if someone already found a solution, I ought to tag it :smileyhappy: The issue just got resolved at work the other day.