0 Replies Latest reply: Dec 6, 2011 8:16 AM by stab RSS

    Need help to inject datasource when using Errai

    stab Newbie

      Hi,

       

      Want to use Errai-bus for database access and tried to follow the code from an earlier question(Errai + DataSource Oct 25, 2010 by dan.dan) .

       

      My server code is like:

       

      package DbErrai.server;

       

      import java.sql.Connection;

      import java.sql.PreparedStatement;

      import java.sql.ResultSet;

       

      import javax.annotation.Resource;

      import javax.inject.Inject;

      import javax.sql.DataSource;

       

      import org.jboss.errai.bus.client.api.Message;

      import org.jboss.errai.bus.client.api.MessageCallback;

      import org.jboss.errai.bus.client.api.base.MessageBuilder;

      import org.jboss.errai.bus.client.framework.MessageBus;

      import org.jboss.errai.bus.server.annotations.Service;

       

      @Service

      public class DbErraiService implements MessageCallback {

       

                @Inject

                MessageBus bus;

       

       

                @Resource(name = "mapobjectdb", mappedName = "java:/mapobjectdb")

                DataSource ds;

                Connection con;

                PreparedStatement pstm;

                ResultSet rs;

       

                @Override

                public void callback(Message message) {

            try {

              con = ds.getConnection();

              MessageBuilder.createConversation(message).subjectProvided()

                         .withValue("Connection opened").done().reply();

              con.close();

            } catch (Exception e) {

              MessageBuilder.createConversation(message).subjectProvided()

                   .withValue(e.toString()).done().reply();

              e.printStackTrace();

            }

                }

      }

       

      But I get NullPointerException at: con = ds.getConnection();

       

      In another application where gwt rpc is used, connection to database works OK with same resource declaration

       

      What am I doing wrong?

       

      Regards

      stab