database tutorial

View: New views
6 Messages — Rating Filter:   Alert me  

database tutorial

by Steve Howerton :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I am working with the tutorial at:
http://www.netbeans.org/kb/articles/mysql.html


The program works great.
untouched the program displays the entire database that is a result of of query.getResultSet().

I added a combobox,textfield,and a button with an action.

I dragged and droped an additional:

searchEnityManager1
bound to the preexisting splashbookdbPU

searchQuery1
(bound to a new searchEntityMananger,and a query that is a result of a getSearchQueryString().

searchList1
bound to searchQuery1
<splashtemplateda.Content>

it all compiles;


nullpointer error ;basically the original query no longer works

here is a error message if that helps.
If I haven't given enough info I can extract code and display it if the above information does not show the obvious error
Thank you for your time
-Steve


[code]
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.
Copying 1 file to C:\Users\depot\Documents\ceyesuma\program_cache\in_progress\Enterprise\splashbookinprogress\target\SplashTemplateDA\build\classes
compile:
run:
[TopLink Info]: 2008.05.09 10:12:18.912--ServerSession(17548445)--TopLink, version: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
[TopLink Info]: 2008.05.09 10:12:19.611--ServerSession(17548445)--file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinprogress/target/SplashTemplateDA/build/classes/-splashbookdbPU login successful
May 9, 2008 10:12:19 PM 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:337)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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:337)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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: 4 seconds)
[/code]

Saving NetBeans IDE preference/options

by Russell Bateman :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

In particular, now that I've gone to all the trouble to configure how my
Java editor behaves, can I save these configurations so that I can pass
them to another workstation, to a friend or restore them after
reinstalling NetBeans?

(Yes, I have browsed Help and the web for this.)

Russ Bateman
Nube, refugee from Eclipse

Re: database tutorial

by Steve Howerton :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I got rid of the second entity manager and the second list(searchEnityManager1 and searchList1 and bound the searchQuery1 to the original entity manager.

basically I have the tutorial (link above) that runs with query bound to entityManager bound to splashbookdbPU and populates list and now I added search list which bound the same way as the original query. Is it exceptable to have one PU,one EntityManager ,one list, and two queries (with seperate @Actions and a added actionPerformed().

If I have a SQL SELECT statement(which may not be written right(JPA)  in this getSearchQueryString() will this set the query for the searchQuery query property?
[code]
searchQuery1 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery(getSearchQueryString());
[/code]


[code]
 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(getSearchQueryString());
[/code]


At the moment I get this error message

[code]
init:
deps-jar:
compile:
run:
[TopLink Info]: 2008.05.10 11:19:55.247--ServerSession(17548445)--TopLink, version: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
[TopLink Info]: 2008.05.10 11:19:55.878--ServerSession(17548445)--file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinprogress/target/SplashTemplateDA/build/classes/-splashbookdbPU login successful
[TopLink Info]: 2008.05.10 11:19:56.253--ServerSession(17548445)--file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinprogress/target/SplashTemplateDA/build/classes/-splashbookdbPU logout successful
May 10, 2008 11:19:56 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:340)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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:340)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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)
[/code]

Re: database tutorial

by Steve Howerton :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I am working with the tutorial at:
http://www.netbeans.org/kb/articles/mysql.html


I got rid of the second entity manager and the second list(searchEnityManager1 and searchList1 and bound the searchQuery1 to the original entity manager.

basically I have the tutorial (link above) that runs with query bound to entityManager bound to splashbookdbPU and populates list and now I added search list which bound the same way as the original query. Is it exceptable to have one PU,one EntityManager ,one list, and two queries (with seperate @Actions and a added actionPerformed().

If I have a SQL SELECT statement(which may not be written right(JPA)  in this getSearchQueryString() will this set the query for the searchQuery
[code]
searchQuery1 = java.beans.Beans.isDesignTime() ? null : entityManager.createQuery(getSearchQueryString());
[/code]


[code]
 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(getSearchQueryString());
[/code]


At the moment I get this error message

[code]
init:
deps-jar:
compile:
run:
[TopLink Info]: 2008.05.10 11:19:55.247--ServerSession(17548445)--TopLink, version: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
[TopLink Info]: 2008.05.10 11:19:55.878--ServerSession(17548445)--file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinprogress/target/SplashTemplateDA/build/classes/-splashbookdbPU login successful
[TopLink Info]: 2008.05.10 11:19:56.253--ServerSession(17548445)--file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinprogress/target/SplashTemplateDA/build/classes/-splashbookdbPU logout successful
May 10, 2008 11:19:56 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:340)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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:340)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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)
[/code]

Re: Saving NetBeans IDE preference/options

by HandyGeek :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Russell,
The other information source for me is this group's archive.  Here is an
answer related to your question, though I haven't tried it myself:
http://www.nabble.com/Save-modules-to6762290.html#a6762290 - HTH, David

Russell Bateman wrote:

> In particular, now that I've gone to all the trouble to configure how
> my Java editor behaves, can I save these configurations so that I can
> pass them to another workstation, to a friend or restore them after
> reinstalling NetBeans?
>
> (Yes, I have browsed Help and the web for this.)
>
> Russ Bateman
> Nube, refugee from Eclipse
>
>

Re: database tutorial

by Steve Howerton :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

As usual I made it much harder than it was  I got rid of the new queries and it works great



Steve Howerton wrote:
I am working with the tutorial at:
http://www.netbeans.org/kb/articles/mysql.html


The program works great.
untouched the program displays the entire database that is a result of of query.getResultSet().

I added a combobox,textfield,and a button with an action.

I dragged and droped an additional:

searchEnityManager1
bound to the preexisting splashbookdbPU

searchQuery1
(bound to a new searchEntityMananger,and a query that is a result of a getSearchQueryString().

searchList1
bound to searchQuery1
<splashtemplateda.Content>

it all compiles;


nullpointer error ;basically the original query no longer works

here is a error message if that helps.
If I haven't given enough info I can extract code and display it if the above information does not show the obvious error
Thank you for your time
-Steve


[code]
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.
Copying 1 file to C:\Users\depot\Documents\ceyesuma\program_cache\in_progress\Enterprise\splashbookinprogress\target\SplashTemplateDA\build\classes
compile:
run:
[TopLink Info]: 2008.05.09 10:12:18.912--ServerSession(17548445)--TopLink, version: Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))
[TopLink Info]: 2008.05.09 10:12:19.611--ServerSession(17548445)--file:/C:/Users/depot/Documents/ceyesuma/program_cache/in_progress/Enterprise/splashbookinprogress/target/SplashTemplateDA/build/classes/-splashbookdbPU login successful
May 9, 2008 10:12:19 PM 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:337)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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:337)
        at splashtemplateda.SplashTemplateDAView.<init>(SplashTemplateDAView.java:41)
        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: 4 seconds)
[/code]