Fail to connect with firebird database using jboss 4
Hello
I am encountering with the problem and that problem eat up my one week. i am not able to run the program appropriately instead i have followed the instructions. What i am doing is that i have developed the session bean which makes connection with firebird database.
I have configured firebird file which is shown as follows:
<?xml version="1.0" encoding="UTF-8"?> <!-- ==================================================================== --> <!-- New ConnectionManager setup for firebird dbs using jca-jdbc xa driver--> <!-- Build jmx-api (build/build.sh all) and view for config documentation --> <!-- ==================================================================== --> <connection-factories> <!--FBManager can be used to create and drop databases. Drop is especially useful during testing, since it assures a clean start next time. --> <mbean code="org.firebirdsql.management.FBManager" name="jboss.jca:service=FirebirdManager"> <attribute name="FileName">D:/Program Files/Firebird/Firebird_1_5/examples/TAX.FDB</attribute> <attribute name="UserName">sysdba</attribute> <attribute name="Password">sa</attribute> <attribute name="CreateOnStart">true</attribute> <attribute name="DropOnStop">false</attribute> </mbean> <tx-connection-factory> <jndi-name>FirebirdDS</jndi-name> <xa-transaction/> <rar-name>firebirdsql.rar</rar-name> <adapter-display-name>Firebird Database Connector</adapter-display-name> <config-property name="Database" type="java.lang.String">localhost/3050:D:/Program Files/Firebird/Firebird_1_5/examples/TAX.FDB</config-property> <user-name>sysdba</user-name> <password>sa</password> <!--additional properties. only use one way of setting tx isolation, please <config-property name="TransactionIsolation"></config-property> <config-property name="TransactionIsolationName">TRANSACTION_READ_COMMITTED</config-property> <config-property name="BlobBufferLength"></config-property> <config-property name="Encoding">UNICODE_FSS</config-property> --> <min-pool-size>0</min-pool-size> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <!-- sql to call on an existing pooled connection when it is obtained from pool <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> </tx-connection-factory> </connection-factories>
i have deployed firebird-ds.xml and firebirdsql.jar files together in server default deploy folder.
Now i have coded one session bean with files (QueryDB.java, QueryDBBean.java, QueryHome.java, jboss.xml and ejb-jar.xml) which simply makes connection with firebird database and run one simple query.
Code for the above mentioned files are as follows:
QueryDBHome.java
package day09;
import java.rmi.RemoteException;
import javax.ejb.*;
/**
* @author Administrator
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public interface QueryDBHome extends EJBHome {
QueryDB create() throws CreateException, RemoteException;
}QueryDB.java
package day09;
import java.util.*;
import javax.ejb.*;
import java.rmi.RemoteException;
/*
EnrollmentCart is the remote interface for enrollment cart
stateful session bean.
*/
public interface QueryDB extends EJBObject
{
public void initDB() throws RemoteException;
public void doDDL() throws RemoteException;
public void getMetaData() throws RemoteException;
public void helloWorld() throws RemoteException;
}QueryDBBean.java
package day09;
import java.util.*;
import javax.ejb.*;
import javax.naming.*;
import java.sql.*;
/**
* QueryDBEJB is stateless session bean to query database properties
*/
public class QueryDBBean implements SessionBean {
public void initDB(){
try {
System.out.println("\nDay 9: Demonstrate the use of JDBC...\n");
System.out.println("initDB: Get initial context from the JNDI service...");
ctx = new InitialContext();
System.out.println("Lookup the DataSource as configured by administrator...");
ds = (javax.sql.DataSource)ctx.lookup ("java:comp/env/jdbc/styejbDB");
System.out.println("Getting a Connection from the pool...");
conn = ds.getConnection();
System.out.println("Connection is obtained...");
} catch (Exception e) {
System.out.println("Exception was thrown: " + e.getMessage());
} finally {
try {
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
} catch (SQLException sqle) {
System.out.println("SQLException during close(): " + sqle.getMessage());
}
}
}
public void doDDL(){
System.out.println("Run some DDL statements:");
try{
if (ctx == null)
initDB();
conn = ds.getConnection();
stmt = conn.createStatement();
try {
System.out.println("Trying to drop table DAY09_STUDENTS...");
stmt.execute("DROP TABLE DAY09_STUDENTS");
} catch (SQLException e) {
System.out.println("Table DAY09_STUDENTS already exists.");
}
stmt.execute("CREATE TABLE DAY09_STUDENTS (student_id varchar(12),"+
"first_name varchar(15),"+
"last_name varchar(15),"+
"address varchar(64))");
System.out.println("Table DAY09_STUDENTS is created...");
System.out.println("Run some DML statements:");
stmt.executeUpdate("INSERT into DAY09_STUDENTS values " +
"('1', 'LILLIAN', 'GHALY', '15 DIAMOND ST, BOSTON, MA')");
stmt.executeUpdate("INSERT into DAY09_STUDENTS values " +
"('2', 'DOUG','ZANDER','11 ORANGE AVE, SACRAMENTO, CA' )");
stmt.executeUpdate("INSERT into DAY09_STUDENTS values " +
"('3', 'SAM','LE', '12 APPLEBEE RD, LOS ANGELES, CA' )");
stmt.executeUpdate("DELETE from DAY09_STUDENTS where student_id = '2'");
rs = stmt.executeQuery("SELECT * from DAY09_STUDENTS");
// Get some Metadata about result set
System.out.println("Query ResultSet Metadata:");
rsmd = rs.getMetaData();
cn = rsmd.getColumnCount();
for (i=1; i<= cn ; i++) {
if (i>1) System.out.print(", ");
System.out.print(rsmd.getColumnLabel(i));
}
System.out.println("");
while (rs.next()) {
for (i=1; i<= cn ; i++) {
if (i>1) System.out.print(", ");
System.out.print(rs.getString(i));
}
System.out.println("");
}
} catch (Exception e) {
System.out.println("Exception was thrown: " + e.getMessage());
} finally {
try {
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
} catch (SQLException sqle) {
System.out.println("SQLException during close(): " + sqle.getMessage());
}
}
}
public void helloWorld(){
try{
System.out.println("Hello world method called");
}
catch(Exception e){
System.out.println("Exception was thrown: " + e.getMessage());
}
}
public void getMetaData() {
// Get some Metadata about database
System.out.println("Query Database Metadata:");
try{
if (ctx == null)
initDB();
conn = ds.getConnection();
dbmd = conn.getMetaData();
System.out.println(" Product Name: " + dbmd.getDatabaseProductName());
System.out.println(" Driver Name: " + dbmd.getDriverName());
rs = dbmd.getSchemas();
System.out.println("Database Schemas:");
rsmd = rs.getMetaData();
cn = rsmd.getColumnCount();
for (i=1; i<= cn ; i++) {
if (i>1) System.out.print(", ");
System.out.print(rsmd.getColumnLabel(i));
}
System.out.println("");
while (rs.next()) {
for (i=1; i<= cn ; i++) {
if (i>1) System.out.print(", ");
System.out.print(rs.getString(i));
if (schema == null)
schema = new StringBuffer(rs.getString(i));
}
System.out.println("");
}
String[] types = {"TABLE"};
if ( schema == null ) {
schema = new StringBuffer("TABLE_SCHEM");
}
System.out.println("Printing all Data Tables for Schema: " + schema);
rs = dbmd.getTables(null, schema.toString(), null, types);
String ostr = "";
while (rs.next()){
ostr = "";
String tableName = rs.getString("TABLE_NAME");
System.out.println("Table Name: " + tableName);
ResultSet rsc = dbmd.getColumns(null,null,tableName,"%");
rsmd = rsc.getMetaData();
cn = rsmd.getColumnCount();
for (i=1; i<= cn ; i++) {
if (i>1) ostr += ", ";
ostr += rsmd.getColumnLabel(i);
}
ostr += "\n";
while (rsc.next()) {
for (i=1; i<= cn ; i++) {
if (i>1) ostr += ", ";
ostr += rsc.getString(i);
}
ostr += "\n";
}
System.out.print(ostr);
}
} catch (Exception e) {
System.out.println("Exception was thrown: " + e.getMessage());
} finally {
try {
if (conn != null)
conn.close();
} catch (SQLException sqle) {
System.out.println("SQLException during close(): " + sqle.getMessage());
}
}
}
public void setSessionContext(SessionContext ctx) {this.bctx = ctx;}
public void ejbCreate() throws CreateException {System.out.println("ejbCreate()");}
public void ejbRemove() {System.out.println("ejbRemove()");}
public void ejbActivate() {System.out.println("ejbActivate()");}
public void ejbPassivate() {System.out.println("ejbPassivate()");}
private SessionContext bctx;
private Context ctx = null;
private StringBuffer schema = null;
private javax.sql.DataSource ds = null;
private java.sql.Connection conn = null;
private java.sql.Statement stmt = null;
private java.sql.ResultSet rs = null;
private java.sql.ResultSetMetaData rsmd = null;
private java.sql.DatabaseMetaData dbmd = null;
private int cn, i;
}And there is one other file called Client.java
/*
* Created on Nov 11, 2004
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
/**
* @author Administrator
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
import java.util.*;
import java.rmi.*;
import java.io.*;
import javax.naming.*;
import javax.ejb.*;
import day09.*;
public class Client {
public static void main(String[] args) {
Context initialContext = null;
QueryDBHome qdbHome = null;
QueryDB qdb = null;
System.out.print("\nDay 9: Demonstration the use of JDBC...\n ");
try
{
System.out.print("Looking up the QueryDB home via JNDI.\n");
initialContext = new InitialContext();
Object object = initialContext.lookup("day09/QueryDBHome");
qdbHome = (QueryDBHome)
javax.rmi.PortableRemoteObject.narrow(object, QueryDBHome.class);
System.out.print("Creating an Query DB.\n");
qdb = (QueryDB) qdbHome.create();
qdb.initDB();
System.out.print("Called init db.\n");
qdb.doDDL();
System.out.print("Called doDDL DB.\n");
qdb.getMetaData();
System.out.print("Called getMetaData DB.\n");
qdb.helloWorld();
}catch ( Exception e){
e.printStackTrace();
}
}
}
When i run the client i see the following result
Day 9: Demonstration the use of JDBC...
Looking up the QueryDB home via JNDI.
Creating an Query DB.
Called init db.
Called doDDL DB.
Called getMetaData DB.
And on the server side i see the following result when i run the client
2004-11-12 01:37:43,625 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing: MBeans waiting for other MBeans: ObjectName: jboss.jca:service=TxCM,name=FirebirdDS state: CREATED I Depend On: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS jboss.jca:service=CachedConnectionManager jboss:service=TransactionManager Depends On Me: jboss.jca:service=ConnectionFactoryBinding,name=FirebirdDS ObjectName: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS state: CREATED I Depend On: jboss.jca:service=ManagedConnectionFactory,name=FirebirdDS Depends On Me: jboss.jca:service=TxCM,name=FirebirdDS ObjectName: jboss.jca:service=ManagedConnectionFactory,name=FirebirdDS state: FAILED I Depend On: jboss.jca:service=RARDeployment,name='firebirdsql.rar' Depends On Me: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS org.jboss.deployment.DeploymentException: couldn't get oldRarDeployment! jboss.jca:service=RARDeployment,name='firebirdsql.rar'; - nested throwable: (org.jboss.deployment.DeploymentException: ConnectionDefinition 'null' not found in rar 'firebirdsql.rar') ObjectName: jboss.jca:service=ConnectionFactoryBinding,name=FirebirdDS state: CREATED I Depend On: jboss.jca:service=TxCM,name=FirebirdDS Depends On Me: MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM: ObjectName: jboss.jca:service=ManagedConnectionFactory,name=FirebirdDS state: FAILED I Depend On: jboss.jca:service=RARDeployment,name='firebirdsql.rar' Depends On Me: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS org.jboss.deployment.DeploymentException: couldn't get oldRarDeployment! jboss.jca:service=RARDeployment,name='firebirdsql.rar'; - nested throwable: (org.jboss.deployment.DeploymentException: ConnectionDefinition 'null' not found in rar 'firebirdsql.rar') 2004-11-12 01:37:43,625 DEBUG [org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread] Notified that enabled: true 2004-11-12 01:37:43,703 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Started jboss.deployment:type=DeploymentScanner,flavor=URL 2004-11-12 01:37:43,703 DEBUG [org.jboss.management.j2ee.LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceController][type= org.jboss.system.ServiceMBean.start][message=] 2004-11-12 01:37:43,703 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: jboss.deployment:type=DeploymentScanner,flavor=URL dependent components: [] 2004-11-12 01:37:43,703 DEBUG [org.jboss.management.j2ee.LocalJBossServerDomain] handleNotification: javax.management.Notification[source=jboss.system:service=ServiceDeployer][type=org.jboss.deployment.SubDeployer.start][message=] 2004-11-12 01:37:43,750 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,750 DEBUG [org.jboss.management.j2ee.ServiceModule] postRegister(), parent: jboss.management.local:j2eeType=J2EEServer,name=Local 2004-11-12 01:37:43,750 DEBUG [org.jboss.management.j2ee.ServiceModule] Created JSR-77 ServiceModule, name: jboss-service.xml 2004-11-12 01:37:43,750 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Created ServiceModule: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,765 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,765 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,765 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.management.local:j2eeType=J2EEDomain,name=Manager, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,781 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,781 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,781 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.aop:service=AspectManager, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,781 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,781 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,796 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.aop:service=AspectDeployer, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,796 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,796 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,796 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.system:type=Log4jService,service=Logging, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,812 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,812 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,812 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.rmi:type=RMIClassLoader, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,812 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,812 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,812 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=WebService, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,828 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,828 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,828 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=Naming, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,828 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,828 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,828 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=JNDIView, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,843 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,843 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,843 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=EJBTimerService, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,843 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,843 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,859 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=EJBTimerServiceRetryPolicy, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,859 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,859 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,859 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.security:service=SecurityConfig, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,875 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,875 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,875 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.security:service=XMLLoginConfig, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,875 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,875 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,875 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.security:service=JaasSecurityManager, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,890 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,890 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,890 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=XidFactory, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,890 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,890 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,890 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=TransactionManager, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,906 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,906 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,906 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=ClientUserTransaction, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,953 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,953 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,953 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=proxyFactory,target=ClientUserTransactionFactory, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,953 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,953 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,953 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=proxyFactory,target=ClientUserTransaction, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,968 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,968 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,968 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=invoker,type=jrmp, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,984 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,984 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,984 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=invoker,type=local, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,984 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:43,984 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:43,984 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss:service=invoker,type=pooled, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,000 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,000 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,000 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.ejb:service=EJBDeployer, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,000 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,000 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,000 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.j2ee:service=EARDeployer, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,015 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,015 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,031 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.scripts:service=BSHDeployer, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,031 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,031 DEBUG [org.jboss.management.j2ee.MBean] postRegister(), parent: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,031 DEBUG [org.jboss.management.j2ee.factory.ServiceModuleFactory] Create MBean, name: jboss.deployment:type=DeploymentScanner,flavor=URL, SAR Module: jboss.management.local:J2EEServer=Local,j2eeType=ServiceModule,name=jboss-service.xml 2004-11-12 01:37:44,046 DEBUG [org.jboss.deployment.MainDeployer] End deployment start on package: jboss-service.xml 2004-11-12 01:37:44,046 DEBUG [org.jboss.deployment.MainDeployer] Deployed package: file:/D:/JBoss/server/default/conf/jboss-service.xml 2004-11-12 01:37:44,078 INFO [org.jboss.system.server.Server] JBoss (MX MicroKernel) [4.0.0RC1 (build: CVSTag=JBoss_4_0_0_RC1 date=200407202112)] Started in 1m:11s:328ms 2004-11-12 01:37:44,078 INFO [org.jboss.web.tomcat.tc5.Tomcat5] Saw org.jboss.system.server.started notification, starting connectors 2004-11-12 01:37:44,125 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,171 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,187 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,218 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080 2004-11-12 01:37:44,343 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,437 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,437 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,453 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,484 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,515 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,546 INFO [org.apache.jk.common.ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009 2004-11-12 01:37:44,546 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,546 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,593 INFO [org.apache.jk.server.JkMain] Jk running ID=0 time=0/140 config=null 2004-11-12 01:37:44,640 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:37:44,703 DEBUG [org.jboss.jmx.adaptor.snmp.agent.SnmpAgentService] It's for me: javax.management.MBeanServerNotification[source=JMImplementation:type=MBeanServerDelegate][type=JMX.mbean.registered][message=], handback:2147483647 2004-11-12 01:40:24,140 INFO [STDOUT] ejbCreate() 2004-11-12 01:40:24,625 INFO [STDOUT] Day 9: Demonstrate the use of JDBC... 2004-11-12 01:40:24,656 INFO [STDOUT] initDB: Get initial context from the JNDI service... 2004-11-12 01:40:24,687 INFO [STDOUT] Lookup the DataSource as configured by administrator... 2004-11-12 01:40:24,687 INFO [STDOUT] Exception was thrown: Could not dereference object 2004-11-12 01:40:24,703 INFO [STDOUT] Run some DDL statements: 2004-11-12 01:40:24,703 INFO [STDOUT] Exception was thrown: null 2004-11-12 01:40:24,718 INFO [STDOUT] Query Database Metadata: 2004-11-12 01:40:24,718 INFO [STDOUT] Exception was thrown: null 2004-11-12 01:40:24,718 INFO [STDOUT] Hello world method called.
Well! i cannot judge whats the problem with my code or may be the deployment problem.
Hope i ll get the solution of this problem :)
Thanks in advance
have fun
ishq