Hi

Can someone help please?
I have a connection to my Posrgresql database.
How do i display the data that is contained in my list?
the part in bold does not work and give the error:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select name from NAMES
Exception in thread "main" java.lang.ClassCastException: [Ljava.lang.Object;
at hello.HelloWorld.main(HelloWorld.java:25)
5 message(s) found:

//this is part of my code.
Session newSession =HibernateUtil.currentSession ().getSessionFactory().openSession();
Transaction newTransaction = newSession.beginTransaction();
List messages = newSession.createSQLQuery("select name from NAMES").list();

//this tells me that my query found n items in the table
System.out.println( messages.size() + " message(s) found:" );

for ( Iterator iter = messages.listIterator();iter.hasNext(); )
{
NAMES loadedMsg = (NAMES) iter.next();
System.out.println( loadedMsg.getText() );
}
newTransaction.commit();
newSession.close();


//this is my NAMES class

package hello;

public class NAMES {
private long id;
private String text;
private NAMES nextMessage;

NAMES()
{

}

public NAMES(String text)
{
this.text = text;
}

public Long getId()
{
return id;
}

private void setId(Long id)
{
this.id = id;
}

public String getText()
{
return text;
}

public void setText(String text)
{
this.text = text;
}

public NAMES getNextMessage()
{
return nextMessage;
}

public void setNextMessage(NAMES nextMessage)
{
this.nextMessage = nextMessage;
}


}

Which line in your code does the exception point to? The exception says
(HelloWorld.java:25), but which line is that?


I don't know if this will help you, but in my code i use an iterator :

for (Iterator iter = messages.iterator(); iter.hasNext();)


In your code, you have a listIterator:

for (Iterator iter = messages.listIterator(); iter.hasNext();)


regards,
Mark