Hibernate Community • View topic - Hibernate error - Retrieving data from AS400 on Portal

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate error - Retrieving data from AS400 on Portal

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

kissiffer4

Post subject: Hibernate error - Retrieving data from AS400 on Portal

Posted: Wed Sep 29, 2010 10:19 am

Newbie

Joined: Tue Sep 28, 2010 3:50 pm
Posts: 1

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.

Top

kostaky

Post subject: Re: Hibernate error - Retrieving data from AS400 on Portal

Posted: Wed Sep 29, 2010 6:24 pm

Beginner

Joined: Fri Mar 11, 2005 7:46 am
Posts: 29

Do you get any database output after it, eg. ResultSet, or PreparedStatement? It might be just a warning. One more thing - try different version of jt400. What is your driver class? We use com.ibm.as400.access.AS400JDBCConnectionPoolDataSource.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum