Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Problems editing functions with Postgres
Problems editing functions with Postgres [message #586573] Tue, 17 July 2007 00:20
Rhys McMurdo is currently offline Rhys McMurdo
Messages: 2
Registered: July 2009
Junior Member
Hi,

I am currently having problems attempting to edit any functions on a
Postgres database. I can connect fine and can see my schemas and perform
table/data queries, however as soon as I try to edit a function, I get
the following Stack Overflow Error:

!ENTRY org.eclipse.ui 4 0 2007-07-17 14:11:47.145
!MESSAGE Unhandled event loop exception
!STACK 0
java.lang.StackOverflowError
at sun.nio.cs.UTF_8$Decoder.decodeArrayLoop(UTF_8.java:212)
at sun.nio.cs.UTF_8$Decoder.decodeLoop(UTF_8.java:358)
at java.nio.charset.CharsetDecoder.decode(CharsetDecoder.java:5 44)
at java.lang.StringCoding$StringDecoder.decode(StringCoding.jav a:140)
at java.lang.StringCoding.decode(StringCoding.java:173)
at java.lang.String.<init>(String.java:444)
at org.postgresql.core.Encoding.decode(Encoding.java:193)
at org.postgresql.core.PGStream.ReceiveString(PGStream.java:320 )
at
org.postgresql.core.v3.QueryExecutorImpl.receiveFields(Query ExecutorImpl.java:1508)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(Quer yExecutorImpl.java:1383)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecut orImpl.java:191)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(Abstract Jdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags (AbstractJdbc2Statement.java:337)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abs tractJdbc2Statement.java:236)
at
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getProced ureColumns(AbstractJdbc2DatabaseMetaData.java:1750)
at
org.eclipse.datatools.connectivity.sqm.loader.JDBCRoutineCol umnLoader.createParametersResultSet(JDBCRoutineColumnLoader. java:268)
at
org.eclipse.datatools.connectivity.sqm.loader.JDBCRoutineCol umnLoader.loadParameters(JDBCRoutineColumnLoader.java:161)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.loadParameters(JDBCUserDefinedFunction.java :129)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.getParameters(JDBCUserDefinedFunction.java: 74)
at
org.eclipse.datatools.modelbase.sql.routines.impl.RoutineImp l.eInverseRemove(RoutineImpl.java:710)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.eInverseRemove(FunctionImpl.java:456)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseRemove(B asicEObjectImpl.java:1421)
at
org.eclipse.datatools.modelbase.sql.routines.impl.ParameterI mpl.eBasicRemoveFromContainerFeature(ParameterImpl.java:288)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eBasicRemoveFrom Container(BasicEObjectImpl.java:1366)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseAdd(Basi cEObjectImpl.java:1395)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.setReturnScalar(FunctionImpl.java:391)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.loadParameters(JDBCUserDefinedFunction.java :135)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.getParameters(JDBCUserDefinedFunction.java: 74)
at
org.eclipse.datatools.modelbase.sql.routines.impl.RoutineImp l.eInverseRemove(RoutineImpl.java:710)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.eInverseRemove(FunctionImpl.java:456)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseRemove(B asicEObjectImpl.java:1421)
at
org.eclipse.datatools.modelbase.sql.routines.impl.ParameterI mpl.eBasicRemoveFromContainerFeature(ParameterImpl.java:288)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eBasicRemoveFrom Container(BasicEObjectImpl.java:1366)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseAdd(Basi cEObjectImpl.java:1395)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.setReturnScalar(FunctionImpl.java:391)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.loadParameters(JDBCUserDefinedFunction.java :135)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.getParameters(JDBCUserDefinedFunction.java: 74)
at
org.eclipse.datatools.modelbase.sql.routines.impl.RoutineImp l.eInverseRemove(RoutineImpl.java:710)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.eInverseRemove(FunctionImpl.java:456)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseRemove(B asicEObjectImpl.java:1421)
at
org.eclipse.datatools.modelbase.sql.routines.impl.ParameterI mpl.eBasicRemoveFromContainerFeature(ParameterImpl.java:288)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eBasicRemoveFrom Container(BasicEObjectImpl.java:1366)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseAdd(Basi cEObjectImpl.java:1395)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.setReturnScalar(FunctionImpl.java:391)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.loadParameters(JDBCUserDefinedFunction.java :135)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.getParameters(JDBCUserDefinedFunction.java: 74)
at
org.eclipse.datatools.modelbase.sql.routines.impl.RoutineImp l.eInverseRemove(RoutineImpl.java:710)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.eInverseRemove(FunctionImpl.java:456)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseRemove(B asicEObjectImpl.java:1421)
at
org.eclipse.datatools.modelbase.sql.routines.impl.ParameterI mpl.eBasicRemoveFromContainerFeature(ParameterImpl.java:288)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eBasicRemoveFrom Container(BasicEObjectImpl.java:1366)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseAdd(Basi cEObjectImpl.java:1395)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.setReturnScalar(FunctionImpl.java:391)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.loadParameters(JDBCUserDefinedFunction.java :135)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.getParameters(JDBCUserDefinedFunction.java: 74)
at
org.eclipse.datatools.modelbase.sql.routines.impl.RoutineImp l.eInverseRemove(RoutineImpl.java:710)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.eInverseRemove(FunctionImpl.java:456)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseRemove(B asicEObjectImpl.java:1421)
at
org.eclipse.datatools.modelbase.sql.routines.impl.ParameterI mpl.eBasicRemoveFromContainerFeature(ParameterImpl.java:288)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eBasicRemoveFrom Container(BasicEObjectImpl.java:1366)
at
org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseAdd(Basi cEObjectImpl.java:1395)
at
org.eclipse.datatools.modelbase.sql.routines.impl.FunctionIm pl.setReturnScalar(FunctionImpl.java:391)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.loadParameters(JDBCUserDefinedFunction.java :135)
at
org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.JDBCUse rDefinedFunction.getParameters(JDBCUserDefinedFunction.java: 74)
at
org.eclipse.datatools.modelbase.sql.routines.impl.RoutineImp l.eInverseRemove(RoutineImpl.java:710)


There is a lot more to it than this, however, it seems to just keep
going and going...

The Postgres version that I am connecting to is 8.2.4 and I have tried
using the latest JDBC drivers from http://jdbc.postgresql.com (Version
2, 3 & 4) with no luck. I asked one of my friends to confirm this in
their work environment and they also get this error (Using a Postgres
8.1 Server). Does this look like a bug and should it be reported as one,
or are we both doing something wrong? I have included version
information of various things below but if you need more information
please let me know

Version informations:
postgres:8.2.4
postgres-jdbc:8.2-505.jdbc4

eclipse.buildId=I20070625-1500
java.vm.version=1.6.0_02-b05

org.eclipse.datatools.connectivity.feature (1.5.0.200707041) "Data Tools
Platform Connectivity Plug-in"
org.eclipse.datatools.connectivity.oda.designer.feature
(1.5.0.200707041) "DTP ODA Designer UI Framework Plug-in"
org.eclipse.datatools.connectivity.oda.feature (1.5.0.200707041) "DTP
Open Data Access"
org.eclipse.datatools.doc.user (1.5.0.200707041) "Data Tools Platform
User Guide"
org.eclipse.datatools.enablement.apache.derby.feature (1.5.0.200707041)
"High-level Sybase Enablement Plug-in"
org.eclipse.datatools.enablement.feature (1.5.0.200707041) "Eclipse Data
Tools Platform Enablement"
org.eclipse.datatools.enablement.hsqldb.feature (1.5.0.200707041)
"Eclipse Data Tools Platform Enablement"
org.eclipse.datatools.enablement.ibm.feature (1.5.0.200707041) "Eclipse
Data Tools Platform Enablement"
org.eclipse.datatools.enablement.jdbc.feature (1.5.0.200707041)
"High-level Sybase Enablement Plug-in"
org.eclipse.datatools.enablement.msft.feature (1.5.0.200707041) "Eclipse
Data Tools Platform Enablement"
org.eclipse.datatools.enablement.mysql.feature (1.5.0.200707041)
"Eclipse Data Tools Platform Enablement"
org.eclipse.datatools.enablement.oda.designer.feature (1.5.0.200707041)
"Eclipse Data Tools Platform XML ODA Designer"
org.eclipse.datatools.enablement.oda.feature (1.5.0.200707041) "Eclipse
Data Tools Platform XML ODA Runtime Driver"
org.eclipse.datatools.enablement.oracle.feature (1.5.0.200707041)
"Eclipse Data Tools Platform Enablement"
org.eclipse.datatools.enablement.postgresql.feature (1.5.0.200707041)
"Eclipse Data Tools Platform Enablement"
org.eclipse.datatools.enablement.sybase.feature (1.5.0.200707041)
"High-level Sybase Enablement Plug-in"
org.eclipse.datatools.intro (1.5.0.200707041) "Eclipse Data Tools
Platform Intro Plug-in"
org.eclipse.datatools.modelbase.feature (1.5.0.200707041) "Eclipse Data
Tools Platform SQLModel Plug-in"
org.eclipse.datatools.sdk.feature (1.5.0.200707041) "Data Tools Platform
Source Code"
org.eclipse.datatools.sqldevtools.feature (1.5.0.200707041) "Eclipse
Data Tools Platform SQL Tools Common UI Plug-in"
Previous Topic:Firebird connection
Next Topic:Help with Ecore ODA Driver - Need MindMap data
Goto Forum:
  


Current Time: Thu Jul 31 19:58:10 EDT 2014

Powered by FUDForum. Page generated in 0.01894 seconds