Smartgwt 3.0 EE eval.
mssql 2008 database
I'm trying to write "hibernate" datasource which uses "beanless mode" to load data from database.
My other ("standard") hibernate datasources with mappings in hbm files work perfectly (they get hibernate session object from spring).
I read "hibernate integration" menual and I created separate spring bean of "org.springframework.orm.hibernate3.LocalSessionFactoryBean".
When I try to fetch data I'm getting hibernate "not mapped errors".
Here is full log (I'm loading dsdb_Klienci datasource):
dsdb_Klienci.ds.xml:
So: I'm loading data from Klienci table (I had to define id column - without that smartgwt engine could not find pk column).
My "beanless" session factory bean (the 2nd one - the 1st one has mappings):
smartgwt.hibernate.cfg.xml:
Where did I make error?
mssql 2008 database
I'm trying to write "hibernate" datasource which uses "beanless mode" to load data from database.
My other ("standard") hibernate datasources with mappings in hbm files work perfectly (they get hibernate session object from spring).
I read "hibernate integration" menual and I created separate spring bean of "org.springframework.orm.hibernate3.LocalSessionFactoryBean".
When I try to fetch data I'm getting hibernate "not mapped errors".
Here is full log (I'm loading dsdb_Klienci datasource):
Code:
2012-05-16 14:26:18,057 [btpool0-8] DEBUG my.DatabaseDsLoader - Found datasource dsdb_Klienci. Loading...
=== 2012-05-16 14:26:18,062 [l0-8] DEBUG XML - Parsed XML from (in memory stream): 5ms
=== 2012-05-16 14:26:18,071 [l0-8] DEBUG HibernateDataSource - Obtaining local Hibernate config for DataSource 'dsdb_Klienci' vai Spring bean 'smartgwtSessionFactory'.
=== 2012-05-16 14:26:18,071 [l0-8] INFO ServerObject - DMI on Spring bean: &smartgwtSessionFactory
=== 2012-05-16 14:26:18,071 [l0-8] INFO HibernateDataSource - dynamically binding entity: dsdb_Klienci
2012-05-16 14:26:18,072 [btpool0-8] WARN org.hibernate.connection.UserSuppliedConnectionProvider - No connection properties specified - the user must supply JDBC connections
2012-05-16 14:26:18,086 [btpool0-8] WARN org.hibernate.impl.SessionFactoryObjectFactory - InitialContext did not implement EventContext
2012-05-16 14:26:18,086 [btpool0-8] DEBUG my.DatabaseDsLoader - Datasource dsdb_Klienci loaded.
=== 2012-05-16 14:26:18,126 [l0-8] INFO RequestContext - URL: '/app/sc/IDACall', User-Agent: 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header
=== 2012-05-16 14:26:18,133 [l0-8] DEBUG XML - Parsed XML from (in memory stream): 5ms
=== 2012-05-16 14:26:18,138 [l0-8] DEBUG RPCManager - Processing 1 requests.
2012-05-16 14:26:18,146 [btpool0-8] DEBUG my.DatabaseDsLoader - Found datasource dsdb_Klienci. Loading...
=== 2012-05-16 14:26:18,150 [l0-8] DEBUG XML - Parsed XML from (in memory stream): 3ms
=== 2012-05-16 14:26:18,156 [l0-8] DEBUG HibernateDataSource - Obtaining local Hibernate config for DataSource 'dsdb_Klienci' vai Spring bean 'smartgwtSessionFactory'.
=== 2012-05-16 14:26:18,156 [l0-8] INFO ServerObject - DMI on Spring bean: &smartgwtSessionFactory
=== 2012-05-16 14:26:18,156 [l0-8] INFO HibernateDataSource - dynamically binding entity: dsdb_Klienci
2012-05-16 14:26:18,157 [btpool0-8] WARN org.hibernate.connection.UserSuppliedConnectionProvider - No connection properties specified - the user must supply JDBC connections
2012-05-16 14:26:18,170 [btpool0-8] WARN org.hibernate.impl.SessionFactoryObjectFactory - InitialContext did not implement EventContext
2012-05-16 14:26:18,170 [btpool0-8] DEBUG my.DatabaseDsLoader - Datasource dsdb_Klienci loaded.
=== 2012-05-16 14:26:18,171 [l0-8] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
},
operationConfig:{
dataSource:"dsdb_Klienci",
operationType:"fetch",
textMatchStyle:"exact"
},
startRow:0,
endRow:75,
componentId:"isc_ListGrid_2",
appID:"builtinApplication",
operation:"dsdb_Klienci_fetch",
oldValues:{
}
}
=== 2012-05-16 14:26:18,171 [l0-8] INFO IDACall - Performing 1 operation(s)
=== 2012-05-16 14:26:18,171 [l0-8] DEBUG AppBase - [builtinApplication.dsdb_Klienci_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-05-16 14:26:18,171 [l0-8] DEBUG AppBase - [builtinApplication.dsdb_Klienci_fetch] No public zero-argument method named '_dsdb_Klienci_fetch' found, performing generic datasource operation
=== 2012-05-16 14:26:18,171 [l0-8] INFO HibernateDataSource - [builtinApplication.dsdb_Klienci_fetch] Performing fetch operation with
criteria: {} values: {}
=== 2012-05-16 14:26:18,177 [l0-8] DEBUG HibernateTransaction - [builtinApplication.dsdb_Klienci_fetch] Started new transaction "399243909"
=== 2012-05-16 14:26:18,177 [l0-8] INFO HibernateDataSource - [builtinApplication.dsdb_Klienci_fetch] Query string: select _dsdb_Klienci from dsdb_Klienci _dsdb_Klienci
=== 2012-05-16 14:26:18,186 [l0-8] WARN HibernateTransaction - [builtinApplication.dsdb_Klienci_fetch] Rolling back 0 database update(s)
=== 2012-05-16 14:26:18,186 [l0-8] DEBUG HibernateTransaction - [builtinApplication.dsdb_Klienci_fetch] Rolling back transaction "399243909"
=== 2012-05-16 14:26:18,188 [l0-8] WARN RequestContext - dsRequest.execute() failed:
org.hibernate.hql.ast.QuerySyntaxException: dsdb_Klienci is not mapped [select _dsdb_Klienci from dsdb_Klienci _dsdb_Klienci]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:277)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
at com.isomorphic.hibernate.HibernateDataSource.processRequest(HibernateDataSource.java:1214)
at com.isomorphic.hibernate.HibernateDataSource.executeFetch(HibernateDataSource.java:586)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1289)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:725)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1948)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:199)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:156)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:121)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
at my.web.ResponseHaeaderFilter.doFilter(ResponseHaeaderFilter.java:59)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:344)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
=== 2012-05-16 14:26:18,189 [l0-8] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2012-05-16 14:26:18,198 [l0-2] INFO RequestContext - URL: '/app/sc/IDACall', User-Agent: 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header
2012-05-16 14:26:18,198 [btpool0-8] DEBUG my.DatabaseDsLoader - Found datasource dsdb_Klienci. Loading...
=== 2012-05-16 14:26:18,206 [l0-8] DEBUG XML - Parsed XML from (in memory stream): 8ms
=== 2012-05-16 14:26:18,206 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 7ms
=== 2012-05-16 14:26:18,211 [l0-8] DEBUG HibernateDataSource - Obtaining local Hibernate config for DataSource 'dsdb_Klienci' vai Spring bean 'smartgwtSessionFactory'.
=== 2012-05-16 14:26:18,211 [l0-8] INFO ServerObject - DMI on Spring bean: &smartgwtSessionFactory
=== 2012-05-16 14:26:18,211 [l0-8] INFO HibernateDataSource - dynamically binding entity: dsdb_Klienci
2012-05-16 14:26:18,212 [btpool0-8] WARN org.hibernate.connection.UserSuppliedConnectionProvider - No connection properties specified - the user must supply JDBC connections
2012-05-16 14:26:18,230 [btpool0-8] WARN org.hibernate.impl.SessionFactoryObjectFactory - InitialContext did not implement EventContext
2012-05-16 14:26:18,230 [btpool0-8] DEBUG my.DatabaseDsLoader - Datasource dsdb_Klienci loaded.
=== 2012-05-16 14:26:18,230 [l0-8] DEBUG RPCManager - non-DMI response, dropExtraFields: false
=== 2012-05-16 14:26:18,231 [l0-8] DEBUG HibernateTransaction - Closing session "399243909"
=== 2012-05-16 14:26:18,232 [l0-8] DEBUG HibernateTransaction - Removed transaction "399243909"
=== 2012-05-16 14:26:18,236 [l0-2] DEBUG RPCManager - Processing 1 requests.
2012-05-16 14:26:18,241 [btpool0-2] DEBUG my.DatabaseDsLoader - Found datasource dsdb_Klienci. Loading...
=== 2012-05-16 14:26:18,245 [l0-2] DEBUG XML - Parsed XML from (in memory stream): 4ms
=== 2012-05-16 14:26:18,254 [l0-2] DEBUG HibernateDataSource - Obtaining local Hibernate config for DataSource 'dsdb_Klienci' vai Spring bean 'smartgwtSessionFactory'.
=== 2012-05-16 14:26:18,254 [l0-2] INFO ServerObject - DMI on Spring bean: &smartgwtSessionFactory
=== 2012-05-16 14:26:18,255 [l0-2] INFO HibernateDataSource - dynamically binding entity: dsdb_Klienci
2012-05-16 14:26:18,255 [btpool0-2] WARN org.hibernate.connection.UserSuppliedConnectionProvider - No connection properties specified - the user must supply JDBC connections
2012-05-16 14:26:18,275 [btpool0-2] WARN org.hibernate.impl.SessionFactoryObjectFactory - InitialContext did not implement EventContext
2012-05-16 14:26:18,276 [btpool0-2] DEBUG my.DatabaseDsLoader - Datasource dsdb_Klienci loaded.
=== 2012-05-16 14:26:18,276 [l0-2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
criteria:{
},
operationConfig:{
dataSource:"dsdb_Klienci",
operationType:"fetch",
textMatchStyle:"substring"
},
startRow:0,
endRow:75,
componentId:"isc_ListGrid_2",
appID:"builtinApplication",
operation:"dsdb_Klienci_fetch",
oldValues:{
}
}
=== 2012-05-16 14:26:18,276 [l0-2] INFO IDACall - Performing 1 operation(s)
=== 2012-05-16 14:26:18,277 [l0-2] DEBUG AppBase - [builtinApplication.dsdb_Klienci_fetch] No userTypes defined, allowing anyone access to all operations for this application
=== 2012-05-16 14:26:18,277 [l0-2] DEBUG AppBase - [builtinApplication.dsdb_Klienci_fetch] No public zero-argument method named '_dsdb_Klienci_fetch' found, performing generic datasource operation
=== 2012-05-16 14:26:18,277 [l0-2] INFO HibernateDataSource - [builtinApplication.dsdb_Klienci_fetch] Performing fetch operation with
criteria: {} values: {}
=== 2012-05-16 14:26:18,285 [l0-2] DEBUG HibernateTransaction - [builtinApplication.dsdb_Klienci_fetch] Started new transaction "2031402714"
=== 2012-05-16 14:26:18,285 [l0-2] INFO HibernateDataSource - [builtinApplication.dsdb_Klienci_fetch] Query string: select _dsdb_Klienci from dsdb_Klienci _dsdb_Klienci
=== 2012-05-16 14:26:18,294 [l0-2] WARN HibernateTransaction - [builtinApplication.dsdb_Klienci_fetch] Rolling back 0 database update(s)
=== 2012-05-16 14:26:18,294 [l0-2] DEBUG HibernateTransaction - [builtinApplication.dsdb_Klienci_fetch] Rolling back transaction "2031402714"
=== 2012-05-16 14:26:18,297 [l0-2] WARN RequestContext - dsRequest.execute() failed:
org.hibernate.hql.ast.QuerySyntaxException: dsdb_Klienci is not mapped [select _dsdb_Klienci from dsdb_Klienci _dsdb_Klienci]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:181)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:93)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:277)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:251)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1650)
at com.isomorphic.hibernate.HibernateDataSource.processRequest(HibernateDataSource.java:1214)
at com.isomorphic.hibernate.HibernateDataSource.executeFetch(HibernateDataSource.java:586)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1289)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:725)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1948)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:199)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:156)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:121)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)
at my.web.ResponseHaeaderFilter.doFilter(ResponseHaeaderFilter.java:59)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:344)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
=== 2012-05-16 14:26:18,298 [l0-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
Code:
<DataSource
ID="dsdb_Klienci"
serverType="hibernate"
tableName="Klient"
configBean="smartgwtSessionFactory"
>
<fields>
<field name="KlientID" primaryKey="true"/>
</fields>
</DataSource>
My "beanless" session factory bean (the 2nd one - the 1st one has mappings):
Code:
<bean id="smartgwtSessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="configLocation" value="classpath:/smartgwt.hibernate.cfg.xml" /> </bean>
Code:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.bytecode.use_reflection_optimizer">false</property>
<property name="hibernate.c3p0.acquire_increment">1</property>
<property name="hibernate.c3p0.idle_test_period">1</property>
<property name="hibernate.c3p0.max_size">15</property>
<property name="hibernate.c3p0.min_size">1</property>
<property name="hibernate.c3p0.timeout">1</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.mssql.nocount">false</property>
<property name="hibernate.query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name="hibernate.search.autoregister_listeners">false</property>
<property name="hibernate.show_sql">false</property>
<property name="hibernate.session_factory_name">java:jdbc/db</property>
</session-factory>
</hibernate-configuration>