Senthil Narayanaswamy

Greenhorn
+ Follow
since Apr 15, 2007
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Senthil Narayanaswamy

Thanks Paul for sharing your thoughts. But i tried using the ?, still it doesn't work.


Any thoughts....

Thanks,
Senthil.
Hi,
I am using Named Query. I trouble i am having is i am not able to make the Order By clause work. This is the code i am using...the query works and i am getting data but only thing is data is not getting sorted.



In Java File...
.

Any help is appreciated.

Thanks,
Senthil.
Hi,
So far i have used seperate classes for Domain Object and DTO. I use Domain Object to persist to DB and DTO to be sent to UI. The thing came up is can, Domain Object and DTO be the same class. Personally, i prefer separate classes. However, i would like to hear from the folks here.
1. Did any of you used one class for Domain and DTO? Is Yes, advantages and disadvantages.

Thanks,
Senthil.
I am trying to setup a Spring Application in the IBM RAD 6.0. The application works fine. Then i tried to connect to databse without using the connection pool and it worked fine. The problem started when i tired using the connection pool and since then i'm not able to connect to database. The Database is Sybase.

In the config file this is what i have...

<bean id="achManDao" class="com.keybank.der.ach.dao.AchManagerDaoJdbc">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
</bean>
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName"><value>jdbc/SYBASDB</value></property>
<property name="jndiTemplate">
<ref bean="jndiTemplate" />
</property>
</bean>
<bean id="jndiTemplate"
class="org.springframework.jndi.JndiTemplate">
<property name="environment">
<props>
<prop key="Context.INITIAL_CONTEXT_FACTORY">
com.ibm.websphere.naming.WsnInitialContextFactory
</prop>
</props>
</property>
</bean>

The exception i'm getting is:

[6/12/07 16:26:17:293 EDT] 00000039 SystemErr R org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: JZ004: User name property missing in DriverManager.getConnection(..., Properties).DSRA0010E: SQL State = JZ004, Error Code = 0DSRA0010E: SQL State = JZ004, Error Code = 0
java.sql.SQLException: JZ004: User name property missing in DriverManager.getConnection(..., Properties).DSRA0010E: SQL State = JZ004, Error Code = 0DSRA0010E: SQL State = JZ004, Error Code = 0;

I know it looks like that i'm missing User Name. But in IBM RAD 6, i did set up User name and password for this datasource.
Below is my DataSource.

Name JNDI name Description
SYBASDB jdbc/SYBASDB New JDBC Datasource

I'm not sure whether i'm missing anything. Can anyone help me out.