Supported Databases

The largest (multi-Terabyte) databases in the world are run on DB2 or 
Teradata (Oracle claims to have multi-TB systems but nobody can find 
them).  Yet Teradata isn't listed here?

On 21 Oct 2003 18:43, swordsman wrote:

>The largest (multi-Terabyte) databases in the world are run on DB2 or
>Teradata (Oracle claims to have multi-TB systems but nobody can find
>them).  Yet Teradata isn't listed here?

So, write a Dialect. This is usually easy.

From what I can see CLOB / CLOB support varies for these databases and 
drivers:

1) MySQL 4.0.16 using Connector 3.0.8 driver: Excellent (1,000,000 
char clob works)
2) Oracle 9.2.0.2 using Oracle thin driver 9.2.0.3: Good. Works for 
4000 char clobs, but I get errors trying to deal with anything 
bigger.. possibly a sqlplus option that needs to be set.
3) Microsoft SQL Server 7.0 using jTDS 0.5 / 0.6: Clob support is 
expected to be fully built into 0.6 final version, although 0.5 has 
some support (I haven't yet tested this with Hibernate though)
4) Sybase ASE 11.9.2 using Sybase jConnect 5.5 driver: Clob support is 
missing.  It seems the driver uses a proprietary API to implement CLOB 
("text" in Sybase terminology) support.

I would just like to say that I have been using Hibernate (2.1.2) with
Ingres for about 3 months now, and everything works fine. I haven't come
across anything yet that I have had to work around. Currently using the
Caribou Lake drivers, but I'm sure the CA ones work just as well.

Hibernate works fine not only with SAP DB 7.3. Tested without 
any problems on SAP DB 7.4 and MySQL Max DB 7.5. Respect !

If you're getting erros use the "DB2 AS400" Dialect instead of the 
plain "DB2" Dialect.  Initially the SQL generated by Hibernate gave me 
syntax errors from the DB2 JDBC Driver.  Once I switched the Dialect 
to DB2 AS400 Hibernate generated completely different SQL that 
executed without error.

On 29 Mar 2004 18:59, tlh1005 wrote:

>If you're getting erros use the "DB2 AS400" Dialect instead of the
>plain "DB2" Dialect.  Initially the SQL generated by Hibernate gave
me 
>syntax errors from the DB2 JDBC Driver.  Once I switched the Dialect
>to DB2 AS400 Hibernate generated completely different SQL that
>executed without error.

If you don't mind, how much have you "exercised" Hibernate against a 
DB2 for OS390 database?  Was there an application written that is in 
use?  Are there any "gotchas" (performance or compatibility) one might 
like to know before using Hibernate against DB2 for OS390?

Thanks.

On 25 Mar 2004 08:15, any_key wrote:

>Hibernate works fine not only with SAP DB 7.3. Tested without
>any problems on SAP DB 7.4 and MySQL Max DB 7.5. Respect !

---------------------------------------
Hi There,

In order to use Hibernate with MySQL MaxDB, would I use the 
configuration settings (dialect etc.) provided for SAP-DB from which 
it is derived? If not, could you please let me see a sample (or the 
relevant fragment) of your hibernate-config file for MaxDB?

Also, does automated DDL schema generation work fine for MaxDB?

Thanks in advance.
Gopal 
gopal (at) psybergate (dot) com

Does Hibernate also support Pervasive.SQL ?
If not, is there a default/standard (i.e. producing not DBMS-
dependant /pure SQL statements) dialect which could be used ?

Thx,

Bernard.

The driver included with SQL Server is version 2.2 of DataDirect’s 
JDBC driver.  The current version of Connect for JDBC commercially 
available from DataDirect is 3.3 and offers a Type 4 JDBC driver for 
high-performance database connectivity for all major databases - 
Oracle, DB2, MS SQL Server, Sybase and Informix. Our drivers support 
the latest database features, such as JTA (Java Transaction API) and 
Windows Authentication for SQL Server.  More Information may be found 
at www.datadirect.com. 

We do not know of any issues with the SequeLink JDBC driver.  

Nancy Vodicka
JDBC Product Marketing Manager
DataDirect Technologies
www.datadirect.com

On 16 Apr 2004 18:58, gopalrc wrote:

