Project

General

Profile

« Previous | Next » 

Revision 892efc69

Added by Andreas Kohlbecker almost 14 years ago

merging /branches/cdmlib/SPRINT-Chichorieae1/ to trunk

View differences:

cdmlib-io/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/validation/BerlinModelOccurrenceImportValidator.java
47 47 
			try {
48 48 
				boolean result = true;
49 49 
				Source source = bmiConfig.getSource();
50 
				String strQuery = "SELECT emOccurrence.OccurrenceId, PTaxon.StatusFk, Name.FullNameCache, Status.Status " +
50 
				String strQuery = "SELECT emOccurrence.OccurrenceId, PTaxon.StatusFk, Name.FullNameCache, Status.Status, PTaxon.PTRefFk, Reference.RefCache " +
51 51 
							" FROM emOccurrence INNER JOIN " +
52 52 
								" PTaxon ON emOccurrence.PTNameFk = PTaxon.PTNameFk AND emOccurrence.PTRefFk = PTaxon.PTRefFk INNER JOIN " +
53 53 
				                " Name ON PTaxon.PTNameFk = Name.NameId INNER JOIN " +
54 
				                " Status ON PTaxon.StatusFk = Status.StatusId " +
54 
				                " Status ON PTaxon.StatusFk = Status.StatusId LEFT OUTER JOIN " +
55 
				                " Reference ON PTaxon.PTRefFk = Reference.RefId " +
55 56 
							" WHERE (PTaxon.StatusFk <> 1)  ";
56 57
57 58 
				ResultSet resulSet = source.getResultSet(strQuery);
......
66 67 
					int statusFk = resulSet.getInt("StatusFk");
67 68 
					String status = resulSet.getString("Status");
68 69 
					String fullNameCache = resulSet.getString("FullNameCache");
70 
					String ptRefFk = resulSet.getString("PTRefFk");
71 
					String ptRef = resulSet.getString("RefCache");
69 72
70 73 
					System.out.println("OccurrenceId:" + occurrenceId + "\n  Status: " + status +
71 
							"\n  FullNameCache: " + fullNameCache );
74 
							"\n  FullNameCache: " + fullNameCache +  "\n  ptRefFk: " + ptRefFk +
75 
							"\n  sec: " + ptRef );
76
72 77 
					result = firstRow = false;
73 78 
				}
74 79

Also available in: Unified diff