users@glassfish.java.net

Re: Internal Exception: java.sql.SQLSyntaxErrorException: Table/View 'WEB_

From: <glassfish_at_javadesktop.org>
Date: Thu, 07 May 2009 23:24:22 PDT

There are several of them, but I think the two most important are:

<?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">
    <jta-data-source>jdbc/__default</jta-data-source>
  </persistence-unit>
</persistence>

in /installdir/examples/web/bookstore/src/META-INF/

and the other in /installdir/examples/web/bookstore/build/classes/META-INF:

<?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">
    <jta-data-source>jdbc/__default</jta-data-source>
  </persistence-unit>
</persistence>

So in this case, should I follow Wolfram's suggestion and follow Pramod Gopinath's web log http://blogs.sun.com/java2dbInGlassFish/entry/automatic_table_generation_feature_in?

Thanks for all your collective help.

Regards,
i matua
[Message sent by forum member 'imatua' (imatua)]

http://forums.java.net/jive/thread.jspa?messageID=345488