>On 25 Mar 2004 08:15, any_key wrote:

>>Hibernate works fine not only with SAP DB 7.3. Tested without
>>any problems on SAP DB 7.4 and MySQL Max DB 7.5. Respect !

>---------------------------------------
>Hi There,

>In order to use Hibernate with MySQL MaxDB, would I use the
>configuration settings (dialect etc.) provided for SAP-DB from which
>it is derived? If not, could you please let me see a sample (or the
>relevant fragment) of your hibernate-config file for MaxDB?

>Also, does automated DDL schema generation work fine for MaxDB?

>Thanks in advance.
>Gopal
>gopal (at) psybergate (dot) com

hi,

you must only set the dialect and the standard options like password, 
url, driver and it works fine for sapb 7.4 and maxdb. seqeunce and 
case sensitive names works also fine.

gert

Has anyone verified oracle7 support In particular using  the weblogic 
type 4 jdbc driver (provided in WLS8.1)?

I had issues getting Firebird to work.  I think they were more problems
with Firebird (1.5) than hibernate.  Kept getting constraint errors that
should not have occured.  Not recommended.

On 02 Jul 2004 03:11, gstamp wrote:

>I had issues getting Firebird to work.  I think they were more problems
>with Firebird (1.5) than hibernate.  Kept getting constraint errors that
>should not have occured.  Not recommended.

I have had excellent success so far with Firebird (although I am using a
newer version).  If you are having issues, maybe you should try
upgrading to the latest release (1.5.1 at this writing).  Many bugs in
Firebird itself were fixed in this release, after a long beta period.  I
am currently using it with a recent version of Hibernate with no problems.

I see this database engine as a major contender to other enterprise
platforms with great support for a wide range of operating systems.  I
recommend it to anyone looking for an alternative to Oracle or DB2, or
even some of the smaller database engines out there (it doesn’t seem to
have much overhead in my testing).

Greg

There is missing support for "current".
Something like 
registerFunction("current", new NoArgSQLFunction
(Hibernate.TIMESTAMP) );

Does anybody have experience with this:

How do you control locking with Hibernate on MSSQL DB?

Currently I'm using native SQL:

<sql-query name="missingDataQuery">
<return alias="md" class="com.generalynx.ecos.data.MissingData"/>
SELECT {md.*}
FROM missingdata {md}
WITH(rowlock, holdlock)
WHERE {md}.egidasource_id = :sourceId
AND {md}.status = :status
</sql-query>

Is there a way to do this 'object oriented'?
Is there a way to control which hint goes into 'what' clause?

Since I have this problem:
I have scheduled data getting service which starts in n threads. And 
all of these threads are reading/inserting/updating the same table 
(missingdata). No service/thread reads the same data (row) = 
intersection of read collections in each thread is empty.

In each thread I start a transaction, reading short (< 10) list of 
MissingData, making each of them 'dirty' by changing property and 
inserting a few new MissingData.
Before I had problems with updating - so I locked each read row (see 
query). But now I get a deadlock while inserting.

Is there a way to control locking on inserts?

What is to do here?

Thanx, Ales

On 27 Apr 2004 10:59, bligny wrote:

>Does Hibernate also support Pervasive.SQL ?
>If not, is there a default/standard (i.e. producing not DBMS-
>dependant /pure SQL statements) dialect which could be used ?

>Thx,

>Bernard.

Hi,

I've just started using Pervasive.SQL with Hibernate. In terms of
persistence behaviours, Pervasive is very close to SQLServer - that is
the dialect that I am currently using. If I get any problems I'll create
a new PervasiveDialect class.

Let me know if you have any problems with the SQLServer dialect.

Cheers,

Ben.

On 03 Dec 2004 12:46, bmorgan wrote:

>On 27 Apr 2004 10:59, bligny wrote:

>>Does Hibernate also support Pervasive.SQL ?
>>If not, is there a default/standard (i.e. producing not DBMS-
>>dependant /pure SQL statements) dialect which could be used ?

>>Thx,

>>Bernard.

>Hi,

>I've just started using Pervasive.SQL with Hibernate. In terms of
>persistence behaviours, Pervasive is very close to SQLServer - that is
>the dialect that I am currently using. If I get any problems I'll create
>a new PervasiveDialect class.

