I have read that JDBC is the most standard and common mechanism for accessing SQL data from Java. I want to know: is there any other mechanism for query data from ORACLE with Java code?

Thanks.

i think u can do this thru java code.but u shud first load a driver appropriate for ur database and jdk version you use.
then u have to open a connection between ur java code and database.
after you have done, in ur result set you can use sql sataements and update ur database.

a sample example will be like this.........

myResultSet = myStatement.executeQuery
(
"SELECT * from accountInformation" );
while(myResultSet.next()) {
System.out.print(myResultSet.getString(1)+" ");

try ur best
venki

You can use JNDI to set up a database for the application or use JDBC directly within your code. JNDI will allow you to use connection pooling and is simpler to use, once set up, read the Tomcat Documentation (accessable from the Tomcat startup page on 127.0.0.1 or http://localhost)

Should point out that JNDI still uses JDBC, JDBC is the way Java connects to databases, you MUST use it, what the tomcat documentation shows is one of TWO ways this can be done.

hai,
         There is no chance with out jdbc we can't get data from the db.
whether ur using the JNDI or something else no chance without jdbc.
only we can change the type of driver.
                                                      all the best .

P.Mallikharjuna Rao

You can simplyfy and make conventional method of accessing Oracle database using
Hibernate.


Gokulan Ethiraj