Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc)  » CDO: Oracle JDBC driver
CDO: Oracle JDBC driver [message #7347] Tue, 13 December 2005 20:53 Go to next message
Eclipse UserFriend
Originally posted by: tvalence1.cox.net

Hi Eike,

I am trying to use Oracle in conjunction with CDO to persist a model that
has been previously saved/accessed via CDO/MySQL.

I tried creating a fragment, org.eclipse.net4j.jdbc.oracle (i.e. similar to
org.eclipse.net4j.jdbc.mysql) to enable CDO to interact with the Oracle JDBC
driver, but it failed to properly validate in
org.eclipse.net4j.spring.db.ContextClassLoaderDataSource().

I was able to workaround the above class loader issue, but now an exception
is being thrown in
org.eclipse.net4j.dbgen.impl.SqlDialectImpl.initTypeMappings ().

Do you have any advice/source on how to properly setup CDO to use the Oracle
Thin Client JDBC driver?

Any help would be greatly appreciated.

Thanks!
- Ted
Re: CDO: Oracle JDBC driver [message #7358 is a reply to message #7347] Thu, 15 December 2005 10:04 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: stepper.sympedia.de

Hi Ted,

Starting with a copy of the jdbc.mysql fragment is a godd idea.
I did it for Oracle long time ago and it worked. If only I could
find it, I'd send it to you.

See my other comments inline...

Cheers
/Eike



TVal schrieb:
> Hi Eike,
>
> I am trying to use Oracle in conjunction with CDO to persist a model that
> has been previously saved/accessed via CDO/MySQL.

Just to clarify, you don't mean some data migration feature?
I assume Mysql was simpler to test with and now you want to switch to Oracle
and start with new data.


> I tried creating a fragment, org.eclipse.net4j.jdbc.oracle (i.e. similar to
> org.eclipse.net4j.jdbc.mysql) to enable CDO to interact with the Oracle JDBC
> driver, but it failed to properly validate in
> org.eclipse.net4j.spring.db.ContextClassLoaderDataSource().

What was the reason? (copy log)


> I was able to workaround the above class loader issue, but now an exception
> is being thrown in
> org.eclipse.net4j.dbgen.impl.SqlDialectImpl.initTypeMappings ().

Can I see the stack trace?


> Do you have any advice/source on how to properly setup CDO to use the Oracle
> Thin Client JDBC driver?

Let's have a look at your logs and if you want to, you can send me the fragment...
Re: CDO: Oracle JDBC driver [message #7401 is a reply to message #7358] Thu, 15 December 2005 19:16 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: tvalence1.cox.net

Eike,

Attached is the jdbc.oracle fragment (minus the actual Oracle driver) and
the debug log from the test.

Note that I had to include the Oracle driver in my application's startup
plug-in to resolve a classloader issue. Hopefully, the resolution of the
fragement issue described below will also resolve the classloader problem.

BTW, my proof-of-concept was based on MySql, but my target environment runs
on Oracle.

Cheers.
- Ted


"Eike Stepper" <stepper@sympedia.de> wrote in message
news:dnrf31$637$1@news.eclipse.org...
> Hi Ted,
>
> Starting with a copy of the jdbc.mysql fragment is a godd idea.
> I did it for Oracle long time ago and it worked. If only I could
> find it, I'd send it to you.
>
> See my other comments inline...
>
> Cheers
> /Eike
>
>
>
> TVal schrieb:
>> Hi Eike,
>>
>> I am trying to use Oracle in conjunction with CDO to persist a model that
>> has been previously saved/accessed via CDO/MySQL.
>
> Just to clarify, you don't mean some data migration feature?
> I assume Mysql was simpler to test with and now you want to switch to
> Oracle
> and start with new data.
>
>
>> I tried creating a fragment, org.eclipse.net4j.jdbc.oracle (i.e. similar
>> to
>> org.eclipse.net4j.jdbc.mysql) to enable CDO to interact with the Oracle
>> JDBC
>> driver, but it failed to properly validate in
>> org.eclipse.net4j.spring.db.ContextClassLoaderDataSource().
>
> What was the reason? (copy log)
>
>
>> I was able to workaround the above class loader issue, but now an
>> exception
>> is being thrown in
>> org.eclipse.net4j.dbgen.impl.SqlDialectImpl.initTypeMappings ().
>
> Can I see the stack trace?
>
>
>> Do you have any advice/source on how to properly setup CDO to use the
>> Oracle
>> Thin Client JDBC driver?
>
> Let's have a look at your logs and if you want to, you can send me the
> fragment...
>



Re: CDO: Oracle JDBC driver [message #7413 is a reply to message #7401] Fri, 16 December 2005 08:08 Go to previous message
Eclipse UserFriend
Originally posted by: stepper.sympedia.de

Ted,

In your new fragment.xml you are referring to an "oracle" dialect:

<extension name="Net4j Pluggable ORACLE Driver" point="org.eclipse.net4j.jdbc.drivers">
<driver className="oracle.jdbc.driver.OracleDriver" exampleURL="jdbc:oracle:thin:@<server>[:<1521>]:<database_name >" name="Oracle">
<supportedDialect name="oracle" />
</driver>
</extension>

Have you developed, configured and deployed this SqlDialect?
The name of the provided oracle dialect is "ORACLE", maybe that helps.

I have coded an additional argument check to detect missing dialects
before an NPE hurts. Please update org.eclipse.net4j.dbgen

Does that help?

Cheers
/Eike



TVal schrieb:
> Eike,
>
> Attached is the jdbc.oracle fragment (minus the actual Oracle driver) and
> the debug log from the test.
>
> Note that I had to include the Oracle driver in my application's startup
> plug-in to resolve a classloader issue. Hopefully, the resolution of the
> fragement issue described below will also resolve the classloader problem.
>
> BTW, my proof-of-concept was based on MySql, but my target environment runs
> on Oracle.
>
> Cheers.
> - Ted
>
>
> "Eike Stepper" <stepper@sympedia.de> wrote in message
> news:dnrf31$637$1@news.eclipse.org...
>
>>Hi Ted,
>>
>>Starting with a copy of the jdbc.mysql fragment is a godd idea.
>>I did it for Oracle long time ago and it worked. If only I could
>>find it, I'd send it to you.
>>
>>See my other comments inline...
>>
>>Cheers
>>/Eike
>>
>>
>>
>>TVal schrieb:
>>
>>>Hi Eike,
>>>
>>>I am trying to use Oracle in conjunction with CDO to persist a model that
>>>has been previously saved/accessed via CDO/MySQL.
>>
>>Just to clarify, you don't mean some data migration feature?
>>I assume Mysql was simpler to test with and now you want to switch to
>>Oracle
>>and start with new data.
>>
>>
>>
>>>I tried creating a fragment, org.eclipse.net4j.jdbc.oracle (i.e. similar
>>>to
>>>org.eclipse.net4j.jdbc.mysql) to enable CDO to interact with the Oracle
>>>JDBC
>>>driver, but it failed to properly validate in
>>>org.eclipse.net4j.spring.db.ContextClassLoaderDataSource().
>>
>>What was the reason? (copy log)
>>
>>
>>
>>>I was able to workaround the above class loader issue, but now an
>>>exception
>>>is being thrown in
>>> org.eclipse.net4j.dbgen.impl.SqlDialectImpl.initTypeMappings ().
>>
>>Can I see the stack trace?
>>
>>
>>
>>>Do you have any advice/source on how to properly setup CDO to use the
>>>Oracle
>>>Thin Client JDBC driver?
>>
>>Let's have a look at your logs and if you want to, you can send me the
>>fragment...
>>
>
>
>
Re: CDO: Oracle JDBC driver [message #561967 is a reply to message #7347] Thu, 15 December 2005 10:04 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6657
Registered: July 2009
Senior Member
Hi Ted,

Starting with a copy of the jdbc.mysql fragment is a godd idea.
I did it for Oracle long time ago and it worked. If only I could
find it, I'd send it to you.

See my other comments inline...

Cheers
/Eike



TVal schrieb:
> Hi Eike,
>
> I am trying to use Oracle in conjunction with CDO to persist a model that
> has been previously saved/accessed via CDO/MySQL.

Just to clarify, you don't mean some data migration feature?
I assume Mysql was simpler to test with and now you want to switch to Oracle
and start with new data.


> I tried creating a fragment, org.eclipse.net4j.jdbc.oracle (i.e. similar to
> org.eclipse.net4j.jdbc.mysql) to enable CDO to interact with the Oracle JDBC
> driver, but it failed to properly validate in
> org.eclipse.net4j.spring.db.ContextClassLoaderDataSource().

What was the reason? (copy log)


> I was able to workaround the above class loader issue, but now an exception
> is being thrown in
> org.eclipse.net4j.dbgen.impl.SqlDialectImpl.initTypeMappings ().

Can I see the stack trace?


> Do you have any advice/source on how to properly setup CDO to use the Oracle
> Thin Client JDBC driver?

Let's have a look at your logs and if you want to, you can send me the fragment...


Re: CDO: Oracle JDBC driver [message #562056 is a reply to message #7358] Thu, 15 December 2005 19:16 Go to previous message
Eclipse UserFriend
Originally posted by: tvalence1.cox.net

Eike,

Attached is the jdbc.oracle fragment (minus the actual Oracle driver) and
the debug log from the test.

Note that I had to include the Oracle driver in my application's startup
plug-in to resolve a classloader issue. Hopefully, the resolution of the
fragement issue described below will also resolve the classloader problem.

BTW, my proof-of-concept was based on MySql, but my target environment runs
on Oracle.

Cheers.
- Ted


"Eike Stepper" <stepper@sympedia.de> wrote in message
news:dnrf31$637$1@news.eclipse.org...
> Hi Ted,
>
> Starting with a copy of the jdbc.mysql fragment is a godd idea.
> I did it for Oracle long time ago and it worked. If only I could
> find it, I'd send it to you.
>
> See my other comments inline...
>
> Cheers
> /Eike
>
>
>
> TVal schrieb:
>> Hi Eike,
>>
>> I am trying to use Oracle in conjunction with CDO to persist a model that
>> has been previously saved/accessed via CDO/MySQL.
>
> Just to clarify, you don't mean some data migration feature?
> I assume Mysql was simpler to test with and now you want to switch to
> Oracle
> and start with new data.
>
>
>> I tried creating a fragment, org.eclipse.net4j.jdbc.oracle (i.e. similar
>> to
>> org.eclipse.net4j.jdbc.mysql) to enable CDO to interact with the Oracle
>> JDBC
>> driver, but it failed to properly validate in
>> org.eclipse.net4j.spring.db.ContextClassLoaderDataSource().
>
> What was the reason? (copy log)
>
>
>> I was able to workaround the above class loader issue, but now an
>> exception
>> is being thrown in
>> org.eclipse.net4j.dbgen.impl.SqlDialectImpl.initTypeMappings ().
>
> Can I see the stack trace?
>
>
>> Do you have any advice/source on how to properly setup CDO to use the
>> Oracle
>> Thin Client JDBC driver?
>
> Let's have a look at your logs and if you want to, you can send me the
> fragment...
>



Re: CDO: Oracle JDBC driver [message #562080 is a reply to message #7401] Fri, 16 December 2005 08:08 Go to previous message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6657
Registered: July 2009
Senior Member
Ted,

In your new fragment.xml you are referring to an "oracle" dialect:

<extension name="Net4j Pluggable ORACLE Driver" point="org.eclipse.net4j.jdbc.drivers">
<driver className="oracle.jdbc.driver.OracleDriver" exampleURL="jdbc:oracle:thin:@<server>[:<1521>]:<database_name >" name="Oracle">
<supportedDialect name="oracle" />
</driver>
</extension>

Have you developed, configured and deployed this SqlDialect?
The name of the provided oracle dialect is "ORACLE", maybe that helps.

I have coded an additional argument check to detect missing dialects
before an NPE hurts. Please update org.eclipse.net4j.dbgen

Does that help?

Cheers
/Eike



TVal schrieb:
> Eike,
>
> Attached is the jdbc.oracle fragment (minus the actual Oracle driver) and
> the debug log from the test.
>
> Note that I had to include the Oracle driver in my application's startup
> plug-in to resolve a classloader issue. Hopefully, the resolution of the
> fragement issue described below will also resolve the classloader problem.
>
> BTW, my proof-of-concept was based on MySql, but my target environment runs
> on Oracle.
>
> Cheers.
> - Ted
>
>
> "Eike Stepper" <stepper@sympedia.de> wrote in message
> news:dnrf31$637$1@news.eclipse.org...
>
>>Hi Ted,
>>
>>Starting with a copy of the jdbc.mysql fragment is a godd idea.
>>I did it for Oracle long time ago and it worked. If only I could
>>find it, I'd send it to you.
>>
>>See my other comments inline...
>>
>>Cheers
>>/Eike
>>
>>
>>
>>TVal schrieb:
>>
>>>Hi Eike,
>>>
>>>I am trying to use Oracle in conjunction with CDO to persist a model that
>>>has been previously saved/accessed via CDO/MySQL.
>>
>>Just to clarify, you don't mean some data migration feature?
>>I assume Mysql was simpler to test with and now you want to switch to
>>Oracle
>>and start with new data.
>>
>>
>>
>>>I tried creating a fragment, org.eclipse.net4j.jdbc.oracle (i.e. similar
>>>to
>>>org.eclipse.net4j.jdbc.mysql) to enable CDO to interact with the Oracle
>>>JDBC
>>>driver, but it failed to properly validate in
>>>org.eclipse.net4j.spring.db.ContextClassLoaderDataSource().
>>
>>What was the reason? (copy log)
>>
>>
>>
>>>I was able to workaround the above class loader issue, but now an
>>>exception
>>>is being thrown in
>>> org.eclipse.net4j.dbgen.impl.SqlDialectImpl.initTypeMappings ().
>>
>>Can I see the stack trace?
>>
>>
>>
>>>Do you have any advice/source on how to properly setup CDO to use the
>>>Oracle
>>>Thin Client JDBC driver?
>>
>>Let's have a look at your logs and if you want to, you can send me the
>>fragment...
>>
>
>
>


Previous Topic:Issue with loading properties from a CDO resource in Library Example project
Next Topic:Newbie question
Goto Forum:
  


Current Time: Thu Dec 01 18:05:45 GMT 2022

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

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

Back to the top