StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POSpring MVC + ComboPooledDataSource (hibernate)
primarykey
Id
8198582
data
AcceptedAnswerId
8201785
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-20T00:49:32.850
FavoriteCount
1
LastActivityDate
2011-11-20T13:24:29.330
LastEditDate
LastEditorUserId
0
OwnerUserId
1031724
ParentId
0
PostTypeId
1
Score
1
ViewCount
5504
LastEditorDisplayName
text
Body
It's my first time I'm using ComboPooledDataSource in hibernate, but there's something wrong with my configurations I think, so that when I call DAO to retrieve all data from database this returns me nothing. GenView <pre><code>@RequestMapping(value="/getHospitals.ajax") public @ResponseBody Map<String,? extends Object> loadHospitals(){ HashMap<String, List<Hastaneler>> modelMap = new HashMap<String,List<Hastaneler>>(); modelMap.put("hastaneler", genBUS.getHospitals()); return modelMap; } </code></pre> GenBUS <pre><code>@Service @Transactional(isolation = Isolation.DEFAULT, readOnly = false, propagation = Propagation.REQUIRED) public class GenBUS implements IGenBUS { private Log log = LogFactory.getLog(GenBUS.class); @Autowired private SessionClientData scd; @Autowired private GenDAO genDAO; private JdbcTemplate jdbcTemplate; @Autowired private ComboPooledDataSource comboPooledDataSource; @PostConstruct public void dataSource2JdbcTemplate() { this.jdbcTemplate = new JdbcTemplate(comboPooledDataSource); } public GenDAO getGenDAO() { return genDAO; } @Override public List<User> getHospitals() { return genDAO.loadAllObject(User.class); } </code></pre> GenDAO <pre><code>@Repository public class GenDAO extends BaseDAO{ private Log log = LogFactory.getLog(GenDAO.class); @Autowired private SessionClientData scd; @Autowired private ComboPooledDataSource comboPooledDataSource; private JdbcTemplate jdbcTemplate; @PostConstruct public void dataSource2JdbcTemplate() { this.jdbcTemplate = new JdbcTemplate(comboPooledDataSource); } @Autowired public GenDAO(SessionFactory sessionFactory) { logger.debug("GenDAO constructor is called !!!!!!!!"); System.out.println("genDaoooooooooooooooo....."); setSessionFactory(sessionFactory); } </code></pre> BaseDAO <pre><code>public class BaseDAO extends HibernateDaoSupport { protected org.hibernate.impl.SessionFactoryImpl baseSessionFactory; public<T> List<T> loadAllObject(Class<T> clazz) { return (List<T>) getHibernateTemplate().loadAll(clazz); } </code></pre> dao.xml <pre><code><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:util="http://www.springframework.org/schema/util" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.0.xsd"> <tx:annotation-driven proxy-target-class="true" transaction-manager="transactionManager" /> <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="baseSessionFactory"/> </bean> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" > <property name="location" value="classpath:/resources/test.properties"/> </bean> <bean id="comboPooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="${database.driverClass}"/> <property name="jdbcUrl" value="${database.url}"/> <property name="properties"> <props> <prop key="user">${database.user}</prop> <prop key="password">${database.password}</prop> </props> </property>  <property name="maxPoolSize" value="50"/> <property name="initialPoolSize" value="2"/> <property name="minPoolSize" value="1"/> <property name="maxStatements" value="200"/> <property name="maxIdleTime" value="300"/> <property name="acquireIncrement" value="10"/> <property name="unreturnedConnectionTimeout" value="90"/> <property name="maxConnectionAge" value="120"/> </bean> <bean id="baseSessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"> <property name="dataSource" ref="comboPooledDataSource"/>  <property name="packagesToScan"> <list> <value>model.GenUser</value> <value>model.Hastaneler</value> <value>model.Hastanelerim</value> <value>model.User</value> </list> </property> <property name="cacheProvider" ref="ehCacheProvider"/> <property name="hibernateProperties"> <props> <prop key="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</prop> <prop key="hibernate.max_fetch_depth">2</prop> <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop> <prop key="hibernate.cache.use_query_cache">true</prop> <prop key="hibernate.cache.use_second_level_cache">true</prop> <prop key="hibernate.dialect">${database.dialect}</prop> <prop key="hibernate.show_sql">true</prop> <prop key="hibernate.use_sql_comments">true</prop> <prop key="hibernate.format_sql">false</prop> <prop key="hibernate.generate_statistics">true</prop> <prop key="current_session_context_class">thread</prop>  </props> </property>  </bean> <bean id="ehCacheProvider" class="org.hibernate.cache.EhCacheProvider"/> </beans> </code></pre> test.properties <pre><code>database.url=jdbc:mysql://127.0.0.1:3306/acilservis database.driverClass=com.mysql.jdbc.Driver database.user=root database.password= database.dialect=org.hibernate.dialect.MySQLDialect format_sql=true show_sql=true </code></pre> I'm using Mysql InnoDB as database engine... Any suggestions?
Tags
<mysql><hibernate><spring-mvc>
Title
Spring MVC + ComboPooledDataSource (hibernate)
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USZaur Guliyev
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POSpring MVC + ComboPooledDataSource (hibernate)
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POSpring MVC + ComboPooledDataSource (hibernate)
 UserUserId
 USprayagupd
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.