[teiid-issues] [JBoss JIRA] Commented: (TEIID-436) Error Installing Teiid with a Postgres Repository

[Ted Jones (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12458644#action_12458644 ] 

Ted Jones commented on TEIID-436:
---------------------------------

Turns out this error was caused by assuming a particular URL format for Postgres. There are optional portions of the url for Postgres which I left off. If host and port are omitted they are assumed to be localhost and  5432 respectively. So, jdbc:postgresql:dv_tejones is equivalent  to jdbc:postgresql://localhost:5432/dv_tejones.

We should check for all possible combinations of the url OR require that the url is entered in the full format.

> Error Installing Teiid with a Postgres Repository
> -------------------------------------------------
>
>                 Key: TEIID-436
>                 URL: https://jira.jboss.org/jira/browse/TEIID-436
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Driver
>    Affects Versions: 6.0.0
>            Reporter: Ted Jones
>             Fix For: 6.1.0
>
>
> While running setupmm with a local Postgres repository, I encountered the following fatal error:
> /home/tejones/apps/EnterpriseDataServicesPlatform/03202009/server-0.0.1-SNAPSHOT/config/install/setup_server.xml:453: [MetaMatrixComponentException] ERR.014.004.0054: Error inserting extension module Next Startup using SQL statement: INSERT  INTO CS_EXT_FILES(FILE_UID,CHKSUM,FILE_NAME,SEARCH_POS,IS_ENABLED,FILE_DESC,CREATED_BY,CREATION_DATE,UPDATED_BY,UPDATE_DATE,FILE_TYPE) VALUES
> 1 [DBIDGeneratorException] ERR.003.013.0011: Error creating id for CS_EXT_FILES context.
> 2 [DBIDGeneratorException] ERR.003.013.0014: Could not obtain a unique ID blocksize of 100 for context CS_EXT_FILES.
> 3 [ManagedConnectionException] ERR.003.013.0016: Unable to obtain the managed connection for the DBID transaction
> 4 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create platform.
> 5 [MetaMatrixException] ERR.003.015.0003: JDBCPlatform Program Error, unable to create platform.
> 6 [IllegalArgumentException]

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira