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 #32880] Tue, 17 July 2007 04:20 Go to next message
Rhys McMurdo is currently offline Rhys McMurdoFriend
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"
Re: Problems editing functions with Postgres [message #33703 is a reply to message #32880] Fri, 27 July 2007 09:05 Go to previous message
Eclipse UserFriend
Originally posted by: hui.cao.sybase.ocm

Hi,
Please open a bug for it. We have met similar problems before when
developing our enablement projects. setReturnScalar() should not be called
from within getParameters(), which would cause infinite loop, because of the
EMF object reference management mechanism.
--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Rhys McMurdo" <rmcmurdo@primustel.com.au> wrote in message
news:f7hg1p$rdt$1@build.eclipse.org...
> 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"
Re: Problems editing functions with Postgres [message #586923 is a reply to message #32880] Fri, 27 July 2007 09:05 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 29
Registered: July 2009
Junior Member
Hi,
Please open a bug for it. We have met similar problems before when
developing our enablement projects. setReturnScalar() should not be called
from within getParameters(), which would cause infinite loop, because of the
EMF object reference management mechanism.
--
Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Rhys McMurdo" <rmcmurdo@primustel.com.au> wrote in message
news:f7hg1p$rdt$1@build.eclipse.org...
> 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:Some handling questions
Next Topic:50 records returned
Goto Forum:
  


Current Time: Sat Dec 20 00:15:16 GMT 2014

Powered by FUDForum. Page generated in 0.01680 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software