Error creating SQL Model Connection connection to Oracle 11g database

Question

I am trying to generate entity classes from oracle 11g database tables using JPA project in STS 4 IDE

I am setting following properties for database connection

jdbcurl = "jdbc:oracle:thin:@localhost:1521:dummy"

user= dummy

password = dummy

database = dummy

I have even set sec_case_sensitive_logon=false in Oracle 11g database

properties

ping success

during entity generation in JPA tool, I am getting following error

Error creating SQL model connection

Answer 1

I was trying to connect with "generic jdbc" connection profile in which some properties were missing (database instance= servicename/sid,catalog=all/dba/user) which were available in Oracle connection profile got from DTP installed from plugin manager as follows:

Help -> install new software -> work with (spring tool suite 4) -> check following options

-database development
-data tools platform connectivity
-data tools platform enablement
-data tools platform enablement for oracle

and then followed the steps from following blogs :

Step 1 : add connection profile

Step 2 : create java classes from existing database table