This question is locked. New answers and comments are not allowed.
I am having all sort of issues with OpenAccess and Oracle.
The latest is having upgradede to a trial version of 2011.1.316, I couldn't get my existing revese engineered diagram to work with this version either. Attempting to create a new domain model using the wizard, I am able to setup a new DB connection to my Oracle database, but when attempting to choose object in the schema to model, I'm faced with the message:
"Unable to retrieve the database schema information.
Reason: The provider is not compatable with the version of Oracle client."
OCI version: 11.1
Database: Oracle Release 10.2.0.4.0 Enterprise Edition.
The previous model was created using OpenAccess 2010.2.714, which reverese engineered a table and a view. Whenever I try to access the view object, using either version of ORM, I get the error:
The compiler error lists "The persistent type 'MyApp.DataObject1' has no primary key specified". The entity objects are set to Kind=ReadOnly.
What am I missing here? It's driving me bonkers.
The latest is having upgradede to a trial version of 2011.1.316, I couldn't get my existing revese engineered diagram to work with this version either. Attempting to create a new domain model using the wizard, I am able to setup a new DB connection to my Oracle database, but when attempting to choose object in the schema to model, I'm faced with the message:
"Unable to retrieve the database schema information.
Reason: The provider is not compatable with the version of Oracle client."
OCI version: 11.1
Database: Oracle Release 10.2.0.4.0 Enterprise Edition.
The previous model was created using OpenAccess 2010.2.714, which reverese engineered a table and a view. Whenever I try to access the view object, using either version of ORM, I get the error:
ORA-00942: table or view does not exist Telerik.OpenAccess.RT.sql.SQLException: ORA-00942: table or view does not exist
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.IsCached(Connection con, RelationalKeyGeneratorInfoCache infoCache, String tab, String kCol, String vCol, String key, Boolean& ret)
at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.init(String className, RelationalTable theClassTable, Connection con, RelationalKeyGeneratorInfoCache relationalKeyGeneratorInfoCache)
at OpenAccessRuntime.Relational.RelationalStorageManagerFactory.init(Boolean full)
The compiler error lists "The persistent type 'MyApp.DataObject1' has no primary key specified". The entity objects are set to Kind=ReadOnly.
What am I missing here? It's driving me bonkers.