i have installed oracle 10g (both ee and xe) editions... while am installing i found port num as 1521 for ee, 1522 for xe

Ads
 

i have installed oracle 10g (both ee and xe) editions... while am installing i found port num as 1521 for ee, 1522 for xe

i have installed oracle 10g (both ee and xe) editions... while am installing i found port num as 1521 for ee, 1522 for xe.... and my program is......
import java.sql.*;
import java.io.*;
public class DBConnect{
public static void main(String ar[])throws SQLException{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("driver is registered");
Connection con=
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:xe","lms","xyz");
System.out.println(con);
System.out.println("connection is established");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("insert into emp values(3,'c')");
while(rs.next()){
int eno=rs.getInt("eno");
System.out.println(eno);
String name=rs.getString("name");
System.out.println(name); 
}
}
}...... while i run this prog.... i got error like
driver is registered
[email protected]
connection is established
Exception in thread "main" java.sql.SQLException: ORA-00942: table or view does
not exist

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1169)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
1273)
        at DBConnect.main(DBConnect.java:12)

E:\jdbcex> 
and in sql i have create user lms and, table emp(eno, name).
please tell me wts the resolution for this problem....
View Answers

Ads









Related Tutorials/Questions & Answers:
i have installed oracle 10g (both ee and xe) editions... while am installing i found port num as 1521 for ee, 1522 for xe
i have installed oracle 10g (both ee and xe) editions... while am installing i found port num as 1521 for ee, 1522 for xe  i have installed oracle 10g (both ee and xe) editions... while am installing i found port num as 1521
i need a school appication using struts frame work with oracle 10g using myeclipse6.0
i need a school appication using struts frame work with oracle 10g using myeclipse6.0   hi i need a school apllication using struts frame work backend 10g xe using myeclipse 6.0
Advertisements
hi .. need help ASAP ..i have a project buit in eclipse , i have installed jasper. i want the steps to work on it ..
hi .. need help ASAP ..i have a project buit in eclipse , i have installed jasper. i want the steps to work on it ..   hi .. need help ASAP ..i have a project buit in eclipse , i have installed jasper. i want the steps to work
prablems on oracle ee installation in windows7 ultimate(32 bit).
prablems on oracle ee installation in windows7 ultimate(32 bit).  Hai i have face several prablems when ever i m install oracle ee in my system(32 bit)windows7 ultimate.it is not installed in my system.can any body help me how
i have got error while compiling simple tag handler
i have got error while compiling simple tag handler   javac.servlet.jsp not found! tell me what are the jar files required to run simple tag handler class   The package you have used javac.servlet.jsp does not exist
Am using windows xp os..how to install wamp server for this os ?i have a trouble in this..
Am using windows xp os..how to install wamp server for this os ?i have a trouble in this..  i installed wamp server . i was put my wampserver is online.. but i cant open phpmyadmin in my browser. i dont know the reason.. pls
i have problem with classnofounderror
i have problem with classnofounderror   import java.sql.*; public... = DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:oracle", "System", "manager... student"); while(rs.next()) System.out.println
i have problem with classnofounderror
i have problem with classnofounderror   import java.sql.*; public... = DriverManager.getConnection("jdbc:oracle:thin:@localhost:8080:oracle", "System", "manager... student"); while(rs.next()) System.out.println
ModuleNotFoundError: No module named 'will-i-am'
have to install padas library. You can install will-i-am python with following...ModuleNotFoundError: No module named 'will-i-am'  Hi, My Python... 'will-i-am' How to remove the ModuleNotFoundError: No module named 'will-i
tables in oracle 10g
tables in oracle 10g  sir i have created a table in oracle 10g,i want to know where this table is stored and how can i move this table to another pc and insert values
I have crude application
I have crude application   I have crude application, how to load into this roseindia.net
:( I am not getting Problem (RMI)
I am not getting Problem (RMI)  When i am excuting RMI EXAMPLE 3,2 I am getting error daying nested exception and Connect Exception  
I have need to help
I have need to help  Write a program that, for four points A, B, C and P, draws a triangle formed by ABC and a small cross showing the position of P; and displays a line of text indicating which of the following three cases
android connection to database oracle 10g
android connection to database oracle 10g  Hello, How i can connect my android application to my oracle 10g database
oracle problem
oracle problem  Hi I have installed oracleXE on my system and for reasons i've uninstalled them and am not able to stop oracle xe services and i could'nt reinstall it. I couldnt reinstall my os for this as it is in my office
ModuleNotFoundError: No module named 'i-am-malicious'
environment you have to install padas library. You can install i-am-malicious...ModuleNotFoundError: No module named 'i-am-malicious'  Hi, My... named 'i-am-malicious' How to remove the ModuleNotFoundError: No module named
ModuleNotFoundError: No module named 'i-am-malicious'
environment you have to install padas library. You can install i-am-malicious...ModuleNotFoundError: No module named 'i-am-malicious'  Hi, My... named 'i-am-malicious' How to remove the ModuleNotFoundError: No module named
ModuleNotFoundError: No module named 'i-am-utils'
have to install padas library. You can install i-am-utils python...ModuleNotFoundError: No module named 'i-am-utils'  Hi, My Python...-am-utils' How to remove the ModuleNotFoundError: No module named 'i-am
ModuleNotFoundError: No module named 'Sam_I_Am'
ModuleNotFoundError: No module named 'Sam_I_Am'  Hi, My Python..._I_Am' How to remove the ModuleNotFoundError: No module named 'Sam_I_Am... to install padas library. You can install Sam_I_Am python with following
ModuleNotFoundError: No module named 'Sam_I_Am'
ModuleNotFoundError: No module named 'Sam_I_Am'  Hi, My Python..._I_Am' How to remove the ModuleNotFoundError: No module named 'Sam_I_Am... to install padas library. You can install Sam_I_Am python with following
I am getting error.How can i get details
I am getting error.How can i get details  Exception in thread "main" java.sql.SQLException: Listener refused the connecti n with the following error... descrip or The Connection descriptor used by the client was: Localhost:1521:orcl
I am from .net background, I want to learn SOA.
I am from .net background, I want to learn SOA.  Hi I am from .net background, I want to learn SOA. Could it possible for me to learn SOA, I suppose SOA includes Java. I dont have knowledge of java. Please help Thanks  
Command 'gem' not found, but can be installed with
Command 'gem' not found, but can be installed with  Hi, I am trying...: Command 'gem' not found, but can be installed with: sudo snap install ruby... versions. What to do?   Hi, This means you don't have gem installed
I need Oracle connector jar file. where will i download?
I need Oracle connector jar file. where will i download?  I need Oracle connector jar file. where will i download
I have problem in my Project
I have problem in my Project  Dear Sir, i have problem in my project about Jtable i have EDIT JButton whenevery i was click on edit he is display all data from database but i want to select any row
I don't found in Tomcat 7.0 's bin folder..
I don't found in Tomcat 7.0 's bin folder..  While making servlet using tomcat 7.0, i don't find startup.bat file in bin folder. My servlet... know how to run my servlet even i am following all the steps
i have an ques. of advanced java
i have an ques. of advanced java  write a wap to implement AWT by login form
i am getting multiple values in listbox
i am getting multiple values in listbox   hi sir, i am using... table group by stuname) order by a.name in a subquery multiple recdates i am getting its working fine, but in main query also i am getting multiple name
I have doubt in jsp file.
I have doubt in jsp file.  I have doubt in jsp file. In a jsp file, there should be two buttons. One is start and other is stop. When we click on start then only stop should be enabled. Other wise it should be disabled. When
what is difference b/w oracle 8i, 9i and 10g
what is difference b/w oracle 8i, 9i and 10g  what are the difference between oracle 8i,9i and 10g? I am not considering the versions and their supported os, in the interview point of view
I am Java programmer. Should I learn Java Script or Python?
I am Java programmer. Should I learn Java Script or Python?  Hi, I learned Core Java and Advanced Java. What should I learn next? I am Java programmer. Should I learn Java Script or Python? Thanks   Hi, Actually

Ads