>Let me know if you have any problems with the SQLServer dialect.

>Cheers,

>Ben.

Hi,

Ignore my last message! You're better off subclassing the Sybase dialect
to create a Pervasive dialect. I'm actually using the Sybase dialect
until I have to change it.

Cheers,

Ben.

Has anyone tried Hibernate with Cloudscape?
Cloudscape is very similar to DB2, so it should work.....

On 16 Dec 2004 05:09, jdk31 wrote:

>Has anyone tried Hibernate with Cloudscape?
>Cloudscape is very similar to DB2, so it should work.....

I have used Hibernate in the context of JBoss (v4.0.1RC2) and this 
reply is largely in that context.

Cloudscape 5.1.20 does not seem to work with JBoss because for some 
reason the metadata lookup fails.

However, Derby 10.0.2.1 (http://incubator.apache.org/derby/) does work 
with JBoss and Hibernate without any errors. Since this the latest 
open source cut of the Cloudscape version, I guess it would work with 
the latest version of Cloudscape too.

However there are one or two things to watch out. There is no 
DerbyDialiect support in Hibernate at the moment. This can however be 
downloaded from:

http://opensource.atlassian.com/projects/hibernate/browse/HB-1224

compiled and inserted into hibernate's jar.

Hope this helps.

Cheers
-raj

Does anyone have any experience in using the Micorsoft drivers and
net.sf.hibernate.dialect.SQLServerDialect for MS Access?

On 14 Jan 2005 11:42, rory steele wrote:

>Does anyone have any experience in using the Micorsoft drivers and
>net.sf.hibernate.dialect.SQLServerDialect for MS Access?


I try but when a call a find an exception is throws:

[Microsoft][Driver ODBC Microsoft Access]SELECT intruction includes a 
reserved keyword or an argument is wrong ...

I try also with different dialect, but the result is the same...

P.S. Exceuse me for my english... The error is in italin, I try to 
translate it.

is Oracle's NVARCHAR2 mapped in Hibernate? Can I use "string" as it is 
the case with VARCHAR2?

thx
seid

On 26 Jan 2005 07:01, seid wrote:

>is Oracle's NVARCHAR2 mapped in Hibernate? Can I use "string" as it is
>the case with VARCHAR2?

Extend your own dialect from Hibernate Oracle dialect and overwrite the
String type with the NVARCHAR2.

A table column of 'date' datatype in oracle 8.1.7 don't store millisec.
So I think that timestamps can't be used with this db.
Update in the same second brings an error.

I'm rigth?

thanx

On 10 Feb 2005 11:35, stefano arosio wrote:

>A table column of 'date' datatype in oracle 8.1.7 don't store millisec.
>So I think that timestamps can't be used with this db.
>Update in the same second brings an error.

>I'm rigth?

>thanx

Close.  This is a bug in the 2.x version of hibernate that it
seems will never be fixed.  Hibernate 2.x maps "timestamp" to
"date" in oracle, so you only get day resolution for date,
timestamp, and even time (!).

See the bug database for more info:

http://opensource.atlassian.com/projects/hibernate/browse/HB-1049

On 22 Jan 2004 10:44, themax wrote:

>From what I can see CLOB / CLOB support varies for these databases and
>drivers:

>2) Oracle 9.2.0.2 using Oracle thin driver 9.2.0.3: Good. Works for
>4000 char clobs, but I get errors trying to deal with anything
>bigger.. possibly a sqlplus option that needs to be set.

Oracle says NOT A BUG.

Use OCI, or use JDBC-Thin-Driver specfic streaming methods for larger
than 4000.

On 07 Mar 2005 04:37, grrrrr wrote:

>On 22 Jan 2004 10:44, themax wrote:

>>From what I can see CLOB / CLOB support varies for these databases
and 
>>drivers:

>>2) Oracle 9.2.0.2 using Oracle thin driver 9.2.0.3: Good. Works for
>>4000 char clobs, but I get errors trying to deal with anything
>>bigger.. possibly a sqlplus option that needs to be set.

>Oracle says NOT A BUG.

>Use OCI, or use JDBC-Thin-Driver specfic streaming methods for larger
>than 4000.

