Possible problem with satic declaration or datasource

[Varnam Aayiram]

Hi Folks...

I was trying to run the following code and am getting this error:

Exception in thread "main" java.lang.NullPointerException
at com.ProjecteBooking4.controller.writeBean.main(writeBean.java:36)

Here is the code:

import java.sql.*;
import javax.sql.DataSource;
import javax.annotation.Resource;
import java.sql.Connection;



public class writeBean {

        @Resource(name = "jdbc/DMIT")
        private static DataSource dataSource;
        
        

    public static void main(String[]args){

       
        String insertBookingSql = "insert into booking (FK_idfacility, FK_iduser,  FK_caldate, dateofbooking, bookingstarttime, bookingendtime) values (?,?,?,?,?,?)";
        PreparedStatement insertBookingStatement;

        try
    {
             

      Connection connection = dataSource.getConnection();
      

insertBookingStatement = connection.prepareStatement(insertBookingSql);


//*** FIRST ROW ****

//FK_idfacility
insertBookingStatement.setString(1,"T1933V");

//FK_iduser
insertBookingStatement.setString(2, "p0248448");

//FK_caldate
insertBookingStatement.setDate(3,Date.valueOf("2010-03-12"));

//dateofbooking
insertBookingStatement.setDate(4,Date.valueOf("2009-06-29"));

//bookingstarttime
insertBookingStatement.setTime(5,Time.valueOf("18:00:00"));

//bookingendtime
insertBookingStatement.setTime(6, Time.valueOf("20:00:00"));


insertBookingStatement.executeUpdate();

//*** END OF FIRST ROW ****



connection.close();


//response.getWriter().println("Database Updated Successfully");
System.out.println("Database Updated Successfully");


    }

catch (SQLException e)
    {

e.printStackTrace();

 }

 }
        
    

}

The error is pointing to the line:

Connection connection = dataSource.getConnection();

What could be causing this problem? Is the satic declaration of DataSource the problem? but unless I decalre it as static I dont think I can access it from the main method. I hope someone can advise. Thanks.

[Peter Johnson]

Looks like the @Resource annotation failed to find the JNDI entry.

What mechanism/container are you using to processes the @Resource annotation? What container is maintaining the data sources and the JNDI tree? (Spring? An app server? Something else?)

By the way, this is not a database issue, rather it is a container issue.

[Varnam Aayiram]

Hi Peter..

I appreciate the reply. I am using glassfish as the appserver. Datasource has already been set up. The database is MySQL, the IDE I am using is NetBeans. The code I posted was part of a web app. I was actually testing this particular piece of code seperately to see if I can use this bean to write to the table. The Servlets in this webapp dont seem to have any problem writing to the table in the database. I am not sure what else to do...

[Peter Johnson]

This is a glassfish question (glassfish failed to fill in the @Resource), moving

[Varnam Aayiram]

Hi..

One thing I don't understand is when I am connecting to the database and doing read writes to the table via servlets I am using this:

 
@Resource(name = "jdbc/DMIT")

but I dont have a problem there, why is it different when called from a main method in a non servlet java file??