Connect to oracle with eclipse!

I've been developing in eclipse for a long time, so I'm not used to other IDEs.

That's why it also serves as a review ...

I like Maven, but jdbc is not provided (?), So Download the jar from here and add it to the external jar. http://download.oracle.com/otn/utilities_drivers/jdbc/10205/ojdbc14.jar

Since instance generation is done during oracle installation, Check the connection string with ↓. The port is 1521.

Run from SQL command line


SELECT DBID,NAME,DB_UNIQUE_NAME,CURRENT_SCN,LOG_MODE FROM V$DATABASE

DBID NAME is the connection string.

Set this!

main


Class.forName("oracle.jdbc.driver.OracleDriver");
//Connect to Oracle8i
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "password");
//Create statement
Statement stmt = conn.createStatement();

Recommended Posts

Connect to oracle with eclipse!
Connect to DB with Java
Connect to MySQL 8 with Java
Connect to Rails server with iPhone
Connect to Amazon EC2 with SSH (Ubuntu)
I want to use DBViewer with Eclipse 2018-12! !!
How to download Oracle JDK 8 rpm with curl
[Java] Connect to MySQL
To debug in eclipse
Submit a job to AWS Batch with Java (Eclipse)
How to switch Tomcat context.xml with WTP in Eclipse
How to use Oracle JDK 9 EA with Travis CI
I started MySQL 5.7 with docker-compose and tried to connect
Ssh connect from container to git with VSCode Remote Container
How to get jdk etc from oracle with cli
Install Oracle JDK 8 with Ansible
Connect to multiple MySQL instances with SSL enabled in JDBC
Connect from Java to PostgreSQL
How to number (number) with html.erb
How to update with activerecord-import
Connect to database with spring boot + spring jpa and CRUD operation
How to use Eclipse Debug_Shell
[Android] Connect to MySQL (unfinished)
I want to connect SONY headphones WH-1000XM4 with LDAC on ubuntu 20.04! !!
I tried to build an http2 development environment with Eclipse + Tomcat
I tried connecting to Oracle Autonomous Database 21c with JDBC Thin
How to scroll horizontally with ScrollView
Operation to connect multiple Streams @Java
Dynamically switch the database to connect to
Java to learn with ramen [Part 1]
How to get started with slim
[Java] Points to note with Arrays.asList ()
How to enclose any character with "~"
Convert Markdown to HTML with flexmark-java
To display multiple lines with UILabel
mysql2 fails to install with bundle install
Introduction to algorithms with java-Shakutori method
I tried to interact with Java
Deploy to EC2 with CircleCi + Capistrano
How to use mssql-tools with alpine
Shortcuts to streamline your Eclipse work
How to connect Heroku and Sequel
Try to imitate marshmallows with MiniMagick
Build jooby development environment with Eclipse
How to get along with Rails
How to pass Oracle Java Silver
How to set Lombok in Eclipse
6 ways to define options with thor
Introducing React to Rails with react-rails
Java, arrays to start with beginners
java Eclipse How to debug javaScript
Update MySQL from 5.7 to 8.0 with Docker
Memo to get with Struts2 + Ajax
Reintroduction to Operators with RxJava Part 1
How to start Camunda with Docker
[Swift] How to connect TabBar with Storyboard Reference and also use NavigationController
Even if I connect to JMX with JConsole, it disconnects immediately (crying)