Thread: binding properties
View Single Post
•
•
Join Date: Aug 2007
Posts: 225
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