Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MM.NET business layer generator
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
01111204
Message ID:
01117148
Vues:
18
>First of all, when accessing data other than SQL Server, you need to specify the data access class in your config file. Check out the MM .NET Dev Guide topic "Specifying Data Access Classes in the Config File" for details.

Ok This is what I had in my Config File.
//***app.config*****

<databases>
    <add key="PERP\Connection" value="Data Source=perp;Persist Security Info=True;User ID=SomePass;Unicode=True" />
    <add key="PERP\DataAccessClass" value="DataAccessOracle" />
  </databases>
This is what is in my BuisnessObject.cs
public ABusinessObject()
        {
            this.DatabaseKey = "PERP";
            *****this.RetrieveAutoIncrementPK = true; I am not using this line because 
            ***** I will take care of the key in the trigger. 
        }
>Secondly, I took a look at the Business Layer Generator source code and I see the current version you have does not instantiate a data access class for Oracle. We are getting ready to release a new version in a matter of days and this version will work properly with the Oracle .NET Data Provider.


I installed the latest version and when I go to the Business Layer Generator
I get to where it has the Database and the connection string. In the database Combo it has
'PERP'  
In the Connection String it has
Data Source=perp;Persist Security Info=True;User ID=rfi;Password=xxxxx;Unicode=True
when I don't put the password in there it grips that the password is null.

The Provider I am using is
.NET Framework Data Provider for Oracle
When I press the Get Data Button I get these errors
**** 1st Error *****
---------------------------
Add-in Exception
---------------------------
Message: ORA-00933: SQL command not properly ended


Source: System.Data.OracleClient

Stack Trace:    at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)

   at System.Data.OracleClient.OracleCommand.Execute
    (OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid,
     OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)


   at System.Data.OracleClient.OracleCommand.Execute
  (OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& 
   resultParameterOrdinals)

   at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)

   at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.FillInternal
    (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, 
     String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 
                           maxRecords, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

   at OakLeaf.MM.Main.Data.mmDataAccessOracle.GetListOfTableFields(String tableName)

   at MMBusinessLayerGenerator.mmWizardPageSelectData.GetDatabaseObjectColumns
(mmDatabaseObjectKind databaseObjectKind, String objectName) 
 in C:\Program Files\Mere Mortals .NET Framework 2005
  \MMBusinessLayerGenerator\MMBusinessLayerGenerator\mmWizardPageSelectData.cs:line 1233
And the Second Error:
***** 2nd Error
---------------------------
Add-in Exception
---------------------------
Message: Object reference not set to an instance of an object.

Source: MMBusinessLayerGenerator

Stack Trace:    at MMBusinessLayerGenerator.mmWizardPageSelectData.ProcessDBCObjects(DataTable dtDatabaseObjects, 
mmDatabaseObjectKind databaseObjectKind, Hashtable databaseObjectColumns, 
List`1 physicalObjectNames, List`1 businessClassNames, List`1 businessRuleNames, 
List`1 defaultValueClassNames, List`1 entityNames, List`1 businessObjectDisplayNames, 
List`1 primaryKeys, String businessObjectPrefix, String businessObjectSuffix, 
String businessRulePrefix, String businessRuleSuffix, String defaultsPrefix, 
String defaultsSuffix, String entityPrefix, String entitySuffix, String tableStripPrefix) 
in C:\Program Files\Mere Mortals .NET Framework 2005
\MMBusinessLayerGenerator\MMBusinessLayerGenerator\mmWizardPageSelectData.cs:line 1115
   at MMBusinessLayerGenerator.mmWizardPageSelectData.GetDatabaseObjects() 
in C:\Program Files\Mere Mortals .NET Framework 2005
\MMBusinessLayerGenerator\MMBusinessLayerGenerator\mmWizardPageSelectData.cs:line 965
Kevin, We don't know what else to do. Dan and I are very new to .Net and MM.Net.

The only back end we have is Oracle.

How can we get connected to Oracle so that we can Finish the jump start so

that we will know how to do our own projects.
What is Wisdom?
Wisdom - The ability to respond to any situation according to God's Plan.
Therefore:
USE Wisdom IN Everything ORDER priority AS Knowledge
SELECT Knowledge
BROWSE FOR Understanding WHERE Wisdom=Guide

LeRoy Jackson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform