Hello, That's it. Open the aggregated project (bookstore), change the JDBC DataSource address and rebuild it to generate a new jar. So if you rebuild the bookstore1 project I think everything is going to run properly.
Tell me the result. On Sep 17, 4:58 pm, "p. stephen wille" <p.stephenwi...@yahoo.com> wrote: > Thanks for the tip.>>Persistence.xml is using the [jdbc/__default] database, > and I think I want it to use [jdbc/BookDB], which is the DB I set up. > However, changing this field in the file does not allow for a successful > build. Do I need to create a new Jar of [bookstore], then remove the current > [bookstore] jar from [bookstore1] and re-associate it with the new updated > jar? I'm asking this I'm getting ready to try it, but any comments are truly > appreciated. > > > stephen wille | p.stephenwi...@yahoo.com > > ________________________________ > From: diegosouza.br <diegosouza...@gmail.com> > > >To: Java EE (J2EE) Programming with Passion! > ><java-ee-j2ee-programming-with-passion@googlegroups.com> > >Sent: Wednesday, September 16, 2009 7:54:52 PM > >Subject: [java ee programming] Re: Bookstore1 DB error... > > >Hello! > > >When you run bookstore1, it uses the bookstore.jar to connect to the > >Data Source specified in persistence.xml. > >See the libraries in your bookstore1 project, then right click the > >bookstore.jar and click "open project". Expand the META-INF node and > >>verify the persistence.xml. I think it's pointing to another Data > >Source address. > > >Good luck! > > >On Sep 16, 8:43 pm, "p. stephen wille" <p.stephenwi...@yahoo.com> > >>wrote: > >> Anyone know anything about this issue? > > >> Per the instructions on p.97, I've added [jdbc/BookDB]. I also populated > >> the database with an sql file I found > >> [..\javaeetutorial5\examples\common\sql\javadb]. However, I get the error > >> message below when I run [bookstore1]. > > >> Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.1 (Build > >> 20080905)): > > > org.eclipse.persistence.exceptions.DatabaseException > >> Internal Exception: java.sql.SQLTransientConnectionException: No current > >> connection. > >> Error Code: 40000 > >> Call: SELECT BOOKID, DESCRIPTION, INVENTORY, TITLE, PRICE, FIRSTNAME, > >> SURNAME, CALENDAR_YEAR, ONSALE FROM WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?) > >>> bind => [203] > > >> Query: ReadObjectQuery(com.sun.bookstore.database.Book) > >> I can run the select statement successfully in Netbeans, so the > >> database exists and is populated. For example, The record returned for > >>> [BookID = 202] is 'web servers for fun and profit'. > >> I've confirmed the DB and connection pool are running - > > >> asadmin> list-jdbc-resources > >> jdbc/__TimerPool > >> jdbc/__CallFlowPool > >>> jdbc/__default > >> jdbc/BookDB > >> Command list-jdbc-resources executed successfully. > > > asadmin> list-jdbc-connection-pools > >> __CallFlowPool > >> __TimerPool > >> DerbyPool > >> Command list-jdbc-connection-pools executed successfully. > > >> Suggestions? > > >> stephen wille | p.stephenwi...@yahoo.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en -~----------~----~----~----~------~----~------~--~---
