# Cant connect to Azure database

**URL:** <https://discourse.hibernate.org/t/cant-connect-to-azure-database/854>\
**Category:** Hibernate ORM\
**Created:** [May 27, 2018, 10:43pm UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854 "2018-05-27T22:43:09Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jason1234](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/jason1234/32/206_2.png) [@jason1234](https://discourse.hibernate.org/u/jason1234)\
**Post date:** [May 27, 2018, 10:43pm UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854/1 "2018-05-27T22:43:09Z")

</div>

Hello,

Just started using hibernate. I connected fine with MySql but I am having a hard time connecting to Azure. I have a feeling I am not entering the connection correctly for it. Below is the error.

```auto
May 27, 2018 3:34:18 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.3.0.Beta1}
May 27, 2018 3:34:18 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
May 27, 2018 3:34:18 PM org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-configuration. Use namespace http://www.hibernate.org/dtd/hibernate-configuration instead. Support for obsolete DTD/XSD namespaces may be removed at any time.
May 27, 2018 3:34:18 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
May 27, 2018 3:34:18 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError
	at dao.SEDAOImpl.getEntities(SEDAOImpl.java:33)
	at service.SEService.getEntities(SEService.java:27)
	at gui.StudentGUI.getStudents(StudentGUI.java:155)
	at gui.StudentGUI.buildTable(StudentGUI.java:142)
	at main.Main_GUI.view(Main_GUI.java:174)
	at main.Main_GUI.lambda$1(Main_GUI.java:84)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.AbstractButton.doClick(Unknown Source)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:270)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:232)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:209)
	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:241)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:209)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:356)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:112)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:84)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:470)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:91)
	at org.hibernate.boot.MetadataSources.buildMetadata(MetadataSources.java:179)
	at util.HibernateUtil.<init>(HibernateUtil.java:19)
	at util.HibernateUtil.<clinit>(HibernateUtil.java:11)
	... 44 more
Caused by: org.hibernate.boot.registry.classloading.spi.ClassLoadingException: Unable to load class [>com.microsoft.sqlserver.jdbc.SQLServerDriver]
	at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:348)
	at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.loadDriverIfPossible(DriverManagerConnectionProviderImpl.java:163)
	at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildCreator(DriverManagerConnectionProviderImpl.java:119)
	at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:103)
	at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:75)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:241)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:209)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
	at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
	at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
	at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:258)
	... 58 more
Caused by: java.lang.ClassNotFoundException: Could not load requested class : >com.microsoft.sqlserver.jdbc.SQLServerDriver
	at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl$AggregatedClassLoader.findClass(ClassLoaderServiceImpl.java:336)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.classForName(ClassLoaderServiceImpl.java:345)
	... 70 more

```

Here are the screenshots of my setup:

![pic3](https://cdck-file-uploads-canada1.s3.dualstack.ca-central-1.amazonaws.com/flex035/uploads/hibernate/original/1X/15b5d467178a97b283ce1dfc623dff99cf22ca5a.JPG)

---

<div class="post-metadata">

**Author:** ![vlad](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/vlad/32/658_2.png) [@vlad](https://discourse.hibernate.org/u/vlad)\
**Post date:** [May 28, 2018, 1:53am UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854/2 "2018-05-28T01:53:43Z")

</div>

You are missing the SQL Server JDBC Driver from the clasdpath.

---

<div class="post-metadata">

**Author:** ![jason1234](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/jason1234/32/206_2.png) [@jason1234](https://discourse.hibernate.org/u/jason1234)\
**Post date:** [May 28, 2018, 2:47am UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854/3 "2018-05-28T02:47:20Z")

</div>

Yeah, I figured it out. Had to do some re configs. Now I am getting’ Incorrect syntac near ‘auto\_increment’’ when creating a table in azure

---

<div class="post-metadata">

**Author:** ![vlad](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/vlad/32/658_2.png) [@vlad](https://discourse.hibernate.org/u/vlad)\
**Post date:** [May 28, 2018, 3:22am UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854/4 "2018-05-28T03:22:53Z")

</div>

That’s because you are using the `MySQLDialect` instead of the `SQLServer2012Dialect`.

---

<div class="post-metadata">

**Author:** ![p3consulting](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/p3consulting/32/565_2.png) [@p3consulting](https://discourse.hibernate.org/u/p3consulting)\
**Post date:** [May 28, 2018, 5:27am UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854/5 "2018-05-28T05:27:39Z")

</div>

Also the URL string seems to be a mix of SQLServer and MySQL settings: jdbc: **_sqlserver1_** ://sedb. **mysql**.database.azure.com: **3306**

---

<div class="post-metadata">

**Author:** ![jason1234](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/jason1234/32/206_2.png) [@jason1234](https://discourse.hibernate.org/u/jason1234)\
**Post date:** [May 28, 2018, 6:05am UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854/6 "2018-05-28T06:05:45Z")

</div>

Thanks again! It worked.

---

<div class="post-metadata">

**Author:** ![jason1234](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/jason1234/32/206_2.png) [@jason1234](https://discourse.hibernate.org/u/jason1234)\
**Post date:** [May 28, 2018, 6:06am UTC](https://discourse.hibernate.org/t/cant-connect-to-azure-database/854/7 "2018-05-28T06:06:51Z")

</div>

I was able to connect using jdbc:sqlserver://sedb.database.windows.net:1433