Hi all,

I improved my application adding Database user management in order to have a Cluster. The problem is that one field ("session_data") must be bytea and I don´t know how to make the setter & getter class and of course how to manage data from this field.

I tried everything, using Object type, httpSession type and no result. For example, i want to extract from each session an attribute that I had set, but this is inside session_data field.

Any ideas?.

Other thing is that when I stop tomcat server, sessions are still in database, so when you restart server, tomcat connector try to restore sessions in hibernate; problem? SessionFactory ID has changed and no name are avalaible (In tomcat 5.5.9 I had tried using JDBC Datasource that is in your hibernate PDF for tomcat and for me.. or i am so stupid it doesn't work).

Thanks all.

Hi!
Please don't scold your self.
You Can.
Actually setter and getter method in a class is looking like

public class one{
String username;
String password;

public String getUsername(){
return username;
}
public void setUsername(String username){
this.username = username;
}

public String getPassword(){
return password;
}
public void setPassword(String password){
this.password= password;
}
}

If You are beginner in Hibernate, Pls try to refer the following link
http://www.laliluna.de/first-hibernate- ... orial.html

Thanks

Hi,

thanks for your help, but I know this. I want to know how to manage bytea Postgresql field into a getter and Setter. I mean that ir you look at "session_data" table you could see that all session attributes are held into a bytea field.

My problem is that i want to extract those attributes in order to get their values. So that, i want to know how could I do table getter & setter for managing this field.

Thanks all.

map it to byte array.

public void setMyBytes(byte [] value)

Thanks Baliuka, it works.

Now my problem is what do I have to do in order to convert this Byte array into the original tomcat's session data?.

I need this because Cluster use database table to make sessions persistents through all tomcat servers, and of course one of the session data Object is the hibernate's SessionFactory.

Any ideas?.

Thanks a lot.

I am not sure I understand this problem, but if you need to desesialize this stuff the just read it from stream:
Object stuff = new ObjectInputStream(new ByteArrayInputStream(myBytes)).readObject();

Ok i'll explain you:

First of all i have a table in postgresql called "tomcat_sessions" like this:



Then, I let tomcat manage http sessions with this code into context.xml



With this code tomcat inserts into postgresql table sessions that are created, update sessions that had changed its state and delete sessions when are invalidated.

Field, in which i am interested (session_data), is where tomcat insert session's attribute Objects, which is bytea type. And here is my necessity:

- You know now that session_data field is actually Http Session Attributes, so i want to make inversed process. I want to generate Object Data from field in order to extract data like this form: session.getAttribute("something");.

This method is implemented in order to make a Cluster, so each web application have their own Hibernate SessionFactory but Http sessions are shared between two, three, four servers. So if one of tomcat servers goes down, another one will get this session and this session user wouldn't be invalidated.

Thanks a lot.