Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Enabling SQL Developer with Sybase Jar (jtdc.jar) for PSM Connections to all users

L4 Transporter

I have SQL developer used by the Oracle team via PSM with no issues. I am on-boarding Sybase team as well and they also want to use SQL Developer. There's jtdc.jar file which I have add in the SQL Developer Preferences to enable the sybase tab for connections to Sybase databases. But after adding the jar file, the Sybase tab is only visible to me. No other user including PSM Shadow users are able to see that tab.

Has anyone faced this issue before?

1 accepted solution

Accepted Solutions

L4 Transporter

Ok, it turned out that if you're doing any changes in the configuration in SQL developer, it will save it for that particular user only in the

C:\Users\<userid>\AppData\Roaming\SQL Developer so that's why the Sybase tab was not visible to all the users.

 

after identifying the above, I was able to tweak my AutoIt code, to copy the required configuration to the PSMShadowUser profile when connecting for the first time and it worked.

View solution in original post

15 REPLIES 15

L4 Transporter

Could you check the file access permission of jtdc.jar?

Permissions are okay. Its not just the PSM Shadow Users , but other users who have same privileges as mine, are not able to see the Sybase tab, unless they add the jtdc.jar file in their session which is very strange to me.

L4 Transporter

Ok, it turned out that if you're doing any changes in the configuration in SQL developer, it will save it for that particular user only in the

C:\Users\<userid>\AppData\Roaming\SQL Developer so that's why the Sybase tab was not visible to all the users.

 

after identifying the above, I was able to tweak my AutoIt code, to copy the required configuration to the PSMShadowUser profile when connecting for the first time and it worked.

Hello @Ratul Gandhi​ 

when I launch my connect for the PSM-Oracle Developer it does not populate credentials but give me this:

 

"NO TNS entries found in ….TNS_ADMIN=c:\oracle\instantclient…"

 

And I have to manually connected to the db I want

Is this normal or I missing something

 

Thanks.

 

@Tesi Iloh​  In the SQL Developer tool, what "Connection Type" are you choosing?

This link might help you: https://stackoverflow.com/questions/47928570/where-to-find-tnsnames-ora-in-sql-developer

Thanks for your quick responds, I use "PSM-SQLPlus" connection.

 

Thanks

Sorry connection type is "Basic"

sorry can you please confirm - you're having issues in SQL Plus or SQL Developer?

PSM SQL Developer.

when launch connect from PVWA credential is not populating automatically

L2 Linker

And this is the version am using "sqldeveloper-19.2.1.247.2212-x64"

 

Thanks.

I think as long as you have all the information required for the connection, it should not ask you TNS file.

Are you supplying all the details in the connection prompt like - username, password, hostname, Servicename or SID?

 

And are you using the PSM plugin from the marketplace or have you developed on your own?

 

Also, when you open the SQLDeveloper from inside the PSM server do you still get the same error while connecting?

L2 Linker

I use your script, modified two or three things

 

There is no PSM Developer plugin in the market place

 

When I launch sqldeveloper.exe directly from the server same issue, which is expected

 

Thanks

I guess you should check with your Database team about the error.

L2 Linker

Thanks but I was curious to see what fix your own.

 

I see other thread here that ran into the same problem.

 

Regards

  • 1 accepted solution
  • 744 Views
  • 15 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!