This question is locked. New answers and comments are not allowed.
After fixing the error in my last thread I started getting another error that was not there before the switch to the Telerik version.
It started throwing this error:
Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-01008: not all variables bound
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.jdbc.conn.PooledPSWithParamLogging.executeQuery()
at OpenAccessRuntime.jdbc.fetch.FetchResultImp.execute()
SQL:
SELECT b."USER_ID", c."ID", c."NAME" FROM "CF_USERS" a JOIN "CF_USER_ROLES" b ON (a."ID" = b."USER_ID") JOIN "CF_ROLES" c ON (b."ROLE_ID" = c."ID") WHERE a."ID" = ? ORDER BY 1 Telerik.OpenAccess.RT.sql.SQLException: ORA-01008: not all variables bound
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.jdbc.conn.PooledPSWithParamLogging.executeQuery()
at OpenAccessRuntime.jdbc.fetch.FetchResultImp.execute()
The users class is tied to the roles class with a many-many. The error is thrown when lazy-loading the roles collection. Here are their app.config entries:
Please help, thank you.
It started throwing this error:
Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-01008: not all variables bound
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.jdbc.conn.PooledPSWithParamLogging.executeQuery()
at OpenAccessRuntime.jdbc.fetch.FetchResultImp.execute()
SQL:
SELECT b."USER_ID", c."ID", c."NAME" FROM "CF_USERS" a JOIN "CF_USER_ROLES" b ON (a."ID" = b."USER_ID") JOIN "CF_ROLES" c ON (b."ROLE_ID" = c."ID") WHERE a."ID" = ? ORDER BY 1 Telerik.OpenAccess.RT.sql.SQLException: ORA-01008: not all variables bound
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.jdbc.conn.PooledPSWithParamLogging.executeQuery()
at OpenAccessRuntime.jdbc.fetch.FetchResultImp.execute()
The users class is tied to the roles class with a many-many. The error is thrown when lazy-loading the roles collection. Here are their app.config entries:
<class name="Role"> |
<extension key="db-do-not-create-table" value="true" /> |
<extension key="db-table-name" value="CF_ROLES" /> |
<field name="id"> |
<extension key="db-column"> |
<extension key="db-type" value="DECIMAL" /> |
<extension key="db-column-name" value="ID" /> |
<extension key="db-length" value="10" /> |
</extension> |
</field> |
<field name="name"> |
<extension key="db-column"> |
<extension key="db-type" value="VARCHAR" /> |
<extension key="db-column-name" value="NAME" /> |
<extension key="db-length" value="50" /> |
</extension> |
</field> |
<field name="privileges"> |
<collection> |
<extension key="inverse" value="role" /> |
</collection> |
</field> |
<field name="roles"> |
<collection> |
<extension key="db-link-table"> |
<extension key="db-table-name" value="CF_ROLE_ROLES" /> |
<extension key="db-owner-ref"> |
<extension key="db-column"> |
<extension key="db-type" value="DECIMAL" /> |
<extension key="db-column-name" value="PARENT_ROLE_ID" /> |
<extension key="db-length" value="10" /> |
</extension> |
</extension> |
<extension key="db-value"> |
<extension key="db-column"> |
<extension key="db-type" value="DECIMAL" /> |
<extension key="db-column-name" value="CHILD_ROLE_ID" /> |
<extension key="db-length" value="10" /> |
</extension> |
</extension> |
</extension> |
<extension key="ordered" value="false" /> |
</collection> |
</field> |
<field name="users"> |
<collection> |
<extension key="inverse" value="roles" /> |
</collection> |
</field> |
<extension key="db-optimistic-locking" value="changed" /> |
</class> |
<class name="User"> |
<extension key="db-do-not-create-table" value="true" /> |
<extension key="db-table-name" value="CF_USERS" /> |
<field name="id"> |
<extension key="db-column"> |
<extension key="db-type" value="DECIMAL" /> |
<extension key="db-column-name" value="ID" /> |
<extension key="db-length" value="10" /> |
</extension> |
</field> |
<field name="email"> |
<extension key="db-column"> |
<extension key="db-type" value="VARCHAR" /> |
<extension key="db-column-name" value="EMAIL" /> |
<extension key="db-length" value="100" /> |
</extension> |
</field> |
<field name="username"> |
<extension key="db-column"> |
<extension key="db-type" value="VARCHAR" /> |
<extension key="db-column-name" value="USERNAME" /> |
<extension key="db-length" value="50" /> |
</extension> |
</field> |
<field name="privileges"> |
<collection> |
<extension key="inverse" value="user" /> |
</collection> |
</field> |
<field name="roles"> |
<collection> |
<extension key="db-link-table"> |
<extension key="db-table-name" value="CF_USER_ROLES" /> |
<extension key="db-owner-ref"> |
<extension key="db-column"> |
<extension key="db-type" value="DECIMAL" /> |
<extension key="db-column-name" value="USER_ID" /> |
<extension key="db-length" value="10" /> |
</extension> |
</extension> |
<extension key="db-value"> |
<extension key="db-column"> |
<extension key="db-type" value="DECIMAL" /> |
<extension key="db-column-name" value="ROLE_ID" /> |
<extension key="db-length" value="10" /> |
</extension> |
</extension> |
</extension> |
<extension key="ordered" value="false" /> |
</collection> |
</field> |
<extension key="db-optimistic-locking" value="changed" /> |
<extension key="db-index" value="USERS_U_USERNAME_1"> |
<extension key="field-name" value="username" /> |
<extension key="db-unique" value="true" /> |
<extension key="db-clustered" value="true" /> |
</extension> |
</class> |
Please help, thank you.