# Adabas SQLGateway & Hibernate **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Adabas-Add-on-Products, SQL-Access, Mainframe-Integration, CONNX\ **Created:** [May 7, 2009, 8:56am UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147 "2009-05-07T08:56:05Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![tamino\_man](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/tamino_man/32/98_2.png) [@tamino\_man](https://techcommunity.softwareag.com/u/tamino_man)\ **Post date:** [May 7, 2009, 8:56am UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/1 "2009-05-07T08:56:05Z")
Hi. I want to use Adabas SQL Gateway(CONNX) with Hibernate(version 3.1). But Hibernate seem to is not support Adabas SQL Gateway. (Dialect class for Adabas SQL Gateway is not exist.) I must add a new Dialect class? or Dialect class for Adabas SQL Gateway is already exist? If someone knows , Please teach me. ---
**Author:** ![Curtis\_Pew](https://avatars.discourse-cdn.com/v4/letter/c/5f9b8f/32.png) [@Curtis\_Pew](https://techcommunity.softwareag.com/u/Curtis_Pew)\ **Post date:** [May 13, 2009, 1:05am UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/2 "2009-05-13T01:05:48Z")
I don ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [May 13, 2009, 5:16pm UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/3 "2009-05-13T17:16:38Z")
Please try the attached CONNXDialect [CONNXDialect.java](https://techcommunity.softwareag.com/uploads/short-url/vieSvFf92kPiCk3UuqlIPOHCzGn.java) (7.36 KB) ---
**Author:** ![tamino\_man](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/tamino_man/32/98_2.png) [@tamino\_man](https://techcommunity.softwareag.com/u/tamino_man)\ **Post date:** [May 14, 2009, 11:35am UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/4 "2009-05-14T11:35:27Z")
Thank you for your reply. I try CONNXDialect. I appreciate your kindness. ---
**Author:** ![BoBlepepeur](https://avatars.discourse-cdn.com/v4/letter/b/5e9695/32.png) [@BoBlepepeur](https://techcommunity.softwareag.com/u/BoBlepepeur)\ **Post date:** [October 14, 2010, 1:38am UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/5 "2010-10-14T01:38:44Z")
Hi ! I use Adabasd in my enterprise with jboss and i see that a lot of people search a dialect to speak good with, so i make one, i hope that it can help some peoples 😉 > **[AdabasD dialect for hibernate - Browse Files at SourceForge.net](https://sourceforge.net/projects/adabasddialect/files/)** > > 1.2 is ready ! Java dialect to use with hibernate to communicate with adabasd database, READ the doc.txt to use !!! Thanks if you want to donate ;-) ---
**Author:** ![tamino\_man](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/tamino_man/32/98_2.png) [@tamino\_man](https://techcommunity.softwareag.com/u/tamino_man)\ **Post date:** [October 14, 2010, 2:02pm UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/6 "2010-10-14T14:02:11Z")
Hi ! BoBlepepeur Thanks for your nice information. But I don’t use AdabasD. (I use Adabas + SQLGateway) When I use AdabasD , I will use your Dialect class. By the way, your Dialect class is not supported an offset yet? If AdabasD is support an offset, I think better support it.(Unfortunately SQLGateway is not supported it.) ---
**Author:** ![BoBlepepeur](https://avatars.discourse-cdn.com/v4/letter/b/5e9695/32.png) [@BoBlepepeur](https://techcommunity.softwareag.com/u/BoBlepepeur)\ **Post date:** [October 18, 2010, 7:33pm UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/7 "2010-10-18T19:33:50Z")
😉 i don’t know if hibernate want to support my dialect in theire newier version, but for the moment i maintain the code 😉 ---
**Author:** ![Joao\_Silva](https://avatars.discourse-cdn.com/v4/letter/j/a698b9/32.png) [@Joao\_Silva](https://techcommunity.softwareag.com/u/Joao_Silva)\ **Post date:** [May 22, 2019, 2:21pm UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/8 "2019-05-22T14:21:18Z")
Does someone have connxdialect.java file available for download ?? I can´t download it from the link above. Thx ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 2:54pm UTC](https://techcommunity.softwareag.com/t/adabas-sqlgateway-hibernate/85147/9 "2021-04-02T14:54:19Z")