search

zhangjingl02 / activejdbc

Automatically exported from code.google.com/p/activejdbc
0 stars 0 forks source link

Column that was dropped is retrieved by the Register class using Oracle jdbc driver #171

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. create table A
2. remove column B from table A
3. restart the server
4. Note that column B is still retrieved and causes error when a update is sent 
to the table A

What is the expected output? What do you see instead?
column B did not be retrieved

What version of the product are you using? On what operating system?
active jdbc 1.4.1
Oracle Database 11g Express Edition Release 11.2.0.2.0
ojdbc6-11.2.0.3

Please provide any additional information below.

As pointed in the link below, when getColumn is called, the Oracle searches for 
all schemas, and this may cause the issue. A possible solution is the send the 
schema name by argument.
http://stackoverflow.com/questions/1601203/jdbc-databasemetadata-getcolumns-retu
rns-duplicate-columns

Original issue reported on code.google.com by ger...@gmail.com on 9 Aug 2012 at 6:14

GoogleCodeExporter commented 9 years ago 
Please see if this helps:
http://code.google.com/p/activejdbc/wiki/DatabaseConnectionManagement?ts=1344540
457&updated=DatabaseConnectionManagement#Specifying_DB_Schema

Original comment by i...@polevoy.org on 9 Aug 2012 at 7:28