I would also recommend using the Oracle 10g JDBC driver if possible. 
It works with Oracle8 and Oracle9i, and provides a fix for this 
limitation. If you set the connection 
property "SetBigStringTryClob=true", no need for Clobs as big (4k+) 
strings will work in PreparedStatements, etc. We made the change and 
all of our Pojos now use strings (no Clobs). We routinely (and 
unfortunately) sling 6-8k string (xml) blobs to Oracle9i CLOB columns 
using java.lang.String mappings in Hibernate 2.1.8. No problems 
encountered so far.

On 29 Mar 2004 18:59, tlh1005 wrote:

>If you're getting erros use the "DB2 AS400" Dialect instead of the
>plain "DB2" Dialect.  Initially the SQL generated by Hibernate gave
me 
>syntax errors from the DB2 JDBC Driver.  Once I switched the Dialect
>to DB2 AS400 Hibernate generated completely different SQL that
>executed without error.

There is a DB2390Dialect available which should be used for DB2 on 
OS390.

Has anybody investigated adding Hibernate support for sqlite3? It would be 
a neat way to get simple setups going quickly.

The list at top has both items - one can be removed. Or are they different?

Btw. HSQL DB 1.8 has new system table names, which prevent the current
dialect to work correctly with sequences.

Cheers,
Christian

Has anyone tested Hibernate with Derby? Derby is the open source version
of Cloudscape. http://incubator.apache.org/derby/

Just wanted to mention that we have been using postgresql 8 on windows
and linux for several months now and have not had any problem.  In fact,
it has been quite nice.  Might want to add it to the list.

The getting started day 1 example in the "eg" directory of the hibernate
distribution is not compatible with MySQL because a field uses an
apparantly reserved word "condition".  The "fix" is to change the
example source code and mapping files to rename the field and associated
g/setters.

See forum topics
http://forum.hibernate.org/viewtopic.php?t=949370
http://forums.mysql.com/read.php?101,40643,40643

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!On 14 Jan 2005 11:42, rory steele wrote:

>Does anyone have any experience in using the Micorsoft drivers and
>net.sf.hibernate.dialect.SQLServerDialect for MS Access?

I have written my own dialect for MS Access, which is working for me
with the Sun JDBC/ODBC bridge. The dialect is not complete, nor tested
thoroughly, but does just what I need.

I can send it to you. Maybe you've written your own since January.

Toby

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE 
PAGE!On 09 Nov 2005 10:21, tobych wrote:

>POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
>PAGE!On 14 Jan 2005 11:42, rory steele wrote:

>>Does anyone have any experience in using the Micorsoft drivers and
>>net.sf.hibernate.dialect.SQLServerDialect for MS Access?

>I have written my own dialect for MS Access, which is working for me
>with the Sun JDBC/ODBC bridge. The dialect is not complete, nor tested
>thoroughly, but does just what I need.

>I can send it to you. Maybe you've written your own since January.

>Toby

Hello,
I have used Access with JDBC/ODBC bridge in 3.0 but when I try to 
insert records into the table using the session.save() method, nothing 
happens.

Kindly help.

gadiga

hello every one ,

I need hibernate dialect for MS access .
any suggestion will be highly appreciable

my mail id:saleeminsha (at) gmail (dot) com
           :saleem.khan (at) daffodildb (dot) com


Regards
saleem

hello rory steele and  tobych ,
I am requesting to both of you to suggest me for the hibernate dialect
for ms access.can you give me the dialect for the ms access.

I will be highly thanfful to you.

my mail ids::saleeminsha (at) gmail (dot) com
           ::saleem.khan (at) daffodildb (dot) com


regards 
saleem

>hello rory steele and  tobych ,
>I am requesting to both of you to suggest me for the hibernate dialect
>for ms access.can you give me the dialect for the ms access.

>I will be highly thanfful to you.

>my mail ids::saleeminsha (at) gmail (dot) com
>           ::saleem.khan (at) daffodildb (dot) com

I've uploaded it to

http://www.tobychampion.co.uk/Access2000Dialect.java.txt

Let me know how you get on.

toby (at) tobychampion.co.uk

Toby Champion

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!On 03 Jan 2006 11:45, saleem.khan wrote:

>hello every one ,

