java - Using IntelliJ IDEA with Oracle XE.. I dont see database or table? -
i new oracle , trying use intellij idea database browser see data , tables..
i did basic install of oracle xe on linux computer , following java code insert , return data:
try { //step1 load driver class class.forname("oracle.jdbc.driver.oracledriver"); //step2 create connection object connection con = drivermanager.getconnection( "jdbc:oracle:thin:@localhost:1521:xe", "system", "xxx"); //step3 create statement object statement stmt = con.createstatement(); //step4 execute query boolean ret = stmt.execute("insert emp values (1, \'john\', 43)"); resultset rs = stmt.executequery("select * emp"); while (rs.next()) system.out.println(rs.getint(1) + " " + rs.getstring(2) + " " + rs.getstring(3)); //step5 close connection object con.close(); but if try use intellij idea database browser dont see xe dabase or table.. using same connect data.
here see on screen

can please tell me should looking table , data.. thanks
there 1 oracle xe database per machine. within single database, you'll have number of schemas. many of schemas installed default (i.e. sys, system, etc.). if coming different database product, mysql or sql server calls "database" similar oracle calls "schema".
based on java code posted, appears created emp table in system schema. bad idea-- should never create new objects in sys or system schema. should creating new schema hold new objects want create. in intellij, appears should able go system schema find table , data inserted. but, again, shouldn't creating objects in system schema in first place.
Comments
Post a Comment