Semantic Technologies :: MapViewer And Google Places API

Apr 17, 2013

I'm new in the group and no have much experience in Spatial area.

I'm looking for information about the posibility of use google places apis to get point of interest from Oracle Spatial / MapBuilder / MapViewer in order to use point of interest from google with own spatial information.

View 1 Replies


ADVERTISEMENT

Semantic Technologies :: Convert Application From Jena TDB To Oracle

Jul 23, 2013

We want to convert our application from Jena TDB to Oracle. In our ontology there are 40.000 triples. Oracle takes 6.8 sec. while Jena TDB takes 0.59 sec. Oracle is much slower than jena TDB. You can see both codes below. There are no inferencing for both apps. How can I improve the performance of Oracle?

Both applications and their data sources are running on same machine. 

Oracle code:Oracle oracle = new Oracle(szJdbcURL, szUser, szPasswd);  Attachment attachment1 = Attachment.createInstance(  new String[] { szSchemaName, szImpactName }, new String[] { },  InferenceMaintenanceMode.NO_UPDATE,  QueryOptions.DEFAULT);  graph1 = new Graph Oracle Sem(oracle, szModelName, attachment1);m = new ModelOracleSem(graph1);  listSubclass = m.listStatements(null,)
[code]....

View 7 Replies View Related

Semantic Technologies :: Orageo Nearest Neighbor No Results?

Oct 13, 2013

 I am using Oracle 12c Spatial and Graph and I would like to retrieve the nearest neighbors of a point from a dataset encoded according to GeoSPARQL.I have created a spatial index on the datatype geo:wktLiteral and I to the query so the optimizer pick a plan using the index RDF_V$GEO_IDX. The query I pose is the following: 

