Jan 20, 2011

Invalid row number (100039) outside allowable range (0..65535)

Lately i got this error while using apache poi version 3.2 but it's still exists in 3.7:
"the poi 3.2 or 3.7 version support till 65535 max rows not more"

Actually, excel 2003 maximum rows in a sheet is 65535, but since than in version like in excel 2007 and excel 2010
the maximum rows per sheet is around 1m. But apache poi still doesn't support this amount of rows.

Meaning, that you need to split into several sheets
Something like this:

if (i>65535){ // or some other number or condirion
    // create a new sheet
    sheet = workBook.createSheet();
   i = 1;

Hoped that it helps,


Jan 6, 2011

java.lang.ClassNotFoundException: javassist.util.proxy.MethodFilter

I got this error while using maven, jetty, wicket, spring and hibernate all with annotations.
Found two solutions
1) Get the java assist jar using maven, but them i got into some other problems.

2) Use this :

It seems that it solved the issue since the jaxrs contains this method filter.

If you know other or better solution, i am here to listen.

Hoped it helped,

Jan 4, 2011

org.postgresql.util.PSQLException: ERROR: syntax error at or near

This happen when you have a name which is a reserved name or already exists by a table for example.

Lets say your are trying to add a new table and the error was:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "User"

You got this error since the postgresql in the current schema has already a User table and this name is reserved.
Change your table (if in your case like this example, it's a table issue) name to a different.

Hoped it helps.


Started SelectChannelConnector@

I am not saying it's ok to receive this kind of message, but if you did, try
accessing your jetty server via http://localhost:8080 or http://ip_address:8080

Hoped it helps.


By the way there is a nice paper back book from amazon named Jetty (Web Server)

addComponentInstantiationListener in wicket 1.5


In 1.4 we could do this :  addComponentInstantiationListener(springInjector);

The only solution that i found in 1.5 M3 is calling the super and doing this like:

Maybe in later versions it will be more easy.

Wicket in Action