Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsCDO: Oracle JDBC driver
https://www.eclipse.org/forums/index.php/mv/msg/2530/7347/#msg_7347
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]]>2005-12-13T20:53:00-00:00Re: CDO: Oracle JDBC driver
https://www.eclipse.org/forums/index.php/mv/msg/2530/561967/#msg_561967
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...]]>Eike Stepper2005-12-15T10:04:28-00:00Re: CDO: Oracle JDBC driver
https://www.eclipse.org/forums/index.php/mv/msg/2530/7358/#msg_7358
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...]]>2005-12-15T10:04:28-00:00Re: CDO: Oracle JDBC driver
https://www.eclipse.org/forums/index.php/mv/msg/2530/562056/#msg_562056
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...
>
]]>2005-12-15T19:16:55-00:00Re: CDO: Oracle JDBC driver
https://www.eclipse.org/forums/index.php/mv/msg/2530/7401/#msg_7401
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...
>
]]>2005-12-15T19:16:55-00:00Re: CDO: Oracle JDBC driver
https://www.eclipse.org/forums/index.php/mv/msg/2530/562080/#msg_562080
In your new fragment.xml you are referring to an "oracle" dialect:
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...
>>
>
>
>]]>Eike Stepper2005-12-16T08:08:21-00:00Re: CDO: Oracle JDBC driver
https://www.eclipse.org/forums/index.php/mv/msg/2530/7413/#msg_7413
Originally posted by: stepper.sympedia.de
Ted,
In your new fragment.xml you are referring to an "oracle" dialect:
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...
>>
>
>
>]]>2005-12-16T08:08:21-00:00