I am working with the tutorial at:
http://www.netbeans.org/kb/articles/mysql.html
can any one help me figure out why I can not set a query with this method?
entityManager = java.beans.Beans.isDesignTime() ? null :
javax.persistence.Persistence.createEntityManagerFactory
("splashbookdbPU").createEntityManager();
org.jdesktop.application.ResourceMap resourceMap =
org.jdesktop.application.Application.getInstance
(splashtemplateda.SplashTemplateDAApp.class).getContext().getResourceMap
(SplashTemplateDAView.class);
query = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery
(resourceMap.getString("query.query")); // NOI18N
list = java.beans.Beans.isDesignTime() ? java.util.Collections.emptyList() :
org.jdesktop.observablecollections.ObservableCollections.observableList
(query.getResultList());
searchQuery1 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery
(null);
private void searchJButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if (searchJComboBox1.getSelectedItem().equals("by Artist")) {
String like = searchJTextField1.getText();
setSearchQueryString("SELECT c FROM content c WHERE c.artist LIKE \"%" + like + "%);
\"");
searchQuery1 = entityManager.createQuery(getSearchQueryString());
searchQuery1.setParameter("like", "searchJTextField1.getText()");
List<Content> List = searchQuery1.getResultList();
}
if (searchJComboBox1.getSelectedItem().equals("by Song")) {
String like = searchJTextField1.getText();
setSearchQueryString("SELECT c FROM content c WHERE c.song LIKE \"%" + like + "%);
\"");
searchQuery1 = entityManager.createQuery(getSearchQueryString());
searchQuery1.setParameter("like", "searchJTextField1.getText()");
List<Content> List = searchQuery1.getResultList();
}
}
init:
deps-jar:
Compiling 1 source file to
C:\Users\depot\Documents\ceyesuma\program_cache\in_progress\Enterprise\splashbookinprogress
\target\SplashTemplateDA\build\classes
Note:
C:\Users\depot\Documents\ceyesuma\program_cache\in_progress\Enterprise\splashbookinprogress
\target\SplashTemplateDA\src\splashtemplateda\SplashTemplateDAView.java uses unchecked or
unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
compile:
run:
[TopLink Info]: 2008.05.11 05:17:44.910--ServerSession(21662929)--TopLink, version: Oracle
TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
[TopLink Info]: 2008.05.11 05:17:45.621--ServerSession(21662929)--
file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinpr
ogress/target/SplashTemplateDA/build/classes/-splashbookdbPU login successful
May 11, 2008 5:17:45 AM org.jdesktop.application.Application$1 run
SEVERE: Application class splashtemplateda.SplashTemplateDAApp failed to launch
java.lang.IllegalArgumentException: An exception occured while creating a query in
EntityManager
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
(EntityManagerImpl.java:209)
at splashtemplateda.SplashTemplateDAView.initComponents
(SplashTemplateDAView.java:360)
at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:42)
at splashtemplateda.SplashTemplateDAApp.startup(SplashTemplateDAApp.java:19)
at org.jdesktop.application.Application$1.run(Application.java:171)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters
(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: Exception [TOPLINK-8002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs
(12/06/2007))): oracle.toplink.essentials.exceptions.EJBQLException
Exception Description: General Problem parsing the query [null]. The parser returned the
following [null].
Internal Exception: java.lang.NullPointerException
at oracle.toplink.essentials.exceptions.EJBQLException.generalParsingException
(EJBQLException.java:140)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
(EJBQLParser.java:155)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParseTree
(EJBQLParser.java:126)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
(EJBQueryImpl.java:215)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
(EJBQueryImpl.java:189)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
(EJBQueryImpl.java:153)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
(EJBQueryImpl.java:114)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
(EJBQueryImpl.java:99)
at oracle.toplink.essentials.internal.ejb.cmp3.EJBQueryImpl.<init>
(EJBQueryImpl.java:86)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
(EntityManagerImpl.java:204)
... 12 more
Caused by: java.lang.NullPointerException
at java.io.StringReader.<init>(StringReader.java:33)
at
oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParserBuilder.buildParser
(EJBQLParserBuilder.java:61)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
(EJBQLParser.java:149)
... 20 more
Exception in thread "AWT-EventQueue-0" java.lang.Error: Application class
splashtemplateda.SplashTemplateDAApp failed to launch
at org.jdesktop.application.Application$1.run(Application.java:177)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters
(EventDispatchThread.java:273)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
at java.awt.EventDispatchThread.pumpEventsForHierarchy
(EventDispatchThread.java:173)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)
Caused by: java.lang.IllegalArgumentException: An exception occured while creating a query
in EntityManager
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
(EntityManagerImpl.java:209)
at splashtemplateda.SplashTemplateDAView.initComponents
(SplashTemplateDAView.java:360)
at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:42)
at splashtemplateda.SplashTemplateDAApp.startup(SplashTemplateDAApp.java:19)
at org.jdesktop.application.Application$1.run(Application.java:171)
... 8 more
Caused by: Exception [TOPLINK-8002] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs
(12/06/2007))): oracle.toplink.essentials.exceptions.EJBQLException
Exception Description: General Problem parsing the query [null]. The parser returned the
following [null].
Internal Exception: java.lang.NullPointerException
at oracle.toplink.essentials.exceptions.EJBQLException.generalParsingException
(EJBQLException.java:140)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
(EJBQLParser.java:155)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParseTree
(EJBQLParser.java:126)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
(EJBQueryImpl.java:215)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
(EJBQueryImpl.java:189)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.buildEJBQLDatabaseQuery
(EJBQueryImpl.java:153)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
(EJBQueryImpl.java:114)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.<init>
(EJBQueryImpl.java:99)
at oracle.toplink.essentials.internal.ejb.cmp3.EJBQueryImpl.<init>
(EJBQueryImpl.java:86)
at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery
(EntityManagerImpl.java:204)
... 12 more
Caused by: java.lang.NullPointerException
at java.io.StringReader.<init>(StringReader.java:33)
at
oracle.toplink.essentials.internal.parsing.ejbql.antlr273.EJBQLParserBuilder.buildParser
(EJBQLParserBuilder.java:61)
at oracle.toplink.essentials.internal.parsing.ejbql.EJBQLParser.buildParserFor
(EJBQLParser.java:149)
... 20 more
BUILD SUCCESSFUL (total time: 5 seconds)