Preview Issue

abhi2005

Hi,
I am creating a simple db component using JDBCXML method and don't have any code written in the Appearance XSL section except the default one. The issue is that although the JDBC query gets executed without any errors, There is not data available on the preview page when i try to preview the component data. Can anybody suggest a solution to this.?

Thanks,
A

Find more posts tagged with

Comments

tec_iwov

if you use the preview link from component edit you will be able to see the xml that the component is transformed against.

abhi2005

if you use the preview link from component edit you will be able to see the xml that the component is transformed against.

there is nothing there. What i asked is something fairly simple- no preview is generated for the data that has to be returned when the query is executed. i dont even have any errors being shown.
Thanks,
Abhilash

flivauda

Do you have your franklin_pool_factory_config.xml file configured?

Also its not clear where you are previewing from:

1) Page Edit. i.e. you edited a page, dropped your component and then previewed.

2) Component Edit. i.e. you are in the component development area and you preview and you get the window with the 4 panes and you aren't seeing any data returned in the bottom left hand pane.

F

tec_iwov

if you look in the lower left hand corner your results should show up under data/external. if there is nothing there then the sql returned no data.

you can turn on debug logging for the class your using to see the query string it's building.

com.interwoven.livesite.external.impl.SQL is the class your using?

abhi2005

if you look in the lower left hand corner your results should show up under data/external. if there is nothing there then the sql returned no data.

you can turn on debug logging for the class your using to see the query string it's building.

com.interwoven.livesite.external.impl.SQL is the class your using?

Here is the scenario - step by step
1. i develop a component for db.
2. the franklin....xml file is already configured.
3. i try to preview this from the 'component deve area'
4. i see no results on the page.

debugging is on and the sql is returning data. the question here is why is nothing being shown on the page?
even if i view the source of the page, there are no errors being shown there.
please suggest.
thanks,
A

tec_iwov

Just to make things clear for me. You open the component editor then within the component edit window you click the preview link at the top of the page that shows the framed preview (see attachment). If your using the com.interwoven.livesite.external.impl.SQL class and have debugging on for that class you do you should see both the sql that's generated and the resulting xml structure that's returned from the class in the teamsite servlet log. In the edit preview window you should see this xml structure embedded in the xml in the "XML viewer" frame. You stated that "don't have any code written in the Appearance XSL section" if your trying to preview the compont within a page or directly from content center you will not see anything.

I hope I'm being clear.