glassfish
  1. glassfish
  2. GLASSFISH-378

java2db generating not valid DDL script, semi-column is missing.

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 9.0pe
    • Fix Version/s: not determined
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      378

      Description

      Having the following :

      <?xml version="1.0" encoding="UTF-8"?>
      <persistence xmlns="http://java.sun.com/xml/ns/persistence">
      <persistence-unit name="test" transaction-type="JTA">
      <jta-data-source>jdbc/__default</jta-data-source>
      <properties>
      <property name="ddl-generation" value="dropandcreate"/>
      <property name="create-ddl-jdbc-file-name" value="create.sql"/>
      <property name="drop-ddl-jdbc-file-name" value="drop.sql"/>
      <property name="toplink.platform.class.name"
      value="oracle.toplink.essentials.platform.database.DerbyPlatform"/>
      <!-- <property name="toplink.logging.level" value="FINEST"/> -->
      </properties>
      </persistence-unit>
      </persistence>

      And looking at the generated create.sql, each SQL statement are not separated by
      a semi-column (, thus the generated DDL script is not valid and can not be
      exacuted without manual correction by adding the missing semi-column.

      This problem is existing on Derby, but it is anticipated that other java2db
      flavor are behaving like that ! Please, fix this issue on derby and then double
      check on other platforms as well.

      Regards,
      JB

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            pramodgo
            Reporter:
            bjb
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: