Home » Eclipse Projects » DTP » Database Explorer doesn't show schemas content for Oracle 9i
| Database Explorer doesn't show schemas content for Oracle 9i [message #13540] |
Tue, 09 May 2006 07:36  |
Eclipse User |
|
|
|
Hi,
I am using the Eclipse 3.2 with WTP 0.9.
I connect to Oracle 9i Database using the classes12.jar file.
I can ping the database and can also see all the schemas, but cant see any
details under the schema such as tables, procedures etc.
As soon as I click a schema I encounter the following exception which is
visible in the Error Log
Could not acquire children from extension:
org.eclipse.datatools.connectivity.db.sqlModelContent
The stack trace is as follows.
java.lang.NullPointerException
at
org.eclipse.datatools.connectivity.sqm.internal.core.definit ion.DatabaseDefinitionImpl.supportsSequence(DatabaseDefiniti onImpl.java:956)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displaySchemaChildren(ServerExplorerVNodeCon tentProviderNav.java:105)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 21)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 28)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:88)
at
org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.getChildren(ServerExplorerContentProviderNav.java:213)
at
org.eclipse.datatools.connectivity.ui.CommonContentProviderB ase.getChildren(CommonContentProviderBase.java:175)
at
org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:73)
at
org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:250)
Already a bug 106841 has been raised for this problem long time back..
Thanks..
vivek
|
|
| | |
| Re: Database Explorer doesn't show schemas content for Oracle 9i [message #16203 is a reply to message #13763] |
Wed, 07 June 2006 09:36  |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Hi Vivek:
This is not so much a Data Source Explorer issue, but rather requires
specialized models and connection support for specific databases. We have
proposed a new DTP project called "Enablement," in which we hope to address
these sorts of issues in conjunction with community support.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Vivek Chauhan" <simplevivek@gmail.com> wrote in message
news:e3sf92$rnt$1@utils.eclipse.org...
> Hi John,
>
> Thanks for your advice.
> It worked when I created a connection using 'Database Explorer'.
> I am using the latest Callisto Release.
> I used the 'Database Development' Perspective before, and was unable to
> create connection using 'Data Source Explorer'.
>
> I just want one clarification, are we going to have 'Database Explorer' in
> 'Database Development' perspective later on. and why doesnot 'Data Source
> Explorer' works..
>
> Thanks a lot.
> vivek
>
>
>
> "John Graham" <jograham@sybase.com> wrote in message
> news:e3qvv4$a8e$1@utils.eclipse.org...
>> Hi Vivek:
>>
>> Have you tried this with the database tools that come with WTP? I'd be
>> interested in hearing if you get a different result. The reason I'm
>> asking is because we're in the process of porting across equivalent
>> functionality, and this might help your situation.
>>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>>
>> "Vivek Chauhan" <simplevivek@gmail.com> wrote in message
>> news:19d2cf659537dbb77b885cca735f8e6b$1@www.eclipse.org...
>>> Hi,
>>>
>>> I am using the Eclipse 3.2 with WTP 0.9.
>>> I connect to Oracle 9i Database using the classes12.jar file.
>>> I can ping the database and can also see all the schemas, but cant see
>>> any details under the schema such as tables, procedures etc.
>>>
>>> As soon as I click a schema I encounter the following exception which is
>>> visible in the Error Log
>>>
>>> Could not acquire children from extension:
>>> org.eclipse.datatools.connectivity.db.sqlModelContent
>>>
>>> The stack trace is as follows.
>>> java.lang.NullPointerException
>>> at
>>> org.eclipse.datatools.connectivity.sqm.internal.core.definit ion.DatabaseDefinitionImpl.supportsSequence(DatabaseDefiniti onImpl.java:956)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displaySchemaChildren(ServerExplorerVNodeCon tentProviderNav.java:105)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 21)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 28)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:88)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.getChildren(ServerExplorerContentProviderNav.java:213)
>>> at
>>> org.eclipse.datatools.connectivity.ui.CommonContentProviderB ase.getChildren(CommonContentProviderBase.java:175)
>>> at
>>> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:73)
>>> at
>>> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:250)
>>>
>>>
>>> Already a bug 106841 has been raised for this problem long time back..
>>>
>>> Thanks..
>>> vivek
>>>
>>
>>
>
>
|
|
| |
| Re: Database Explorer doesn't show schemas content for Oracle 9i [message #17013 is a reply to message #16243] |
Wed, 14 June 2006 16:46 |
| Eclipse User |
|
|
|
Originally posted by: jograham.sybase.com
Daniel Serodio wrote:
> John Graham wrote:
>> Hi Vivek:
>>
>> Have you tried this with the database tools that come with WTP? I'd be
>> interested in hearing if you get a different result. The reason I'm asking
>> is because we're in the process of porting across equivalent functionality,
>> and this might help your situation.
> How do we, users, tell the database tools from WTP apart from the
> database tools from DTP?
> Thanks,
> Daniel Serodio
Hi Daniel:
This is a really good question, one for which I am afraid there is no
complete answer today. As WTP and DTP collaborate more closely, we expect
these tools to merge into one, so the problem will vanish. For now,
probably just the naming of the various components is the best way to
distinquish them. For DTP we have the following:
> Driver Templates (pref page)
> New->Connection Profiles->Connection Profile
> Data Source Explorer (as opposed to WTP Database Explorer)
> Database Development (perspective)
> Database Debug (perspective)
> Connectivity (pref page)
> SQL Development (pref pages)
> New->SQL Development->SQL File
> SQL Results (view)
HTH,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
| Re: Database Explorer doesn't show schemas content for Oracle 9i [message #574657 is a reply to message #13540] |
Tue, 09 May 2006 17:01 |
| Eclipse User |
|
|
|
Hi Vivek:
Have you tried this with the database tools that come with WTP? I'd be
interested in hearing if you get a different result. The reason I'm asking
is because we're in the process of porting across equivalent functionality,
and this might help your situation.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Vivek Chauhan" <simplevivek@gmail.com> wrote in message
news:19d2cf659537dbb77b885cca735f8e6b$1@www.eclipse.org...
> Hi,
>
> I am using the Eclipse 3.2 with WTP 0.9.
> I connect to Oracle 9i Database using the classes12.jar file.
> I can ping the database and can also see all the schemas, but cant see any
> details under the schema such as tables, procedures etc.
>
> As soon as I click a schema I encounter the following exception which is
> visible in the Error Log
>
> Could not acquire children from extension:
> org.eclipse.datatools.connectivity.db.sqlModelContent
>
> The stack trace is as follows.
> java.lang.NullPointerException
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.definit ion.DatabaseDefinitionImpl.supportsSequence(DatabaseDefiniti onImpl.java:956)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displaySchemaChildren(ServerExplorerVNodeCon tentProviderNav.java:105)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 21)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 28)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:88)
> at
> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.getChildren(ServerExplorerContentProviderNav.java:213)
> at
> org.eclipse.datatools.connectivity.ui.CommonContentProviderB ase.getChildren(CommonContentProviderBase.java:175)
> at
> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:73)
> at
> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:250)
>
>
> Already a bug 106841 has been raised for this problem long time back..
>
> Thanks..
> vivek
>
|
|
|
| Re: Database Explorer doesn't show schemas content for Oracle 9i [message #574702 is a reply to message #13724] |
Wed, 10 May 2006 06:24 |
| Eclipse User |
|
|
|
Hi John,
Thanks for your advice.
It worked when I created a connection using 'Database Explorer'.
I am using the latest Callisto Release.
I used the 'Database Development' Perspective before, and was unable to
create connection using 'Data Source Explorer'.
I just want one clarification, are we going to have 'Database Explorer' in
'Database Development' perspective later on. and why doesnot 'Data Source
Explorer' works..
Thanks a lot.
vivek
"John Graham" <jograham@sybase.com> wrote in message
news:e3qvv4$a8e$1@utils.eclipse.org...
> Hi Vivek:
>
> Have you tried this with the database tools that come with WTP? I'd be
> interested in hearing if you get a different result. The reason I'm asking
> is because we're in the process of porting across equivalent
> functionality, and this might help your situation.
>
> Regards,
> John Graham
> Eclipse Data Tools Platform PMC Chair
>
> "Vivek Chauhan" <simplevivek@gmail.com> wrote in message
> news:19d2cf659537dbb77b885cca735f8e6b$1@www.eclipse.org...
>> Hi,
>>
>> I am using the Eclipse 3.2 with WTP 0.9.
>> I connect to Oracle 9i Database using the classes12.jar file.
>> I can ping the database and can also see all the schemas, but cant see
>> any details under the schema such as tables, procedures etc.
>>
>> As soon as I click a schema I encounter the following exception which is
>> visible in the Error Log
>>
>> Could not acquire children from extension:
>> org.eclipse.datatools.connectivity.db.sqlModelContent
>>
>> The stack trace is as follows.
>> java.lang.NullPointerException
>> at
>> org.eclipse.datatools.connectivity.sqm.internal.core.definit ion.DatabaseDefinitionImpl.supportsSequence(DatabaseDefiniti onImpl.java:956)
>> at
>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displaySchemaChildren(ServerExplorerVNodeCon tentProviderNav.java:105)
>> at
>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 21)
>> at
>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 28)
>> at
>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:88)
>> at
>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.getChildren(ServerExplorerContentProviderNav.java:213)
>> at
>> org.eclipse.datatools.connectivity.ui.CommonContentProviderB ase.getChildren(CommonContentProviderBase.java:175)
>> at
>> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:73)
>> at
>> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:250)
>>
>>
>> Already a bug 106841 has been raised for this problem long time back..
>>
>> Thanks..
>> vivek
>>
>
>
|
|
|
| Re: Database Explorer doesn't show schemas content for Oracle 9i [message #579120 is a reply to message #13763] |
Wed, 07 June 2006 09:36 |
| Eclipse User |
|
|
|
Hi Vivek:
This is not so much a Data Source Explorer issue, but rather requires
specialized models and connection support for specific databases. We have
proposed a new DTP project called "Enablement," in which we hope to address
these sorts of issues in conjunction with community support.
Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
"Vivek Chauhan" <simplevivek@gmail.com> wrote in message
news:e3sf92$rnt$1@utils.eclipse.org...
> Hi John,
>
> Thanks for your advice.
> It worked when I created a connection using 'Database Explorer'.
> I am using the latest Callisto Release.
> I used the 'Database Development' Perspective before, and was unable to
> create connection using 'Data Source Explorer'.
>
> I just want one clarification, are we going to have 'Database Explorer' in
> 'Database Development' perspective later on. and why doesnot 'Data Source
> Explorer' works..
>
> Thanks a lot.
> vivek
>
>
>
> "John Graham" <jograham@sybase.com> wrote in message
> news:e3qvv4$a8e$1@utils.eclipse.org...
>> Hi Vivek:
>>
>> Have you tried this with the database tools that come with WTP? I'd be
>> interested in hearing if you get a different result. The reason I'm
>> asking is because we're in the process of porting across equivalent
>> functionality, and this might help your situation.
>>
>> Regards,
>> John Graham
>> Eclipse Data Tools Platform PMC Chair
>>
>> "Vivek Chauhan" <simplevivek@gmail.com> wrote in message
>> news:19d2cf659537dbb77b885cca735f8e6b$1@www.eclipse.org...
>>> Hi,
>>>
>>> I am using the Eclipse 3.2 with WTP 0.9.
>>> I connect to Oracle 9i Database using the classes12.jar file.
>>> I can ping the database and can also see all the schemas, but cant see
>>> any details under the schema such as tables, procedures etc.
>>>
>>> As soon as I click a schema I encounter the following exception which is
>>> visible in the Error Log
>>>
>>> Could not acquire children from extension:
>>> org.eclipse.datatools.connectivity.db.sqlModelContent
>>>
>>> The stack trace is as follows.
>>> java.lang.NullPointerException
>>> at
>>> org.eclipse.datatools.connectivity.sqm.internal.core.definit ion.DatabaseDefinitionImpl.supportsSequence(DatabaseDefiniti onImpl.java:956)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.vnode.ServerExplorerVNodeCon tentProviderNav.displaySchemaChildren(ServerExplorerVNodeCon tentProviderNav.java:105)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:1 21)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractOnDemandContentProvi derNav.getChildren(AbstractOnDemandContentProviderNav.java:2 28)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.layout.AbstractLayoutProviderNav.ge tChildren(AbstractLayoutProviderNav.java:88)
>>> at
>>> org.eclipse.datatools.connectivity.sqm.server.internal.ui.ex plorer.providers.content.impl.ServerExplorerContentProviderN av.getChildren(ServerExplorerContentProviderNav.java:213)
>>> at
>>> org.eclipse.datatools.connectivity.ui.CommonContentProviderB ase.getChildren(CommonContentProviderBase.java:175)
>>> at
>>> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:73)
>>> at
>>> org.eclipse.ui.internal.navigator.extensions.SafeDelegateTre eContentProvider.getChildren(SafeDelegateTreeContentProvider .java:250)
>>>
>>>
>>> Already a bug 106841 has been raised for this problem long time back..
>>>
>>> Thanks..
>>> vivek
>>>
>>
>>
>
>
|
|
|
| Re: Database Explorer doesn't show schemas content for Oracle 9i [message #579225 is a reply to message #13724] |
Wed, 07 June 2006 11:35 |
| Eclipse User |
|
|
|
John Graham wrote:
> Hi Vivek:
>
> Have you tried this with the database tools that come with WTP? I'd be
> interested in hearing if you get a different result. The reason I'm asking
> is because we're in the process of porting across equivalent functionality,
> and this might help your situation.
How do we, users, tell the database tools from WTP apart from the
database tools from DTP?
Thanks,
Daniel Serodio
|
|
|
| Re: Database Explorer doesn't show schemas content for Oracle 9i [message #579594 is a reply to message #16243] |
Wed, 14 June 2006 16:46 |
| Eclipse User |
|
|
|
Daniel Serodio wrote:
> John Graham wrote:
>> Hi Vivek:
>>
>> Have you tried this with the database tools that come with WTP? I'd be
>> interested in hearing if you get a different result. The reason I'm asking
>> is because we're in the process of porting across equivalent functionality,
>> and this might help your situation.
> How do we, users, tell the database tools from WTP apart from the
> database tools from DTP?
> Thanks,
> Daniel Serodio
Hi Daniel:
This is a really good question, one for which I am afraid there is no
complete answer today. As WTP and DTP collaborate more closely, we expect
these tools to merge into one, so the problem will vanish. For now,
probably just the naming of the various components is the best way to
distinquish them. For DTP we have the following:
> Driver Templates (pref page)
> New->Connection Profiles->Connection Profile
> Data Source Explorer (as opposed to WTP Database Explorer)
> Database Development (perspective)
> Database Debug (perspective)
> Connectivity (pref page)
> SQL Development (pref pages)
> New->SQL Development->SQL File
> SQL Results (view)
HTH,
John Graham
Eclipse Data Tools Platform PMC Chair
|
|
|
Goto Forum:
Current Time: Fri May 02 14:38:26 EDT 2025
Powered by FUDForum. Page generated in 0.04523 seconds |
Home