databases.oracle generates incosistent names with Aliases

[Drew Smathers]

databases.oracle module in oracle-support uses Aliases with default name derived for class variable counter on Alias. This causes different query to be generated for the same logical query which busts oracle's statement caching. This can (and has in my application) lead to ORA-04031 errors.

[James Henstridge (jamesh)]

If this is a problem for Oracle and doesn't negatively affect other databases, it'd probably be better to make the change to the database independent portion of Storm. What do you think?

[Drew Smathers (djfroofy)]

Yes, I agree. Sorry, but I forgot to add link to my patch in bug report:

http://bazaar.launchpad.net/~djfroofy/storm/oracle-support-patches/revision/278

The change indeed is made to storm.databases.oracle since the issue is specific to how oracle-specific code uses Aliases.