Exception at TestETVSM.java

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Execute TestETVSM.java

What is the expected output? What do you see instead?

I expected to see the same result found at "eTVSM Themis Java API
tutorial", but there is an exception because the function itopic_add
receives text and text altouth it`s called with numeric and text.

Exception in thread "main" org.postgresql.util.PSQLException: ERROR:
function etvsm_ontology.itopic_add(numeric, text) does not exist
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.
java:1548)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1
316)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
452)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statem
ent.java:351)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
344)
        at
org.themis.ir.etvsm.eTVSMOntology.dumpWNSynsetMF(eTVSMOntology.java:155)
        at testethemis.TestETVSM.main(TestETVSM.java:29)
Java Result: 1

What version of the product are you using? On what operating system?
Last version from the repository (from 03/09/2009).

Please provide any additional information below.
- PostgreSQL 8.3.6 on i386-apple-darwin, compiled by GCC
i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build 5370)
- JVM 1.5.0_16-133 
- Mac OS X Leopard.

Original issue reported on code.google.com by marcelo....@gmail.com on 9 Mar 2009 at 6:14

[GoogleCodeExporter]

Try to use PostgreSQL 8.2, this should solve the problem.

Original comment by artem.po...@gmail.com on 11 Mar 2009 at 8:38

• Changed state: Accepted

[GoogleCodeExporter]

- Ok, the test works whith PostgreSQL 8.2

- But i tested eTVSM whith the following documents (each line is a document):

# location location location, location based services, bright future, mobile
computing, proponents, marketplace

# analytics, mountains

# videoconferencing capabilities, web accessibility, algorithm, robot, high 
speed

# computer infrastructures, high throughput, service mobility, services 
architecture,
grid services, ogsa, federated, data management, interoperability, scenarios

# internet protocol, security issues

# dynamic trust, system elements, management trust, careful evaluation, trust
management, private service, service resources, credentials

# policy management, life cycle, negotiation, complexity, developers, state 
machine

# locality optimizations, code optimizations, benchmark programs, refactoring, 
slo,
execution

# open source implementation, digital library project, physical books, 
electronic
books, web browsers, hyperlinks

# computer society members, fellow status, csda, society awards, certifications
temporal model, environments

# hardware software codesign, life cycle model, consumer electronics companies,
adaptive hardware, survival kit, profits

# distribution platforms, digital distribution, marketer, creators, audiences

# government regulation, specter, free speech, consolidation, search engine

# isabel beichl, computational scientists

# peer reviewers, special thanks, volunteers, amp, high quality, science

- The searched term was "computer"; but the result was empty.

Original comment by marcelo....@gmail.com on 12 Mar 2009 at 12:21

[GoogleCodeExporter]

Sorry, i made a mistake.

Original comment by marcelo....@gmail.com on 12 Mar 2009 at 11:57

[GoogleCodeExporter]

Hi, I am very interested in Themis. But I don't know how to configure the 
system. I
tried PostgreSQL 8.2, but not all the sql insertion working. And the problem 
about
"function doesn't exist" like marcelo.aiwww mentioned above happened to me as 
well.

Would you please tell me how I can configure the system and make Themis work? 

Thanks a lot.

Original comment by panqi...@gmail.com on 12 Aug 2009 at 6:07

[GoogleCodeExporter]

I gave up using ETVSM. Now i'm using only VSM whith PostgreSQL 8.4.

Original comment by marcelo....@gmail.com on 12 Aug 2009 at 12:38

[GoogleCodeExporter]

Here is the quick fix

create or replace function etvsm_ontology.itopic_add(numeric, text) 
  returns integer as
$BODY$
begin
  return etvsm_ontology.itopic_add(cast($1 as text), $2);
end;
$BODY$
  language plpgsql volatile 
  cost 100;

create or replace function etvsm_ontology.tmap_add(numeric, character varying)
  returns integer as
$BODY$
begin
  return etvsm_ontology.tmap_add(cast($1 as text), cast($2 as text));
end;
$BODY$
  language plpgsql volatile
  cost 100;

Original comment by vtqve...@gmail.com on 20 Aug 2010 at 8:57