binding properties

Thread Solved

•
•
Join Date: Aug 2007
Posts: 247
Reputation: ceyesuma is an unknown quantity at this point 
Solved Threads: 0
ceyesuma ceyesuma is offline Offline
Posting Whiz in Training

binding properties

 
0
  #1
May 12th, 2008
I have the tutorial running with a entire database displayed.
I am working with the tutorial at:
http://www.netbeans.org/kb/articles/mysql.html

The above tutorial creates a jDesktopAPP. with components bound to the table.

I am trying to add a button (basically).

I am in the process of understanding binding.

the program loads with <list> which is the entire database.

I created a new query (createQuery())

I would like to clear that list and repoulate it with a getResultSet()

As far as binding goes I have never acessed propertiest to set them or accessed properties

to work with them.

Could some one give me some idea where to start?

I have coded in a combobox,textfield,button(@Action)and actionPerformed()
Right now everything compiles yet the query is not created.

Can someone tell me some basic procedures I must follow to utilize persistence?

All this code does is add the above mentioned components and I added an error message to

try to put my question into context.
Thank for your time.



Java Syntax (Toggle Plain Text) 
  1. private void searchJComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) {               
  2.  
  3.  
  4.     setSearchItem((String) searchJComboBox1.getSelectedItem());
  5.     if (searchJComboBox1.getSelectedItem().equals("by Artist")) {
  6.         String holdQuery = searchJComboBox1.getSelectedItem().toString();
  7.         setSearchInput(holdQuery);
  8.  
  9.     //searchJTextField1.setText(getSearchQuery());
  10.     }
  11.     if (searchJComboBox1.getSelectedItem().equals("by Song")) {
  12.         String holdQuery = searchJComboBox1.getSelectedItem().toString();
  13.         setSearchInput(holdQuery);
  14.  
  15.     //searchJTextField1.setText(getSearchQuery());
  16.     }
  17. }                                                 
  18.  
  19. private void searchJButton1ActionPerformed(java.awt.event.ActionEvent evt) {                
  20.  
  21.  
  22.     if (searchJComboBox1.getSelectedItem().equals("by Artist")) {
  23.         String like = searchJTextField1.getText();
  24.         setSearchQueryString("SELECT c FROM content c WHERE c.artist LIKE :like");
  25.         searchQuery1 = entityManager.createQuery(getSearchQueryString());
  26.         searchQuery1.setParameter("like", "%" + searchJTextField1.getText() + "%");
  27.         List<Content> List = searchQuery1.getResultList();
  28.     }
  29.      if (searchJComboBox1.getSelectedItem().equals("by Song")) {
  30.         String like = searchJTextField1.getText();
  31.         setSearchQueryString("SELECT c FROM content c WHERE c.song LIKE :like");
  32.         searchQuery1 = entityManager.createQuery(getSearchQueryString());
  33.         searchQuery1.setParameter("like", "%" + searchJTextField1.getText() + "%");
  34.         List<Content> List = searchQuery1.getResultList();
  35.     }
  36. }                                              
  37.  
  38.     @Action
  39.     public Task searchSplash() {
  40.  
  41.  
  42.         return new SearchSplashTask(getApplication());
  43.     }
  44.  
  45.     private class SearchSplashTask extends Task {
  46.  
  47.         SearchSplashTask(org.jdesktop.application.Application app) {
  48.             super(app);
  49.         }
  50.  
  51.         @SuppressWarnings("unchecked")
  52.         @Override
  53.         protected Void doInBackground() {
  54.             try {
  55.                 setProgress(0, 0, 4);
  56.                 setMessage("Rolling back the current changes...");
  57.                 setProgress(1, 0, 4);
  58.                 entityManager.getTransaction().rollback();
  59.                 Thread.sleep(1000L); // remove for real app
  60.  
  61.                 setProgress(2, 0, 4);
  62.  
  63.                 setMessage("Starting a new transaction...");
  64.                 entityManager.getTransaction().begin();
  65.                 Thread.sleep(500L); // remove for real app
  66.  
  67.                 setProgress(3, 0, 4);
  68.  
  69.                 setMessage("Fetching new data...");
  70.                 java.util.Collection data = searchQuery1.getResultList();
  71.  
  72.  
  73.                 for (Object entity : data) {
  74.                     entityManager.refresh(entity);
  75.                 }
  76.  
  77.                 Thread.sleep(1300L); // remove for real app
  78.  
  79.                 setProgress(4, 0, 4);
  80.  
  81.                 Thread.sleep(150L); // remove for real app
  82.  
  83.                 list.clear();
  84.             //list.addAll(search);
  85.             } catch (InterruptedException ignore) {
  86.             }
  87.             return null;
  88.         }
  89.  
  90.         @Override
  91.         protected void finished() {
  92.             setMessage("Done.");
  93.             setSaveNeeded(false);
  94.         }
  95.     }

