java oracle connection problem
I have successfully made connection with the oracle10g database that i am using and also able to put in data using JSP. But the codes that i have tried for fetching the data are not working even though they do not show any error.Can you kindly provide me a code written in JSP for fetching data from a oracle10g database.View Answers
June 19, 2010 at 12:07 PM
Hi Friend,
We have used MySQL database,try the following code:
<%@page import="java.sql.*"%>
<table border=1>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from data");
%>
<tr><th>Name</th><th>Address</th></tr>
<%
while(rs.next()){
%>
<tr><td><%=rs.getString("name")%></td><td><%=rs.getString("address")%></td></tr>
<%
}
rs.close();
st.close();
con.close();
}
catch(Exception e){}
%>
</table>
Hope that it will be helpful for you.
Thanks
We have used MySQL database,try the following code:
<%@page import="java.sql.*"%>
<table border=1>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from data");
%>
<tr><th>Name</th><th>Address</th></tr>
<%
while(rs.next()){
%>
<tr><td><%=rs.getString("name")%></td><td><%=rs.getString("address")%></td></tr>
<%
}
rs.close();
st.close();
con.close();
}
catch(Exception e){}
%>
</table>
Hope that it will be helpful for you.
Thanks
Related Tutorials/Questions & Answers:
java oracle connection problem - SQL
java oracle connection problem I have successfully made connection with the oracle10g database that i am using and also able to put in data using JSP. But the codes that i have tried for fetching the data are not working even
java oracle connection problem I have successfully made connection with the oracle10g database that i am using and also able to put in data using JSP. But the codes that i have tried for fetching the data are not working even
Java Connection to Oracle database
Java Connection to Oracle database HI I am ubable to connnect jdbc to Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed Oracle and in TNS i culdn't
Java Connection to Oracle database HI I am ubable to connnect jdbc to Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed Oracle and in TNS i culdn't
Advertisements
About connection database oracle to java
About connection database oracle to java I culdn't connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected Oracle... just typed DNS as Oracle and for TNS i clicked on the list of TNS .But it has
About connection database oracle to java I culdn't connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected Oracle... just typed DNS as Oracle and for TNS i clicked on the list of TNS .But it has
About connection database oracle to java
About connection database oracle to java **Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java **Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java
About connection database oracle to java Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java
About connection database oracle to java Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java Hi I culdn't connect oracle datebase to java.when i compile the program it is ok.but when i clicked... Oracle and then i clicked add button.Then Dialog box came indicating DNS and TNS
About connection database oracle to java
About connection database oracle to java I culdn't connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected Oracle... just typed DNS as Oracle and for TNS i clicked on the list of TNS. But it has
About connection database oracle to java I culdn't connect oracle... Panel>>Administrative Tools>>Data Sources in that i selected Oracle... just typed DNS as Oracle and for TNS i clicked on the list of TNS. But it has
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
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
jsp connection with oracle.
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
jsp connection with oracle.
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
jsp connection with oracle. I want to connect with jsp to oracle,,,plz send me the codes
Problem with url in oracle
Problem with url in oracle hi i m having trouble with the following code. when i run it i get the error as invalid oracle url specified. i am using tomcat 6 and oracle 10g release2 10.2.0.3. heres the code <html> <
Problem with url in oracle hi i m having trouble with the following code. when i run it i get the error as invalid oracle url specified. i am using tomcat 6 and oracle 10g release2 10.2.0.3. heres the code <html> <
oracle connectivity problem with netbeans
oracle connectivity problem with netbeans sir I am using oracle window version +net bean6.8. jam trying to connect net bean to oracle. for this after adding new driver(ojdbc6.jar) in services tab I got connectivity with oracle
oracle connectivity problem with netbeans sir I am using oracle window version +net bean6.8. jam trying to connect net bean to oracle. for this after adding new driver(ojdbc6.jar) in services tab I got connectivity with oracle
Hibernate- Oracle connection - Hibernate
to make a connection to oracle DB from eclipse. Thanks...Hibernate- Oracle connection In Eclipse I tried Windows -->... on databaseconnection --> New Oracle Added ojdbc14 Jar file path UID
to make a connection to oracle DB from eclipse. Thanks...Hibernate- Oracle connection In Eclipse I tried Windows -->... on databaseconnection --> New Oracle Added ojdbc14 Jar file path UID
Oracle 9i database problem
Oracle 9i database problem Hi Somebody has given the solution but i.............,send reply immediately. I have a problem in Oracle9i .I have installed Oracle 9i in my laptop.and i got sql+ page ok.i have gone to control panel->odbc
Oracle 9i database problem Hi Somebody has given the solution but i.............,send reply immediately. I have a problem in Oracle9i .I have installed Oracle 9i in my laptop.and i got sql+ page ok.i have gone to control panel->odbc
error oracle database connection?
error oracle database connection? hi now i am trying to connect oracle database and also insert my data into table, but it's not working.. I created... in oracle table. my table name is logininfoclient_sla. this is my coding
error oracle database connection? hi now i am trying to connect oracle database and also insert my data into table, but it's not working.. I created... in oracle table. my table name is logininfoclient_sla. this is my coding
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
android connection to database oracle 10g Hello, How i can connect my android application to my oracle 10g database
how to solve this problem for oracle connectivity
how to solve this problem for oracle connectivity Exception in thread "main" java.sql.SQLException: Io exception: The Network Adap ter could not establish the connection
how to solve this problem for oracle connectivity Exception in thread "main" java.sql.SQLException: Io exception: The Network Adap ter could not establish the connection
jdbc oracle connectivity problem
jdbc oracle connectivity problem Hi All, I am trying to connect my swing application to oracle DB . but class.forname is giving error. Please suggest me if there is some different way to connect swing application to oracle
jdbc oracle connectivity problem Hi All, I am trying to connect my swing application to oracle DB . but class.forname is giving error. Please suggest me if there is some different way to connect swing application to oracle
Problem with open connection - Hibernate
Problem with open connection Hi Team, I am running one hibernate application and the database is ORACLE 10g.I am getting the below error.I... open connection
Problem with open connection Hi Team, I am running one hibernate application and the database is ORACLE 10g.I am getting the below error.I... open connection
Could not establish the connection to oracle - JDBC
to use: Connection conn = DriverManager.getConnection("jdbc:oracle:oci8... to use: Connection conn = DriverManager.getConnection ("jdbc:oracle:thin... oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle
to use: Connection conn = DriverManager.getConnection("jdbc:oracle:oci8... to use: Connection conn = DriverManager.getConnection ("jdbc:oracle:thin... oracle.jdbc.driver.OracleDriver()); Connection conn = DriverManager.getConnection("jdbc:oracle
JDBC Connection code to connect servlet with oracle.
JDBC Connection code to connect servlet with oracle. JDBC Connection code to connect servlet with oracle
JDBC Connection code to connect servlet with oracle. JDBC Connection code to connect servlet with oracle
REQ for connection b/w jdbc and oracle database
REQ for connection b/w jdbc and oracle database REQ for connection b/w jdbc and oracle database The Java classes to connect...:*** a) If you are using oracle oci driver,you have to use: Connection conn
REQ for connection b/w jdbc and oracle database REQ for connection b/w jdbc and oracle database The Java classes to connect...:*** a) If you are using oracle oci driver,you have to use: Connection conn
problem in jdbc connection
problem in jdbc connection when i am trying to insert into apache derby databse using java in netbeans an exceprion is thrown at run time like this:- java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver....what
problem in jdbc connection when i am trying to insert into apache derby databse using java in netbeans an exceprion is thrown at run time like this:- java.lang.ClassNotFoundException: org.apache.derby.jdbc.ClientDriver....what
connection of java file to excel file and put data from excel file into oracle db
connection of java file to excel file and put data from excel file into oracle db how to create button on excel sheet using java swing and how we give action to that button excel sheet? how we connect excel file to java file
connection of java file to excel file and put data from excel file into oracle db how to create button on excel sheet using java swing and how we give action to that button excel sheet? how we connect excel file to java file
Todd oracle DB connection through PHP
Todd oracle DB connection through PHP Can u please explain how to connect Todd oracle DB using PHP & What are the setups we need to perform? Thanks
Todd oracle DB connection through PHP Can u please explain how to connect Todd oracle DB using PHP & What are the setups we need to perform? Thanks
how to solve an internet connection problem
how to solve an internet connection problem when i run my application it give me this error: Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not yet implemented the problem is that i don`t know
how to solve an internet connection problem when i run my application it give me this error: Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not yet implemented the problem is that i don`t know
Problem to get connection from DAO class to JDBC
Problem to get connection from DAO class to JDBC package controller... ConnectionProvider { private static Connection con=null; //static Connection..."); }catch(Exception e){} } public static Connection getCon(){ return con
Problem to get connection from DAO class to JDBC package controller... ConnectionProvider { private static Connection con=null; //static Connection..."); }catch(Exception e){} } public static Connection getCon(){ return con
if my database(oracle) connection failure means wat is the code to write in exception ?
if my database(oracle) connection failure means wat is the code to write in exception ? if my database(oracle) connection failure means wat is the code to write in exception
if my database(oracle) connection failure means wat is the code to write in exception ? if my database(oracle) connection failure means wat is the code to write in exception
Oracle - Java Beginners
Oracle Hi sir, I installed oracle but the error occur on The java Runtime Environment was not found, at bin\jrew.exe. Hence the Oracle Universal Installer can not be run JRE version 1.1.7 Are the Java and Oracle related
Oracle Hi sir, I installed oracle but the error occur on The java Runtime Environment was not found, at bin\jrew.exe. Hence the Oracle Universal Installer can not be run JRE version 1.1.7 Are the Java and Oracle related
how to connection jsp to oracle database connections in netbeans ide
how to connection jsp to oracle database connections in netbeans ide how to connect jsp to oracle database connections in netbeans ide?pls provide screenshots if possible
how to connection jsp to oracle database connections in netbeans ide how to connect jsp to oracle database connections in netbeans ide?pls provide screenshots if possible
how to connection jsp to oracle database connections in netbeans ide
how to connection jsp to oracle database connections in netbeans ide how to connect jsp to oracle database connections in netbeans ide?pls provide screenshots if possible
how to connection jsp to oracle database connections in netbeans ide how to connect jsp to oracle database connections in netbeans ide?pls provide screenshots if possible
java-oracle
java-oracle hi friends, I wanted to upload a image from jsp page to oracle database.i am not getting how to do it... Please help me if you can....... please give me detail code
java-oracle hi friends, I wanted to upload a image from jsp page to oracle database.i am not getting how to do it... Please help me if you can....... please give me detail code
java with Oracle Database
java with Oracle Database Hello I have been encountering a problem regarding creating a table with Oracle.When i am creating new table in the Database using Oracle , it is giving error saying an errror occured incursive sql
java with Oracle Database Hello I have been encountering a problem regarding creating a table with Oracle.When i am creating new table in the Database using Oracle , it is giving error saying an errror occured incursive sql
ex. connect to Oracle - Java Beginners
ex. connect to Oracle dear sir, I want to ask how to connect java to oracle, please give me a details tutorial with example code how to connect to oracle. what software i must to use? thank's Hi
ex. connect to Oracle dear sir, I want to ask how to connect java to oracle, please give me a details tutorial with example code how to connect to oracle. what software i must to use? thank's Hi
how to write a code for oracle database connection in asp.net for validation.
how to write a code for oracle database connection in asp.net for validation...:\oracle\product\10.2.0\client_1\BIN directory. This directory may be different based on your oracle configuration. using Oracle.DataAccess.Client; // C
how to write a code for oracle database connection in asp.net for validation...:\oracle\product\10.2.0\client_1\BIN directory. This directory may be different based on your oracle configuration. using Oracle.DataAccess.Client; // C
JAVA BEAN WITH ORACLE FORMS
JAVA BEAN WITH ORACLE FORMS Hi..I am doing my final year Project.. I need the ste-by-step procedure to integrate a bean with oracle forms? Please help me
JAVA BEAN WITH ORACLE FORMS Hi..I am doing my final year Project.. I need the ste-by-step procedure to integrate a bean with oracle forms? Please help me
java to oracle code - JDBC
java to oracle code please suggest m calculate the database performance between scaled images and unscaled images in the database
java to oracle code please suggest m calculate the database performance between scaled images and unscaled images in the database
Java vs Oracle Connectivity - JDBC
Java vs Oracle Connectivity Write a java program to establish connection with oracle database? Hi Friend, Use Oracle with Java... are using oracle oci driver,you have to use: Connection conn
Java vs Oracle Connectivity Write a java program to establish connection with oracle database? Hi Friend, Use Oracle with Java... are using oracle oci driver,you have to use: Connection conn
java programming problem - JDBC
java programming problem Hi, Request you to provide the source code in Java for the following programming problem : upload .csv file data into oracle database. please send the solution to raichallp@yahoo.in
java programming problem Hi, Request you to provide the source code in Java for the following programming problem : upload .csv file data into oracle database. please send the solution to raichallp@yahoo.in
java connecting to oracle db
java connecting to oracle db PLZ SAY ME HOW TO INSERT THE VALUES INTO ORACLE THIS IS THE CODE: import java.io.*; import java.sql.*; import..."); Connection con=DriverManager.getConnection("jdbc:oracle:thin
java connecting to oracle db PLZ SAY ME HOW TO INSERT THE VALUES INTO ORACLE THIS IS THE CODE: import java.io.*; import java.sql.*; import..."); Connection con=DriverManager.getConnection("jdbc:oracle:thin
java connecting to oracle db - JDBC
java connecting to oracle db how to connect oracle data base... to use: Connection conn = DriverManager.getConnection("jdbc:oracle:oci8... have to use: Connection conn = DriverManager.getConnection ("jdbc:oracle:thin
java connecting to oracle db how to connect oracle data base... to use: Connection conn = DriverManager.getConnection("jdbc:oracle:oci8... have to use: Connection conn = DriverManager.getConnection ("jdbc:oracle:thin
java and oracle - JSP-Servlet
java and oracle I am developing a small project where I need to upload the resume of the employee and store it into database and retrieve the same... data types in oracle database. And I need to write the code in servlets
java and oracle I am developing a small project where I need to upload the resume of the employee and store it into database and retrieve the same... data types in oracle database. And I need to write the code in servlets
java programming problem - JDBC
problem to the following mail id : Problem : upload excel file data into oracle database using java / j2ee. mail id : raichallp@yahoo.co.in...java programming problem Hi, Request you to provide a solution
problem to the following mail id : Problem : upload excel file data into oracle database using java / j2ee. mail id : raichallp@yahoo.co.in...java programming problem Hi, Request you to provide a solution
oracle
oracle sir now am doing one project , my frond end is vb and backend is oracle. so 1> how can i store the image in my field 2> how can i back up the table into .txt file
oracle sir now am doing one project , my frond end is vb and backend is oracle. so 1> how can i store the image in my field 2> how can i back up the table into .txt file
java Problem
java Problem I want to create a binary tree for displaying members in Downline. i am creating a site for MLM(Multi-Level MArketing). tree must be dynamically populated from database. is there any help for me. Thanks in advance
java Problem I want to create a binary tree for displaying members in Downline. i am creating a site for MLM(Multi-Level MArketing). tree must be dynamically populated from database. is there any help for me. Thanks in advance
JAVA Problem
JAVA Problem Write a program that takes two parameters 1. a word 2. an array of words It should then remove all instances of the word in the array. For Example: INPUT word="ravi" word_array = ["Chethan Bhagat
JAVA Problem Write a program that takes two parameters 1. a word 2. an array of words It should then remove all instances of the word in the array. For Example: INPUT word="ravi" word_array = ["Chethan Bhagat
i am getting the problem when i am downloading the pdf file from oracle 10g database - Struts
i am getting the problem when i am downloading the pdf file from oracle 10g database if i created the pdf file from pdf machine,it is storing into datbase and download the pdf file from database. but when i created the pdf file
i am getting the problem when i am downloading the pdf file from oracle 10g database if i created the pdf file from pdf machine,it is storing into datbase and download the pdf file from database. but when i created the pdf file
Connection to database table in Oracle with Example
Connection to database table in Oracle with Example In this Section, we will discuss about connecting Java frontend with OracleDatabase. Step1: First, Download the oracle driver and install or copy it in your system , if you are using
Connection to database table in Oracle with Example In this Section, we will discuss about connecting Java frontend with OracleDatabase. Step1: First, Download the oracle driver and install or copy it in your system , if you are using
java servlet connectivity problem with access
java servlet connectivity problem with access Import java.sql...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc... : java.sql.Connection required: Connection Connection con
java servlet connectivity problem with access Import java.sql...("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc... : java.sql.Connection required: Connection Connection con
Questions by Category
- Swing-AWT
- Date-Calendar
- JDBC
- Regex
- XML
- Security
- Java Server Faces Questions
- JSP Servlet
- EJB
- JavaMail
- JMS
- Java3D
- Log4J
- Spring
- Hibernate
- Maven
- IDE Questions
- Mobile Applications
- Ajax
- Framework
- Struts
- WebSevices
- Java Magazine
- JSP-Interview Questions
- Java Interview Questions
- Servlet Interview Questions
- Hibernate Interview Questions
- JUNIT
- Java Beginners
- Applet
- JNDI
- RMI
- LDAP
- RUP
- UML
- SQL
- Design concepts & design patterns
- Ant
- CVS
- Subversion
- Development process
- AOP
- IoC
- PHP