Revision 74

View differences:

org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/main/java/org/gvsig/oracle/dal/operations/OracleListTablesOperation.java
61 61 
	    		builder.append(EXCLUDE_SYSTEM_TABLES_FILTER);
62 62 
	    	}
63 63 
	    	if (schema!=null) {
64 
	    		if (!where) {
64 
	    		if (where) {
65 
	    			builder.append(" AND ");
66 
	    		}
67 
	    		else {
65 68 
	    			builder.append(" WHERE ");
66 69 
	    		}
67 70 
	    		builder.append(METADATA_COLUMN_TABLE_OWNER);
68 
	    		builder.append(" = ");
71 
	    		builder.append(" = '");
69 72 
	    		builder.append(schema);
73 
	    		builder.append("'");
70 74 
	    	}
71 75 
	    	builder.append(" UNION ");
72 76 
	    	builder.append(ALL_VIEWS_QUERY);
......
79 83 
	    		where = false;
80 84 
	    	}
81 85 
	    	if (schema!=null) {
82 
	    		if (!where) {
86 
	    		if (where) {
87 
	    			builder.append(" AND ");
88 
	    		}
89 
	    		else {
83 90 
	    			builder.append(" WHERE ");
84 91 
	    		}
85 92 
	    		builder.append(METADATA_COLUMN_TABLE_OWNER);
86 
	    		builder.append(" = ");
93 
	    		builder.append(" = '");
87 94 
	    		builder.append(schema);
95 
	    		builder.append("'");
88 96 
	    	}
89 97 
	        Statement st = null;
90 98 
	        ResultSet rs = null;

Also available in: Unified diff