search

KyleChaplin / Payroll-System

0 stars 0 forks source link

Unable to connect to database #3

Closed KyleChaplin closed 8 months ago

KyleChaplin commented 8 months ago

I was receiving errors - IO Error: The Network Adapter could not establish the connection

Fix for me - https://appuals.com/how-to-fix-io-error-the-network-adapter-could-not-establish-the-connection-on-oracle-sql/

KyleChaplin commented 8 months ago

Connection can't be made in java app - No suitable driver found for jdbc:oracle:thin:@localhost:1521:ORCL

KyleChaplin commented 8 months ago

Needed to add dependency to maven pom.xml

`

com.oracle.database.jdbc 
  <artifactId>ojdbc11-production</artifactId>
  <version>23.3.0.23.09</version>
  <type>pom</type>
</dependency>`
KyleChaplin commented 8 months ago

No listener error

Open cmd in admin - lsnrctl start