Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-04 Thread Hugh Williams
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 wro

Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-04 Thread Chris Baker
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 wrote: > Hey Hugh, > > Actually all of the databases on that page that aren't marked with > "requires Dialect" already have a Dialect inc

Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-04 Thread Chris Baker
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

Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-04 Thread Hugh Williams
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 lac

Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-04 Thread Chris Baker
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

Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-04 Thread Hugh Williams
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 hand

Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-03 Thread Chris Baker
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 specif

Re: [Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-03 Thread Hugh Williams
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 the

[Virtuoso-users] Virtuoso Hibernate Dialect

2008-08-02 Thread Chris Baker
Heynow, Does anyone know anything about a Hibernate dialect for Virtuoso? thanks Chris