<?xml version="1.0" encoding="UTF-8"?> <Context path="myDataSource" reloadable="true" swallowOutput="true"> <Resource auth="Container" description="connDB1" driverClassName="oracle.jdbc.driver.OracleDriver" initialSize="10" logAbandoned="true" maxActive="30" maxIdle="6" maxWait="5000" minEvictableIdleTimeMillis="20000" name="" numTestsPerEvictionRun="3" removeAbandoned="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="30000" type="javax.sql.DataSource" url="jdbc:oracle:thin:@//....." username="..." password="..." /> <Resource auth="Container" description="connDB2" driverClassName="oracle.jdbc.driver.OracleDriver" initialSize="10" logAbandoned="true" maxActive="30" maxIdle="6" maxWait="5000" minEvictableIdleTimeMillis="20000" name="" numTestsPerEvictionRun="3" removeAbandoned="true" testWhileIdle="true" timeBetweenEvictionRunsMillis="30000" type="javax.sql.DataSource" url="jdbc:oracle:thin:@//....." username="..." password="..." /> </Context>
<constructor-arg> <ref bean="dts1" /> </constructor-arg> <constructor-arg> <ref bean="dts2" /> </constructor-arg>
public class MyDao1Impl implements MyDao { private JdbcTemplate myJdbcTemplate; public void setMyJdbcTemplate( final JdbcTemplate myJdbcTemplate) { this.myJdbcTemplate = myJdbcTemplate; } @Override public List<Object[]> executeQuery(final StringBuilder sql) { return (List<Object[]>) this.reportJdbcTemplate.query( sqlStringQuery.toString(), new ResultSetExtractor() { @Override public List<Object[]> extractData(final ResultSet rs) throws SQLException, DataAccessException { final List<Object[]> res = new ArrayList<Object[]>(); while (rs.next()) { final int columnCount = rs.getMetaData() .getColumnCount(); final Object[] objs = new Object[columnCount]; for (int i = 0; i < objs.length; i++) { objs[i] = rs.getObject(i + 1); } res.add(objs); } return res; } }); } public MyObject getById(final Long idMyObject){ ........... return res; } }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?xml version="1.0" encoding="UTF-8" standalone="no"?> org.hibernate.ejb.HibernatePersistence <jta-data-source>jdbc/sportreserv</jta-data-source>
@PersistenceContext(unitName = "SportReserv-PU") private EntityManager em;