PDA

View Full Version : Cannot create Repository on EnterpriseDB (PostgreSQL 8.1)



kettle_anonymous
04-18-2006, 09:21 AM
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?

jbleuel
04-18-2006, 11:30 PM
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

kettle_anonymous
04-20-2006, 07:49 AM
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

jbleuel
04-20-2006, 08:10 AM
LOGIN is now a reserved word and this should result in
WHERE "LOGIN" = ?

Why does PostgreSQL see this as a function?

jbleuel
04-21-2006, 10:03 AM
Opened and fixed a bug for this: [http://www.javaforge.com/proj/tracker/itemDetails.do?task_id=2053&navigation=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