[Solved] Oracle Database connectivity with java [closed]

by


Try this:

Open CMD:
1. sqlplus / as sysdba;
2. create user test identified by 123;
3. grant all privileges to test;

Here: test is the new user whose password is 123
Now when you need to login with this user
Type in CMD: Sqlplus test/123

Correction:
In URL:
url=”jdbc:oracle:thin:@localhost:1523:system”;

the last parameter should be SID

Usually the Service Id is XE
url=”jdbc:oracle:thin:@localhost:1523:XE”;

4

solved Oracle Database connectivity with java [closed]