Hi,
Any help with the following error would be much appreciated. I am trying to pull data from our AS400 DB2 database, but I keep getting the following error:
[9/28/10 17:10:32:030 EDT] 000051d6 SystemOut O In ReportYearSelectAction() ActionForward execute() 1
[9/28/10 17:10:32:030 EDT] 000051d6 SystemOut O getCurrentReportYear()
[9/28/10 17:10:32:030 EDT] 000051d6 SystemOut O Session is not null and open
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O DB2 UDB for AS/400
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O STSOWN
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O AS/400 Toolbox for Java JDBC Driver
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O jdbc:as400://test400b.mls.com
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O "
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O com.ibm.ws.rsadapter.jdbc.WSJdbcDatabaseMetaData@40195f39
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O In HibernateReportYearDAO 1()
[9/28/10 17:10:32:280 EDT] 000051d6 SystemOut O In HibernateReportYearDAO 2()
[9/28/10 17:10:32:624 EDT] 000051d6 SystemOut O Hibernate: select rptcurryr0_.CURRENT_YEAR as col_0_0_ from MLSSTS.rptcurryr rptcurryr0_
[9/28/10 17:10:32:624 EDT] 000051d6 SystemOut O ReportYearSelectAction() ActionForward execute() error.com.ibm.as400.access.AS400JDBCConnection tried to access method com/ibm/as400/access/AS400JDBCPreparedStatement.<init>(Lcom/ibm/as400/access/AS400JDBCConnection;ILcom/ibm/as400/access/JDTransactionManager;Lcom/ibm/as400/access/JDPackageManager;Ljava/lang/
The code is as follows:
Code:
session = super.getSession();
StringBuffer strBuf = new StringBuffer();
strBuf.append("select max(rpt.currentYear) from RptCurrYr rpt");
Query query = session.createQuery(strBuf.toString());
Iterator itr = query.list().iterator();
while (itr.hasNext()) {
currentYear = ((Integer) itr.next()).intValue();
}
I am using the hibernate-3.0.5.jar and jt400.jar. I am also using the spring-2.0.6.jar.
Again, I would be really grateful for any help with this.
Thanks.
Login
FAQ
Search
