Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Cannot create Repository on EnterpriseDB (PostgreSQL 8.1)

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Cannot create Repository on EnterpriseDB (PostgreSQL 8.1)

    I am trying to create a repository on my EnterpriseDB server but the creation fails because some tables use the keyword OPERATOR as a column name. Is there a way to alias this to something different?

  2. #2
    Join Date
    Nov 1999
    Posts
    459

    Default RE: Cannot create Repository on EnterpriseDB (PostgreSQL 8.1)

    I found PostgreSQL history for 8.1.1 http://pgsql81.sourcesdb.com/r.php?num=2515 : Add more reserved words, mostly for SQL92 compliance(Thomas)

    Seems they added OPERATOR now ;-)

    Add getReservedWords() to PostgreSQLDatabaseMeta should fix this.

    I will do this in the next minutes... if you send me your mail adress, I could send you the latest jar... otherwise it will be availavble tomorrow...

    Cheers,
    Jens

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Cannot create Repository on EnterpriseDB (PostgreSQL 8.1)

    OK, I downloaded the latest kettle.jar file (4/20), removed the repositories.xml file from my home drive, created a new database in PostgreSQL, opened spoon, created a new connection and repository. The repository created but I recieve this error when attempting to log into it with admin/admin


    Unable to load user with login [admin] from the repository

    An error occurred executing SQL:
    SELECT ID_USER FROM R_USER WHERE LOGIN = ?
    ERROR: function login() does not exist




    be.ibridge.kettle.core.exception.KettleException:
    Unable to load user with login [admin] from the repository

    An error occurred executing SQL:
    SELECT ID_USER FROM R_USER WHERE LOGIN = ?
    ERROR: function login() does not exist



    at be.ibridge.kettle.repository.UserInfo.<init>(UserInfo.java:108)
    at be.ibridge.kettle.repository.UserInfo.<init>(UserInfo.java:117)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog.ok(RepositoriesDialog.java:422)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog.access$600(RepositoriesDialog.java:65)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog$5.handleEvent(RepositoriesDialog.java:303)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:843)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3080)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2713)
    at be.ibridge.kettle.repository.dialog.RepositoriesDialog.open(RepositoriesDialog.java:348)
    at be.ibridge.kettle.spoon.Spoon.main(Spoon.java:4337)
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    An error occurred executing SQL:
    SELECT ID_USER FROM R_USER WHERE LOGIN = ?
    ERROR: function login() does not exist


    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:1720)
    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:1660)
    at be.ibridge.kettle.core.database.Database.getOneRow(Database.java:3245)
    at be.ibridge.kettle.repository.Repository.getIDWithValue(Repository.java:520)
    at be.ibridge.kettle.repository.Repository.getUserID(Repository.java:432)
    at be.ibridge.kettle.repository.UserInfo.<init>(UserInfo.java:69)
    ... 10 more
    Caused by: org.postgresql.util.PSQLException: ERROR: function login() does not exist

    at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
    at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
    at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
    at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
    at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
    at be.ibridge.kettle.core.database.Database.openQuery(Database.java:1690)
    ... 15 more

  4. #4
    Join Date
    Nov 1999
    Posts
    459

    Default RE: Cannot create Repository on EnterpriseDB (PostgreSQL 8.1)

    LOGIN is now a reserved word and this should result in
    WHERE "LOGIN" = ?

    Why does PostgreSQL see this as a function?

  5. #5
    Join Date
    Nov 1999
    Posts
    459

    Default RE: Cannot create Repository on EnterpriseDB (PostgreSQL 8.1)

    Opened and fixed a bug for this: [http://www.javaforge.com/proj/tracke...vigation=true]

    Could you download and try the latest Kettle.jar when it is build (only with date after Apr 21 2006 20:01).

    Thanks,
    Jens

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.