Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » CDO: Oracle JDBC driver
| CDO: Oracle JDBC driver [message #7347] |
Tue, 13 December 2005 20:53  |
Eclipse User |
|
|
|
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  |
| Eclipse User |
|
|
|
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 |
| Eclipse User |
|
|
|
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 |
| Eclipse User |
|
|
|
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 |
|
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...
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: CDO: Oracle JDBC driver [message #562056 is a reply to message #7358] |
Thu, 15 December 2005 19:16 |
| Eclipse User |
|
|
|
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 |
|
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...
>>
>
>
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Goto Forum:
Current Time: Wed Feb 05 11:45:25 GMT 2025
Powered by FUDForum. Page generated in 0.02937 seconds |
] 
Search
Help
Register
Login
Home
