| Problems editing functions with Postgres [message #32880] |
Tue, 17 July 2007 00:20  |
Eclipse User |
|
|
|
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 05:05  |
| Eclipse User |
|
|
|
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 05:05 |
| Eclipse User |
|
|
|
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"
|
|
|
Powered by
FUDForum. Page generated in 0.03854 seconds
Home