Tushar Ravi

Thanks Paul for your valuable feedback. I did try creating a separate project and run the same program with only the jars related for this but still in vain

The below code works fine for HSSFWorkbook but it gives me an error when using for XSSFWorkbook.

Exception in thread "main" java.lang.NoSuchMethodError: schemasMicrosoftComVml.CTShape.getClientDataList()Ljava/util/List;
at org.apache.poi.xssf.usermodel.XSSFComment.setColumn(XSSFComment.java:127)
at org.apache.poi.xssf.usermodel.XSSFDrawing.createCellComment(XSSFDrawing.java:302)
at org.apache.poi.xssf.usermodel.XSSFDrawing.createCellComment(XSSFDrawing.java:50)

The error is thrown for the line Comment comment = drawing.createCellComment(anchor);

private static void addCellComments() { try { Workbook wb = new XSSFWorkbook(); //or new HSSFWorkbook(); CreationHelper factory = wb.getCreationHelper(); Sheet sheet = wb.createSheet(); Row row = sheet.createRow(3); Cell cell = row.createCell(5); cell.setCellValue("F4"); Drawing drawing = sheet.createDrawingPatriarch(); // When the comment box is visible, have it show in a 1x3 space ClientAnchor anchor = factory.createClientAnchor(); anchor.setCol1(cell.getColumnIndex()); anchor.setCol2(cell.getColumnIndex() + 1); anchor.setRow1(row.getRowNum()); anchor.setRow2(row.getRowNum() + 3); // Create the comment and set the text+author Comment comment = drawing.createCellComment(anchor); RichTextString str = factory.createRichTextString("Hello, World!"); comment.setString(str); comment.setAuthor("Apache POI"); // Assign the comment to the cell cell.setCellComment(comment); FileOutputStream out = new FileOutputStream("D:/Test.xlsx"); wb.write(out); out.close(); } catch (Exception e) { e.printStackTrace(); } }

Any help appreciated. Thanks in advance.

Hello All,

I am not able to get the desired results. Can any one of you help me?

@Test public void test1() throws Exception { String formula = "AVG(SUM(AVG(M1)))"; match(formula); } private void match(String formula) throws Exception { String regex = "AVG(.*)"; Pattern pattern = Pattern.compile(regex); Matcher matcher = pattern.matcher(formula); while (matcher.find()) { for (int i = 1; i <= matcher.groupCount(); i++) { System.out.println(i + "----------" + matcher.group(i)); } } }

The results are
1----------(SUM(AVG(M1)))

What i expect is
1----------(SUM(AVG(M1)))
2----------(M1)

How can i achieve this?

Thanks in advance.

Hello friends,

I am facing an error if I use the tablename from the collection in PL/SQL.

Below is the SQL
SET serveroutput ON; DECLARE type code IS TABLE OF VARCHAR2(100); type pd_code IS TABLE OF VARCHAR2(100); tc code; pc pd_code; uri VARCHAR2(100); BEGIN SELECT DISTINCT code bulk collect INTO tc FROM my_tables my_tables FOR i IN tc.FIRST .. tc.LAST LOOP uri := SUBSTR(tc(i), 5, LENGTH(tc(i))); SELECT DISTINCT uri bulk collect INTO pc FROM tc(i); END LOOP; FOR i IN pc.FIRST .. pc.LAST LOOP DBMS_OUTPUT.PUT_LINE(pc(i)); END LOOP; END;

The error i get : SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"

for SELECT DISTINCT uri bulk collect INTO pc FROM tc(i);

Can you please help?

Thanks in Advance
Tushar.

Hi there,

I am facing an error while executing the below code.

public void batchUpdate() throws Exception { Connection conn = null; PreparedStatement statement = null; StringBuilder sql = new StringBuilder(); try { conn = getOracleConnection(); // Using JDBC commands sql.append("INSERT INTO EMPLOYEE (ID,NAME) VALUES (1,'JOHN')"); sql.append("INSERT INTO EMPLOYEE (ID,NAME) VALUES (1,'JIM')"); statement = conn.prepareStatement(sql.toString()); statement.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { statement.close(); conn.close(); } }

The exception thrown is

java.sql.SQLException: ORA-00933: SQL command not properly ended

If i give semicolon at the end of the sqls i get
java.sql.SQLException: ORA-00911: invalid character

Any suggestions appreciated.

Thanks in advance

Tushar.

Congratulations !! And many thanks for your feedback

Awesome reply fred . I liked the way you explained with the example "Go clean your room" .

Thanks a lot.

Tushar

Hi guys,

I have question on this topic.

I have an interface ViewActions.java
public interface ViewActions { public int testData(); }

another interface DataActions.java
public interface DataActions{ public int testData(); }


I am implementing the above interfaces in a class Test.java

public class Test implements ViewActions, DataActions { public int testData() { } }

This compiles and runs fine.

I want to know how will this work ? How will the JVM know if the testData() overridden is from DataActions.java or ViewActions.java.

Many thanks in advance.

Tushar

Thanks a lot to all of you for your valuable comments. Marc you explanation was awesome .

Abimaran,

Will check the forum before I post ;)

Hello guys,

This is my first post in the forum, and definetly not the last

I have a doubt on the downcasting concept. I am trying to convert Object to String.

Object obj = new Object();

String s = obj; // This throws compilcation error.


To prevent the compilation error I change the code to
String s = (String) obj ; // Downcasting ...

But then i get a runtime error for class cast exception.

In that case how can i ever cast a parent to child, and does the downcast concept really work?

Any help appreciated .

Sorry for posting it here. First time user

Thanks

Tushar.