Re: Select from View (as opposed to table) using iBatis

2010-06-10 Thread Larry Meadors
Are you connecting as the same use that your code is connecting as? The ibatis project has moved and been renamed. It is no longer being maintained as an Apache project, but has moved (along with the development team) here: http://www.mybatis.org/ Please join us at the new location by joining t

Re: Select from View (as opposed to table) using iBatis

2010-06-09 Thread mule_user
The View exists in DB2, but no table exists with that name. Yes, 42704 is throws if table is not found. I can run the SQL generated SQL by iBatis (that is spit out in Console) in DB2 control center and get successful results. Yes, while table does not exist, the view exist. The error code of 42

Re: Select from View (as opposed to table) using iBatis

2010-06-09 Thread Jeff Butler
Please join us at the new project site: www.mybatis.org Select from view is support. The error message is "Undefined Name". DB2 cannot find the view called MY_SCHEMA.V_MY_VIEW. Jeff Butler On Wed, Jun 9, 2010 at 4:11 PM, mule_user wrote: > > I am using iBatis (2.5) with DB2 version 8.x and Sp

Select from View (as opposed to table) using iBatis

2010-06-09 Thread mule_user
I am using iBatis (2.5) with DB2 version 8.x and Spring 2.5. Is there any issue in querying a view (as opposed to table)? It is a very simple select as: select CD from ${jdbc.schema}.V_MY_VIEW org.impl.CodeBean is a simple POJO with