Skip to content

Instantly share code, notes, and snippets.

@pietrom
pietrom / jboss_resource-ref.xml
Created November 12, 2012 13:41
Resource-ref jboss.xml's fragment
<resource-ref>
<!-- Maps global 'x/y/ConnectionFactory jndi-name to component local java:comp/env/jms/QCF -->
<res-ref-name>jms/QCF</res-ref-name>
<jndi-name>x/y/ConnectionFactory</jndi-name>
</resource-ref>
@pietrom
pietrom / sybase-search-column.sql
Created November 12, 2012 10:53
How to search tables containing a column with given name in Sybase
select tab.name
from sysobjects tab
inner join syscolumns col
on tab.id = col.id
where tab.type = 'U'
and col.name = 'COLUMN_NAME_TO_SEARCH'
@pietrom
pietrom / sybase-table-metadata.sql
Created November 12, 2012 10:49
How to select table columns metadata from Sybase system tables
select *
from sysobjects tab
inner join syscolumns col
on tab.id = col.id
where tab.type = 'U'
and tab.name = 'TABLE_NAME'
@pietrom
pietrom / ejb-jar_res_ref.xml
Created November 9, 2012 08:09
Resource-ref ejb-jar.xml's fragment
<resource-ref>
<!-- local jndi name: lookup it using java:comp/env/jms/QCF -->
<res-ref-name>jms/QCF</res-ref-name>
<res-type>javax.jms.Container</res-type>
<res-auth>Container</res-auth>
</resource-ref>