How can I Initialize getJdbcTemplate()?

[java_dev]

Task- Just need to select table data (one column also ok) from table1 and return as java.util.List

------------------------------
integration-dao.xml
-----------------------------

<bean id="cListDAO "
class="com…..CListDAO "
p:dataSource-ref="dataSource" 
p:sqlLoader-ref="sqlLoader" /> 


<bean id="sqlLoader"
class="com.asi.integration.common.business.dao.sql .SQLLoader" />

-------------------------
integration-datasource.xml
-------------------------

<bean id="dataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close"
p:driverClass="${my.jdbc.driverClassName}"
p:jdbcUrl="${my.jdbc.url}"
p:user="${my.jdbc.username}"
password="${my.jdbc.password}"
p:initialPoolSize="${my.jdbc.pool.init.size}"
p:maxPoolSize="${my.jdbc.pool.max.size}"
preferredTestQuery="${my.jdbc.preferredTestQuery }"
p:idleConnectionTestPeriod="${my.jdbc.idleConnecti onTestPeriod}"/>

-------------------------------
integration-hibernate.xml
--------------------------------

<!-- Hibernate SessionFactory for datasource -->
<bean id="mySessionFactory"
class="org.springframework.orm.hibernate3.LocalSes sionFactoryBean"
p:dataSource-ref="dataSource">

<!-- tried by giving this also--><!--<property name="dataSource" ref="dataSource"></property> --> 
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
${my.hibernate.dialect}
</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.max_fetch_depth">3</prop>
<prop key="hibernate.query.substitutions">
true 1, false 0
</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property> 
</bean>

-------------------------
SQLConstants.java
-------------------------

public class SQLConstants {
public static final String PACKAGE = ClassUtils.getPackageName(SQLConstants.class);
public static final String C_NUMBERS_LIST =
"CNumberList.sql";

/**
* Private constructor to prevent instantiation.
*/
private SQLConstants() {
super();
}
}

-------------------------
CNumberList.sql
----------------------

 select * FROM table1

----------------------------
CListDAO.java
-----------------------

public class CListDAO extends JdbcDAO { 


public List claims() {


List li = getJdbcTemplate().queryForList(
this.loadQuery(SQLConstants.PACKAGE, 
SQLConstants.C_NUMBERS_LIST));

Iterator iter = li.iterator(); 
System.out.println("I want ===>>"+li.size());
while(iter.hasNext()){
System.out.println("I want->>>>"+iter.next());
}

return li; 
}

--------------------------
JdbcDAO.java
----------------------------------

public class JdbcDAO extends JdbcDaoSupport implements IJdbcDAO {
private SQLLoader _sqlLoader;

….

protected String loadQuery(String packageName, String sqlName) {
return _sqlLoader.loadQuery(packageName, sqlName);
}
….
}

----------------------------------------


I am getting NullPointerException at

 “ getJdbcTemplate().queryForList(
this.loadQuery(SQLConstants.PACKAGE, 
SQLConstants.C_NUMBERS_LIST));

, I observed getJdbcTemplate() Is comming as null.

How can i create instance of JdbcTemplate here ?
Do I need to use sessionfactory , if yes , how can I wire up ?

Please tell me what I missed above.

Thanks in advance.

==========================
Error:
===========================

 java.lang.NullPointerException
at com…….CListDAO.getRecords(ClaimsListDAO.java:32)
at com……..runScheduledJob(GenerationScheduledJob.java :52)
at com….common.jobs.AbstractScheduledJob.execute(Abst ractScheduledJob.java:21)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.springframework.util.MethodInvoker.invoke(Meth odInvoker.java:276)
at org.springframework.scheduling.quartz.MethodInvoki ngJobDetailFactoryBean$MethodInvokingJob.executeIn ternal(MethodInvokingJobDetailFactoryBean.java:260 )
at org.springframework.scheduling.quartz.QuartzJobBea n.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:2 02)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run (SimpleThreadPool.java:529)

[java_dev]

Can any one help me in solving my problem ?

[jcaccia]

If you had used [CODE] tags probably someone might be interested in reading your code...

[java_dev]

Thanks for reply jcaccia.

I modified my post with code tags, Can you help me in solving my problem?

Please let me know if you need more details from my end.

[dlorde]

