Hi

As you may guess I am new to Hibernate.

I have downloaded struts-hibernate example by Ted Husted and have got it working fine with IBM DB2UDB7 on Windows XP.

The problem is that I have tried the same app trying to access a DB2/400 on iseries.

I get the following error

SELECT user.user_uid as user_uid, user.version as version, user.name as name, user.userName as userName FROM cl_users user WHERE (user.userName=? )
[01/09/03 15:47:05:762 BST] 5a3e1560 JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -104, SQLState: 42601
[01/09/03 15:47:05:792 BST] 5a3e1560 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter [SQL0104] Token . was not valid. Valid tokens: + - AS <IDENTIFIER>.
[01/09/03 15:47:05:812 BST] 5a3e1560 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Could not execute query
[01/09/03 15:47:05:842 BST] 5a3e1560 JDBCException E net.sf.hibernate.util.JDBCExceptionReporter TRAS0014I: The following exception was logged java.sql.SQLException: [SQL0104] Token . was not valid. Valid tokens: + - AS <IDENTIFIER>.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:520)


My hibernate.properties file looks like

hibernate.connection.driver_class = com.ibm.as400.access.AS400JDBCDriver
hibernate.connection.url = jdbc:as400://TFMAIN/NETDATA
hibernate.connection.username = NETDATA
hibernate.connection.password = HTTPSVR
hibernate.dialect =net.sf.hibernate.dialect.DB2Dialect
hibernate.show_sql = true


any help with with this would be extremely appreciated.

kind regards
Paul

Its been a while since I've worked with DB2/400, but I'm going to take a wild guess that "user" is a reserved word.

Is this a result of attempting to execute an HQL query? If so, try changing your alias from user to something more benign.

For example, if you have "from User as user where user.userName = :userName", change it to "from User as u where u.userName = :userName"...

right.


or just upgrade to a newer version of hibernate, which doesn't pass aliases directly through.

Guys

Thanks for the replies.

I upgraded to hibernate 2.0.3 but I got the same errors.

I then changed the alias from 'user' to 'u' and it worked.

I will continue to use 2.0.3 with the rest of the development.

Once again thanks guys

Paul