Skip to Content
avatar image
Former Member

PDK PortalDataViewer "Could not retrieve data"

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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Dec 09, 2003 at 11:12 AM

    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 comment
    10|10000 characters needed characters exceeded