SELECT geo, wkt
FROM TABLE(SEM_MATCH('
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
SELECT ?geo ?wkt
    
[code]...

 I do not get any error but I do not get any results neither. However, there are a lot of points around POINT(22.39 38.25) in my dataset and if I remove the filter I get results.Do I use orageo:nearestNeighbor in a wrong way?  

View 6 Replies View Related

Semantic Technologies :: NullPointerException While Executing SPARQL Through Jena

Jul 19, 2012

I was trying to execute a SPARQL through Jena API. I am getting the following exception when invoking the

"ResultSetFormatter.out(System.out, results);" method.

I connect to Oracle using the following Jena code

============================================
Oracle oracle = new Oracle(szJdbcURL, szUser, szPasswd);
Model model = ModelOracleSem.createOracleSemModel(
oracle, szModelName);
==============================================

This is the exception I am getting.

java.lang.NullPointerException
     at oracle.spatial.rdf.client.jena.OracleRepeatApply.nextStage(OracleRepeatApply.java:794)
     at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.makeNextStage(QueryIterRepeatApply.java:101)
     at com.hp.hpl.jena.sparql.engine.iterator.QueryIterRepeatApply.hasNextBinding(QueryIterRepeatApply.java:53)
[code].....    

View 1 Replies View Related

Semantic Technologies :: User-defined Function In FILTER Clause?

Apr 28, 2013

can i create the user-defined functions and use them in the FILTER clause in the sem_match function? there are some built-in functions for the FILTER clasue. however, only one function (DATATYPE(literal)) support for date/time in the built-in functions. i want to implement some user-defined funcitons in the FILTER clause which can check time intervals in ontology. there are some functions about valid time in the WorkSpace Manager such as WM_OVERLAPS, WM_CONTAINS,WM_MEETS, etc. so, can i write some functions using the these valid time functions in WM and use them in the FILTER clause?

View 2 Replies View Related

Semantic Technologies :: Maximum Node ID Larger Than Java Maximum Integer Value

Mar 7, 2013

I'm currently doing migration from Oracle 10gR2 RDF to Oracle 11gR2 Semantic Technology.I followed the steps on the documentation and successfully created the network using the following:

-----
EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
CREATE TABLE rdf_network_trace (id NUMBER, triple SDO_RDF_TRIPLE_S);
--Created SEQUENCE andTRIGGER FOR rdf_network_trace id
[code]....

when I looked at my Node Ids, they were like +635762253807433724+, +6118969225776891730+. The problem is, I am not the one who is assigning Node Ids, They were automatically generated when inserting TRIPLE data to the rdf table.

Did I miss something when I created my network?

View 11 Replies View Related

Semantic Technologies :: Can Bind LONG Value Only For Insert Into LONG Column

Dec 22, 2012

I got an exception when I was using sesame adapter to dump a turtle file which contains long texts as objects into oracle semantic database. The exception information is:

org.openrdf.repository.RepositoryException: org.openrdf.sail.SailException: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

ORA-06512: in "SF.ORACLE_ORARDF_ADDHELPER", line 1
ORA-06512: in line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) ...

View 1 Replies View Related

Forms :: Display Map Using Mapviewer?

Sep 6, 2012

How do I display map on the oracle forms using mapviewer?

View 1 Replies View Related

SQL & PL/SQL :: Decimal Places In A Value

Dec 12, 2011

I have a table with column amount as decimal(11,2). I want to store the values as shown below

15.30

but it stores as

15.3

Is it possible to store the value in 15.30?

View 4 Replies View Related

SQL & PL/SQL :: Store Data From Multiple Places In Materialized View?

Apr 14, 2011

I have a PL/SQL procedure which gathers data from multiple places as well as calculates some data. I want to store all this in a materialized view.So, I created an object type (I've shortened the definitions):

CREATE OR REPLACE TYPE mf_record_type AS OBJECT
(identifier VARCHAR2(6),
name VARCHAR2(100));

Then created the table type of the object:

CREATE OR REPLACE TYPE mf_table_type IS TABLE OF mf_record_type;

Then in the stored procedure defined a variable of the table type:

v_mf_record mf_table_type := mf_table_type();

Then I loop and populate the record type:

v_mf_record.EXTEND(1);
v_mf_record(x) := mf_record_type(v_rec.identifier, v_mf_detail.name);

When all that is done I try and create the materialized view:

EXECUTE IMMEDIATE ('CREATE MATERIALIZED VIEW mf_snapshot_mv AS
SELECT * FROM TABLE (CAST (v_mf_record AS mf_table_type))');

ORA-00904: "V_MF_RECORD": invalid identifier

Am I doing something wrong here? Can't I create the materialized view based on something other than a physical table?

View 1 Replies View Related

Reports & Discoverer :: Field Value To Be Printed Partially In 3 Places?

Jul 21, 2011

I need to print a value of a report partially at three places.

Example: If Field Value is 12-24-15 then I need to print 12 at One Place then 24 at second Place and 15 at third Place on the same page of a report and omitting -(Hyphen).

View 11 Replies View Related

PL/SQL :: How To Generate Large Random Number Without Decimal Places

Nov 5, 2012

I need to generate random numbers from the range 71 million to 90 million. While generatind the same iam getting the value with decimal places.

How to generate with out decimal places ?

SQL> select ABS(dbms_random.value(71000000,90000000)) from dual;
ABS(DBMS_RANDOM.VALUE(71000000,90000000))
-----------------------------------------
87283730.7

View 6 Replies View Related

PL/SQL :: Pass Statements Using Oracle Semantic Functions In PHP?

Apr 26, 2013

I am developing android application connected to Oracle database using PHP, and I use PL/SQL statements with semantic technologies provided in Oracle(specifically, SEM_MATCH, SEM_MODELS, SEM_RULEBASES or something like this).

However, it doesn't work properly...the connection between android and Oracle works well, though. Also, the query statement is implemented well in the sql developer.The whole php code is shown below :

*<?php*

function db_connect()
*{*
*$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 203.249.105.20)(PORT = 1521)))(CONNECT_DATA=(SID=orcl)))";*

[code]...

View 6 Replies View Related

Application Express :: Google ReCaptcha Plugin In 4.2

Oct 31, 2012

