Hi All ....
below ia the error I am getting...
test1.java:0: The method java.util.Dictionary getTypeMap() declared in
class ora
cle.jdbc.driver.OracleConnection cannot override the method of the same
signatur
e declared in interface java.sql.Connection. They must have the same
return typ
e.
Above is the error for the source code I am using which is below...
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;
import java.util.Dictionary;
public class test1 {
public static void main (String args[]) {
OracleConnection conn = null;
Statement stmt = null;
int empno = 22;
String add1 = "addfvkuhkre";
String add2 = "abfgbddfvkuhkre";
try {
System.out.println("In main");
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver ());
conn =
(OracleConnection)DriverManager.getConnection("jdbc:oracle:oci8:@celtics:cel
tics:1521:crm","scott", "tiger");
java.util.Dictionary map = conn.getTypeMap();
map.put("ADDRESS", Class.forName("helperAdd"));
stmt = conn.createStatement ();
helperAdd helper = null;
PreparedStatement pstmt
= conn.prepareStatement ("insert into emp1 values (?, ?)");
helper = new helperAdd(add1, add2);
pstmt.setInt(1, empno);
pstmt.setObject(2, helper, OracleTypes.STRUCT);
pstmt.executeQuery();
System.out.println("insert done");
pstmt.close();
}
//catch(Exception crtEx){ throw new Exception("crtEx");}
catch(ClassNotFoundException e)
{
System.out.println(e);
}
catch(SQLException e)
{
System.out.println(e);
}
catch(Exception e)
{
System.out.println(e);
}
finally
{
try{
if (conn != null) conn.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
}
helper ...
public class helperAdd implements java.io.Serializable {
public String add1;
public String add2;
public helperAdd() { }
public helperAdd(
String add1,
String add2 ) {
this.add1 = add1;
this.add2 = add2;
}
}
Thanks in Advance
MURALI KRISHNA BALUSA
VELOCIENT TECHNOLOGIES
NEW DELHI.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".