Im using hibernate to connect to my DB2 database.
I got
java.sql.SQLException: No suitable driver found for jdbc:db2://ldild4268.mycompany.com:55000/myDB.
I have db2jcc.jar, db2jcc_javax.jar, db2jcc_license_cu.jar, db2policy.jar, db2ggjava.jar and db2umplugin.jar added into my
Java Build Path.
I am able to connect to my database through SQuirrel.
database.properties:
jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
jdbc.url=jdbc:db2://ldild4268.mycompany.com:55000/myDB
jdbc.username=uname
jdbc.password=pwd
datasource.xml:
<bean
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>/WEB-INF/database.properties</value>
</property>
</bean>
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
hibernate.xml:
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.DB2Dialect</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>/myModel.hbm.xml</value>
</list>
</property>
</bean>
myModel.hbm.xml:
<hibernate-mapping>
<class name="com.myCompany.model.myModel" table="table1" catalog="">
<composite-id>
<key-property name="key1" column="key1" length="10"/>
<key-property name="key2" column="key2" length="19"/>
</composite-id>
<property name="name" type="string">
<column name="Name" length="50"/>
</property>
</class>
</hibernate-mapping>
myModelDaoImpl:
@Repository("myModelDao")
public class myModelDaoImpl extends PortfolioHibernateDaoSupport implements myModelDao{
private SessionFactory sessionFactory;
public List<Date> getKey1() {
return this.sessionFactory.getCurrentSession()
.createQuery("select pn.key1 from com.myCompany.model.myModel pn")
.list();
}
public String getPs() {
String query = "select pn.name from com.myCompany.model.myModel pn where pn.key1='2011-09-30' and pn.key2=1049764";
List list = getHibernateTemplate().find(query);
}
}
also, the method getKey1 throws nullPointer exception. How can I use createquery instead of hibernateTemplate?
Thanks in advance!
