Subject | Re: [Firebird-Java] ApacheMQ and Firebird |
---|---|
Author | Roman Rokytskyy |
Post date | 2011-08-15T07:53:22Z |
> I have installed Jaybird. Because I want to use ApacheMQ and FirebirdIn the docs I see nothing that would prevent it from running.
> together. ApacheMQ allows any JDBC connection for persistent storage.
> Has anyone else done this?
One tip - if your messages will be smaller than 32K (minus size of
other columns), I would use an adapter that stores data in VARCHAR
columns:
public class FirebirdJDBCAdapter extends BytesJDBCAdapter {
@Override
public void setStatements(Statements statements) {
statements.setBinaryDataType("VARCHAR(32000)");
super.setStatements(statements);
}
}
Reason is that fetching data from BLOB requires an additional roundtrip
to the database. If you cannot guarantee that payload will be smaller
than 32k, use BLOB adapter.
> By the way incredibly quiet in the group no messages for at least 4The last message in the group is dated by 28.07.2011... check your
> months
email/subscription. :)
Roman