Hi all,
I try to access to a local mysql DB to render some data in a PortalDataViewer.
But I always get an errormessage: Could not retrieve data.
Here is the relevant part of the code:
******************************************
System.err.println(sss);
Statement std = con.createStatement();
ResultSet res = std.executeQuery("select * from company");
/*while(res.next())
{
System.out.println(res.getString("cust_no"));
}*/
con.close();
ISource pdvSource = portalDV.createSource(request, res);
portalDV.setSource(pdvSource);
***********************
The SQL statement is fine-when I outcomment the result- I get the data in the server output window.
But in the IView I get the errormessage Could not retrieve data.
Thanks for your help!
Hi Antonio,
PDV is not a magic connection tool. It is just an implementation of the table view control. if you like to connect please read the tutorial for JDBC at java.sun.com or the section in the J2EE Server documentation (If you use J2EE Server.
Best Regards,
Oliver
Add a comment