Dear all, I am having a little issue with saving a set into an oracle db using plain
JDBC.
I have a transfer object LoggedInUserInfo and want to persist its filds in my login table but can't find any way to handle the collection part.
Here's the object
public class LoggedInUserInfo implements Serializable
{
private
String userName;
private Date loginTime;
private String remoteAddress;
private Set <String> permissions;
public LoggedInUserInfo(String userName)
{
this.userName = userName;
this.loginTime = new Date();
}
public Date getLoginTime()
{
return loginTime;
}
public String getUserName()
{
return userName;
}
public String getRemoteAddress()
{
return remoteAddress;
}
public Set<String> getPermissions()
{
return permissions;
}
In my dao class, I issue a prepared statment and proced to set its place holders like so:
LoggedInUserInfo info --my transfer object that I want to save.
PrepareStatement loginStmt--my prepared statement
loginStmt.setString(0,info.getUsername());
..
loginStmt.setxx(1, info.getPermissions)....DOESN'T WORK HERE..WHICH METHOD CAN I USE, HOW ELSE CAN I DO THIS? setArray() is not working either...