Hello everyone,
I've got a problem. I have developed a portlet wich collects data from a MySQL database and puts it into a primefaces dataTable.
On my local test-liferay (V 6.2) it works quite fine. But on my live-vm-liferay (also V 6.2) it does only print the datatable and no content in it.
For me it looks like liferay doesn't load the bean or something.
Here's the source-code:
view.xhtml:
<!--?xml version="1.0" encoding="UTF-8"?-->
<f:view xmlns="http://www.w3.org/1999/xhtml" xmlns:f="http://java.sun.com/jsf/core" xmlns:h="http://java.sun.com/jsf/html" xmlns:p="http://primefaces.org/ui" xmlns:pt="http://xmlns.jcp.org/jsf/passthrough">
<h:head>
</h:head>
<h:body>
<!-- Here liferay should print the bean-instance-->
<p:outputlabel value="${projektBeanNew}" />
<h:form id="dForm">
<p:datatable id="dTable" var="projekt" value="#{projektBeanNew.projekte}" sortmode="multiple" rows="25" paginator="true">
<f:facet name="header">
Alle Projekte
</f:facet>
<p:column sortby="name" headertext="Name">
<h:outputtext value="#{projekt.name}" />
</p:column>
<p:column sortby="key" headertext="Key">
<h:outputtext value="#{projekt.key}" />
</p:column>
<p:column sortby="beschreibung" headertext="Beschreibung">
<h:outputtext value="#{projekt.beschreibung}" />
</p:column>
<p:column sortby="projektleiter" headertext="Projektleiter">
<h:outputtext value="#{projekt.projektleiter}" />
</p:column>
</p:datatable>
</h:form>
</h:body>
</f:view>
Bean:
@ViewScoped
@Named("projektBeanNew")
public class ProjekteBeanNew {
@Inject
private Logger logger;
private List<projekt> projekte;
public ProjekteBeanNew(){
init();
}
@PostConstruct
private void init() {
System.out.println("Test");
projekte = new ArrayList<projekt>();
String url = "jdbc:mysql://pmp2-vm/";
String dbName = "pmp2";
String driver = "com.mysql.jdbc.Driver";
String userName = "AlleProjekte";
String password = "AlleProjekte";
try {
System.out.println("test1");
Class.forName(driver).newInstance();
System.out.println("test2");
Connection conn = DriverManager.getConnection(url + dbName, userName, password);
System.out.println("test3");
Statement st = conn.createStatement();
ResultSet res = st.executeQuery("SELECT `Key`, `Name`, Beschreibung, JiraPersonen.`Nachname` FROM JiraProjekte JOIN JiraPersonen ON Projektleiter=JiraPersonen.Email");
while (res.next()) {
Projekt temp = new Projekt();
temp.setKey(res.getString("Key"));
temp.setName(res.getString("Name"));
temp.addBeschreibung(res.getString("Beschreibung"));
temp.addProjektleiter(new Person(res.getString("Nachname")));
projekte.add(temp);
}
res.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public List<projekt> getProjekte(){
return projekte;
}
}</projekt></projekt></projekt>
Greetings
Jan