We have just upgraded from APEX 4.0.1 to APEX 4.2. The installation and migration of the applications went very well (after installing the patch for the import of the workspaces :-) ). But we have met a problem - we have a Google reCaptcha plugin on 101 page (authentication page). It has runs pretty well on 4.0.1, but after upgrade whole plugin item just has disappeared from 101. Actually it has disappeared from IE9, IE8, Mozilla 16 and Google chrome. The only browser that is displaying reCaptcha is Opera.

why this happened and how we can fix it? The client wants to make some tests this week and we have to fix the situation.

View 1 Replies View Related

Application Express :: Integration With Google Map Visualization

Nov 1, 2013

Is there a way I can integrate my customer base (over 100k with address information) to a Google map. High level, I want my user to enter an address and on google map it should show me markers for existing customers closer to that address. 

View 3 Replies View Related

SQL & PL/SQL :: Unable To Send Email Through Google To Private Domain

Dec 1, 2012

how to send email (PL/sql Procedure) to private domain through google mail.

View 2 Replies View Related

SQL & PL/SQL :: Google Translator - How To Pass Special Characters In URI Type

Aug 30, 2012

I am using http url for Google translator to convert into different languages.

While passing the string, to escape the white spaces, I am using utl_url.escape . But many of my words contain special characters like '+ , @ , $ , ) ,. ,; [, ] etc.

Not sure how to pass these special characters in uri type.

httpuritype
('http://translate.google.com/?hl=' ||
p_from || '&layout=1&eotf=1&sl=' || p_from ||
'&tl=' || p_to || '&text=' ||
utl_url.escape (p_words) || '#').getclob();

few of my words for translation are

VALERIANA OFFICINALIS L. + HYPERICUM PERFORATUM L. + MELISSA OFFICINALIS L.
VALERIANA OFFICINALIS L. + HYPERICUM PERFORATUM L. + [ MELISSA OFFICINALIS] L.

View 16 Replies View Related

Forms :: Oracle 6i For Windows 7 64 Bit / Can't Find Exact Location From Google

Sep 20, 2012

i want to download form 6i and report 6i for window 7 64bit. from where i can download it. i can't find exact location from google.

View 6 Replies View Related

Application Express :: Integrate Google Geo Coding As Restful Service

Dec 3, 2012

How to integrate Google geocoding as RESTful service introduced by APEX 4.2? my supervisor wanted to use RESTful service for geocoding function. While I am using Google geocoding through simple HTTP request. I even do not know whether I am using SOAP or RESTful with PL/SQL utl_http.request.

View 0 Replies View Related

Forms :: Clienthost - Unable To Block Form When Working On Google Webpage?

Apr 25, 2011

I am trying to open the url from the form and block the form when working on the url.I am able to block the form when working on notepad, adobe and word doc by using the below code

CLIENT_HOST('CMD /C NOTEPAD '||fname);
CLIENT_HOST('cmd /c "c:/web_util[1].pdf"');

and when I use CLIENT_HOST( 'cmd /C "C:/Program Files/Internet Explorer/iexplore.exe" www.google.com'); it is opening the www.google.com but unable to block the form when working on google webpage.

I am using oralce forms 10.1.2.3 and the browser is IE8.

View 1 Replies View Related

Application Express :: Part Of Screen Is Missing For Dashboard In IE And Google Chrome

Mar 7, 2013

When I see the apex dashboard in the IE or google chrome, part of screen goes missing.Last part of dashboard doesn't come but it works fine in Mozilla Firefox.What should I do? Is there some settings I need to do in IE.I am using the IE version 9.0 for 64 bit.

View 0 Replies View Related

Application Express :: Why Buttons From Theme Distorted When Viewing In Google Chrome

Jun 4, 2013

I did an application and i used "Bluejay Theme" and found out that the buttons are distorted when viewing in Google Chrome. Strangely it doesn't happened when viewing in IE or Firefox.

From Chrome -

[URL].......

From Firefox or IE -

[URL]........

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved