Padmanabh Sahasrabudhe

To make it more clear. Suppose I have a HA scenario where I have 5 instances of my application server should be installed in parallel and then run a set of tests. In this case waiting sequentially for 5 jobs to complete is time consuming. Triggering 5 jobs in parallel with one slave each may be a solution but not sure if I can have completion status as in put parametter from all the 5 jobs to a next job which will run the tests. So I was looking at a way to have the installation of 5 instances on 5 different machines through one jenkins job and then run the tests in the same job. I hope I am clear now. Thanks for link to Selenium Grid .

Thanks Jeanne.

By more than one slave I meant I can't use more than one slave in one job.

Imagine I start a job which requires silent installation of test server on more than one machine and then trigger automation tests in the same job. Is this possible with jenkins? I read the link you have given, but didn't get any explicit mention of this.

Thanks,
Padmanabh

Has anybody used any Jenkins plugin for HA kind of testing deployment setup on different machines?

Jenkins allows only 1 slave machine which can be used for standalone server testing automation setup.

But if I want to have a distributed setup on different machines is there any way available in Jenkins or other tool?

Regards,
Padmanabh

I have following code to which I pass j.testcase parameter. Somehow the value I pass for j.testcase is not picked up by the target run. I pass the parameter as ant run -Dj.testcase=Test2. Any comments?

<target name="run" depends="setup"> <switch value="${j.testcase}"> <case value="Test1"> <antcall target="Test1" inheritAll="true" inheritRefs="true"/> </case> <case value="Test2"> <antcall target="Test2" inheritAll="true" inheritRefs="true"/> </case> <case value="Test3"> <antcall target="Test3" inheritAll="true" inheritRefs="true"/> </case> <case value="Test4"> <antcall target="Test4" inheritAll="true" inheritRefs="true"/> </case> <case value="all"> <antcall target="Test1" inheritAll="true" inheritRefs="true"/> <antcall target="Test2" inheritAll="true" inheritRefs="true"/> <antcall target="Test3" inheritAll="true" inheritRefs="true"/> <antcall target="Test4" inheritAll="true" inheritRefs="true"/> </case> <default> <echo message="Allowed values for -Dj.testcase :"/> <echo message=" Test1"/> <echo message=" Test2"/> <echo message=" Test3"/> <echo message=" Test4"/> </default> </switch> <antcall target="postrun"/> </target>

Sorted out the column order issue. I am pasting the code here for others if ineterested. I used opencsv here.

