-1

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

shreeramaute
  • 362
  • 3
  • 14
  • What are the details of the failures? Why *should* it work--you haven't shown us that these are the right credentials. – nitind Nov 10 '19 at 17:02
  • What is the error i cant see images – CompEng Nov 11 '19 at 05:15
  • i have uploaded error creating SQL "model connection" dialog box screenshot i dont have enough credits to make it visible in question post, just click on the < model connection failed > link – shreeramaute Nov 11 '19 at 13:08

1 Answers1

0

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

Community
  • 1
  • 1
shreeramaute
  • 362
  • 3
  • 14