Visa alla stored procedures i SQL-server
I korthet ser det ut så här:
SELECT
ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND OBJECTPROPERTY
(
OBJECT_ID(ROUTINE_NAME),
'IsMsShipped'
) = 0
ORDER BY ROUTINE_NAME
Min loggbok på nätet, knappast intressant för någon.
SELECT
ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND OBJECTPROPERTY
(
OBJECT_ID(ROUTINE_NAME),
'IsMsShipped'
) = 0
ORDER BY ROUTINE_NAME
Ungefär så här ser mina xml filer ut:
ejb.xml<ejb-jar>
<enterprise-beans>
<session>
<ejb-name>
junit.framework.ejb.TestRunnerSession
</ejb-name>
<home>junit.framework.ejb.TestRunnerSessionHome</home>
<remote>junit.framework.ejb.TestRunnerSession</remote>
<ejb-class>
junit.framework.ejb.TestRunnerSessionBean
</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<env-entry>
<description>UserActionLog</description>
<env-entry-name>UserActionLogClass</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>
theapp.model.dao.UserActionLogDAOOracle
</env-entry-value>
</env-entry>
<resource-ref>
<res-ref-name>jdbc/OraclePool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</session>
</enterprise-beans>
</ejb-jar>
jboss.xml
=========
<jboss>
<enterprise-beans>
<session>
<ejb-name>junit.framework.ejb.TestRunnerSession</ejb-name>
<jndi-name>junit.framework.ejb.TestRunnerSession</jndi-name>
<resource-ref>
<res-ref-name>jdbc/OraclePool</res-ref-name>
<jndi-name>java:/jdbc.OracleData</jndi-name>
</resource-ref>
</session>
</enterprise-beans>
</jboss>
public class TestDAO extends MyDAO {
protected Connection getConnection(String datasource)
throws NamingException, SQLException {
try {
Class.forName("com.inet.tds.TdsDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return DriverManager.
getConnection(
"jdbc:inetdae:dbServer.com:1433?database=db1"
, "user", "password");
}
}