database connection

[adikimicky]

Can any one please tell me how to connect a simple java web application to Oracle10g Express edition?
Which driver should I use?
Thanks in advance.

[radhakrishna.p]

i think mostly type-4 driver is best to use for connecting to databse

go through the following post (explains everything)

http://www.daniweb.com/software-development/java/threads/352336/java-connection-with-oracle-10g-express

[adikimicky]

i think mostly type-4 driver is best to use for connecting to databse"

Do you mean Oracle in XE or / Microsoft ODBC for Oracle?

[radhakrishna.p]

if you use the bellow statement for connecting to database (in the above given url)

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")

that says you are using type-1 driver which is provided by Microsoft ODBC for Oracle

incase, if you use the bellow statement for connecting to database

Class.forName("oracle.jdbc.driver.OracleDriver") 

that says you are using type-4 driver (ojdbc.jar and ojdbc14.jar files are needed to connect to database) which comes with Oracle10g Express Edition

note : check bin folder of oracle10g installation for those jar files

in java there are 4 ways to connect to database . the following url explains description of all the 4 ways

http://www.roseindia.net/jdbc/jdbc-driver-and-its-types.shtml

let me know if you have any doubts in my clarification

happy coding

[adikimicky]

Well, when I am using type4 driver using the following code:

import java.sql.*;
public class jbc
{
    public static void main(String args[])
    {
        int i=0;
        try
        {
            String str="Select * from adi";
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.getConnection("jdbc:driver:OracleDriver:ff","SYSTEM","monika");
            System.out.println("Connection open");
            Statement stmt=con.createStatement();
            ResultSet rs= stmt.executeQuery(str);
            System.out.println("first Name");
            while(i<3)
            {
                rs.next();
                String lname=rs.getString("name");
                System.out.println(lname);
                i++;
            }
            con.close();
        }
        catch(Exception ex)
        {
           ex.printStackTrace();
        }
    }
}

It is giving me the same error :

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at jbc.main(jbc.java:10)
BUILD SUCCESSFUL (total time: 2 seconds)

While . when I tried using type 1 driver, the code is running fine only for retrieving values from the table i.e only for **Select ** queries. If I make certain changes to
the line

     String str="Insert into adi values('ram')";

then it is giving the following error:

run:
Connection open
java.sql.SQLException: No ResultSet was produced
    at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:259)
    at jbc.main(jbc.java:14)
BUILD SUCCESSFUL (total time: 3 seconds)

Please help me..:(

[adikimicky]

For inserting values in the table through code, I have modified lines as was doing a little mistake of not updating it.

  try
        {

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con =     DriverManager.getConnection("jdbc:odbc:sd","SYSTEM","monika");
            System.out.println("Connection open");
            Statement stmt=con.createStatement();
            String str1="INSERT INTO adi (name) values ('Ram') ";
            stmt.executeUpdate(str1);
            String str2="Select * from adi";
            ResultSet rs2= stmt.executeQuery(str2);
            System.out.println("first Name");
            while(i<3)
            {
                rs2.next();
                String lname=rs2.getString("name");
                System.out.println(lname);
                i++;
            }

But still i t is not working.It is only retrieving the already saved contents of the table.

Connection open
first Name
monika
aditya
shonu
BUILD SUCCESSFUL (total time: 2 seconds)

[radhakrishna.p]

hai adikimicky

there is no mistakes in the program except some logical mistakes which is unknown to you

i think you are in initial stages of learning concept. no problem

please change the while loop (in the previous post) as follows

while(rs2.next())
{
String lname=rs2.getString("name");
System.out.println(lname); 
}

so that program will run as you expects

what you have done is you fixed the while loop for running 3 times only thats the reason you got 3 names in the output

all remaining things are good

check it once and let me know the status

happy coding

[radhakrishna.p]

in one of the previous post

you said you are using type-4 driver

but in the coding part you got the connection object like as follows

Connection con = DriverManager.getConnection("jdbc:driver:OracleDriver:ff","SYSTEM","monika");

but if you use type_4 driver the connection string should be like as follows

Connection con = DriverManager.getConnection("jdbc:driver:thin","SYSTEM","monika");

no need of OracleDriver:ff simply remove that

and then also you got the ClassNotFoundException

for this you need to set (ojdbc.jar file and ojdbc14.jar ) files to your current classpath

i told you that thing also please hava alook at previous post so that you get the proper reason for the problem you have

happy coding

[adikimicky]

Hey thanks a lott madam.
it worked by using type 1 driver.
Thanks a lott..:)