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 -~----------~----~----~----~------~----~------~--~---
