Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] Oracle Adapter Wanted(CDO)
[CDO] Oracle Adapter Wanted [message #662335] Wed, 30 March 2011 09:40 Go to next message
David Skogan is currently offline David Skogan
Messages: 1
Registered: March 2011
Junior Member
Hi,

Could someone please provide information about how to connect to a oracle database over CDO.

Source code or examples would be nice.

Regards
David
Re: [CDO] Oracle Adapter Wanted [message #662369 is a reply to message #662335] Wed, 30 March 2011 12:22 Go to previous messageGo to next message
techteam is currently offline techteam
Messages: 54
Registered: September 2010
Member
Hi,
at the moment I know only one way, which goes over the CDO Hibernate Store.
Examples for this (not direct for an Oracle DB) should you find there:
http://dev.eclipse.org/viewcvs/viewvc.cgi/trunk/plugins/?roo t=Modeling_CDO

If you following the CDO Source Installation Tutorial (
http://wiki.eclipse.org/CDO_Source_Installation ), you would have all
needed files in your workspace.

At the way over the CDO DB Store, there are only an old bug, but no
implementation ( https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428 )

Hope it helps

Heiko

Am 30.03.2011 11:40, schrieb David Skogan:
> Hi,
>
> Could someone please provide information about how to connect to a
> oracle database over CDO.
> Source code or examples would be nice.
>
> Regards
> David
Re: [CDO] Oracle Adapter Wanted [message #662420 is a reply to message #662369] Wed, 30 March 2011 15:32 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Hey Guys,

The implementation of the adapter (not the driver) has been accidentally deleted by the webmasters: https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428 . You may want to contact Hasan and see if he can find it again on one of his drives. I'd be more than happy to review that code and push it through the IP clearance at Eclipse.

My personal guess is that a new implementation is not too costly, either. I've only been reluctant to do it, because of the flood of different JDBC drivers on my box that are needed to entertain all these DBs. And I have no experience with Oracle myself. If you look at some of the other DBAdapters you'll find out that they do not contain a lot of code.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper



Am 30.03.2011 05:22, schrieb Heiko:
> Hi,
> at the moment I know only one way, which goes over the CDO Hibernate Store.
> Examples for this (not direct for an Oracle DB) should you find there: http://dev.eclipse.org/viewcvs/viewvc.cgi/trunk/plugins/?roo t=Modeling_CDO
>
> If you following the CDO Source Installation Tutorial ( http://wiki.eclipse.org/CDO_Source_Installation ), you would have all needed files in your workspace.
>
> At the way over the CDO DB Store, there are only an old bug, but no implementation ( https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428 )
>
> Hope it helps
>
> Heiko
>
> Am 30.03.2011 11:40, schrieb David Skogan:
>> Hi,
>>
>> Could someone please provide information about how to connect to a
>> oracle database over CDO.
>> Source code or examples would be nice.
>>
>> Regards
>> David
>
Re: [CDO] Oracle Adapter Wanted [message #663846 is a reply to message #662420] Wed, 06 April 2011 15:25 Go to previous messageGo to next message
Eclipse User
Originally posted by: info.dav85.de

Hey Guys,

I am currently implement a DBAdapter for Oracle. The adapter works fine,
but in some cases I need do modify something in the CDO Schema. The
problem is, that the CDO Schema contains keywords from Oracle, e.g
..
public static final IDBField COMMIT_INFOS_COMMENT = //
COMMIT_INFOS.addField("comment", DBType.VARCHAR); //$NON-NLS-1$

in this case "comment" is a keyword in oracle and must be renamed.

The other problem that I have at the moment is to write boolean values.
In Oracle boolean is not provided as a datatype. You have to create the
column with the type VARCHAR2(1) or NUMBER(1,0). After that the table
will be created correctly.
But than CDO try to write a value in this column and it crashes with a
SQL Exception

Caused by: java.sql.SQLException: Invalid column type

The reason:

protected void doSetValue(PreparedStatement stmt, int index, Object
value) throws SQLException
{
stmt.setObject(index, value, getSqlType());
}

The function getSqlType() from AbstractTypeMapping returns "BOOLEAN" and
the value is false or true. In Oracle the column has the type
NUMBER(1,0) or VARCHAR(2) and not BOOLEAN and needs a value 1 or 0 or
'Y' or 'N'.

It seems that all other datatypes works fine.

That is current state of my implementation. Tommorrow I'll continue
working on this adapter.

@Eike: Have you some ideas or tips how I can handle this problem?

If the adapter works correctly I can provide it for the CDO Project.

Regards
David


Am 30/03/2011 17:32, schrieb Eike Stepper:
> Hey Guys,
>
> The implementation of the adapter (not the driver) has been accidentally
> deleted by the webmasters:
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428 . You may want to
> contact Hasan and see if he can find it again on one of his drives. I'd
> be more than happy to review that code and push it through the IP
> clearance at Eclipse.
>
> My personal guess is that a new implementation is not too costly,
> either. I've only been reluctant to do it, because of the flood of
> different JDBC drivers on my box that are needed to entertain all these
> DBs. And I have no experience with Oracle myself. If you look at some of
> the other DBAdapters you'll find out that they do not contain a lot of
> code.
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
> Am 30.03.2011 05:22, schrieb Heiko:
>> Hi,
>> at the moment I know only one way, which goes over the CDO Hibernate
>> Store.
>> Examples for this (not direct for an Oracle DB) should you find there:
>> http://dev.eclipse.org/viewcvs/viewvc.cgi/trunk/plugins/?roo t=Modeling_CDO
>>
>>
>> If you following the CDO Source Installation Tutorial (
>> http://wiki.eclipse.org/CDO_Source_Installation ), you would have all
>> needed files in your workspace.
>>
>> At the way over the CDO DB Store, there are only an old bug, but no
>> implementation ( https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428 )
>>
>> Hope it helps
>>
>> Heiko
>>
>> Am 30.03.2011 11:40, schrieb David Skogan:
>>> Hi,
>>>
>>> Could someone please provide information about how to connect to a
>>> oracle database over CDO.
>>> Source code or examples would be nice.
>>>
>>> Regards
>>> David
>>
Re: [CDO] Oracle Adapter Wanted [message #663854 is a reply to message #663846] Wed, 06 April 2011 15:51 Go to previous messageGo to next message
Thomas Schindl is currently offline Thomas Schindl
Messages: 5422
Registered: July 2009
Senior Member
Am 06.04.11 17:25, schrieb David Hein:
> Hey Guys,
>
> I am currently implement a DBAdapter for Oracle. The adapter works fine,
> but in some cases I need do modify something in the CDO Schema. The
> problem is, that the CDO Schema contains keywords from Oracle, e.g
> .
> public static final IDBField COMMIT_INFOS_COMMENT = //
> COMMIT_INFOS.addField("comment", DBType.VARCHAR); //$NON-NLS-1$
>
> in this case "comment" is a keyword in oracle and must be renamed.

Well all you need to do is to quote it and then you can even use
reserved words in oracle (and most other databases).

So if you use
COMMIT_INFOS.addField("\\"comment\\"",DBType.VARCHAR) it should work not?

Tom
Re: [CDO] Oracle Adapter Wanted [message #663863 is a reply to message #663846] Wed, 06 April 2011 16:10 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Am 06.04.2011 17:25, schrieb David Hein:
> Hey Guys,
>
> I am currently implement a DBAdapter for Oracle. The adapter works fine,
Good news ;-)

> but in some cases I need do modify something in the CDO Schema. The problem is, that the CDO Schema contains keywords from Oracle, e.g
> .
> public static final IDBField COMMIT_INFOS_COMMENT = //
> COMMIT_INFOS.addField("comment", DBType.VARCHAR); //$NON-NLS-1$
>
> in this case "comment" is a keyword in oracle and must be renamed.
I think we can rename it in CDO.

>
> The other problem that I have at the moment is to write boolean values. In Oracle boolean is not provided as a datatype.
Thank you, Oracle!!!

> You have to create the column with the type VARCHAR2(1) or NUMBER(1,0). After that the table will be created correctly.
> But than CDO try to write a value in this column and it crashes with a SQL Exception
>
> Caused by: java.sql.SQLException: Invalid column type
>
> The reason:
>
> protected void doSetValue(PreparedStatement stmt, int index, Object value) throws SQLException
> {
> stmt.setObject(index, value, getSqlType());
> }
>
> The function getSqlType() from AbstractTypeMapping returns "BOOLEAN" and the value is false or true. In Oracle the column has the type NUMBER(1,0) or VARCHAR(2) and not BOOLEAN and needs a value 1 or 0 or 'Y' or 'N'.
>
> It seems that all other datatypes works fine.
>
> That is current state of my implementation. Tommorrow I'll continue working on this adapter.
>
> @Eike: Have you some ideas or tips how I can handle this problem?
I suspect we need to default to a different TypeMapping with Oracle. Stefan, what do you think?

>
> If the adapter works correctly I can provide it for the CDO Project.
That would be awesome! When you're ready, please submit an enhancement request and attach your code. Maybe we can get it through the IP clearance process for Indigo.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


>
> Regards
> David
>
>
> Am 30/03/2011 17:32, schrieb Eike Stepper:
>> Hey Guys,
>>
>> The implementation of the adapter (not the driver) has been accidentally
>> deleted by the webmasters:
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428 . You may want to
>> contact Hasan and see if he can find it again on one of his drives. I'd
>> be more than happy to review that code and push it through the IP
>> clearance at Eclipse.
>>
>> My personal guess is that a new implementation is not too costly,
>> either. I've only been reluctant to do it, because of the flood of
>> different JDBC drivers on my box that are needed to entertain all these
>> DBs. And I have no experience with Oracle myself. If you look at some of
>> the other DBAdapters you'll find out that they do not contain a lot of
>> code.
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>
>> Am 30.03.2011 05:22, schrieb Heiko:
>>> Hi,
>>> at the moment I know only one way, which goes over the CDO Hibernate
>>> Store.
>>> Examples for this (not direct for an Oracle DB) should you find there:
>>> http://dev.eclipse.org/viewcvs/viewvc.cgi/trunk/plugins/?roo t=Modeling_CDO
>>>
>>>
>>> If you following the CDO Source Installation Tutorial (
>>> http://wiki.eclipse.org/CDO_Source_Installation ), you would have all
>>> needed files in your workspace.
>>>
>>> At the way over the CDO DB Store, there are only an old bug, but no
>>> implementation ( https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428 )
>>>
>>> Hope it helps
>>>
>>> Heiko
>>>
>>> Am 30.03.2011 11:40, schrieb David Skogan:
>>>> Hi,
>>>>
>>>> Could someone please provide information about how to connect to a
>>>> oracle database over CDO.
>>>> Source code or examples would be nice.
>>>>
>>>> Regards
>>>> David
>>>
>
Re: [CDO] Oracle Adapter Wanted [message #663864 is a reply to message #663854] Wed, 06 April 2011 16:11 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Am 06.04.2011 17:51, schrieb Tom Schindl:
> Am 06.04.11 17:25, schrieb David Hein:
>> Hey Guys,
>>
>> I am currently implement a DBAdapter for Oracle. The adapter works fine,
>> but in some cases I need do modify something in the CDO Schema. The
>> problem is, that the CDO Schema contains keywords from Oracle, e.g
>> .
>> public static final IDBField COMMIT_INFOS_COMMENT = //
>> COMMIT_INFOS.addField("comment", DBType.VARCHAR); //$NON-NLS-1$
>>
>> in this case "comment" is a keyword in oracle and must be renamed.
> Well all you need to do is to quote it and then you can even use
> reserved words in oracle (and most other databases).
>
> So if you use
> COMMIT_INFOS.addField("\\"comment\\"",DBType.VARCHAR) it should work not?
Sounds good. We'll try it. Thanks!

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: [CDO] Oracle Adapter Wanted [message #664019 is a reply to message #663863] Thu, 07 April 2011 08:26 Go to previous messageGo to next message
Stefan Winkler is currently offline Stefan Winkler
Messages: 277
Registered: July 2009
Location: Germany
Senior Member
Hi,

see below.

Am 06.04.11 18:10, schrieb Eike Stepper:

>> You have to create the column with the type VARCHAR2(1) or
>> NUMBER(1,0). After that the table will be created correctly.
>> But than CDO try to write a value in this column and it crashes with a
>> SQL Exception
>>
>> Caused by: java.sql.SQLException: Invalid column type
>>
>> The reason:
>>
>> protected void doSetValue(PreparedStatement stmt, int index, Object
>> value) throws SQLException
>> {
>> stmt.setObject(index, value, getSqlType());
>> }
>>
>> The function getSqlType() from AbstractTypeMapping returns "BOOLEAN"
>> and the value is false or true. In Oracle the column has the type
>> NUMBER(1,0) or VARCHAR(2) and not BOOLEAN and needs a value 1 or 0 or
>> 'Y' or 'N'.
>>
>> It seems that all other datatypes works fine.
>>
>> That is current state of my implementation. Tommorrow I'll continue
>> working on this adapter.
>>
>> @Eike: Have you some ideas or tips how I can handle this problem?
> I suspect we need to default to a different TypeMapping with Oracle.
> Stefan, what do you think?
>

I just had a look into the CoreTypeMappings source and there's already a
mapping from Boolean to Smallint. Maybe you can try that first before
adding a new type mapping.

To map a boolean to smallint you could implement
DBAdapter.adaptType
this method does database-specific type overrides. If you implement it like

DBType adaptType(DBType in) {
return in == DBType.BOOLEAN ? DBType.SMALLINT : in;
}

the EBoolean should be mapped to SMALLINT and the already existing
smallint type mapping should kick in and do the mapping for you.

Cheers,
Stefan
Re: [CDO] Oracle Adapter Wanted [message #664026 is a reply to message #663864] Thu, 07 April 2011 08:34 Go to previous messageGo to next message
Stefan Winkler is currently offline Stefan Winkler
Messages: 277
Registered: July 2009
Location: Germany
Senior Member
Hi,

Am 06.04.11 18:11, schrieb Eike Stepper:
> Am 06.04.2011 17:51, schrieb Tom Schindl:
>> Am 06.04.11 17:25, schrieb David Hein:
>>> Hey Guys,
>>>
>>> I am currently implement a DBAdapter for Oracle. The adapter works fine,
>>> but in some cases I need do modify something in the CDO Schema. The
>>> problem is, that the CDO Schema contains keywords from Oracle, e.g
>>> .
>>> public static final IDBField COMMIT_INFOS_COMMENT = //
>>> COMMIT_INFOS.addField("comment", DBType.VARCHAR); //$NON-NLS-1$
>>>
>>> in this case "comment" is a keyword in oracle and must be renamed.
>> Well all you need to do is to quote it and then you can even use
>> reserved words in oracle (and most other databases).
>>
>> So if you use
>> COMMIT_INFOS.addField("\\"comment\\"",DBType.VARCHAR) it should work not?
> Sounds good. We'll try it. Thanks!

Problem is that the quoting character is DB-dependent. Some use single
quotes, some use double quotes and some use back-ticks.

There is an open bug
(https://bugs.eclipse.org/bugs/show_bug.cgi?id=306356) addressing the
quoting issue. It's somewhere on my todo list ...

Cheers,
Stefan
Re: [CDO] Oracle Adapter Wanted [message #664043 is a reply to message #664019] Thu, 07 April 2011 09:12 Go to previous messageGo to next message
Eclipse User
Originally posted by: info.dav85.de

Am 07/04/2011 10:26, schrieb Stefan Winkler:
> Hi,
>
> see below.
>
> Am 06.04.11 18:10, schrieb Eike Stepper:
>
>>> You have to create the column with the type VARCHAR2(1) or
>>> NUMBER(1,0). After that the table will be created correctly.
>>> But than CDO try to write a value in this column and it crashes with a
>>> SQL Exception
>>>
>>> Caused by: java.sql.SQLException: Invalid column type
>>>
>>> The reason:
>>>
>>> protected void doSetValue(PreparedStatement stmt, int index, Object
>>> value) throws SQLException
>>> {
>>> stmt.setObject(index, value, getSqlType());
>>> }
>>>
>>> The function getSqlType() from AbstractTypeMapping returns "BOOLEAN"
>>> and the value is false or true. In Oracle the column has the type
>>> NUMBER(1,0) or VARCHAR(2) and not BOOLEAN and needs a value 1 or 0 or
>>> 'Y' or 'N'.
>>>
>>> It seems that all other datatypes works fine.
>>>
>>> That is current state of my implementation. Tommorrow I'll continue
>>> working on this adapter.
>>>
>>> @Eike: Have you some ideas or tips how I can handle this problem?
>> I suspect we need to default to a different TypeMapping with Oracle.
>> Stefan, what do you think?
>>
>
> I just had a look into the CoreTypeMappings source and there's already a
> mapping from Boolean to Smallint. Maybe you can try that first before
> adding a new type mapping.
>
> To map a boolean to smallint you could implement
> DBAdapter.adaptType
> this method does database-specific type overrides. If you implement it like
>
> DBType adaptType(DBType in) {
> return in == DBType.BOOLEAN ? DBType.SMALLINT : in;
> }
>
> the EBoolean should be mapped to SMALLINT and the already existing
> smallint type mapping should kick in and do the mapping for you.
>
> Cheers,
> Stefan
>

Thank you very much! With this method and the mapping to SMALLINT the
ORACLE Driver writes "BOOLEAN" (VARCHAR(2)) values in the table. :)
Yesterday I was to frustrated to found this method. :-D

Now I will test it with my complete ecore models. If the tests are
successful i will do some refactoring, because there is a lot of debug
code and than I create an enhancement for the oracle db adapter.
Re: [CDO] Oracle Adapter Wanted [message #664044 is a reply to message #664026] Thu, 07 April 2011 09:30 Go to previous messageGo to next message
Eclipse User
Originally posted by: info.dav85.de

Am 07/04/2011 10:34, schrieb Stefan Winkler:
> Hi,
>
> Am 06.04.11 18:11, schrieb Eike Stepper:
>> Am 06.04.2011 17:51, schrieb Tom Schindl:
>>> Am 06.04.11 17:25, schrieb David Hein:
>>>> Hey Guys,
>>>>
>>>> I am currently implement a DBAdapter for Oracle. The adapter works
>>>> fine,
>>>> but in some cases I need do modify something in the CDO Schema. The
>>>> problem is, that the CDO Schema contains keywords from Oracle, e.g
>>>> .
>>>> public static final IDBField COMMIT_INFOS_COMMENT = //
>>>> COMMIT_INFOS.addField("comment", DBType.VARCHAR); //$NON-NLS-1$
>>>>
>>>> in this case "comment" is a keyword in oracle and must be renamed.
>>> Well all you need to do is to quote it and then you can even use
>>> reserved words in oracle (and most other databases).
>>>
>>> So if you use
>>> COMMIT_INFOS.addField("\\"comment\\"",DBType.VARCHAR) it should work
>>> not?
>> Sounds good. We'll try it. Thanks!
>
> Problem is that the quoting character is DB-dependent. Some use single
> quotes, some use double quotes and some use back-ticks.
>
> There is an open bug
> (https://bugs.eclipse.org/bugs/show_bug.cgi?id=306356) addressing the
> quoting issue. It's somewhere on my todo list ...
>
> Cheers,
> Stefan
I have test it with double quotes and it works with oracle. What is the
current state of this bug?

Cheers,
David
Re: [CDO] Oracle Adapter Wanted [message #664092 is a reply to message #664044] Thu, 07 April 2011 12:30 Go to previous messageGo to next message
Stefan Winkler is currently offline Stefan Winkler
Messages: 277
Registered: July 2009
Location: Germany
Senior Member
Hi,

>> There is an open bug
>> (https://bugs.eclipse.org/bugs/show_bug.cgi?id=306356) addressing the
>> quoting issue. It's somewhere on my todo list ...
>>
>> Cheers,
>> Stefan
> I have test it with double quotes and it works with oracle. What is the
> current state of this bug?

Well, the implementation idea is there, but it hasn't been realized yet. :-(

Maybe it's best to rename the column comment to cdo_comment first (and
add a TODO-comment with a reference to bug 306356.

Cheers,
Stefan
Re: [CDO] Oracle Adapter Wanted [message #664749 is a reply to message #664092] Mon, 11 April 2011 20:14 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 750
Registered: July 2009
Senior Member
I am interested in your Oracle DB adapter implementation as well...
[CDO] Oracle Adapter Wanted [message #668190 is a reply to message #664749] Wed, 04 May 2011 12:38 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 750
Registered: July 2009
Senior Member
I have published a preliminarily version of an Oracle DB Adapter:

https://bugs.eclipse.org/bugs/show_bug.cgi?id=344666
Re: [CDO] Oracle Adapter Wanted [message #668352 is a reply to message #668190] Thu, 05 May 2011 10:08 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Am 04.05.2011 14:38, schrieb Erdal Karaca:
> I have published a preliminarily version of an Oracle DB Adapter:
>
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=344666
Cool! I expect to find time to look at it by tomorrow...

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: [CDO] Oracle Adapter Wanted [message #947168 is a reply to message #662335] Tue, 16 October 2012 22:02 Go to previous messageGo to next message
Silvestre Martins is currently offline Silvestre Martins
Messages: 43
Registered: July 2009
Member

Hello,

I would like to resurrect this topic because it would be interesting to know what is the current state of this. From the bug (https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428) it seems that have been some activity but there isn't any update for more than 1 year.
Is there already a stable driver so we can integrate CDO with Oracle without using Hibernate?


Cheers,
Silvestre
Re: [CDO] Oracle Adapter Wanted [message #947439 is a reply to message #947168] Wed, 17 October 2012 04:47 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Am 17.10.2012 00:34, schrieb Silvestre Martins:
>
> Hello,
>
> I would like to resurrect this topic because it would be interesting to know what is the current state of this. From
> the bug (https://bugs.eclipse.org/bugs/show_bug.cgi?id=270428) it seems that have been some activity but there isn't
> any update for more than 1 year.
> Is there already a stable driver so we can integrate CDO with Oracle without using Hibernate?
From my perspective not much has changed regarding a possible release of the OracleAdapter that's attached to this
bugzilla. We'd need an OSGi bundle of the JDBC driver that can be downloaded from somewhere in the net. I'm not sure
about the legal implications, though. The best I can offer is to talk to Janet from Eclipse's legal department next week
at the EclipseCon. Maybe she can talk to Oracle and find a solution...

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: [CDO] Oracle Adapter Wanted [message #947607 is a reply to message #947439] Wed, 17 October 2012 08:31 Go to previous messageGo to next message
Silvestre Martins is currently offline Silvestre Martins
Messages: 43
Registered: July 2009
Member
Hi Eike,
thanks for the reply. I think we all would appreciate that you can ask for some support here Wink

But in your opinion, what is the current limitation? Is it only the legal issue or also the current driver we already have in the bugzilla is still not fully working?


Cheers,
Silvestre

[Updated on: Wed, 17 October 2012 08:32]

Report message to a moderator

Re: [CDO] Oracle Adapter Wanted [message #947633 is a reply to message #947607] Wed, 17 October 2012 09:03 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Am 17.10.2012 10:31, schrieb Silvestre Martins:
>
> Hi Eike,
> thanks for the reply. I think we all would appreciate that you can ask for some support here ;)
>
> But in your opinion, what is the current limitation? Is it the legal implication or also the current driver we already
> have is still not fully working?
Really the former. Although I've never used the OracleAdapter attached to the bugzilla I know that some large companies
are using it happily in production. You may have to crawl through these bugs, too:

https://bugs.eclipse.org/bugs/buglist.cgi?list_id=3248878&short_desc=oracle&classification=Modeling&query_format=advanced&short_desc_type=allwordssubstr&component=cdo.core&component=cdo.dawn&component=cdo.db&component=cdo.docs&component=cdo.hibernate&component=cdo.legacy&component=cdo.net4j&component=cdo.net4j.db&component=cdo.net4j.ui&component=cdo.objy&component=cdo.releng&component=cdo.ui&product=EMF

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: [CDO] Oracle Adapter Wanted [message #947791 is a reply to message #947633] Wed, 17 October 2012 12:49 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 750
Registered: July 2009
Senior Member
You can work around the legal issue by transforming the ojdbcXXX.jar into a bundle and deploy it yourself (as part of your [enterprise] product).
Just use PDE's new wizard "Create a plug-in project from existing JAR archives."
Re: [CDO] Oracle Adapter Wanted [message #947897 is a reply to message #947791] Wed, 17 October 2012 14:52 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Am 17.10.2012 14:49, schrieb Erdal Karaca:
> You can work around the legal issue by transforming the ojdbcXXX.jar into a bundle and deploy it yourself (as part of
> your [enterprise] product).
> Just use PDE's new wizard "Create a plug-in project from existing JAR archives."
The problem for me is just that I need that bundle available in the public so that our Hudson build can insatll it and
then build our DBAdapter for it. At least for the duration of the build all related bundles are visible to the public
via Eclipse.org. I can't do that without legal backing ;-(

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: [CDO] Oracle Adapter Wanted [message #948945 is a reply to message #947897] Thu, 18 October 2012 14:38 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 750
Registered: July 2009
Senior Member
Another (really ugly) hack would be to use reflection at the locations specific to the oracle apis, so the build could succeed without the driver being on the build path.

Eike Stepper wrote on Wed, 17 October 2012 10:52
Am 17.10.2012 14:49, schrieb Erdal Karaca:
> You can work around the legal issue by transforming the ojdbcXXX.jar into a bundle and deploy it yourself (as part of
> your [enterprise] product).
> Just use PDE's new wizard "Create a plug-in project from existing JAR archives."
The problem for me is just that I need that bundle available in the public so that our Hudson build can insatll it and
then build our DBAdapter for it. At least for the duration of the build all related bundles are visible to the public
via Eclipse.org. I can't do that without legal backing ;-(

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Re: [CDO] Oracle Adapter Wanted [message #948955 is a reply to message #948945] Thu, 18 October 2012 14:43 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5545
Registered: July 2009
Senior Member
Am 18.10.2012 16:38, schrieb Erdal Karaca:
> Another (really ugly) hack would be to use reflection at the locations specific to the oracle apis, so the build could
> succeed without the driver being on the build path.
I have no clue what you mean :P

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


>
> Eike Stepper wrote on Wed, 17 October 2012 10:52
>> Am 17.10.2012 14:49, schrieb Erdal Karaca:
>> > You can work around the legal issue by transforming the ojdbcXXX.jar into a bundle and deploy it yourself (as part
>> of > your [enterprise] product).
>> > Just use PDE's new wizard "Create a plug-in project from existing JAR archives."
>> The problem for me is just that I need that bundle available in the public so that our Hudson build can insatll it
>> and then build our DBAdapter for it. At least for the duration of the build all related bundles are visible to the
>> public via Eclipse.org. I can't do that without legal backing ;-(
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>
>
Re: [CDO] Oracle Adapter Wanted [message #949713 is a reply to message #948955] Fri, 19 October 2012 08:04 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 750
Registered: July 2009
Senior Member
Smile

You wanted to talk to the Eclipse Foundation to ask Oracle... let us wait for their answer.

BTW. I remember the BIRT project had an embedded oracle jdbc driver in one of their plugins... I will ask on the BIRT forum...

Eike Stepper wrote on Thu, 18 October 2012 10:43
Am 18.10.2012 16:38, schrieb Erdal Karaca:
> Another (really ugly) hack would be to use reflection at the locations specific to the oracle apis, so the build could
> succeed without the driver being on the build path.
I have no clue what you mean Razz

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper


>
> Eike Stepper wrote on Wed, 17 October 2012 10:52
>> Am 17.10.2012 14:49, schrieb Erdal Karaca:
>> > You can work around the legal issue by transforming the ojdbcXXX.jar into a bundle and deploy it yourself (as part
>> of > your [enterprise] product).
>> > Just use PDE's new wizard "Create a plug-in project from existing JAR archives."
>> The problem for me is just that I need that bundle available in the public so that our Hudson build can insatll it
>> and then build our DBAdapter for it. At least for the duration of the build all related bundles are visible to the
>> public via Eclipse.org. I can't do that without legal backing ;-(
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>
>

Re: [CDO] Oracle Adapter Wanted [message #957611 is a reply to message #662335] Thu, 25 October 2012 11:04 Go to previous message
Silvestre Martins is currently offline Silvestre Martins
Messages: 43
Registered: July 2009
Member

During my last tests I found an issue using CDO with Oracle Adapter, when committing (the first commit from my test), I get the error: ORA-01000 maximum open cursors exceeded

The test is only to instantiate a model with many objects and complex hierarchy to setup the initial database.

The default value for the maximum open cursors in my Oracle DB was 100.
I updated then this value to 200, and then it worked.
I executed a query to check the current number of open cursors, and it was 128.
If I repeat the test then it is ok and the number of open cursors doesn't increase. I also changed the test to perform many times the same operation before committing, and the number of open cursors is stable on 128.

My question: is there a recommended minimum value for the maximum open cursors to be used with CDO? Can I expect that this value is variable and it can increase depending on the changes that I'm committing?


Thanks in advance.
Silvestre

Previous Topic:EMF Compare of combined models, comparing packages at new different levels
Next Topic:Need to modify the locking mechanism in CDO
Goto Forum:
  


Current Time: Fri Oct 24 18:48:09 GMT 2014

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

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