Hello. I'm just starting to get into Reactor. I really like it thus far. I
have everything working and configured except for db inserts and creates.
I'm using oracle and sequences. I've googled the heck out of it and tried
everything i could find in the ml archives.
I have the following setup:
<object name="my_table">
<field name="ID" sequence="APPLICATION_SEQ" />
</object>
When I create an object without an ID and save it it says the sequence
cannot be found:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-02289: sequence does not exist
I'm positive this sequence exists, as I can query it in sqlDeveloper. I
found If I append the schema name to it when called in a standard cfquery it
works. When i add it to the reactore config:
<object name="my_table">
<field name="ID" sequence="WEB_APPS.APPLICATION_SEQ" />
</object>
It breaks every other query I have in the application.
I do have a custom sequnceDAO component I made. Is there an easy way to just
call this method and use that to set the PK?
Thanks!
Nick Maloney
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
