知識過客

在Hibernate中使用Connection Pool來增強與資料庫連線的穩定度... <!-- configuration pool via c3p0 --> < property name = "connection.provider_class" > org.hibernate.connection.C3P0ConnectionProvider </ property > < property name = "c3p0.min_size" > 0 </ property > < property name = "c3p0.max_size" > 30 </ property > < property name = "c3p0.timeout" > 600 </ property > < property name = "c3p0.max_statements" > 0 </ property > < property name = "c3p0.acquire_increment" > 1 </ property > < property name = "c3p0.idle_test_period" > 60 </ property >

當TB_FD_USER裡面的PK=USER_NO時候 只有放PK到findByExample會被忽略喔... eStoreService dao = (eStoreService)SpringService.getService(SpringService.USE_JDBC, "eStoreService"); TbFdUser user = new TbFdUser(); user.setUserNo(new Long(1)); Collection c = dao.getUserByExample(user); System.out.println("result size:"+c.size()); Result... Hibernate: select this_.USER_NO as USER1_4_0_, this_.ADDRESS as ADDRESS4_0_, this_.AREA_CODE as AREA3_4_0_, this_.BANK_ACCOUNT as BANK4_4_0_, this_.BIRTHDAY as BIRTHDAY4_0_, this_.CITY as CITY4_0_, this_.COMPANY_NAME as COMPANY7_4_0_, this_.COUNTRY_CODE as COUNTRY8_4_0_, this_.CREATE_BY as CREATE9_4_0_, this_.CREATE_DATE as CREATE10_4_0_, this_.EMAIL as EMAIL4_0_, this_.FAX_NO as FAX12_4_0_, this_.FLAG as FLAG4_0_, this_.ID_NO as ID14_4_0_, this_.INTRODUCED_BY as INTRODUCED15_4_0_, this_.LOGIN_ID as LOGIN16_4_0_, this_.LOGIN_PWD as LOGIN17_4_0_, this_.MOBILE_NO as MOBILE18_4_0_, this_.PROVINCE_CODE as PROVINCE19_4_0_, this_.SEX as SEX4_0_, this_.STAT...

Spring using JDBC configuration Spring的DB存取可以設定使用proxool pool或是jdbc driver manager的方式 DAO的設定部分都不用錯修改喔~~ 下面是driver manager跟proxool的設定部分(需擇一，因為定義的bean id是一樣的啦，而且同一個專案，用一個就夠啦...) [applicationContext.xml]     <!-- Using JDBC Connection (select one with "Using proxool connection pool") -->     <bean id="projectDataSource"         class="org.springframework.jdbc.datasource.DriverManagerDataSource">         <property name="driverClassName">             <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>         </property>         <property name="url">             <value>                 jdbc:microsoft:sqlserver://server_ip:1433;...

如何使用Criteria查詢時，使用FK table中的欄位作條件？ DetachedCriteria c = DetachedCriteria.forClass(Hr2UserEvent.class); //主table中的欄位查詢 c.add(Restrictions.eq("workId", workId)); //FK中的欄位查詢 c.createCriteria("hr2UserEventType").add(Restrictions.eq("eventId", eventId)); //這裡是使用jdbctemplate查詢，當然，也可以用hobernate session Collection collection = getHibernateTemplate().findByCriteria(c);