Click here to Skip to main content
15,899,008 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using below mentioned code to insert values in MSAccess 2000 which having table structure as mentioned below:-

Field Name Data Type
TodaysDate Date/Time
Cart ID Number
Client Name Text
Team & Segment Text
Duration Number
Tape ID Text
Start Date Date/Time
End Date Date/Time

C#
private boolean enterDataIntoMSAccessDatabaseusingPreparedStatement()
    {
        try {

            ps = connection.prepareStatement("INSERT INTO [Cart ID Details] VALUES (?,?,?,?,?,?,?,?)");

            System.out.println("After Query");

        }

        catch (SQLException se) {

            generateErrorMessage("Error in Prepared Statement \n " + se.getMessage() );

            return false;

        }

        catch (Exception e)
        {
            generateErrorMessage("Unexpected Error Occured \n " + e.getMessage());
        }

        String todaysDate = cartIDApplicationAddCartIDDatejTextField.getText().trim();

        String cartID = cartIDApplicationAddCartIDCartIDjTextField.getText().trim();

        String clientName = cartIDApplicationAddCartIDClientNamejTextField.getText().trim();

        String teamSegment = cartIDApplicationAddCartIDTeamAndSegmentjTextField.getText().trim();

        String duration = cartIDApplicationAddCartIDDurationjTextField.getText().trim();

        String tapeID = cartIDApplicationAddCartIDTapeIDjTextField.getText().trim();

        String startDate = cartIDApplicationAddCartIDStartDatejTextField.getText().trim();

        String endDate = cartIDApplicationAddCartIDEndDatejTextField.getText().trim();

        try {

            //System.out.println("Before ps.setString()");

            ps.setString(1, todaysDate);
            ps.setString(2, cartID );
            ps.setString(3, clientName);
            ps.setString(4, teamSegment);
            ps.setString(5, duration);
            ps.setString(6, tapeID);
            ps.setString(7, startDate);
            ps.setString(8, endDate);


            //System.out.println("After ps.setString()");

                ps.executeUpdate();


       }
        catch (SQLException se) {

            generateErrorMessage("Error while inserting data in database \n " + se.getMessage());

            return false;
        }

        catch (Exception e)
        {
            generateErrorMessage("Unexpected Error Occured \n" + e.getMessage() );
        }

        return true;
    }



The above boolean function is called in "Save Button" action event, but when I click Save I am getting as Runtime Exception.

Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: JOptionPane: parentComponent does not have a valid parent
at javax.swing.JOptionPane.createInternalFrame(JOptionPane.java:1511)
at javax.swing.JOptionPane.showInternalOptionDialog(JOptionPane.java:1286)
at javax.swing.JOptionPane.showInternalMessageDialog(JOptionPane.java:1100)
at javax.swing.JOptionPane.showInternalMessageDialog(JOptionPane.java:1074)
at cartidapplication.CartID.generateErrorMessage(CartID.java:141)
at cartidapplication.CartID.enterDataIntoMSAccessDatabaseusingPreparedStatement(CartID.java:1141)
at cartidapplication.CartID.cartIDApplicationAddCartIDSavejButtonActionPerformed(CartID.java:1235)
at cartidapplication.CartID.access$1100(CartID.java:27)
at cartidapplication.CartID$12.actionPerformed(CartID.java:431)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6505)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
at java.awt.Component.processEvent(Component.java:6270)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4861)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4687)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Kindly help me to sort out this issue.
Posted

1 solution

In your generateErrorMessage method, are you calling JOptionPane.showInternalMessageDialog with a first parameter of null?

You need to make sure that the message dialog have a valid parent.

Hope this helps,
Fredrik
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900