This discussion is archived
2 Replies Latest reply: Nov 1, 2012 5:26 AM by Sašo C. RSS

jdbc_image_query problem

Sašo C. Newbie
Currently Being Moderated
Hi!

I'am using JavaScript API to add JDBC themes to the map. But I have problem using jdbc_image_query to show JDBC dynamic image theme.

My JavaScript code:

var JDBCthemeXml =
"<themes><theme name='JDBC_THEME'><jdbc_image_query asis='true' image_format='PNG' image_column='VSEBINA' image_mbr_column='GEOMETRY' jdbc_srid='2170' datasource='ARSO_BI_STAGE'>select VSEBINA, GEOMETRY, ID FROM PP_REGISTER_IZRISOV_MVIEW_TST WHERE kljuc = 'T2M_KLIMA_IZRIS_20110823'</jdbc_image_query></theme></themes>";
var themebasedfoi3 = new MVThemeBasedFOI('themebasedfoi3', JDBCthemeXml);
mapview.addThemeBasedFOI(themebasedfoi3);

always produce error:
[MVThemeBasedFOIControl.foiLoaded] MAPVIEWER-05523: Cannot process response from MapViewer server. (MAPVIEWER-06009: Error processing an FOI request.
Root cause:FOIServlet:MAPVIEWER-01015: Unable to retrieve theme definition. [arso_bi_stage.<themes><theme name='JDBC_THEME'><jdbc_image_query asis='true' image_format='PNG' image_column='VSEBINA' image_mbr_column='GEOMETRY' jdbc_srid='2170' datasource='ARSO_BI_STAGE'>select VSEBINA, GEOMETRY, ID FROM PP_REGISTER_IZRISOV_MVIEW_TST WHERE kljuc = 'T2M_KLIMA_IZRIS_20110823'</jdbc_image_query></theme></themes>])


On the other hand, the JDBC dynamic geometry theme behaves normal:
var JDBCthemeXml =
"<themes><theme name='JDBC_THEME'><jdbc_query asis='true' spatial_column='GEOMETRY' jdbc_srid='2170' datasource='ARSO_BI_STAGE'> select GEOMETRY from GR_OPE_SDO where OPE_NAZIV LIKE 'K%' </jdbc_query></theme></themes>";


This is log from Weblogic server:
---------------------------------------------------------------------------------
[2012-10-28T19:45:27.638+01:00] [bi_server1] [ERROR] [] [oracle.mapviewer.logger] [tid: Thread-215] [userId: <anonymous>] [ecid: 5fc906cae137b73b:2ac55e66:13a9d0ea079:-8000-0000000000002b42,1:32234] [APP: mapviewer#11.1.1] MAPVIEWER-01002: Cannot load theme. [<THEMES><THEME NAME='JDBC_THEME'><JDBC_IMAGE_QUERY IMAGE_FORMAT='PNG' IMAGE_COLUMN='VSEBINA' IMAGE_MBR_COLUMN='GEOMETRY' JDBC_SRID='2170' DATASOURCE='ARSO_BI_STAGE'>SELECT VSEBINA, GEOMETRY, ID FROM PP_REGISTER_IZRISOV_MVIEW_TST WHERE KLJUC = 'T2M_KLIMA_IZRIS_20110823'</JDBC_IMAGE_QUERY></THEME></THEMES>]
[2012-10-28T19:45:27.638+01:00] [bi_server1] [ERROR] [] [oracle.mapviewer.logger] [tid: [ACTIVE].ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 5fc906cae137b73b:2ac55e66:13a9d0ea079:-8000-0000000000002b42,0] [APP: mapviewer#11.1.1] MAPVIEWER-06009: Error processing an FOI request.[[
Message:MAPVIEWER-01015: Unable to retrieve theme definition. [arso_bi_stage.<themes><theme name='JDBC_THEME'><jdbc_image_query image_format='PNG' image_column='VSEBINA' image_mbr_column='GEOMETRY' jdbc_srid='2170' datasource='ARSO_BI_STAGE'>select VSEBINA, GEOMETRY, ID FROM PP_REGISTER_IZRISOV_MVIEW_TST WHERE kljuc = 'T2M_KLIMA_IZRIS_20110823'</jdbc_image_query></theme></themes>]
Sun Oct 28 19:45:27 CET 2012
Severity: 0
Description:
     at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:866)
     at oracle.lbs.foi.ThemeRenderingThread.getFeatures(ThemeRenderingThread.java:769)
     at oracle.lbs.foi.ThemeRenderingThread.render(ThemeRenderingThread.java:297)
     at oracle.lbs.foi.ThemeRenderingThread.run(ThemeRenderingThread.java:209)

]]
[2012-10-28T19:45:28.435+01:00] [bi_server1] [NOTIFICATION] [] [oracle.mapviewer.logger] [tid: Thread-216] [userId: <anonymous>] [ecid: 5fc906cae137b73b:2ac55e66:13a9d0ea079:-8000-0000000000002b44,1:32236] [APP: mapviewer#11.1.1] [ G_STAT_REGIJE ] sql exec time: 734ms, total time loading 12 features: 797ms.
[2012-10-28T19:45:28.482+01:00] [bi_server1] [NOTIFICATION] [] [oracle.mapviewer.logger] [tid: Thread-214] [userId: <anonymous>] [ecid: 5fc906cae137b73b:2ac55e66:13a9d0ea079:-8000-0000000000002b40,1:32235] [APP: mapviewer#11.1.1] [ G_OBCINA ] sql exec time: 563ms, total time loading 210 features: 859ms.
---------------------------------------------------------------------------------


Any idea what is wrong with jdbc_image_query to show JDBC dynamic image theme? It should be no problem if I understand http://docs.oracle.com/cd/E17904_01/web.1111/e10145/vis_concepts.htm. Maybe should I provide some extra information like original image resolution information or imagescaling="false" ?




Regards,
Sašo

Edited by: Sašo C. on 28.10.2012 13:16

Edited by: Sašo C. on 28.10.2012 13:18

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points