How to programmatically dump the threads list of a running java process in bash

It seems that jdb cannot accept commands from command line, so we must use expect.
I created the following expect script dumpthreads
You can use it like:
dumpthreads java_process_pid

#!/usr/bin/expect
set pid [lindex $argv 0];
spawn jdb -connect sun.jvm.hotspot.jdi.SAPIDAttachingConnector:pid=$pid;
expect ">";
send "threads\n";
expect ">";
send "quit\n";

How to convince the SmartGWT ListGrid to automatically fetch from the server only the data it displays

Since I was looking all over the net how to do this and I only found pieces of information, here is an example:

[java]
public class OperationsGrid extends ListGrid{
OperationsGrid(){
super();
TreeGridField accNoField = new TreeGridField(“accountNo”, 150);
TreeGridField commentField = new TreeGridField(“comment”, 150);

setFields(accNoField,commentField);
setHeight100();
setWidth100();
setAutoFetchData(true);
setAlternateRecordStyles(true);
setDataSource(OperationsDS.getInstance());
setShowFilterEditor(true);
}
}
[/java]

[java]
public class OperationsDS extends DataSource{
static OperationsDS instance = null;
static OperationsDS getInstance(){
if(instance == null){
instance = new OperationsDS();
}
return instance;
}

OperationsDS(){

setDataURL(xpath);
DataSourceTextField noField = new DataSourceTextField(“accountNo”, “Account Number”, 128);
DataSourceTextField commentField = new DataSourceTextField(“comment”, “Comment”, 128);

noField.setRequired(true);
noField.setPrimaryKey(true);

setFields(noField,commentField);
setDataFormat(DSDataFormat.JSON);
setRecordXPath(“response/result”);
setClientOnly(false);
}
@Override
protected Object transformRequest(DSRequest dsRequest){
String url = null;

if(dsRequest.getOperationType().equals(DSOperationType.FETCH)){
dsRequest.setActionURL(getDataURL()+”&start=”+dsRequest.getStartRow()+”&end=”+dsRequest.getEndRow());
}
return super.transformRequest(dsRequest);
}
@Override
protected void transformResponse(DSResponse response, DSRequest request,
Object data) {
DSOperationType operationType = request.getOperationType();

if (operationType == DSOperationType.FETCH) {
JSONArray info = XMLTools.selectObjects(data, “/response/resultInfo/numTotalRows”);
Integer total = (int)Math.round(info.get(0).isNumber().doubleValue());

info = XMLTools.selectObjects(data, “/response/resultInfo/startRow”);
Integer start = (int)Math.round(info.get(0).isNumber().doubleValue());

info = XMLTools.selectObjects(data, “/response/resultInfo/endRow”);
Integer end = (int)Math.round(info.get(0).isNumber().doubleValue());

if(total != null)
response.setTotalRows(total);
if(start != null)
response.setStartRow(start);
if(end != null)
response.setEndRow(end);
} else {
super.transformResponse(response, request, data);
}

}
}
[/java]

In this example the server outputs in JSON format and returns the the current start row, current end row and total number of rows in response/resultInfo.
Basically you need to override transformRequest and transformResponse. In transformRequest you should add the start and end row to the requestURL and in transformResponse you should set the startRow, endRow, and totalRows, provided that you receive this information from your server. Also don’t forget to setAutoFetchData(true) on the grid.

Hope this helps somebody.

MySQL Java SQLException error codes enum

Because I had this problem and I could not find a list of MySQL error codes on the Internet, I’ve decided to implement my own MySQL error codes enum. It is based on MySQL 5.1.35 sources, include/mysqld_ername.h file.
Now I can do something like this:

[java]
catch (SQLException e) {
if(e.getErrorCode() == MySQLExceptionCode.ER_DUP_ENTRY.getErrorCode()){
r = Result.DUPLICATE_ACCOUNT_NO;
} else
r = Result.DATABASE_ERROR;
}
[/java]

You can find the java file here.