>I need hibernate dialect for MS access .
>any suggestion will be highly appreciable

>my mail id:saleeminsha (at) gmail (dot) com
>           :saleem.khan (at) daffodildb (dot) com

I've posted mine here:

http://www.tobychampion.co.uk/Access2000Dialect.java.txt

Toby Champion
toby (at) tobychampion.co.uk

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!On 12 Jan 2006 12:08, tobych wrote:

>I've uploaded it to

http://www.tobychampion.co.uk/Access2000Dialect.java.txt

any chance you have updated the MSAccess Dialect for Hibernate 3?  it
appears the StrandardSQLFunction (or Hibernate class) for nullable
constructor not allowed

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE 
PAGE!On 02 Jul 2004 03:11, gstamp wrote:

>I had issues getting Firebird to work.  I think they were more
problems
>with Firebird (1.5) than hibernate.  Kept getting constraint errors
that
>should not have occured.  Not recommended.

I meet a problem about hibernate 3 + Firebird 1.5 + Tomcat 5.0 .
After insert more than 10 note into the databse, Firebird collapse.
Then I must restart the Firebird. It will no effict for only restart 
the Tomcat.
Shall I configure the Firebird or hibernate ?
I only use the JDBC.

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
PAGE!On 16 Feb 2006 09:21, slb wrote:

>POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
>PAGE!On 12 Jan 2006 12:08, tobych wrote:

>>I've uploaded it to

>http://www.tobychampion.co.uk/Access2000Dialect.java.txt

>any chance you have updated the MSAccess Dialect for Hibernate 3?  it
>appears the StrandardSQLFunction (or Hibernate class) for nullable
>constructor not allowed



Has anyone managed to successfully created an MS Access dialect for
Hibernate 3 ???

Please share!

>Has anyone managed to successfully created an MS Access dialect for
>Hibernate 3 ???
Hxtt Access dialect sample is at http://www.hxtt.com/test/hibernate.zip
, but it's for commercial HXTT Access package for Microsoft Access
version from 95, 97, 2000, XP, 2002, to 2003.

POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE 
PAGE!On 29 Nov 2005 16:13, gadiga wrote:

>POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
>PAGE!On 09 Nov 2005 10:21, tobych wrote:

>>POST QUESTIONS ON THE FORUM! COMMENTS HERE SHOULD ADD VALUE TO THE
>>PAGE!On 14 Jan 2005 11:42, rory steele wrote:

>>>Does anyone have any experience in using the Micorsoft drivers and
>>>net.sf.hibernate.dialect.SQLServerDialect for MS Access?

>>I have written my own dialect for MS Access, which is working for me
>>with the Sun JDBC/ODBC bridge. The dialect is not complete, nor
tested
>>thoroughly, but does just what I need.

>>I can send it to you. Maybe you've written your own since January.

>>Toby

>Hello,
>I have used Access with JDBC/ODBC bridge in 3.0 but when I try to
>insert records into the table using the session.save() method,
nothing 
>happens.

>Kindly help.

>gadiga

Hi Tody or gadiga
Can you provide me the acess 200 dialect for hibernate 3.0 ? Please/

Thanks
Sue

Mysql has been historically "ignorant" to transactions and this causes
me some trouble when trying to use JPA:

next code worked fine with Postgresql/HSQL/Derby:

   1 emForUserSession.getTransaction().begin();
   2 clon = emForUserSession.merge(clon);
   3 emForUserSession.getTransaction().commit();

But default Mysql setup rejects it since autocommits are executed
everywhere raising exceptions similar to:
java.lang.IllegalStateException: Transaction not active
javax.persistence.TransactionRequiredException: no transaction is in
progress

 A quick solution for me was to add the option relaxAutoCommit=true
to the driver setup in persistence.xml:
<property name="hibernate.connection.url"
value="jdbc:mysql://localhost:3306/devDDBB?relaxAutoCommit=true"/>

Postcript:
 From all the databases I had the opportunity to test against Hibernate
(JPA HibernateEntityManager actually) Postgresql was by far the ddbb
which caused me less troubles.

Firebird 2 works fine with Hibernate 3.x as far as I can tell, in 
combination with the latest Jaybird driver.

No more need to install Interclient.