Need a solution to convert the object get from a database into a public key

[Kavitha Sundararaj]

Hi, friends,

run the following code:

import java.security.*;
  import java.sql.*;
  class keytesting
  {
  public static void main(String args[])
  {
   keytesting k = new keytesting();
   k.keytest();
  }
  public void keytest() 
  {
  try
  {
  String strSql;
  strSql = "SELECT pubkey FROM table1"; 
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con = DriverManager.getConnection("jdbc:odbc:jothi1"); 
  Statement stmt = con.createStatement();
  ResultSet rs = stmt.executeQuery(strSql);
  while (rs.next())
  {
   Object obj;
   obj = rs.getObject("pubkey");
  
   System.out.println("obj " + obj.toString());
    
   PublicKey pk;
   pk = (PublicKey) (obj);
   System.out.println("pk " + pk.toString());
  }
  stmt.close();
  con.close();
  }
  catch(Exception e) 
  {
   System.out.println("Error " + e.getMessage());
  }
 }
}

Table structure in Access:

table name : table1
field name : pubkey ; Data type : OLE Object.

I want to put this key in Oracle/SQL Server. For that, I have to use BLOB, and ntxt respectively. It is not working here. Please try this in Oracle/SQL also.

Anyone give me the solution.

[edited to add code tags and disable smilies]
[ November 25, 2004: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Kavitha,
Welcome to JavaRanch!

pk = (PublicKey) (obj);

I think this is the root of the problem. Databases generally don't recognize objects. We usually get a binary stream and read it the object type we are looking for. Take a look at the ObjectInputStream and ObjectOutputStream classes.