Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 5 of 5

Thread: Problem with update table after inserting new values

  1. #1
    Member
    Join Date
    Apr 2012
    Posts
    57
    My Mood
    Angelic
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Problem with update table after inserting new values

    Hello,

    I'm trying to write a small program where I have a JTable connected with Db.

    Connection is working but the thing which doesnt work is when I insert new variables into Jtable I can't get it refreshed.

    here is my code : Only for the Update method

    protected void Update_Table() {
    					// TODO Auto-generated method stub
    					try{
    						String update = "SELECT * FROM devices";
    					//	statUp = (Statement) con.createStatement(update);
    						ResultSet rest = statUp.executeQuery(update);
    						table.setModel(DbUtils.resultSetToTableModel(rest));
    						//DbUtils.
    					}
    					catch(Exception ex){
    						ex.printStackTrace();
    						JOptionPane.showInputDialog(null, "Couldn't create new Device");
    					}
    				}

    The problem is in DbUtils.resultSetToTableModel(rest));
    Where rest is ResultSet.

    I got several errors :

    Exception in thread "AWT-EventQueue-0" java.lang.Error: Unresolved compilation problem: 
    	DbUtils cannot be resolved
     
    	at JTable2.Update_Table(JTable2.java:213)
    	at JTable2$2.actionPerformed(JTable2.java:158)
    	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
    	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
    	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
    	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
    	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
    	at java.awt.Component.processMouseEvent(Unknown Source)
    	at javax.swing.JComponent.processMouseEvent(Unknown Source)
    	at java.awt.Component.processEvent(Unknown Source)
    	at java.awt.Container.processEvent(Unknown Source)
    	at java.awt.Component.dispatchEventImpl(Unknown Source)
    	at java.awt.Container.dispatchEventImpl(Unknown Source)
    	at java.awt.Component.dispatchEvent(Unknown Source)
    	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    	at java.awt.Container.dispatchEventImpl(Unknown Source)
    	at java.awt.Window.dispatchEventImpl(Unknown Source)
    	at java.awt.Component.dispatchEvent(Unknown Source)
    	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
    	at java.awt.EventQueue.access$000(Unknown Source)
    	at java.awt.EventQueue$3.run(Unknown Source)
    	at java.awt.EventQueue$3.run(Unknown Source)
    	at java.security.AccessController.doPrivileged(Native Method)
    	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    	at java.awt.EventQueue$4.run(Unknown Source)
    	at java.awt.EventQueue$4.run(Unknown Source)
    	at java.security.AccessController.doPrivileged(Native Method)
    	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
    	at java.awt.EventQueue.dispatchEvent(Unknown Source)
    	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    	at java.awt.EventDispatchThread.run(Unknown Source)

    Thank you for your help


  2. #2
    Super Moderator jps's Avatar
    Join Date
    Jul 2012
    Posts
    2,642
    My Mood
    Daring
    Thanks
    90
    Thanked 263 Times in 232 Posts

    Default Re: Problem with update table after inserting new values

    That error means the compiler doesn't know what DbUtils is. Did you spell it correctly? Is it properly defined somewhere? Are your imports in order?

  3. #3
    Member
    Join Date
    Apr 2012
    Posts
    57
    My Mood
    Angelic
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Problem with update table after inserting new values

    Hey,

    My imports seems fine. I found sth similar which I tried to do here you can see it. java - JTable setting model and preserve column formats (width, alignment, etc.) - Stack Overflow

  4. #4
    Administrator copeg's Avatar
    Join Date
    Oct 2009
    Location
    US
    Posts
    5,372
    Thanks
    184
    Thanked 836 Times in 779 Posts
    Blog Entries
    5

    Default Re: Problem with update table after inserting new values

    Imports define what is imported at compile time, and affect compilation. Exceptions occur at runtime - is the library containing DbUtils on the classpath? If so, is it the most up to date library?

  5. #5
    Member
    Join Date
    Apr 2012
    Posts
    57
    My Mood
    Angelic
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Problem with update table after inserting new values

    heya,

    thx guys for your help Friend of mine solved it. I was missing the library for dbUtils. Thx

Similar Threads

  1. Inserting variables into table
    By Ramzi89 in forum JDBC & Databases
    Replies: 0
    Last Post: August 19th, 2012, 06:02 PM
  2. TAKE & PUT VALUES INTO AN ORACLE TABLE THRU A LOOP
    By jai in forum Algorithms & Recursion
    Replies: 1
    Last Post: September 17th, 2011, 06:39 AM
  3. [SOLVED] Update Values Globally
    By techwiz24 in forum What's Wrong With My Code?
    Replies: 3
    Last Post: June 10th, 2011, 07:20 PM
  4. Beginner Needs Help Inserting row to table
    By MoniD in forum JDBC & Databases
    Replies: 5
    Last Post: March 10th, 2011, 02:15 PM
  5. Update table in database
    By CTheSky in forum JDBC & Databases
    Replies: 4
    Last Post: February 24th, 2011, 02:02 AM