PostgreSQL SQL generation failing

From: Jürgen Lorenz Simon (simon_jackso..ac.com)
Date: Fri Oct 19 2007 - 08:17:09 EDT

  • Next message: JIRA: "[OS-JIRA] Created: (WOL-600) Support for ERXLocalizedString in "Clean WOBuilder Names""

    Hello,

    I'm trying to generate SQL for PostgreSQL using the EOModeler plugin
    for Eclipse.
    The attributes are defined using EOJDBCPostgresqlPrototypes.

    When attempting schema generation, I receive the following error
    message:

    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
    (Unknown Source)
            at org.objectstyle.wolips.eomodeler.actions.GenerateSQLDialog$1.run
    (Unknown Source)
            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: com.webobjects.jdbcadaptor.JDBCAdaptorException: Unable to
    find type information for external type 'bytea' in attribute
    'colorData' of entity 'Blob'. Check spelling and capitalization.
            at
    com.webobjects.jdbcadaptor.JDBCExpression.columnTypeStringForAttribute
    (JDBCExpression.java:289)
            at
    com.webobjects.jdbcadaptor.PostgresqlExpression.columnTypeStringForAttri
    bute(PostgresqlExpression.java:377)
            at
    com.webobjects.eoaccess.EOSQLExpression.addCreateClauseForAttribute
    (EOSQLExpression.java:2498)
            at
    com.webobjects.eoaccess.EOSynchronizationFactory.createTableStatementsFo
    rEntityGroup(EOSynchronizationFactory.java:318)
            at
    com.webobjects.eoaccess.EOSynchronizationFactory.createTableStatementsFo
    rEntityGroups(EOSynchronizationFactory.java:487)
            at
    com.webobjects.eoaccess.EOSynchronizationFactory.schemaCreationStatement
    sForEntities(EOSynchronizationFactory.java:951)
            at
    com.webobjects.eoaccess.EOSynchronizationFactory.schemaCreationScriptFor
    Entities(EOSynchronizationFactory.java:747)
            at
    org.objectstyle.wolips.eomodeler.core.sql.EOFSQLGenerator.generateSchema
    CreationScript(EOFSQLGenerator.java:384)
            ... 8 more

    I checked the PostgreSQL documentation, and bytea seems to be
    appropriate. I use the
    following versions and tools:

    Eclipse
            Version: 3.3.0
            Build id: M20070921-1145

    WOLips
            3.3.4498

    PostgreSQL
            Database Version 8.2, installed via Fink.
            JDBC Drivers for JDBC3 for 8.2

    ProjectWonder
            Version 4.0 for PostgreSQLPlugin

    Any pointers are much appreciated.

    J.L.Simon

    This archive was generated by hypermail 2.0.0 : Fri Oct 19 2007 - 08:18:44 EDT