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 >> > >
