[TYPO3-english] Oracle & Typo3 + TV

[Xavier Perseguers]

Hello,

> basically I got TV working, though. I have to insert DS record via Oracle
> backend still only.
> When I try to do that through typo BE, I get following error:
> 
> 2: SQL error: 'ORA-01400: cannot insert NULL into
> ("TYPO3"."tx_templavoila_ds"."uid")'
> (tx_templavoila_datastructure:NEW4a70a4a523163)
> 
> As far I'm understanding, TV or dbal do not count right or do not count
> correct uid (?), or is that anything regarding auto increment on typo3 or
> oracle side?
> Template object, which has similar uid management though works fine from
> typo3 BE.
> I've checked Oracle BE, and I found out that both uid's (template obj and DS
> obj) are set up the same way,
> including indexes, thus I do not understand that prob.

Please check if you have sequences defined for the auto-increment 
feature. It should have been created automatically by AdoDB when the TV 
tables have been created and then auto-increment on primary key is 
handled by AdoDB through a call to get the next sequence number, meaning 
it should never try to insert NULL as it does for MySQL. Instead the 
query should already contain the next id.

-- 
Xavier Perseguers
MVC ExtJS Samples Leader

http://forge.typo3.org/projects/show/extension-mvc_extjs_samples