Hello when I try to get content of html page using http_client function I
am still getting 0 back and I am getting an error which I really dont know
how to fix it.
My procedure so far
create procedure
POD.DBA.PRODUCT_OPEN_DATA(
IN new_origin_uri VARCHAR
)
{
--IN graph_iri VARCHAR,
--IN dest VARCHAR,
--INOUT content any
--INOUT async_queue any,
--INOUT ping_service any,
--INOUT api_key any,
--INOUT opts any
DECLARE TMP, URL, CONTENT, XT any;
DECLARE LISTNUM INTEGER;
LISTNUM := 0;
--ERROR HANDLING
DECLARE EXIT HANDLER FOR SQLSTATE '*'
{
RETURN 0;
};
IF (new_origin_uri LIKE 'http://www.product-open-data.com/brand-list-%/') {
TMP:= sprintf_inverse(new_origin_uri,'
http://www.product-open-data.com/brand-list-%s/' ,0);
LISTNUM := trim(TMP[0], '/');
if (LISTNUM is null or LISTNUM > 27) {
return 0;
} else {
URL := sprintf ('http://www.product-open-data.com/brand-list-%s/', LISTNUM);
}
CONTENT := http_client (URL=>url, http_method=>'GET', timeout=>20);
return CONTENT;
--XT := xtree_doc(CONTENT, parser_mode => 0, content_encoding => 'UTF-8');
--XT := DB.DBA.RDF_MAPPER_XSLT (registry_get ('_rdf_mappers_path_') ||
--'xslt/main/pod2rdf.xsl', XD, vector ('baseUri', new_origin_uri));
--XD := serialize_to_UTF8_xml (XT);
}
*You can try it e.g. with http://www.product-open-data.com/brand-list-16/
<http://www.product-open-data.com/brand-list-16/> *
*It is weird because it worked two days ago???*
c:\Program Files\virtuoso-opensource\database>virtuoso-t -f &
Mon May 05 2014
16:36:55 [Using virtuoso.ini in c:\Program
Files\virtuoso-opensource\database]
16:36:55 { Loading plugin 1: Type `plain', file `wikiv' in `../hosting'
16:36:55 WikiV version 0.6 from OpenLink Software
16:36:55 Support functions for WikiV collaboration tool
16:36:55 SUCCESS plugin 1: loaded from ..\hosting\wikiv.dll }
16:36:55 { Loading plugin 2: Type `plain', file `mediawiki' in `../hosting'
16:36:55 MediaWiki version 0.1 from OpenLink Software
16:36:55 Support functions for MediaWiki collaboration tool
16:36:55 SUCCESS plugin 2: loaded from ..\hosting\mediawiki.dll }
16:36:55 { Loading plugin 3: Type `plain', file `creolewiki' in `../hosting'
16:36:55 CreoleWiki version 0.1 from OpenLink Software
16:36:55 Support functions for CreoleWiki collaboration tool
16:36:55 SUCCESS plugin 3: loaded from ..\hosting\creolewiki.dll }
16:36:55 { Loading plugin 4: Type `plain', file `im' in `../hosting'
16:36:55 IM version 0.6 from OpenLink Software
16:36:55 Support functions for Image Magick 6.6.7
16:36:55 SUCCESS plugin 4: loaded from ..\hosting\im.dll }
16:36:55 { Loading plugin 5: Type `plain', file `wbxml2' in `../hosting'
16:36:55 WBXML2 version 0.9 from OpenLink Software
16:36:55 Support functions for WBXML2 0.10.7 Library
16:36:55 SUCCESS plugin 5: loaded from ..\hosting\wbxml2.dll }
16:36:56 OpenLink Virtuoso Universal Server
16:36:56 Version 07.10.3207-threads for Win64 as of Feb 17 2014
16:36:56 uses parts of OpenSSL, PCRE, Html Tidy
16:36:56 Database version 3126
16:36:56 SQL Optimizer enabled (max 1000 layouts)
16:36:57 Compiler unit is timed at 0.000225 msec
16:36:57 built-in procedure "EXEC_STMT" overruled by the RDBMS
16:36:58 built-in procedure "DB.DBA.RDF_PROXY_GET_HTTP_HOST" overruled by
the RD
BMS
16:36:58 built-in procedure "DB.DBA.RDF_SPONGE_IRI_SCH" overruled by the
RDBMS
16:36:58 built-in procedure "DB.DBA.RDF_PROXY_ENTITY_IRI" overruled by the
RDBMS
16:36:58 built-in procedure "repl_undot_name" overruled by the RDBMS
16:36:58 Roll forward started
16:36:59 158 transactions, 151649 bytes replayed (100 %)
16:36:59 Roll forward complete
*16:36:59 Error executing a server init statement : 22023: SR512: JSO
instance IR*
*I <sys:qmv-61cd3e6adf1391ecab642314a7013344> does not exist --
DB.DBA.RDF_QUAD_*
*FT_UPGRADE ()*
16:36:59 Checkpoint started
16:36:59 Checkpoint finished, log reused
16:36:59 HTTP/WebDAV server online at 8890
16:36:59 Server online at 1111 (pid 10908)
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