Java Syntax (Toggle Plain Text) 
  1.  entityManager = java.beans.Beans.isDesignTime() ? null : 
  2.  
  3. javax.persistence.Persistence.createEntityManagerFactory
  4.  
  5. ("splashbookdbPU").createEntityManager();
  6.         org.jdesktop.application.ResourceMap resourceMap = 
  7.  
  8. org.jdesktop.application.Application.getInstance
  9.  
  10. (splashtemplateda.SplashTemplateDAApp.class).getContext().getResourceMap
  11.  
  12. (SplashTemplateDAView.class);
  13.         query = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery
  14.  
  15. (resourceMap.getString("query.query")); // NOI18N
  16.         list = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() : 
  17.  
  18. org.jdesktop.observablecollections.ObservableCollections.observableList
  19.  
  20. (query.getResultList());
  21.         searchQuery1 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery
  22.  
  23. (null);


Java Syntax (Toggle Plain Text) 
  1.  
  2.  
  3.  
  4. init:
  5. deps-jar:
  6. Copying 1 file to 
  7.  
  8. C:\Users\depot\Documents\ceyesuma\program_cache\in_progress\Enterprise\splashbookinprogress
  9.  
  10. \target\SplashTemplateDA\build\classes
  11. compile:
  12. run:
  13. [TopLink Info]: 2008.05.12 05:49:17.417--ServerSession(25094328)--TopLink, version: Oracle 
  14.  
  15. TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
  16. [TopLink Info]: 2008.05.12 05:49:19.438--ServerSession(25094328)--
  17.  
  18. file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinpr
  19.  
  20. ogress/target/SplashTemplateDA/build/classes/-splashbookdbPU login successful
  21. May 12, 2008 5:49:20 PM org.jdesktop.application.Application$1 run
  22. SEVERE: Application class splashtemplateda.SplashTemplateDAApp failed to launch
  23. java.lang.IllegalArgumentException: An exception occured while creating a query in 
  24.  
  25. EntityManager
  26.         at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
  27.  
  28. (EntityManagerImpl.java:209)
  29.         at splashtemplateda.SplashTemplateDAView.initComponents
  30.  
  31. (SplashTemplateDAView.java:360)
  32.         at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:42)
  33.         at splashtemplateda.SplashTemplateDAApp.startup(SplashTemplateDAApp.java:19)
  34.         at org.jdesktop.application.Application$1.run(Application.java:171)
  35.         at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
  36.         at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
  37.         at java.awt.EventDispatchThread.pumpOneEventForFilters
  38.  
  39. (EventDispatchThread.java:273)
  40.         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
  41.         at java.awt.EventDispatchThread.pumpEventsForHierarchy
  42.  
  43. (EventDispatchThread.java:173)
  44.         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
  45.         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
  46.         at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
  47. Caused by: Exception [TOPLINK-8002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs 
  48.  
  49. (12/06/2007))): oracle.toplink.essentials.exceptions.EJBQLException
  50. Exception Description: General Problem parsing the query [null]. The parser returned the 
  51.  
  52. following [null].
  53. Internal Exception: java.lang.NullPointerException
  54.         at oracle.toplink.essentials.exceptions.EJBQLException.generalParsingException
  55.  
  56. (EJBQLException.java:140)
  57.         at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
  58.  
  59. (EJBQLParser.java:155)
  60.         at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParseTree
  61.  
  62. (EJBQLParser.java:126)
  63.         at 
  64.  
  65. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
  66.  
  67. (EJBQueryImpl.java:215)
  68.         at 
  69.  
  70. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
  71.  
  72. (EJBQueryImpl.java:189)
  73.         at 
  74.  
  75. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
  76.  
  77. (EJBQueryImpl.java:153)
  78.         at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
  79.  
  80. (EJBQueryImpl.java:114)
  81.         at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
  82.  
  83. (EJBQueryImpl.java:99)
  84.         at oracle.toplink.essentials.internal.ejb.cmp3.EJBQueryImpl.<init>
  85.  
  86. (EJBQueryImpl.java:86)
  87.         at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
  88.  
  89. (EntityManagerImpl.java:204)
  90.         ... 12 more
  91. Caused by: java.lang.NullPointerException
  92.         at java.io.StringReader.<init>(StringReader.java:33)
  93.         at 
  94.  
  95. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParserBuilder.buildParser
  96.  
  97. (EJBQLParserBuilder.java:61)
  98.         at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
  99.  
  100. (EJBQLParser.java:149)
  101.         ... 20 more
  102. Exception in thread "AWT-EventQueue-0" java.lang.Error: Application class 
  103.  
  104. splashtemplateda.SplashTemplateDAApp failed to launch
  105.         at org.jdesktop.application.Application$1.run(Application.java:177)
  106.         at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
  107.         at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
  108.         at java.awt.EventDispatchThread.pumpOneEventForFilters
  109.  
  110. (EventDispatchThread.java:273)
  111.         at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
  112.         at java.awt.EventDispatchThread.pumpEventsForHierarchy
  113.  
  114. (EventDispatchThread.java:173)
  115.         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
  116.         at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
  117.         at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
  118. Caused by: java.lang.IllegalArgumentException: An exception occured while creating a query 
  119.  
  120. in EntityManager
  121.         at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
  122.  
  123. (EntityManagerImpl.java:209)
  124.         at splashtemplateda.SplashTemplateDAView.initComponents
  125.  
  126. (SplashTemplateDAView.java:360)
  127.         at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:42)
  128.         at splashtemplateda.SplashTemplateDAApp.startup(SplashTemplateDAApp.java:19)
  129.         at org.jdesktop.application.Application$1.run(Application.java:171)
  130.         ... 8 more
  131. Caused by: Exception [TOPLINK-8002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs 
  132.  
  133. (12/06/2007))): oracle.toplink.essentials.exceptions.EJBQLException
  134. Exception Description: General Problem parsing the query [null]. The parser returned the 
  135.  
  136. following [null].
  137. Internal Exception: java.lang.NullPointerException
  138.         at oracle.toplink.essentials.exceptions.EJBQLException.generalParsingException
  139.  
  140. (EJBQLException.java:140)
  141.         at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
  142.  
  143. (EJBQLParser.java:155)
  144.         at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParseTree
  145.  
  146. (EJBQLParser.java:126)
  147.         at 
  148.  
  149. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
  150.  
  151. (EJBQueryImpl.java:215)
  152.         at 
  153.  
  154. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
  155.  
  156. (EJBQueryImpl.java:189)
  157.         at 
  158.  
  159. oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
  160.  
  161. (EJBQueryImpl.java:153)
  162.         at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
  163.  
  164. (EJBQueryImpl.java:114)
  165.         at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
  166.  
  167. (EJBQueryImpl.java:99)
  168.         at oracle.toplink.essentials.internal.ejb.cmp3.EJBQueryImpl.<init>
  169.  
  170. (EJBQueryImpl.java:86)
  171.         at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
  172.  
  173. (EntityManagerImpl.java:204)
  174.         ... 12 more
  175. Caused by: java.lang.NullPointerException
  176.         at java.io.StringReader.<init>(StringReader.java:33)
  177.         at 
  178.  
  179. oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParserBuilder.buildParser
  180.  
  181. (EJBQLParserBuilder.java:61)
  182.         at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
  183.  
  184. (EJBQLParser.java:149)
  185.         ... 20 more
  186. BUILD SUCCESSFUL (total time: 11 seconds)
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 247
Reputation: ceyesuma is an unknown quantity at this point 
Solved Threads: 0
ceyesuma ceyesuma is offline Offline
Posting Whiz in Training

