java - Connecting to Azure SQL Server using Hibernate JDBC connection -


hibernate connection works local postgresql , automatically creates tables, when want use azure sql server (microsoft sql server) , change driver name etc., didn't error didn't work. (didn't create tables)

jdbc.driverclassname=com.microsoft.sqlserver.jdbc.sqlserverdriver jdbc.databaseurl=jdbc:sqlserver://xxxx.database.windows.net:1433;database=xxxx jdbc.password=xxxx jdbc.user=xxx@xxxx jdbc.encrypt=true jdbc.hostnameincertificate=*.database.windows.net jdbc.logintimeout=30; jdbc.dialect=org.hibernate.dialect.sqlserverdialect  <bean id="propertyconfigurer"       class="org.springframework.beans.factory.config.propertyplaceholderconfigurer"       p:location="/web-inf/jdbc.properties" > </bean>  <bean id="datasource"     class="org.apache.commons.dbcp.basicdatasource" destroy-method="close"     p:driverclassname="${jdbc.driverclassname}"     p:url="${jdbc.databaseurl}" p:username="${jdbc.user}"     p:password="${jdbc.password}"> </bean>  <bean id="sessionfactory" class="org.springframework.orm.hibernate4.localsessionfactorybean">     <property name="datasource" ref="datasource"/>     <property name="packagestoscan">         <list>             <value>com.xxx.entity</value>         </list>     </property>      <property name="hibernateproperties">         <props>             <prop key="hibernate.dialect">${jdbc.dialect}</prop>             <prop key="hibernate.c3p0.min_size">5</prop>             <prop key="hibernate.c3p0.max_size">20</prop>             <prop key="hibernate.c3p0.idle_test_period">60</prop>             <prop key="hibernate.c3p0.max_statements">100</prop>             <!--<prop key="hibernate.hbm2ddl.auto">${database.hbm2ddl.auto}</prop>-->             <!--<prop key="hibernate.show_sql">${database.show_sql}</prop>-->             <!--<prop key="hibernate.format_sql">${database.format_sql}</prop>-->         </props>     </property> </bean> 

azure sql quite different local ms sql server , has specific requirements.

from no error message taking stab in dark check have clustered index on each table being created. requirement on azure.


Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -