Hello Jukka, I'm sorry for temporary inconvenience. RDF mapping will support more column datatypes, the patch is coming soon. In the current version, supported types are integer, varchar, date, datetime, timestamp; incompletely supported are long varchar and long varbinary. A possible workaround is to use a intermediate view that will adjust column types: create view xyz as (select UnitInStock as IntUnits integer, ... /* other required columns here */ from "Demo"."demo"."Products"); This view will be absolutely transparent for SQL optimizer, adding no run-time costs, in the same time it can be used as a source for RDF view before the patch is ready. Best Regards, Ivan Mikhailov, OpenLink Software. ________________________________
From: virtuoso-users-boun...@lists.sourceforge.net [mailto:virtuoso-users-boun...@lists.sourceforge.net] On Behalf Of Jukka Villstedt Sent: Tuesday, March 20, 2007 3:40 AM To: virtuoso-users@lists.sourceforge.net Subject: [Virtuoso-users] SQL to RDF mapping Hello, I'm doing an SQL to RDF mapping for part of the virtuoso demo database and I get the following error message: "The datatype of column "UnitsInStock" of table "Demo.demo.Products" (COL_DTP=188) can not be mapped to an RDF literal in current version of Virtuoso" That column is of type SMALLINT. How could I overcome this restriction? It would be ok to threat all RDF literals as untyped for my purposes. -Jukka
