RE: PSML stored in BLOB column in Oracle database

[Hoffman, Randy]

Actually I went in and said create a new account, which it did fine, logged
me in.
Then i started messing with portlets, minimizing, closing and then it throws
the error.  At that point profile in Jetspeed_user_profile is null for the
created user.

thanks,
 
randy


-----Original Message-----
From: Pernoud Aurelien [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 29, 2003 11:06 AM
To: Jetspeed Developers List
Subject: RE: PSML stored in BLOB column in Oracle database



Jetspeed shouldn't update profile to null, are you sure your
jetspeed_user_profile was correctly migrated to BLOB type ?

Here is a utility I wrote to get the profile from DB and extract it back to
XML, see if it's ok :

import java.io.File;
import java.io.FileOutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class BlobExtract
{
        public static void main(String[] args)
        throws Exception
        {
         try
         {  
        
System.setProperty("jdbc.drivers","oracle.jdbc.driver.OracleDriver"); 
                 // Prepare a connection
                 Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:@host:port:tns", "username",
"password");

                
                 // Prepare a Statement:
                 PreparedStatement stmnt = conn.prepareStatement("select
PROFILE from JETSPEED_USER_PROFILE where USER_NAME='USERNAM'");
                 

                 // Execute
                 ResultSet rs = stmnt.executeQuery();
                 
                // On en fait un fichier
                FileOutputStream out = new FileOutputStream(new
File("C:\\Temp\\Blob.xml"));

                 while(rs.next())
                 {
                        try
                        {
                           // Get as a BLOB
                           Blob aBlob = rs.getBlob(1);
                           System.out.println("Blob length : " +
aBlob.length());
                           byte[] allBytesInBlob = aBlob.getBytes(1, (int)
aBlob.length());
                           out.write(allBytesInBlob);
                        }
                        catch(Exception ex)
                        {
                           // The driver could not handle this as a BLOB...
                           // Fallback to default (and slower) byte[]
handling
                           //byte[] bytes = rs.getBytes(1);
                           ex.printStackTrace();
                        }
                 }
           // Close resources
           rs.close();
           stmnt.close();

         }
         catch(Exception ex)
         {
           ex.printStackTrace();
         }
        }
}


Hoffman, Randy a �crit :

> I've got the latest village jar and converted the table and data to 
> BLOB's but it appears jetspeed is updating the profile object (psml
> data) to null which throws a null exception in village's Value.java.
> From my understanding, blob's are supposed to have an empty_blob
> value when empty not null.  Anyone run into this or have any ideas?
> 
> Thanks!
> 
> randy

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]