Oracle connector db store: restart of connector fails due to recreation attempt of connector db objects

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Setup Oracle as the store for google connector (in the 
applicationContext.properties/applicationContext.xml
2. Start up the connector server (at this step the connector Oracle objects: 
table, sequence, etc. are created).
3. Stop the connector connector server
4. Restart the connector server - the connector throws an error as it tries to 
recreate the database objects

What version of the product are you using? On what operating system?
connector 3.0.8 on Tomcat/Windows 7/Oracle 11g

Please provide any additional information below.
- com.google.enterprise.connector.util.database.JdbcDatabase: the escaping done 
for the "_" character (at line 411) does not need to be performed for Oracle 
datasources (or at least Oracle 11g datasources). Due to this replace the table 
name is not found in the meta data upon restart and the CREATE DDLs are 
reexecuted thus causing the error described above
- I am attaching a BeyondCompare report that highlights the changes I did to 
get over this issue. Please let me know if this can be considered as a patch 
fix in a next release or if another fix is implemented.

Original issue reported on code.google.com by alex@ikayzo.com on 3 Jul 2013 at 2:18

Attachments:

• JdbcDatabaseOracleCreateTablesFix.html