I modified my post with code tags, Can you help me in solving my problem?

The point of the code tags is to preserve the formatting. If the code is unformatted, they won't help.

I am always doing that which I cannot do, in order that I may learn how to do it...
P. Picasso

[java_dev]

Yes, I can understand, that the reason I changed as per your suggestion. I need help in solving my problem.

Please help me.

[dlorde]

Yes, I can understand, that the reason I changed as per your suggestion.

<sigh> Your code is not formatted, so putting it in code tags is pointless. jcaccia was asking for formatted (readable) code.

I need help in solving my problem.

Perhaps jcaccia might be more inclined to help if the code was formatted and readable...?

Programs must be written for people to read, and only incidentally for machines to execute...
H. Abelson and G. Sussman

[Deliverance]

are you planning on providing your own transaction management?

[java_dev]

Thanks for reply Deliverance!
No, I am not planning to providing any transaction management.

Result List of claims() I will give to a job.

I am also updating my recent try….

I modified my Integration-dao.xml as follows. Still I am getting same exception, do I need to change any thing on CListDAO.java ?

	<bean id="claimNumberListDAO"
		class="com.asi.integration.cc.jobs.activity.ClaimNumberListDAO"
		p:dataSource-ref="dataSource" p:sqlLoader-ref="sqlLoader" 
		p:jdbcTemplate-ref="jdbcTemplate"/>

	<!-- The db JdbcTemplate class -->
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
	</bean>

[Deliverance]

It's hard to say, I've never done it that way. I have always provided some level of transaction management independent of hibernate.

Have you tested everything with an in memory database?

	
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
	destroy-method="close">
	<property name="driverClass" value="org.hsqldb.jdbcDriver" />
	<property name="jdbcUrl" value="jdbc:hsqldb:mem:test" />
	<property name="user" value="sa" />
	<property name="password" value="" />
</bean>

then add a session manager as a bean, and in your code, wire the session factory to one of your DAOs and try

SessionFactoryUtils.getSession(sessionFactory, true);

[java_dev]

And also can you please give the best place(url) from where I can read about spring with help of example(like java tutorial)?

[Deliverance]

The Spring documentation is a great resource and at some point, you will benefit greatly from reading through the entire thing
http://static.springsource.org/sprin...nce/index.html



The design concept you were looking for is Java proxying.

http://java.sun.com/j2se/1.4.2/docs/...ion/proxy.html

[java_dev]

Hi Deliverance, I am facing one issue, I injected FieldValue in spring config file as follows,

x-shedular.xml

<bean id="fieldValue" class="com….FieldValue"/> 

<bean id="activityGenerationJob"
		class="com….CActivityGenerationScheduledJob"
		  p:fieldValue-ref="fieldValue" 
		/>

CActivityGenerationScheduledJob.java

When I tired to override two columns  
fieldValue[0].setIdentifier("0");  
fieldValue[0].setName("FirstDate");
fieldValue[0].setValue(updated_FirstDate);

fieldValue[0].setIdentifier("1");  
fieldValue[0].setName("SecondDate");
fieldValue[0].setValue(updated_ SecondDate);

cAPIClient.addActivityWithOverride(somenumber, “some value”,fieldValue);

Constructor Summary 
1. FieldValue() 
2. FieldValue(java.lang.String identifier, java.lang.String name, java.lang.String value)

I can't set size as bellow , becose it is a final value

if(fieldValue.length ==0){
 fieldValue.length = 5;
}

addActivityWithOverride() method 3 parameter is type of FieldValue, When I tried with HashMap, type cast exception is comming.

but my first name and value is overriding/replacing by second value, here how can I initialize the FieldValue with value more than 1 so that I can generate Activity With Override.

Please help.

[Deliverance]

And with good reason.

length is a property that primitive array types provide, as a convenience for polling the size of the array. It can only be read from.

FieldValue [] fieldValues = new FieldValue[5];
System.out.println(fieldValues.length);

[java_dev]

Deliverance, When I initialized as
try1: with out removing FieldValue bean injection in config file

fieldValue = new FieldValue[5];

try2: after removing FieldValue bean injection in config file

FieldValue fieldValue = new FieldValue[5];

For Both tries, I am getting null pointer exception at

fieldValue[0].setIdentifier("0");

please help.