Hi,

We are using Oracle 8.0 and JDK 1.2.

While retrieving data through JDBC, from a table, a cryptic General error message is coming.

The table structure is :

Student_Name varchar2(10)
Student_id varchar2(5)
Books_issued Books

where Books is a nested table created from the Object Books_Type which has the following structure:

Books_id varchar2(5)
Author varchar2(10)
Title varchar2(10)
Issue_Date Date
Return_Date Date


The query :

select * from student;

works in SQL but not in JDBC.

But, queries like
select books_issued the(select books_issued from student )
or
select student_id from student

is working through JDBC.

The code in our java program is given below :

import java.sql.*;
import genins.dbconnect.*;

public class ORDMS
{
public static void main(String ar[])
{

ResultSet res ;
MDBConnect st = new MDBConnect();
try
{
res = st.executeQuery("select * from student ");
while(res.next())
{
System.out.println("inside next..");
System.out.println("Integer"+res.getString(1));
System.out.println(" "+res.getString(2));
System.out.println(" "+res.getString(3));
System.out.println(" "+res.getString(4));
System.out.println(" "+res.getString(5));
}
}
catch(SQLException e)
{
System.out.println("Exception ERROR"+e);
}
}
}


The Connectivity to the database is done through a java program in the package dbconnect.

After executing the above piece of code, only this particular SQL query is not executing and gives the cryptic message : General Error.

Please tell us whether it is possible to retrieve all the fields through a single SQL Query and how...

Regards,

JavaTeam.

Kishore Kumar D
Bangalore.
India.