package fr.gouv.finances.dgfip.xemelios.refCollecSpl.importer;
+import fr.gouv.finances.dgfip.xemelios.data.DataImpl;
+import fr.gouv.finances.dgfip.xemelios.data.DataLayerManager;
import fr.gouv.finances.dgfip.xemelios.data.impl.pool.PoolManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
String ret = "Non";
Connection con = null;
try {
- con = PoolManager.getInstance().getConnection();
- PreparedStatement ps = con.prepareStatement("SELECT 1 FROM CG_ACCUEIL_IX WHERE COLLECTIVITE=? AND EXERCICE=?");
+ DataImpl dataLayer = DataLayerManager.getImplementation();
+ String layerName = dataLayer.getLayerName();
+ String query = ("oracle".equals(layerName) ? "SELECT 1 FROM CG_ACCUEIL WHERE COLLECTIVITE=? AND EXERCICE=?" : "SELECT 1 FROM CG_ACCUEIL_IX WHERE COLLECTIVITE=? AND EXERCICE=?" );
+
+ con = PoolManager.getInstance().getConnection();
+ PreparedStatement ps = con.prepareStatement(query);
+
ps.setString(1,collectivite);
ps.setString(2,annee);
ResultSet rs = ps.executeQuery();