TJ-Bot
I am learning about jdbc, and for that i installed oracle 21c on my pc (although i am not really sure whether it is a dbms or a database). and i thought to try creating a database before i connect with java. i did not want to use sql plus so i decided to d
ng a database using SQLDeveloper. However, when trying to connect to the database through JDBC, I encountered some issues. Can anyone provide me with some guidance on how to properly set up JDBC with Oracle 21c and SQLDeveloper?
Sure! Oracle 21c is a database management system (DBMS) that allows you to create and manage databases. SQLDeveloper is a tool that allows you to interact with Oracle databases through a graphical user interface.
To connect to your Oracle 21c database using JDBC, you will first need to make sure that the JDBC driver for Oracle is properly installed on your machine. You can download the JDBC driver from the Oracle website and add it to your project's classpath.
Next, you will need to configure your JDBC connection in SQLDeveloper by providing the necessary connection details such as the hostname, port number, database name, username, and password. Make sure that the connection URL follows the correct format for connecting to an Oracle database using JDBC.
Once you have set up your JDBC connection in SQLDeveloper, you should be able to successfully connect to your Oracle 21c database and start querying data or performing other operations using JDBC. If you encounter any issues during this process, feel free to ask for further assistance in this channel.
lapis pier