- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
RSA VIA L&G 7.0 - No suitable driver found for jdbc:jdbc:postgresql error with PostgreSQL database collectors with RSA Identity Management and Governance
Got an error - No suitable driver found for jdbc:jdbc:postgresql error with PostgreSQL database collectors with RSA Identity Management and Governance with version 7.0
- Tags:
- Access Compliance Manager
- ACM
- Community Thread
- Discussion
- Forum Thread
- Identity G&L
- Identity Governance & Lifecycle
- IG&L
- IGL
- no suitable driver
- postgres
- postgresql
- RSA Identity
- RSA Identity G&L
- RSA Identity Governance & Lifecycle
- RSA Identity Governance and Lifecycle
- RSA IGL
- Version 7.0
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Following Steps worked :-
Download the driver http://jdbc.postgresql.org/download.html
Copy postgrestsql-9.4-1201.jdbc41.jar to IMG Server
cd /home/oracle/deploy
Ran ./customizeACM.sh -c
cp /tmp/postgresql-9.4-1201.jdbc41.jar /tmp/customizeACM/aveksa.war/WEB-INF/LocalAgent/common/lib/
chown oracle:oinstall postgresql-9.4-1201.jdbc4.jar
./customizeACM.sh –d
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Following Steps worked :-
Download the driver http://jdbc.postgresql.org/download.html
Copy postgrestsql-9.4-1201.jdbc41.jar to IMG Server
cd /home/oracle/deploy
Ran ./customizeACM.sh -c
cp /tmp/postgresql-9.4-1201.jdbc41.jar /tmp/customizeACM/aveksa.war/WEB-INF/LocalAgent/common/lib/
chown oracle:oinstall postgresql-9.4-1201.jdbc4.jar
./customizeACM.sh –d
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Pooja,
I was trying to achieve the same feature in 7.0.1. Tried above steps but still getting the error.
Any suggestion, if something else can be verified.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hey Subash,
After you do the customizeACM.sh -d, you should also restart the services:
acm stop
acm start
Then also make sure you remove the redundant jdbc: in the beginning of the connection string. Check KB 000032018.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Did that Mostafa but no help. Can you check below machine when available, if anything missing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Subash,
Did you find solution to your problem? I am facing the same error as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Gunpreet,
The steps mentioned by Pooja did work for me.
Below are the few details we need to be careful about :-
1. There is an additional jdbc: in the URL. Please remove it. It should be jdbc: postgresql://host:port/database
2. Please make sure correct host, port and sid value supplied in above url. If you try the "Test Connection " button without entering correct host or port , it gives the generic error that driver can't be found.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Thanks Pooja.
I did work for me on Aveksa 7.0.1 using WildFly.
Any idea on how to get this done on the 6.8.1 version, usign JBoss? I believe it should be a matter of copying the jar file to a specific location
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
It's fine, i got this right.
It's a matter of copying the jar file in this location and restart the server right after
/home/oracle/jboss-4.2.2.GA/server/default/deploy/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/common/lib/
Thanks for your help
