If Java EE Tutorial relies on asadmin deploy command options to create tables
for you, Glassfishv3-prelude doesn't have support for them and you'll need to
change the persistence.xml to set the EclipseLink property:
"eclipselink.ddl-generation" either to "drop-and-create-tables" or to
"create-tables".
If the steps included loading DDL, you missed that step.
The latest V3 builds have support for automatic table creation requested via
asadmin deploy command options.
Regards,
-marina
glassfish_at_javadesktop.org wrote:
> Hi everybody,
>
> I know there is a thread having the same subject by Jose Alvarez de Lara, but the answer he got does not seem to work for me.
> I am also trying to run the Books example from the Java EE Tutorial. I use Eclipse, Glassfishv3-prelude and the JavaDB which came with the server. As persistence provider I use EclipseLink, which also came with the server.
> I have made a database BookDB, and populated the table WEB_BOOKSTORE_BOOKS in schema APP. I can make a connection to this database using Data Tools in Eclipse and the ping succeeds.
> On the server I made a connection pool (BookDBPool) for this database, and here the ping also succeeds. I made a jdbc-resource jdbc/BookDB for this connection pool.
> This is persistence.xml :
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
> <persistence-unit name="book" transaction-type="JTA">
> <!-- provider>oracle.toplink.essentials.PersistenceProvider</provider> -->
> <jta-data-source>jdbc/BookDB</jta-data-source>
> <class>com.sun.bookstore.database.Book</class>
> </persistence-unit>
> </persistence>
> I removed the <provider> tag, so it uses the default provider, EclipseLink.
>
> In my entity class is the following Table-annotation:
> @Entity
> @Table(name = "WEB_BOOKSTORE_BOOKS", schema = "APP")
> public class Book implements Serializable {.....
>
> The application deploys without warnings or errors. When I try to run, I get:
> SEVERE: StandardWrapperValve[BookStoreServlet]: PWC1406: Servlet.service() for servlet BookStoreServlet threw exception
> Local Exception Stack:
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.1 (Build 20080905)): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'APP.WEB_BOOKSTORE_BOOKS' does not exist.
> Error Code: -1
> Call: SELECT BOOKID, INVENTORY, SURNAME, PRICE, FIRSTNAME, CALENDAR_YEAR, ONSALE, TITLE, DESCRIPTION FROM APP.WEB_BOOKSTORE_BOOKS WHERE (BOOKID = ?)
> bind => [203]
> Query: ReadObjectQuery(com.sun.bookstore.database.Book)
> at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:322)
>
> I also tried this with
> @Table(name = "WEB_BOOKSTORE_BOOKS")
> and with
> @Table(name = "APP.WEB_BOOKSTORE_BOOKS")
> but that did not help.
>
> I consulted the EclipseLink tutorials on this @Table annotation, but I can't find any clues as to what I am missing. How should I specify the name of the table?
>
> Regards, Dries Knottnerus
> [Message sent by forum member 'driesknottnerus' (driesknottnerus)]
>
> http://forums.java.net/jive/thread.jspa?messageID=339852
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>