Re: binding properties

 
0
  #2
May 12th, 2008
I think I need some of this:

Java Syntax (Toggle Plain Text) 
  1.  try {
  2.                 entityManager.getTransaction().commit();
  3.                 entityManager.getTransaction().begin();
  4.             } catch (RollbackException rex) {
  5.                 rex.printStackTrace();
  6.                 entityManager.getTransaction().begin();
  7.                 List<splashtemplateda.Content> merged = new ArrayList<splashtemplateda.Content>(list.size());
  8.                 for (splashtemplateda.Content c : list) {
  9.                     merged.add(entityManager.merge(c));
  10.                 }
  11.                 list.clear();
  12.                 list.addAll(merged);
  13.             }
  14.             return null;
  15.         }
If I mastertable.clear()
is it possible that
where merge could hold the getResultSet()
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2007
Posts: 247
Reputation: ceyesuma is an unknown quantity at this point 
Solved Threads: 0
ceyesuma ceyesuma is offline Offline
Posting Whiz in Training

Re: binding properties

 
0
  #3
May 13th, 2008
Scratch this one. As usual I made it much more complicated than it had to be. The solution was much easier than I made it
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the Java Forum


Views: 1272 | Replies: 2
Thread Tools Search this Thread



Tag cloud for Java
access actionlistener android api apple applet application arguments array arrays automation binary bluetooth c++ class classes client code combobox component coordinates data database design desktop detection draw eclipse error event exception fast file fractal game givemetehcodez graphics gridlayout gui helpwithhomework html ide image inheritance input integer interface j2me java javaprojects jmf jni jpanel jtextfield julia linux list loop method methods mobile netbeans newbie number object objects oracle os phone pixel print problem program programming project read recursion remote remove robot scanner screen search server set size sms socket sort sql string swing test text threads time transfer tree update windows
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2010 DaniWeb® LLC