Home » Modeling » EMF » [CDO] How to configure cdo-server.xml to use H2
| |
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #647949 is a reply to message #647935] |
Mon, 10 January 2011 14:49   |
 Stephane Rousseau
Messages: 34
Registered: September 2010 |
Member |
|
|
Hello,
I found the answer here :
http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
It would be useful if this link is added to the CDO wiki
(http://wiki.eclipse.org/CDO).
Regards.
Stephane
On 10/01/2011 15:16, Stephane Rousseau wrote:
> This was already asked here :
> http://www.mail-archive.com/h2-database@googlegroups.com/msg 03087.html
>
> but the answer was (and is) not helpful because the stack trace in
> Eclipse doesn't change.
>
> Stephane
>
> On 10/01/2011 14:58, Stephane Rousseau wrote:
>> Hello,
>>
>> I want to use H2 instead of Derby.
>>
>> In the cdo-servel.xml, I added this code :
>> <dbAdapter name="h2"/>
>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>> url="jdbc:h2:tcp://localhost/~/test"
>> user="sa"/>
>> but I have this exception :
>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>> [90008-117]
>>
>> I can't find an example of such a config for H2. So if anybody can give
>> me one, it would be great.
>>
>> By the way, in the method DBUtil class.getDBAdapter(String adapterName),
>> the IDBAdapter.REGISTRY returns only two elements (derby-embedded and
>> h2).
>> So, I can't use the config provided in cdo-server.xml for hsqldb, mysql
>> and postgresql. I would like to know how to register a new element.
>>
>> Regards.
>>
>> Stephane Rousseau
>
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #647950 is a reply to message #647932] |
Mon, 10 January 2011 14:48 |
|
Am 10.01.2011 14:58, schrieb Stephane Rousseau:
> Hello,
>
> I want to use H2 instead of Derby.
Yeah, we've also changed our default to H2 years ago:
<dbAdapter name="h2"/>
<dataSource class="org.h2.jdbcx.JdbcDataSource"
uRL="jdbc:h2:_database/repo1"/>
>
> In the cdo-servel.xml, I added this code :
> <dbAdapter name="h2"/>
> <dataSource class="org.h2.jdbcx.JdbcDataSource"
> url="jdbc:h2:tcp://localhost/~/test"
For some reason I can not remember it's important that you write "uRL=". Must be somehow related to reflection as the Datasource's setter is setURL().
> user="sa"/>
> but I have this exception :
> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url [90008-117]
>
> I can't find an example of such a config for H2. So if anybody can give me one, it would be great.
>
> By the way, in the method DBUtil class.getDBAdapter(String adapterName), the IDBAdapter.REGISTRY returns only two elements (derby-embedded and h2).
> So, I can't use the config provided in cdo-server.xml for hsqldb, mysql and postgresql. I would like to know how to register a new element.
We have some other DB adapters, as well:
/org.eclipse.net4j.db.hsqldb
/org.eclipse.net4j.db.mysql
/org.eclipse.net4j.db.postgresql
And there's even a DB2 adapter in CVS.
For all adapters except Derby and H2 you need the underlying driver bundles installed before you install our adapter plugins. See http://net4j.sourceforge.net/update/ and http://www.eclipse.org/cdo/downloads/updates.php
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #647951 is a reply to message #647949] |
Mon, 10 January 2011 14:53 |
|
Am 10.01.2011 15:49, schrieb Stephane Rousseau:
> Hello,
>
> I found the answer here :
> http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
>
> It would be useful if this link is added to the CDO wiki (http://wiki.eclipse.org/CDO).
I *think* it's superceded by http://wiki.eclipse.org/Getting_started_with_CDO_Helios which is the first link in our Tutorials section: http://wiki.eclipse.org/CDO/User_Contributed_Documentation#T utorials
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
>
> Regards.
>
> Stephane
>
> On 10/01/2011 15:16, Stephane Rousseau wrote:
>> This was already asked here :
>> http://www.mail-archive.com/h2-database@googlegroups.com/msg 03087.html
>>
>> but the answer was (and is) not helpful because the stack trace in
>> Eclipse doesn't change.
>>
>> Stephane
>>
>> On 10/01/2011 14:58, Stephane Rousseau wrote:
>>> Hello,
>>>
>>> I want to use H2 instead of Derby.
>>>
>>> In the cdo-servel.xml, I added this code :
>>> <dbAdapter name="h2"/>
>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>> url="jdbc:h2:tcp://localhost/~/test"
>>> user="sa"/>
>>> but I have this exception :
>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>> [90008-117]
>>>
>>> I can't find an example of such a config for H2. So if anybody can give
>>> me one, it would be great.
>>>
>>> By the way, in the method DBUtil class.getDBAdapter(String adapterName),
>>> the IDBAdapter.REGISTRY returns only two elements (derby-embedded and
>>> h2).
>>> So, I can't use the config provided in cdo-server.xml for hsqldb, mysql
>>> and postgresql. I would like to know how to register a new element.
>>>
>>> Regards.
>>>
>>> Stephane Rousseau
>>
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #647973 is a reply to message #647951] |
Mon, 10 January 2011 15:40 |
Stephane Rousseau
Messages: 34
Registered: September 2010 |
Member |
|
|
May be this page
(http://wiki.eclipse.org/CDO/Server_Configuration_Reference) should be
updated to add H2 parameters as it is written in
http://wiki.eclipse.org/Getting_started_with_CDO_Helios
This is because I'm using http://wiki.eclipse.org/CDO/ as a portal. May
be I should not.
Regards,
Stephane
On 10/01/2011 15:53, Eike Stepper wrote:
> Am 10.01.2011 15:49, schrieb Stephane Rousseau:
>> Hello,
>>
>> I found the answer here :
>> http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
>>
>> It would be useful if this link is added to the CDO wiki
>> (http://wiki.eclipse.org/CDO).
> I *think* it's superceded by
> http://wiki.eclipse.org/Getting_started_with_CDO_Helios which is the
> first link in our Tutorials section:
> http://wiki.eclipse.org/CDO/User_Contributed_Documentation#T utorials
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>>
>> Regards.
>>
>> Stephane
>>
>> On 10/01/2011 15:16, Stephane Rousseau wrote:
>>> This was already asked here :
>>> http://www.mail-archive.com/h2-database@googlegroups.com/msg 03087.html
>>>
>>> but the answer was (and is) not helpful because the stack trace in
>>> Eclipse doesn't change.
>>>
>>> Stephane
>>>
>>> On 10/01/2011 14:58, Stephane Rousseau wrote:
>>>> Hello,
>>>>
>>>> I want to use H2 instead of Derby.
>>>>
>>>> In the cdo-servel.xml, I added this code :
>>>> <dbAdapter name="h2"/>
>>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>>> url="jdbc:h2:tcp://localhost/~/test"
>>>> user="sa"/>
>>>> but I have this exception :
>>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>>> [90008-117]
>>>>
>>>> I can't find an example of such a config for H2. So if anybody can give
>>>> me one, it would be great.
>>>>
>>>> By the way, in the method DBUtil class.getDBAdapter(String
>>>> adapterName),
>>>> the IDBAdapter.REGISTRY returns only two elements (derby-embedded and
>>>> h2).
>>>> So, I can't use the config provided in cdo-server.xml for hsqldb, mysql
>>>> and postgresql. I would like to know how to register a new element.
>>>>
>>>> Regards.
>>>>
>>>> Stephane Rousseau
>>>
>>
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #647992 is a reply to message #647950] |
Mon, 10 January 2011 17:15 |
Stephane Rousseau
Messages: 34
Registered: September 2010 |
Member |
|
|
I'm back with another problem.
In the Indigo update site (Indigo -
http://download.eclipse.org/releases/indigo), I can't find the mysql
adapter. It shows me only Derby and H2 adapters.
Did I miss sommething or does my CDO version (4.0.0.v20101214-0950) not
up-to-date ? I can't load 4.0 milestone builds or 4.0 integration builds
at http://www.eclipse.org/cdo/downloads/updates.php I have Error 404...
Regards,
Stephane
On 10/01/2011 15:48, Eike Stepper wrote:
> Am 10.01.2011 14:58, schrieb Stephane Rousseau:
>> Hello,
>>
>> I want to use H2 instead of Derby.
> Yeah, we've also changed our default to H2 years ago:
>
> <dbAdapter name="h2"/>
> <dataSource class="org.h2.jdbcx.JdbcDataSource"
> uRL="jdbc:h2:_database/repo1"/>
>
>
>>
>> In the cdo-servel.xml, I added this code :
>> <dbAdapter name="h2"/>
>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>> url="jdbc:h2:tcp://localhost/~/test"
> For some reason I can not remember it's important that you write "uRL=".
> Must be somehow related to reflection as the Datasource's setter is
> setURL().
>
>> user="sa"/>
>> but I have this exception :
>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>> [90008-117]
>>
>> I can't find an example of such a config for H2. So if anybody can
>> give me one, it would be great.
>>
>> By the way, in the method DBUtil class.getDBAdapter(String
>> adapterName), the IDBAdapter.REGISTRY returns only two elements
>> (derby-embedded and h2).
>> So, I can't use the config provided in cdo-server.xml for hsqldb,
>> mysql and postgresql. I would like to know how to register a new element.
> We have some other DB adapters, as well:
>
> /org.eclipse.net4j.db.hsqldb
> /org.eclipse.net4j.db.mysql
> /org.eclipse.net4j.db.postgresql
>
> And there's even a DB2 adapter in CVS.
>
> For all adapters except Derby and H2 you need the underlying driver
> bundles installed before you install our adapter plugins. See
> http://net4j.sourceforge.net/update/ and
> http://www.eclipse.org/cdo/downloads/updates.php
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #648085 is a reply to message #647973] |
Tue, 11 January 2011 08:01 |
|
Am 10.01.2011 16:40, schrieb Stephane Rousseau:
> May be this page (http://wiki.eclipse.org/CDO/Server_Configuration_Reference) should be updated to add H2 parameters as it is written in http://wiki.eclipse.org/Getting_started_with_CDO_Helios
Done.
>
> This is because I'm using http://wiki.eclipse.org/CDO/ as a portal. May be I should not.
You can. And it is a wiki. That means everybody is invited to help to fill it and keep it up to date. The more the community steps in to help with things they can accomplish we the more features we can add for you, the more bugs we can fix for you, the more time we can invest to provide you with frequent builds, etc.
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
>
> Regards,
>
> Stephane
>
> On 10/01/2011 15:53, Eike Stepper wrote:
>> Am 10.01.2011 15:49, schrieb Stephane Rousseau:
>>> Hello,
>>>
>>> I found the answer here :
>>> http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
>>>
>>> It would be useful if this link is added to the CDO wiki
>>> (http://wiki.eclipse.org/CDO).
>> I *think* it's superceded by
>> http://wiki.eclipse.org/Getting_started_with_CDO_Helios which is the
>> first link in our Tutorials section:
>> http://wiki.eclipse.org/CDO/User_Contributed_Documentation#T utorials
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>>
>>> Regards.
>>>
>>> Stephane
>>>
>>> On 10/01/2011 15:16, Stephane Rousseau wrote:
>>>> This was already asked here :
>>>> http://www.mail-archive.com/h2-database@googlegroups.com/msg 03087.html
>>>>
>>>> but the answer was (and is) not helpful because the stack trace in
>>>> Eclipse doesn't change.
>>>>
>>>> Stephane
>>>>
>>>> On 10/01/2011 14:58, Stephane Rousseau wrote:
>>>>> Hello,
>>>>>
>>>>> I want to use H2 instead of Derby.
>>>>>
>>>>> In the cdo-servel.xml, I added this code :
>>>>> <dbAdapter name="h2"/>
>>>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>>>> url="jdbc:h2:tcp://localhost/~/test"
>>>>> user="sa"/>
>>>>> but I have this exception :
>>>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>>>> [90008-117]
>>>>>
>>>>> I can't find an example of such a config for H2. So if anybody can give
>>>>> me one, it would be great.
>>>>>
>>>>> By the way, in the method DBUtil class.getDBAdapter(String
>>>>> adapterName),
>>>>> the IDBAdapter.REGISTRY returns only two elements (derby-embedded and
>>>>> h2).
>>>>> So, I can't use the config provided in cdo-server.xml for hsqldb, mysql
>>>>> and postgresql. I would like to know how to register a new element.
>>>>>
>>>>> Regards.
>>>>>
>>>>> Stephane Rousseau
>>>>
>>>
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #648097 is a reply to message #647992] |
Tue, 11 January 2011 08:08 |
|
Am 10.01.2011 18:15, schrieb Stephane Rousseau:
> I'm back with another problem.
>
> In the Indigo update site (Indigo - http://download.eclipse.org/releases/indigo), I can't find the mysql adapter. It shows me only Derby and H2 adapters.
That's because we're not allowed to contribute anything to the release train that has non-optional dependencies on anything outside the train repo.
>
> Did I miss sommething or does my CDO version (4.0.0.v20101214-0950) not up-to-date ? I can't load 4.0 milestone builds or 4.0 integration builds at http://www.eclipse.org/cdo/downloads/updates.php I have Error 404...
What is 404?
You need to have access to the URLs listed in http://www.eclipse.org/cdo/downloads/updates.php in order to install any of the features we may not contribute to Indigo. For some features with non-Eclipse dependencies you may even need to install drivers from http://net4j.sourceforge.net/update/ before.
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
>
> Regards,
>
> Stephane
>
>
> On 10/01/2011 15:48, Eike Stepper wrote:
>> Am 10.01.2011 14:58, schrieb Stephane Rousseau:
>>> Hello,
>>>
>>> I want to use H2 instead of Derby.
>> Yeah, we've also changed our default to H2 years ago:
>>
>> <dbAdapter name="h2"/>
>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>> uRL="jdbc:h2:_database/repo1"/>
>>
>>
>>>
>>> In the cdo-servel.xml, I added this code :
>>> <dbAdapter name="h2"/>
>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>> url="jdbc:h2:tcp://localhost/~/test"
>> For some reason I can not remember it's important that you write "uRL=".
>> Must be somehow related to reflection as the Datasource's setter is
>> setURL().
>>
>>> user="sa"/>
>>> but I have this exception :
>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>> [90008-117]
>>>
>>> I can't find an example of such a config for H2. So if anybody can
>>> give me one, it would be great.
>>>
>>> By the way, in the method DBUtil class.getDBAdapter(String
>>> adapterName), the IDBAdapter.REGISTRY returns only two elements
>>> (derby-embedded and h2).
>>> So, I can't use the config provided in cdo-server.xml for hsqldb,
>>> mysql and postgresql. I would like to know how to register a new element.
>> We have some other DB adapters, as well:
>>
>> /org.eclipse.net4j.db.hsqldb
>> /org.eclipse.net4j.db.mysql
>> /org.eclipse.net4j.db.postgresql
>>
>> And there's even a DB2 adapter in CVS.
>>
>> For all adapters except Derby and H2 you need the underlying driver
>> bundles installed before you install our adapter plugins. See
>> http://net4j.sourceforge.net/update/ and
>> http://www.eclipse.org/cdo/downloads/updates.php
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #648098 is a reply to message #648097] |
Tue, 11 January 2011 08:36 |
Stephane Rousseau
Messages: 34
Registered: September 2010 |
Member |
|
|
Hello,
It's the 404 HTTP unknown page error.
Here is the 404 error text :
Not Found
We're sorry, the page or file cannot be found. Here are some reasons why:
* This is an Eclipse Update site/p2 repository; you must access it
from Eclipse (see how).
* A file may have moved to the archives. You can try the link below:
http://archive.eclipse.org/modeling/emf/cdo/updates/4.0-mile stones/
* Your file was part of a Nighly build which is no longer there.
Simply download the latest version.
* The project is uploading a new build, and this file is not there
yet. Try again later.
I will use the last stable build version.
Regards,
Stephane
On 11/01/2011 09:08, Eike Stepper wrote:
> Am 10.01.2011 18:15, schrieb Stephane Rousseau:
>> I'm back with another problem.
>>
>> In the Indigo update site (Indigo -
>> http://download.eclipse.org/releases/indigo), I can't find the mysql
>> adapter. It shows me only Derby and H2 adapters.
> That's because we're not allowed to contribute anything to the release
> train that has non-optional dependencies on anything outside the train
> repo.
>
>>
>> Did I miss sommething or does my CDO version (4.0.0.v20101214-0950)
>> not up-to-date ? I can't load 4.0 milestone builds or 4.0 integration
>> builds at http://www.eclipse.org/cdo/downloads/updates.php I have
>> Error 404...
> What is 404?
>
> You need to have access to the URLs listed in
> http://www.eclipse.org/cdo/downloads/updates.php in order to install any
> of the features we may not contribute to Indigo. For some features with
> non-Eclipse dependencies you may even need to install drivers from
> http://net4j.sourceforge.net/update/ before.
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>>
>> Regards,
>>
>> Stephane
>>
>>
>> On 10/01/2011 15:48, Eike Stepper wrote:
>>> Am 10.01.2011 14:58, schrieb Stephane Rousseau:
>>>> Hello,
>>>>
>>>> I want to use H2 instead of Derby.
>>> Yeah, we've also changed our default to H2 years ago:
>>>
>>> <dbAdapter name="h2"/>
>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>> uRL="jdbc:h2:_database/repo1"/>
>>>
>>>
>>>>
>>>> In the cdo-servel.xml, I added this code :
>>>> <dbAdapter name="h2"/>
>>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>>> url="jdbc:h2:tcp://localhost/~/test"
>>> For some reason I can not remember it's important that you write "uRL=".
>>> Must be somehow related to reflection as the Datasource's setter is
>>> setURL().
>>>
>>>> user="sa"/>
>>>> but I have this exception :
>>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>>> [90008-117]
>>>>
>>>> I can't find an example of such a config for H2. So if anybody can
>>>> give me one, it would be great.
>>>>
>>>> By the way, in the method DBUtil class.getDBAdapter(String
>>>> adapterName), the IDBAdapter.REGISTRY returns only two elements
>>>> (derby-embedded and h2).
>>>> So, I can't use the config provided in cdo-server.xml for hsqldb,
>>>> mysql and postgresql. I would like to know how to register a new
>>>> element.
>>> We have some other DB adapters, as well:
>>>
>>> /org.eclipse.net4j.db.hsqldb
>>> /org.eclipse.net4j.db.mysql
>>> /org.eclipse.net4j.db.postgresql
>>>
>>> And there's even a DB2 adapter in CVS.
>>>
>>> For all adapters except Derby and H2 you need the underlying driver
>>> bundles installed before you install our adapter plugins. See
>>> http://net4j.sourceforge.net/update/ and
>>> http://www.eclipse.org/cdo/downloads/updates.php
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://www.esc-net.de
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>>
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #648099 is a reply to message #648085] |
Tue, 11 January 2011 08:41 |
Stephane Rousseau
Messages: 34
Registered: September 2010 |
Member |
|
|
Hello,
I started using Eclipse and CDO less than 6 months ago. So I'm a
beginner who can't help you to write code or doc but who can only help
you to update the doc because I try to follow wiki and tutorials.
Regards
Stephane
On 11/01/2011 09:01, Eike Stepper wrote:
> Am 10.01.2011 16:40, schrieb Stephane Rousseau:
>> May be this page
>> (http://wiki.eclipse.org/CDO/Server_Configuration_Reference) should be
>> updated to add H2 parameters as it is written in
>> http://wiki.eclipse.org/Getting_started_with_CDO_Helios
> Done.
>
>>
>> This is because I'm using http://wiki.eclipse.org/CDO/ as a portal.
>> May be I should not.
> You can. And it is a wiki. That means everybody is invited to help to
> fill it and keep it up to date. The more the community steps in to help
> with things they can accomplish we the more features we can add for you,
> the more bugs we can fix for you, the more time we can invest to provide
> you with frequent builds, etc.
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>>
>> Regards,
>>
>> Stephane
>>
>> On 10/01/2011 15:53, Eike Stepper wrote:
>>> Am 10.01.2011 15:49, schrieb Stephane Rousseau:
>>>> Hello,
>>>>
>>>> I found the answer here :
>>>> http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
>>>>
>>>> It would be useful if this link is added to the CDO wiki
>>>> (http://wiki.eclipse.org/CDO).
>>> I *think* it's superceded by
>>> http://wiki.eclipse.org/Getting_started_with_CDO_Helios which is the
>>> first link in our Tutorials section:
>>> http://wiki.eclipse.org/CDO/User_Contributed_Documentation#T utorials
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://www.esc-net.de
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>>>>
>>>> Regards.
>>>>
>>>> Stephane
>>>>
>>>> On 10/01/2011 15:16, Stephane Rousseau wrote:
>>>>> This was already asked here :
>>>>> http://www.mail-archive.com/h2-database@googlegroups.com/msg 03087.html
>>>>>
>>>>> but the answer was (and is) not helpful because the stack trace in
>>>>> Eclipse doesn't change.
>>>>>
>>>>> Stephane
>>>>>
>>>>> On 10/01/2011 14:58, Stephane Rousseau wrote:
>>>>>> Hello,
>>>>>>
>>>>>> I want to use H2 instead of Derby.
>>>>>>
>>>>>> In the cdo-servel.xml, I added this code :
>>>>>> <dbAdapter name="h2"/>
>>>>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>>>>> url="jdbc:h2:tcp://localhost/~/test"
>>>>>> user="sa"/>
>>>>>> but I have this exception :
>>>>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>>>>> [90008-117]
>>>>>>
>>>>>> I can't find an example of such a config for H2. So if anybody can
>>>>>> give
>>>>>> me one, it would be great.
>>>>>>
>>>>>> By the way, in the method DBUtil class.getDBAdapter(String
>>>>>> adapterName),
>>>>>> the IDBAdapter.REGISTRY returns only two elements (derby-embedded and
>>>>>> h2).
>>>>>> So, I can't use the config provided in cdo-server.xml for hsqldb,
>>>>>> mysql
>>>>>> and postgresql. I would like to know how to register a new element.
>>>>>>
>>>>>> Regards.
>>>>>>
>>>>>> Stephane Rousseau
>>>>>
>>>>
>>
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #648102 is a reply to message #648098] |
Tue, 11 January 2011 08:59 |
|
Am 11.01.2011 09:36, schrieb Stephane Rousseau:
> Hello,
>
> It's the 404 HTTP unknown page error.
Are you getting this for our update.php *info* page?
Or if you point your web browser to one of the p2 URLs?
The latter is not supposed to deliver an HTML page if it's a composite repo. Our build generates static HTML pages for each single build, though. Like https://hudson.eclipse.org/hudson/job/emf-cdo-integration/la stStableBuild/artifact/result/site.p2/index.html
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
>
> Here is the 404 error text :
>
> Not Found
>
> We're sorry, the page or file cannot be found. Here are some reasons why:
>
> * This is an Eclipse Update site/p2 repository; you must access it from Eclipse (see how).
> * A file may have moved to the archives. You can try the link below:
> http://archive.eclipse.org/modeling/emf/cdo/updates/4.0-mile stones/
> * Your file was part of a Nighly build which is no longer there. Simply download the latest version.
> * The project is uploading a new build, and this file is not there yet. Try again later.
>
> I will use the last stable build version.
>
> Regards,
>
> Stephane
>
> On 11/01/2011 09:08, Eike Stepper wrote:
>> Am 10.01.2011 18:15, schrieb Stephane Rousseau:
>>> I'm back with another problem.
>>>
>>> In the Indigo update site (Indigo -
>>> http://download.eclipse.org/releases/indigo), I can't find the mysql
>>> adapter. It shows me only Derby and H2 adapters.
>> That's because we're not allowed to contribute anything to the release
>> train that has non-optional dependencies on anything outside the train
>> repo.
>>
>>>
>>> Did I miss sommething or does my CDO version (4.0.0.v20101214-0950)
>>> not up-to-date ? I can't load 4.0 milestone builds or 4.0 integration
>>> builds at http://www.eclipse.org/cdo/downloads/updates.php I have
>>> Error 404...
>> What is 404?
>>
>> You need to have access to the URLs listed in
>> http://www.eclipse.org/cdo/downloads/updates.php in order to install any
>> of the features we may not contribute to Indigo. For some features with
>> non-Eclipse dependencies you may even need to install drivers from
>> http://net4j.sourceforge.net/update/ before.
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>>
>>> Regards,
>>>
>>> Stephane
>>>
>>>
>>> On 10/01/2011 15:48, Eike Stepper wrote:
>>>> Am 10.01.2011 14:58, schrieb Stephane Rousseau:
>>>>> Hello,
>>>>>
>>>>> I want to use H2 instead of Derby.
>>>> Yeah, we've also changed our default to H2 years ago:
>>>>
>>>> <dbAdapter name="h2"/>
>>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>>> uRL="jdbc:h2:_database/repo1"/>
>>>>
>>>>
>>>>>
>>>>> In the cdo-servel.xml, I added this code :
>>>>> <dbAdapter name="h2"/>
>>>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>>>> url="jdbc:h2:tcp://localhost/~/test"
>>>> For some reason I can not remember it's important that you write "uRL=".
>>>> Must be somehow related to reflection as the Datasource's setter is
>>>> setURL().
>>>>
>>>>> user="sa"/>
>>>>> but I have this exception :
>>>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>>>> [90008-117]
>>>>>
>>>>> I can't find an example of such a config for H2. So if anybody can
>>>>> give me one, it would be great.
>>>>>
>>>>> By the way, in the method DBUtil class.getDBAdapter(String
>>>>> adapterName), the IDBAdapter.REGISTRY returns only two elements
>>>>> (derby-embedded and h2).
>>>>> So, I can't use the config provided in cdo-server.xml for hsqldb,
>>>>> mysql and postgresql. I would like to know how to register a new
>>>>> element.
>>>> We have some other DB adapters, as well:
>>>>
>>>> /org.eclipse.net4j.db.hsqldb
>>>> /org.eclipse.net4j.db.mysql
>>>> /org.eclipse.net4j.db.postgresql
>>>>
>>>> And there's even a DB2 adapter in CVS.
>>>>
>>>> For all adapters except Derby and H2 you need the underlying driver
>>>> bundles installed before you install our adapter plugins. See
>>>> http://net4j.sourceforge.net/update/ and
>>>> http://www.eclipse.org/cdo/downloads/updates.php
>>>>
>>>> Cheers
>>>> /Eike
>>>>
>>>> ----
>>>> http://www.esc-net.de
>>>> http://thegordian.blogspot.com
>>>> http://twitter.com/eikestepper
>>>>
>>>>
>>>
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
| Re: [CDO] How to configure cdo-server.xml to use H2 [message #648103 is a reply to message #648099] |
Tue, 11 January 2011 08:59 |
|
Am 11.01.2011 09:41, schrieb Stephane Rousseau:
> Hello,
>
> I started using Eclipse and CDO less than 6 months ago. So I'm a beginner who can't help you to write code or doc but who can only help you to update the doc because I try to follow wiki and tutorials.
That's already more than nothing ;-)
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
>
> Regards
>
> Stephane
>
> On 11/01/2011 09:01, Eike Stepper wrote:
>> Am 10.01.2011 16:40, schrieb Stephane Rousseau:
>>> May be this page
>>> (http://wiki.eclipse.org/CDO/Server_Configuration_Reference) should be
>>> updated to add H2 parameters as it is written in
>>> http://wiki.eclipse.org/Getting_started_with_CDO_Helios
>> Done.
>>
>>>
>>> This is because I'm using http://wiki.eclipse.org/CDO/ as a portal.
>>> May be I should not.
>> You can. And it is a wiki. That means everybody is invited to help to
>> fill it and keep it up to date. The more the community steps in to help
>> with things they can accomplish we the more features we can add for you,
>> the more bugs we can fix for you, the more time we can invest to provide
>> you with frequent builds, etc.
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>>
>>> Regards,
>>>
>>> Stephane
>>>
>>> On 10/01/2011 15:53, Eike Stepper wrote:
>>>> Am 10.01.2011 15:49, schrieb Stephane Rousseau:
>>>>> Hello,
>>>>>
>>>>> I found the answer here :
>>>>> http://wiki.eclipse.org/Getting_started_with_CDO_Galileo
>>>>>
>>>>> It would be useful if this link is added to the CDO wiki
>>>>> (http://wiki.eclipse.org/CDO).
>>>> I *think* it's superceded by
>>>> http://wiki.eclipse.org/Getting_started_with_CDO_Helios which is the
>>>> first link in our Tutorials section:
>>>> http://wiki.eclipse.org/CDO/User_Contributed_Documentation#T utorials
>>>>
>>>> Cheers
>>>> /Eike
>>>>
>>>> ----
>>>> http://www.esc-net.de
>>>> http://thegordian.blogspot.com
>>>> http://twitter.com/eikestepper
>>>>
>>>>
>>>>>
>>>>> Regards.
>>>>>
>>>>> Stephane
>>>>>
>>>>> On 10/01/2011 15:16, Stephane Rousseau wrote:
>>>>>> This was already asked here :
>>>>>> http://www.mail-archive.com/h2-database@googlegroups.com/msg 03087.html
>>>>>>
>>>>>> but the answer was (and is) not helpful because the stack trace in
>>>>>> Eclipse doesn't change.
>>>>>>
>>>>>> Stephane
>>>>>>
>>>>>> On 10/01/2011 14:58, Stephane Rousseau wrote:
>>>>>>> Hello,
>>>>>>>
>>>>>>> I want to use H2 instead of Derby.
>>>>>>>
>>>>>>> In the cdo-servel.xml, I added this code :
>>>>>>> <dbAdapter name="h2"/>
>>>>>>> <dataSource class="org.h2.jdbcx.JdbcDataSource"
>>>>>>> url="jdbc:h2:tcp://localhost/~/test"
>>>>>>> user="sa"/>
>>>>>>> but I have this exception :
>>>>>>> [ERROR] org.h2.jdbc.JdbcSQLException: Invalid value for parameter url
>>>>>>> [90008-117]
>>>>>>>
>>>>>>> I can't find an example of such a config for H2. So if anybody can
>>>>>>> give
>>>>>>> me one, it would be great.
>>>>>>>
>>>>>>> By the way, in the method DBUtil class.getDBAdapter(String
>>>>>>> adapterName),
>>>>>>> the IDBAdapter.REGISTRY returns only two elements (derby-embedded and
>>>>>>> h2).
>>>>>>> So, I can't use the config provided in cdo-server.xml for hsqldb,
>>>>>>> mysql
>>>>>>> and postgresql. I would like to know how to register a new element.
>>>>>>>
>>>>>>> Regards.
>>>>>>>
>>>>>>> Stephane Rousseau
>>>>>>
>>>>>
>>>
>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Goto Forum:
Current Time: Thu Sep 19 18:30:15 GMT 2024
Powered by FUDForum. Page generated in 0.06197 seconds |
] 
Search
Help
Register
Login
Home
