Title:
Bug 79756:With ORM settings to dropcreate, when you create a new CFC, the first time you load the application, you always get a message that the table for the CFC doesn't exist
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Rob Kolosky / Rob Kolosky (rkolosky)
Created: 09/04/2009
Components: ORM Support
Versions: 9.0
Failure Type: Unspecified
Found In Build/Fixed In Build: 9,0,0,247238 / 255645
Priority/Frequency: Normal / Unknown
Locale/System: English / Win All
Vote Count: 1
Problem:
With ORM settings to dropcreate, when you create a new CFC, the first time you load the application, you always get a message that the table for the CFC doesn't exist.
Method:
Application.cfc:<cfcompenent> <cfset this.applicationName = "cf9Test" /> <cfset this.ormEnabled = true /> <cfset this.dataSource = "<valid Datasource>" /> <cfset this.ormsettings.dbcreate = "dropcreate" /> <cfset this.ormSettings.dialect = "MicrosoftSQLServer" />State.cfc:<cfcomponent output="false" persistent="true" table="tblState"><cfproperty name="stateID" fieldtype="id" generator="identity" ormtype="int" /><cfproperty name="stateAbbr" type="string" ormType="string" sqlType="varchar(2)" /><cfproperty name="state" type="string" ormType="string" sqlType="varchar(50)" /></cfcomponent>index.cfm:<cfset thisState = new State() />
Result:
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot drop the table '<tableName>', because it does not exist or you do not have permission.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3039905
External Customer Info:
External Company:
External Customer Name: Rob Kolosky
External Customer Email: 0D63608F448DC27599201549
External Test Config: 09/04/2009Attachments:
Comments: