Hi Chris,
SQL Server would provide the closet mapping to Virtuoso ...
Regards
Hugh
On 4 Aug 2008, at 17:49, Chris Baker wrote:
They do say that you could try extending one of the existing
Dialects. I wonder which one is closest to Virtuoso.
On Mon, Aug 4, 2008 at 12:08 PM, Chris Baker <ign...@gmail.com> wrote:
Hey Hugh,
Actually all of the databases on that page that aren't marked with
"requires Dialect" already have a Dialect included in the Hibernate
core library. This basically means that all of the supported
databases have Dialects.
I would say that Hibernate definitely lacks the "intelligence" to
figure things out on its own. By examining the code for the
Dialects you can get a jist of how it all fits together. Not being
someone who's spent any time under the hood with Hibernate it's not
a task that I'd like to undertake lightly.
I'm betting that the Hibernate team would be a real help in
creating such a Dialect and that it would be a big plus in bringing
more Java developers into the fold.
Chris
On Mon, Aug 4, 2008 at 11:31 AM, Hugh Williams
<hwilli...@openlinksw.com> wrote:
Hi Chris,
Doesn't Hibernate at least look to deduce answers to these
questions via JDBC metadata calls? JDBC, like ODBC, possesses
extensive metadata oriented APIs that data access clients are
really supposed to use in relation to deducing underlying SQL
engine behavior.
If Hibernate lacks such intelligence (I desperately hope not), then
it might provide us with guidance for an effective solution i.e. a
clear layer for deducing behavior across a JDBC Driver that
implements the JDBC metadata APIs.
Note also their appear to be many other databases Hibernate has
been tested with for which their is not a specific SQL Dialect
plugin as detailed at:
http://www.hibernate.org/80.html
Indicating this is not an absolute requirement it would seem.
Thus I would suggest you try using both products and if any issues
are encountered that you feel are Virtuoso specific do report them
and will shall be glad to assist in resolution ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
On 4 Aug 2008, at 15:08, Chris Baker wrote:
Hey Hugh,
There's no specific problem. I'm just a test first kind of guy and
and want to make sure that something is compatible before
committing. The Hibernate Dialects are mapped to specific vendors
not to any standard. Something can be SQL 99 compliant in many
different ways. Hibernate needs to have its hand held by
specifically pointing out how things work, such as joins and
functions etc.
Since there is no OpenLink Hibernate Dialect that means that I
can't be sure how the technologies will interact. That's a big
wild card in my book and as a developer I don't like wild cards.
My next step in all this is to reach out to the Hibernate
Development list for some tips on creating such a Dialect.
thanks for your help
Chris
On Mon, Aug 4, 2008 at 8:23 AM, Hugh Williams
<hwilli...@openlinksw.com> wrote:
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
---------------------------------------------------------------------
----
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