public static void main(String[] args) throws Exception { // TODO Auto-generated method stub final String csvfile2 = "C:\\ooordered.csv"; CSVReader reader = new CSVReader(new FileReader(csvfile2)); String [] nextLine,sortedNextLine; List<String> columns = new ArrayList<String>(); List<String> sortedColumns = new ArrayList<String>(); Map<Integer,Integer> map = new HashMap<Integer,Integer>(); if ((nextLine = reader.readNext()) != null) { int i = nextLine.length; for(int j=0;j<i;j++){ columns.add(nextLine[j]); sortedColumns.add(nextLine[j]); } Collections.sort(sortedColumns); } for(int i=0;i<columns.size();i++){ String str = columns.get(i); map.put(i, sortedColumns.indexOf(str)); } for(int i=0;i<map.size();i++){ System.out.println(" key is :" + i + ", value is :" + map.get(i)); } CSVWriter writer = new CSVWriter(new FileWriter("C:\\yourfile.csv"), ',',CSVWriter.NO_QUOTE_CHARACTER); sortedNextLine = new String[sortedColumns.size()]; System.out.println(sortedNextLine.length); //System.out.println(sortedNextLine[0] + "-" + sortedNextLine[1]); for(int k = 0; k >< sortedColumns.size(); k++){ sortedNextLine[k] = sortedColumns.get(k); System.out.println(sortedNextLine[k]); } writer.writeNext(sortedNextLine); while ((nextLine = reader.readNext()) != null) { for(int count=0;count < nextLine.length ; count++){ String str = nextLine[count]; sortedNextLine[map.get(count)] = str; } writer.writeNext(sortedNextLine); } writer.close(); }

resolved..writer.close() was missing.

I am having the following code which I expect to run on following csv file and print A,B,C in new file yourfile.csv. Somehow I see that I am entering a null record. Could anybody tell me whats wrong with following code?
ooordered.csv file
B,A,C
e,2,r
a,1,e
q,3,w

Code:

import java.io.FileReader; import java.io.FileWriter; import java.util.ArrayList; import java.util.Collections; import java.util.HashMap; import java.util.List; import java.util.Map; import au.com.bytecode.opencsv.CSVReader; import au.com.bytecode.opencsv.CSVWriter; public class CompareCsv { /** * @param args * @throws Exception */ public static void main(String[] args) throws Exception { // TODO Auto-generated method stub final String csvfile2 = "C:\\ooordered.csv"; CSVReader reader = new CSVReader(new FileReader(csvfile2)); String [] nextLine,sortedNextLine; List<String> columns = new ArrayList<String>(); List<String> sortedColumns = new ArrayList<String>(); if ((nextLine = reader.readNext()) != null) { int i = nextLine.length; for(int j=0;j<i;j++){ columns.add(nextLine[j]); sortedColumns.add(nextLine[j]); } Collections.sort(sortedColumns); } Map><Integer,Integer> map = new HashMap<Integer,Integer>(); for(int i=0;i<columns.size();i++){ String str = columns.get(i); map.put(i, sortedColumns.indexOf(str)); } for(int i=0;i<map.size();i++){ System.out.println(" key is :" + i + ", value is :" + map.get(i)); } CSVWriter writer = new CSVWriter(new FileWriter("C:\\yourfile.csv"), ','); sortedNextLine = new String[sortedColumns.size()]; System.out.println(sortedNextLine.length); //System.out.println(sortedNextLine[0] + "-" + sortedNextLine[1]); for(int k = 0; k >< sortedColumns.size(); k++){ System.out.println(sortedColumns.get(k)); sortedNextLine[k] = sortedColumns.get(k); } writer.writeNext(sortedNextLine); } }

All,

I think I need to reframe my problem. I was behind a wrong issue. My issue is I have these two files

A,B,C
1,a,e
3,q,w
2,e,r

and
B,A,C
a,1,e
e,2,r
q,3,w

Technically, both of these files contains same data which I want to verify the same through my code. Winston, I am not generating data from Excel but thanks for your pointers.

I only wish to see if the rows which file 1 has are all present in file 2 or not. I need not retain them. The contents of the two files should same row wise.

Ritchie,

Not sure what you meant? Could you please demonstrate with little code? Also, how using maps will help me getting rid scenario where columns and rows both are out of order?

Thanks,
Padmanabh

Junilu,
ABC are column headers. But 1,2,3 need not be row headers since the order in which the data is exported is uncertain. Assuming I get consistent column order (say A,B,C everytime) I use following code. But I am not sure how to deal with it when it comes out of order (B,A,C).

/** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try { HashSet<String> f1 = new HashSet<String>(FileUtils.readLines(new File("C:\\ordered.csv"))); HashSet<String> f2 = new HashSet<String>(FileUtils.readLines(new File("C:\\ooordered.csv"))); HashSet<String> f3 = new HashSet<String>(FileUtils.readLines(new File("C:\\ordered.csv"))); f1.removeAll(f2); f2.removeAll(f3); if(f1.isEmpty()&&f2.isEmpty()){ System.out.println("Hurray, test passed!!!"); } if(f1.isEmpty()&&!f2.isEmpty()){ System.out.println("Hurray, test failed since f2 has more records!!!"); } if(!f1.isEmpty()&&f2.isEmpty()){ System.out.println("Hurray, test failed since f1 has more records!!!"); } if(!f1.isEmpty()&&!f2.isEmpty()){ System.out.println("Hurray, test failed since the files have unequal records!!!"); } } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

Thanks,
Padmanabh

I get a csv file from an export utility which has different column order every time. For example the first time it may export the following csv file

A,B,C
1,a,e
3,q,w
2,e,r

The second time it may export the same file as following data:

B,A,C
a,1,e
e,2,r
q,3,w

I am not bothered about change in row order since I have a program which can compare the two csv files correctly even if they have rows out of order but I don't know how to overcome the change in column order. Is there a way to process this csv file and get another file of fixed column order?

Thanks.

Hi All,

I have two questions:

1] When I point the maven project in eclipse to the settings.xml I get a new Maven llibrary in the Java Build Path. I am not sure from where does the eclipse pick up these jars.

2] Maven at present is not recognising the environment variables I use in settings.xml and pom.xml. Right now, I have substituted them with hard coded absolute path. But is there a way to make maven understand the environmnet variables during designtime?

Thanks.

Hi All,

I went thru' the earlier question posted on the forum and applied all the workaround fixes in my code but I am still seeing this issue. Can anybody help me?
public static JGeometry getGeometry(String geometryName) throws Exception{ /// reading a geometry from database Connection conn = getJDBCConnection(); Statement statement = conn.createStatement(); ResultSet rs = statement.executeQuery("SELECT geom from my_geom_type where geom_name='"+geometryName+"'"); System.out.println("Query is " + "SELECT geom from my_geom_type where geom_name='"+geometryName+"'"); rs.next(); STRUCT st = (oracle.sql.STRUCT) rs.getObject(1); JGeometry j_geom = JGeometry.load(st); rs.close(); statement.close(); conn.close(); return j_geom; }

When I make this query I get one row returned from the sqlplus prompt.
I also tried using the column name instead of int 1 in getObject. Also how can I make sure that I close all the earlier resultsets and statement called from this code?
This is the stacktrace till my class it called:
java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:813)
at oracle.jdbc.driver.OracleResultSet.getObject(OracleResultSet.java:458)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getObject(Unknown Source)

Thanks,

Sorry the full Stacktrace is:
Supports getGeneratedKeys(): true
java.sql.SQLException: Unsupported feature
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:765)
at oracle.jdbc.driver.PhysicalConnection.createSQLXML(PhysicalConnection.java:8893)
at my.SQLXMLType.storeXMLDocument(SQLXMLType.java:58)
at my.SQLXMLType.getSQLXML(SQLXMLType.java:134)
at my.SQLXMLType.main(SQLXMLType.java:51)