Hi Chris,
Virtuoso is an ANSI SQL (89, 92, 99/SQL3) compliant engine and as
such we would expect Hibernate to have Standard ANSI SQL Dialect that
can be used or is probably used by default enabling Virtuoso to be
used with it.
Is their a specific problem you are experiencing with the handling of
date and time data types in reference to your comment below ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
The user specifically highlights the handling of TIMESTAMP casting as
an example, thus I shall find out if this in a specific problem being
encountered in what he is trying to do ...
On 3 Aug 2008, at 20:49, Chris Baker wrote:
Hey Hugh,
JDBC works great.
The secret sauce that gets Hibernate to work is a dialect class
that abstracts away the specific flavor of SQL for a database
vendor. For instance how OpenLink manages dates and times through a
TIMESTAMP type with casting functions. When you set up Hibernate
you specify which SQL dialect you want to use. I haven't been able
to find anything anywhere about something like this for Virtuoso.
I'm not sure what the effect would be of just connecting to
Hiberate without specifying the dialect. The documentation warns
you that you need to specify one.
As Hibernate is becoming the most popular ways of interacting with
relational databases in Java, especially now with the JPA standard,
I would think that a dialect would be a huge plus.
Chris
On Sun, Aug 3, 2008 at 9:33 AM, Hugh Williams
<hwilli...@openlinksw.com> wrote:
Hi Chris,
Can you describe in more detail how your are attempting or would
expect to be using hibernate with Virtuoso, which I presume is the
object/relational persistence and query service for Java (http://
www.hibernate.org/) ? From tests we have performed with Hibernate
in the past their is a binding to JDBC and as Virtuoso has its own
JDBC driver their is no specific dialect required for Virtuoso you
simply invoke the JDBC Driver for your target database (Virtuoso in
this case) and it should work. The Virtuoso JDBC Driver details are:
Driver File Name = virtjdbc3.jar (located in ~/libsrc/JDBCType4 of
your VOS installation)
Driver Class Name = virtuoso.jdbc3.Driver
Driver Connect String format = jdbc:virtuoso://<Hostname>:<Port#>/
DATABASE=<dbname>/UID=<user name>/PWD=<password>/
Further details on the Virtuoso JDBC Driver can be obtained from:
http://docs.openlinksw.com/virtuoso/VirtuosoDriverJDBC.html
Please let us know if this helps ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
http://www.openlinksw.com
On 3 Aug 2008, at 02:24, Chris Baker wrote:
Heynow,
Does anyone know anything about a Hibernate dialect for Virtuoso?
thanks
Chris
----------------------------------------------------------------------
---
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
----------------------------------------------------------------------
---
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
