Problem generating sql with postgres

From: Greg Hulands (ghuland..ac.com)
Date: Wed Apr 09 2008 - 18:11:21 EDT

  • Next message: Mike Schrag: "Re: Problem generating sql with postgres"

    Hi,
    I am trying to generate the sql for the model and get the exception
    below. In the dialog it complains that "Unable to find type
    information for external type 'decimal' in attribute 'amount' of
    entity 'DiscountRule'. Check spelling and capitalization."

    I am using ERPrototypes and have it set to amount. This is WO 5.4
    frameworks from webobjects.mdimension.com and the latest nightly of
    wolips.

    java.lang.RuntimeException: Failed to generate SQL.
            at org.objectstyle.wolips.eomodeler.core.sql.EOFSQLGeneratorFactory
    $
    ReflectionSQLGenerator
    .generateSchemaCreationScript(EOFSQLGeneratorFactory.java:57)
            at
    org
    .objectstyle
    .wolips
    .eomodeler
    .actions.GenerateSQLDialog.generateSql(GenerateSQLDialog.java:295)
            at org.objectstyle.wolips.eomodeler.actions.GenerateSQLDialog
    $1.run(GenerateSQLDialog.java:276)
            at java.lang.Thread.run(Thread.java:613)
    Caused by: java.lang.reflect.InvocationTargetException
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at
    sun
    .reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
    39)
            at
    sun
    .reflect
    .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
    25)
            at java.lang.reflect.Method.invoke(Method.java:585)
            at org.objectstyle.wolips.eomodeler.core.sql.EOFSQLGeneratorFactory
    $
    ReflectionSQLGenerator
    .generateSchemaCreationScript(EOFSQLGeneratorFactory.java:55)
            ... 3 more
    Caused by: N/A
            at
    com
    .webobjects
    .jdbcadaptor
    .JDBCExpression.columnTypeStringForAttribute(JDBCExpression.java:163)
            at
    com
    .webobjects
    .jdbcadaptor
    .PostgresqlExpression
    .columnTypeStringForAttribute(PostgresqlExpression.java:382)
            at
    com
    .webobjects
    .eoaccess
    .synchronization
    .EOSchemaSynchronizationFactory
    ._columnCreationClauseForAttribute(EOSchemaSynchronizationFactory.java:
    2124)
            at
    com
    .webobjects
    .jdbcadaptor
    .PostgresqlSynchronizationFactory
    .createTableStatementsForEntityGroup
    (PostgresqlSynchronizationFactory.java:348)
            at
    com
    .webobjects
    .eoaccess
    .synchronization
    .EOSchemaSynchronizationFactory
    .createTableStatementsForEntityGroups
    (EOSchemaSynchronizationFactory.java:500)
            at
    com
    .webobjects
    .jdbcadaptor
    .PostgresqlSynchronizationFactory
    .schemaCreationStatementsForEntities
    (PostgresqlSynchronizationFactory.java:505)
            at
    com
    .webobjects
    .jdbcadaptor
    .PostgresqlSynchronizationFactory
    .schemaCreationScriptForEntities(PostgresqlSynchronizationFactory.java:
    444)
            at
    org
    .objectstyle
    .wolips
    .eomodeler
    .core
    .sql.EOFSQLGenerator.generateSchemaCreationScript(EOFSQLGenerator.java:
    423)
            ... 8 more

    Any suggestions?

    Regards,
    Greg



    This archive was generated by hypermail 2.0.0 : Wed Apr 09 2008 - 18:12:25 EDT