Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » CDO server with Microsoft sql server
CDO server with Microsoft sql server [message #998029] Wed, 09 January 2013 08:18 Go to next message
Alex Mising name is currently offline Alex Mising name
Messages: 61
Registered: February 2011
Member
I'm creating cdo-server.xml file for Microsoft sql server:

<repository name="demo">

<store type="db">
<mappingStrategy type="horizontal"/>
<dbAdapter name="???"/>
<dataSource
class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://servername;databaseName=dbname"
user="user"
password="psw"
/>
</store>
</repository>

what dbAdapter name should I use?
Re: CDO server with Microsoft sql server [message #998079 is a reply to message #998029] Wed, 09 January 2013 10:36 Go to previous messageGo to next message
Erdal Karaca is currently offline Erdal Karaca
Messages: 745
Registered: July 2009
Senior Member
There is no db adapter for ms sql server.
You can try the hibernate store which provides many RDBMSs or you can implement a new db adapter to support ms sql server.

Alex Mising name wrote on Wed, 09 January 2013 09:18
I'm creating cdo-server.xml file for Microsoft sql server:

<repository name="demo">

<store type="db">
<mappingStrategy type="horizontal"/>
<dbAdapter name="???"/>
<dataSource
class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://servername;databaseName=dbname"
user="user"
password="psw"
/>
</store>
</repository>

what dbAdapter name should I use?

Re: CDO server with Microsoft sql server [message #998124 is a reply to message #998029] Wed, 09 January 2013 12:16 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Am 09.01.2013 09:18, schrieb Alex Mising name:
> I'm creating cdo-server.xml file for Microsoft sql server:
>
> <repository name="demo">
>
> <store type="db">
> <mappingStrategy type="horizontal"/>
> <dbAdapter name="???"/>
> <dataSource
> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> url="jdbc:sqlserver://servername;databaseName=dbname"
> user="user"
> password="psw"
> />
> </store>
> </repository>
>
> what dbAdapter name should I use?
As Erdal already said, we haven't got a DBAdapter for Microsoft, yet. But we'd certainly be interested in respective
contributions. If you have a look at the other DBAdapters you'll notice that they're comparingly small and simple.

Is there an OSGi bundle with the JDBC driver available on the net?

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: CDO server with Microsoft sql server [message #998130 is a reply to message #998124] Wed, 09 January 2013 12:26 Go to previous messageGo to next message
Christophe Bouhier is currently offline Christophe Bouhier
Messages: 921
Registered: July 2009
Senior Member
this seems to work with Hibernate:

http://jtds.sourceforge.net/
Re: CDO server with Microsoft sql server [message #998136 is a reply to message #998124] Wed, 09 January 2013 12:30 Go to previous messageGo to next message
Thomas Schindl is currently offline Thomas Schindl
Messages: 5331
Registered: July 2009
Senior Member
Hi,

We have implemented a MS-SQL-Adapter sometime ago and use it
successfully in production since about 6 months.

Let me see how we can make it available to you.

Tom

Am 09.01.13 13:16, schrieb Eike Stepper:
> Am 09.01.2013 09:18, schrieb Alex Mising name:
>> I'm creating cdo-server.xml file for Microsoft sql server:
>>
>> <repository name="demo">
>>
>> <store type="db">
>> <mappingStrategy type="horizontal"/>
>> <dbAdapter name="???"/>
>> <dataSource
>> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>> url="jdbc:sqlserver://servername;databaseName=dbname"
>> user="user"
>> password="psw"
>> />
>> </store>
>> </repository>
>>
>> what dbAdapter name should I use?
> As Erdal already said, we haven't got a DBAdapter for Microsoft, yet.
> But we'd certainly be interested in respective contributions. If you
> have a look at the other DBAdapters you'll notice that they're
> comparingly small and simple.
>
> Is there an OSGi bundle with the JDBC driver available on the net?
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
Re: CDO server with Microsoft sql server [message #998150 is a reply to message #998130] Wed, 09 January 2013 12:52 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Am 09.01.2013 13:26, schrieb Christophe Bouhier:
> this seems to work with Hibernate:
> http://jtds.sourceforge.net/
Interesting. No linux support, it seems.

The one from Microsoft doesn't seem to be the primary choice for production but I'd only need something to build against.

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Re: CDO server with Microsoft sql server [message #998151 is a reply to message #998136] Wed, 09 January 2013 12:52 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Am 09.01.2013 13:30, schrieb Tom Schindl:
> Hi,
>
> We have implemented a MS-SQL-Adapter sometime ago and use it
> successfully in production since about 6 months.
>
> Let me see how we can make it available to you.
Wow, that'd be cool!

Cheers
/Eike

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


>
> Tom
>
> Am 09.01.13 13:16, schrieb Eike Stepper:
>> Am 09.01.2013 09:18, schrieb Alex Mising name:
>>> I'm creating cdo-server.xml file for Microsoft sql server:
>>>
>>> <repository name="demo">
>>>
>>> <store type="db">
>>> <mappingStrategy type="horizontal"/>
>>> <dbAdapter name="???"/>
>>> <dataSource
>>> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>> url="jdbc:sqlserver://servername;databaseName=dbname"
>>> user="user"
>>> password="psw"
>>> />
>>> </store>
>>> </repository>
>>>
>>> what dbAdapter name should I use?
>> As Erdal already said, we haven't got a DBAdapter for Microsoft, yet.
>> But we'd certainly be interested in respective contributions. If you
>> have a look at the other DBAdapters you'll notice that they're
>> comparingly small and simple.
>>
>> Is there an OSGi bundle with the JDBC driver available on the net?
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
Re: CDO server with Microsoft sql server [message #998168 is a reply to message #998136] Wed, 09 January 2013 13:35 Go to previous messageGo to next message
Alex Mising name is currently offline Alex Mising name
Messages: 61
Registered: February 2011
Member
Am 09.01.2013 13:30, schrieb Tom Schindl:
> Hi,
>
> We have implemented a MS-SQL-Adapter sometime ago and use it
> successfully in production since about 6 months.
>
> Let me see how we can make it available to you.

Yes, that'd be cool!

[Updated on: Wed, 09 January 2013 13:36]

Report message to a moderator

Re: CDO server with Microsoft sql server [message #998288 is a reply to message #998151] Wed, 09 January 2013 18:20 Go to previous messageGo to next message
Thomas Schindl is currently offline Thomas Schindl
Messages: 5331
Registered: July 2009
Senior Member
Hi,

here we go. I've published our code including JDTS Driver on our github
account [1], created a build and published an update-site [2], we are
using CDO inside tomcat (=without OSGi) so please report if you have
problems with it.

If you look at the code you'll notice it is not really rocket sience ;-)

Please note we've hardcoded the Blob size currently so that it suites
our needs, maybe we should add a config option for this using
-Dcdo.mssql.blobsize=... but patches are welcome.

The license is LPGL because JDTS is LGPL!

I hope this helps.

Tom

[1] https://github.com/BestSolution-at/cdo-mssqladapter
[2]
http://foss.bestsolution.at/downloads/cdo-mssqladapter/p2-repos/nightly/site/



Am 09.01.13 13:52, schrieb Eike Stepper:
> Am 09.01.2013 13:30, schrieb Tom Schindl:
>> Hi,
>>
>> We have implemented a MS-SQL-Adapter sometime ago and use it
>> successfully in production since about 6 months.
>>
>> Let me see how we can make it available to you.
> Wow, that'd be cool!
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>>
>> Tom
>>
>> Am 09.01.13 13:16, schrieb Eike Stepper:
>>> Am 09.01.2013 09:18, schrieb Alex Mising name:
>>>> I'm creating cdo-server.xml file for Microsoft sql server:
>>>>
>>>> <repository name="demo">
>>>>
>>>> <store type="db">
>>>> <mappingStrategy type="horizontal"/>
>>>> <dbAdapter name="???"/>
>>>> <dataSource
>>>> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>> url="jdbc:sqlserver://servername;databaseName=dbname"
>>>> user="user"
>>>> password="psw"
>>>> />
>>>> </store>
>>>> </repository>
>>>>
>>>> what dbAdapter name should I use?
>>> As Erdal already said, we haven't got a DBAdapter for Microsoft, yet.
>>> But we'd certainly be interested in respective contributions. If you
>>> have a look at the other DBAdapters you'll notice that they're
>>> comparingly small and simple.
>>>
>>> Is there an OSGi bundle with the JDBC driver available on the net?
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://www.esc-net.de
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>
Re: CDO server with Microsoft sql server [message #1000667 is a reply to message #998288] Tue, 15 January 2013 08:00 Go to previous messageGo to next message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Hi Tom,

That's great! I wonder if we could ship that DBAdapter with CDO?

Martin, do you think you could host the driver bundle on http://www.elver.org/eclipse/2.0.0/update ?

Cheers
/Eike

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



Am 09.01.2013 19:20, schrieb Tom Schindl:
> Hi,
>
> here we go. I've published our code including JDTS Driver on our github
> account [1], created a build and published an update-site [2], we are
> using CDO inside tomcat (=without OSGi) so please report if you have
> problems with it.
>
> If you look at the code you'll notice it is not really rocket sience ;-)
>
> Please note we've hardcoded the Blob size currently so that it suites
> our needs, maybe we should add a config option for this using
> -Dcdo.mssql.blobsize=... but patches are welcome.
>
> The license is LPGL because JDTS is LGPL!
>
> I hope this helps.
>
> Tom
>
> [1] https://github.com/BestSolution-at/cdo-mssqladapter
> [2]
> http://foss.bestsolution.at/downloads/cdo-mssqladapter/p2-repos/nightly/site/
>
>
>
> Am 09.01.13 13:52, schrieb Eike Stepper:
>> Am 09.01.2013 13:30, schrieb Tom Schindl:
>>> Hi,
>>>
>>> We have implemented a MS-SQL-Adapter sometime ago and use it
>>> successfully in production since about 6 months.
>>>
>>> Let me see how we can make it available to you.
>> Wow, that'd be cool!
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>> Tom
>>>
>>> Am 09.01.13 13:16, schrieb Eike Stepper:
>>>> Am 09.01.2013 09:18, schrieb Alex Mising name:
>>>>> I'm creating cdo-server.xml file for Microsoft sql server:
>>>>>
>>>>> <repository name="demo">
>>>>>
>>>>> <store type="db">
>>>>> <mappingStrategy type="horizontal"/>
>>>>> <dbAdapter name="???"/>
>>>>> <dataSource
>>>>> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>>> url="jdbc:sqlserver://servername;databaseName=dbname"
>>>>> user="user"
>>>>> password="psw"
>>>>> />
>>>>> </store>
>>>>> </repository>
>>>>>
>>>>> what dbAdapter name should I use?
>>>> As Erdal already said, we haven't got a DBAdapter for Microsoft, yet.
>>>> But we'd certainly be interested in respective contributions. If you
>>>> have a look at the other DBAdapters you'll notice that they're
>>>> comparingly small and simple.
>>>>
>>>> Is there an OSGi bundle with the JDBC driver available on the net?
>>>>
>>>> Cheers
>>>> /Eike
>>>>
>>>> ----
>>>> http://www.esc-net.de
>>>> http://thegordian.blogspot.com
>>>> http://twitter.com/eikestepper
>>>>
>>>>
Re: CDO server with Microsoft sql server [message #1000674 is a reply to message #1000667] Tue, 15 January 2013 08:16 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5334
Registered: July 2009
Senior Member
Hi Eike, Tom,
No problem can host it there, but... this update site already has the microsoft supplied jdbc driver. Wouldn't that work
fine also?

gr. Martin

On 01/15/2013 09:00 AM, Eike Stepper wrote:
> Hi Tom,
>
> That's great! I wonder if we could ship that DBAdapter with CDO?
>
> Martin, do you think you could host the driver bundle on http://www.elver.org/eclipse/2.0.0/update ?
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
> Am 09.01.2013 19:20, schrieb Tom Schindl:
>> Hi,
>>
>> here we go. I've published our code including JDTS Driver on our github
>> account [1], created a build and published an update-site [2], we are
>> using CDO inside tomcat (=without OSGi) so please report if you have
>> problems with it.
>>
>> If you look at the code you'll notice it is not really rocket sience ;-)
>>
>> Please note we've hardcoded the Blob size currently so that it suites
>> our needs, maybe we should add a config option for this using
>> -Dcdo.mssql.blobsize=... but patches are welcome.
>>
>> The license is LPGL because JDTS is LGPL!
>>
>> I hope this helps.
>>
>> Tom
>>
>> [1] https://github.com/BestSolution-at/cdo-mssqladapter
>> [2]
>> http://foss.bestsolution.at/downloads/cdo-mssqladapter/p2-repos/nightly/site/
>>
>>
>>
>> Am 09.01.13 13:52, schrieb Eike Stepper:
>>> Am 09.01.2013 13:30, schrieb Tom Schindl:
>>>> Hi,
>>>>
>>>> We have implemented a MS-SQL-Adapter sometime ago and use it
>>>> successfully in production since about 6 months.
>>>>
>>>> Let me see how we can make it available to you.
>>> Wow, that'd be cool!
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://www.esc-net.de
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>>>> Tom
>>>>
>>>> Am 09.01.13 13:16, schrieb Eike Stepper:
>>>>> Am 09.01.2013 09:18, schrieb Alex Mising name:
>>>>>> I'm creating cdo-server.xml file for Microsoft sql server:
>>>>>>
>>>>>> <repository name="demo">
>>>>>>
>>>>>> <store type="db">
>>>>>> <mappingStrategy type="horizontal"/>
>>>>>> <dbAdapter name="???"/>
>>>>>> <dataSource
>>>>>> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>>>> url="jdbc:sqlserver://servername;databaseName=dbname"
>>>>>> user="user"
>>>>>> password="psw"
>>>>>> />
>>>>>> </store>
>>>>>> </repository>
>>>>>>
>>>>>> what dbAdapter name should I use?
>>>>> As Erdal already said, we haven't got a DBAdapter for Microsoft, yet.
>>>>> But we'd certainly be interested in respective contributions. If you
>>>>> have a look at the other DBAdapters you'll notice that they're
>>>>> comparingly small and simple.
>>>>>
>>>>> Is there an OSGi bundle with the JDBC driver available on the net?
>>>>>
>>>>> Cheers
>>>>> /Eike
>>>>>
>>>>> ----
>>>>> http://www.esc-net.de
>>>>> http://thegordian.blogspot.com
>>>>> http://twitter.com/eikestepper
>>>>>
>>>>>
>


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: CDO server with Microsoft sql server [message #1000683 is a reply to message #1000667] Tue, 15 January 2013 08:50 Go to previous messageGo to next message
Thomas Schindl is currently offline Thomas Schindl
Messages: 5331
Registered: July 2009
Senior Member
Hi,

well we have a compile time dependency on a LGPL library (JDTS) not sure
if you are allowed to ship something with this dependency.

For easiest consumption I simply packaged the driver with the library -
which would prevent it to be used as it is today - although I have no
problem moving it to its own bundle.

Tom

Am 15.01.13 09:00, schrieb Eike Stepper:
> Hi Tom,
>
> That's great! I wonder if we could ship that DBAdapter with CDO?
>
> Martin, do you think you could host the driver bundle on
> http://www.elver.org/eclipse/2.0.0/update ?
>
> Cheers
> /Eike
>
> ----
> http://www.esc-net.de
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
> Am 09.01.2013 19:20, schrieb Tom Schindl:
>> Hi,
>>
>> here we go. I've published our code including JDTS Driver on our github
>> account [1], created a build and published an update-site [2], we are
>> using CDO inside tomcat (=without OSGi) so please report if you have
>> problems with it.
>>
>> If you look at the code you'll notice it is not really rocket sience ;-)
>>
>> Please note we've hardcoded the Blob size currently so that it suites
>> our needs, maybe we should add a config option for this using
>> -Dcdo.mssql.blobsize=... but patches are welcome.
>>
>> The license is LPGL because JDTS is LGPL!
>>
>> I hope this helps.
>>
>> Tom
>>
>> [1] https://github.com/BestSolution-at/cdo-mssqladapter
>> [2]
>> http://foss.bestsolution.at/downloads/cdo-mssqladapter/p2-repos/nightly/site/
>>
>>
>>
>>
>> Am 09.01.13 13:52, schrieb Eike Stepper:
>>> Am 09.01.2013 13:30, schrieb Tom Schindl:
>>>> Hi,
>>>>
>>>> We have implemented a MS-SQL-Adapter sometime ago and use it
>>>> successfully in production since about 6 months.
>>>>
>>>> Let me see how we can make it available to you.
>>> Wow, that'd be cool!
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://www.esc-net.de
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>>>> Tom
>>>>
>>>> Am 09.01.13 13:16, schrieb Eike Stepper:
>>>>> Am 09.01.2013 09:18, schrieb Alex Mising name:
>>>>>> I'm creating cdo-server.xml file for Microsoft sql server:
>>>>>>
>>>>>> <repository name="demo">
>>>>>>
>>>>>> <store type="db">
>>>>>> <mappingStrategy type="horizontal"/>
>>>>>> <dbAdapter name="???"/>
>>>>>> <dataSource
>>>>>> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>>>> url="jdbc:sqlserver://servername;databaseName=dbname"
>>>>>> user="user"
>>>>>> password="psw"
>>>>>> />
>>>>>> </store>
>>>>>> </repository>
>>>>>>
>>>>>> what dbAdapter name should I use?
>>>>> As Erdal already said, we haven't got a DBAdapter for Microsoft, yet.
>>>>> But we'd certainly be interested in respective contributions. If you
>>>>> have a look at the other DBAdapters you'll notice that they're
>>>>> comparingly small and simple.
>>>>>
>>>>> Is there an OSGi bundle with the JDBC driver available on the net?
>>>>>
>>>>> Cheers
>>>>> /Eike
>>>>>
>>>>> ----
>>>>> http://www.esc-net.de
>>>>> http://thegordian.blogspot.com
>>>>> http://twitter.com/eikestepper
>>>>>
>>>>>
>
Re: CDO server with Microsoft sql server [message #1000684 is a reply to message #1000674] Tue, 15 January 2013 08:50 Go to previous messageGo to next message
Thomas Schindl is currently offline Thomas Schindl
Messages: 5331
Registered: July 2009
Senior Member
Am 15.01.13 09:16, schrieb Martin Taal:
> Hi Eike, Tom,
> No problem can host it there, but... this update site already has the
> microsoft supplied jdbc driver. Wouldn't that work fine also?
>

It looks like we are using a different jdbc driver you do. I decided to
package the driver with the OSGi-Bundle so I have no external dependencies.

Tom
Re: CDO server with Microsoft sql server [message #1000686 is a reply to message #1000684] Tue, 15 January 2013 08:53 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5334
Registered: July 2009
Senior Member
Hi Tom,
If you externalize the jdbc driver in a property setting somewhere then maybe you can avoid the compile time dependency.
I don't know how the plugin dependencies are organized but with the buddypolicy trick/hack it is possible to work
without direct plugin dependencies also. So then your adapter would be nice and clean and not so lgpl dependent I guess.

gr. Martin

On 01/15/2013 09:50 AM, Tom Schindl wrote:
> Am 15.01.13 09:16, schrieb Martin Taal:
>> Hi Eike, Tom,
>> No problem can host it there, but... this update site already has the
>> microsoft supplied jdbc driver. Wouldn't that work fine also?
>>
>
> It looks like we are using a different jdbc driver you do. I decided to
> package the driver with the OSGi-Bundle so I have no external dependencies.
>
> Tom
>


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: CDO server with Microsoft sql server [message #1000704 is a reply to message #1000686] Tue, 15 January 2013 09:43 Go to previous messageGo to next message
Thomas Schindl is currently offline Thomas Schindl
Messages: 5331
Registered: July 2009
Senior Member
Hi Martin,

I'm not a fan of this buddypolicy trickery, better would be to use
OSGi-Services (if in OSGi) and ServiceLoader (if in plain java).

Tom

Am 15.01.13 09:53, schrieb Martin Taal:
> Hi Tom,
> If you externalize the jdbc driver in a property setting somewhere then
> maybe you can avoid the compile time dependency.
> I don't know how the plugin dependencies are organized but with the
> buddypolicy trick/hack it is possible to work without direct plugin
> dependencies also. So then your adapter would be nice and clean and not
> so lgpl dependent I guess.
>
> gr. Martin
>
> On 01/15/2013 09:50 AM, Tom Schindl wrote:
>> Am 15.01.13 09:16, schrieb Martin Taal:
>>> Hi Eike, Tom,
>>> No problem can host it there, but... this update site already has the
>>> microsoft supplied jdbc driver. Wouldn't that work fine also?
>>>
>>
>> It looks like we are using a different jdbc driver you do. I decided to
>> package the driver with the OSGi-Bundle so I have no external
>> dependencies.
>>
>> Tom
>>
>
>
Re: CDO server with Microsoft sql server [message #1000716 is a reply to message #1000704] Tue, 15 January 2013 10:07 Go to previous messageGo to next message
Martin Taal is currently offline Martin Taal
Messages: 5334
Registered: July 2009
Senior Member
Yes, in any case it is up to you or anyone else. It is no problem for me to host the complete db adapter on elver.org.
You can email the plugin jar file to me if you want.

gr. Martin

On 01/15/2013 10:43 AM, Tom Schindl wrote:
> Hi Martin,
>
> I'm not a fan of this buddypolicy trickery, better would be to use
> OSGi-Services (if in OSGi) and ServiceLoader (if in plain java).
>
> Tom
>
> Am 15.01.13 09:53, schrieb Martin Taal:
>> Hi Tom,
>> If you externalize the jdbc driver in a property setting somewhere then
>> maybe you can avoid the compile time dependency.
>> I don't know how the plugin dependencies are organized but with the
>> buddypolicy trick/hack it is possible to work without direct plugin
>> dependencies also. So then your adapter would be nice and clean and not
>> so lgpl dependent I guess.
>>
>> gr. Martin
>>
>> On 01/15/2013 09:50 AM, Tom Schindl wrote:
>>> Am 15.01.13 09:16, schrieb Martin Taal:
>>>> Hi Eike, Tom,
>>>> No problem can host it there, but... this update site already has the
>>>> microsoft supplied jdbc driver. Wouldn't that work fine also?
>>>>
>>>
>>> It looks like we are using a different jdbc driver you do. I decided to
>>> package the driver with the OSGi-Bundle so I have no external
>>> dependencies.
>>>
>>> Tom
>>>
>>
>>
>


--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@xxxxxxxx - mtaal@xxxxxxxx
Web: www.springsite.com - www.elver.org
Re: CDO server with Microsoft sql server [message #1000733 is a reply to message #1000683] Tue, 15 January 2013 10:46 Go to previous message
Eike Stepper is currently offline Eike Stepper
Messages: 5524
Registered: July 2009
Senior Member
Guys,

I took this discussion as a chance to review why exactly we carry these driver dependencies in the adapter bundles.
Frankly, I believe they're historical relicts. The framework doesn't use them, nor does it use the spare API that
requires them. I'm quite sure that nobody needs them there and that future DB integrations would benefit from their
removal. I've filed and fixed this bug:

398167: [DB] Remove JDBC driver dependencies from DBAdapter bundles
https://bugs.eclipse.org/bugs/show_bug.cgi?id=398167

I think with this change we can stop talking about the drivers (at least in the context of the net4j.db integration
framework) and focus on good DBAdapters. We can develop and build them now without worrying about availability and
licensing of driver bundles. Of course we'll continue to ship the drivers for existing adapters that are in Orbit.

Tom, would you like to submit a bugzilla and contribute your
https://github.com/BestSolution-at/cdo-mssqladapter/blob/master/at.bestsolution.cdo.mssql.adapter/src/at/bestsolution/cdo/mssql/adapter/SqlServerAdapter.java
? These ~100 LOCs wouldn't even require a CQ, anymore ;-)

Cheers
/Eike

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




Am 15.01.2013 09:50, schrieb Tom Schindl:
> Hi,
>
> well we have a compile time dependency on a LGPL library (JDTS) not sure
> if you are allowed to ship something with this dependency.
>
> For easiest consumption I simply packaged the driver with the library -
> which would prevent it to be used as it is today - although I have no
> problem moving it to its own bundle.
>
> Tom
>
> Am 15.01.13 09:00, schrieb Eike Stepper:
>> Hi Tom,
>>
>> That's great! I wonder if we could ship that DBAdapter with CDO?
>>
>> Martin, do you think you could host the driver bundle on
>> http://www.elver.org/eclipse/2.0.0/update ?
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://www.esc-net.de
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>
>> Am 09.01.2013 19:20, schrieb Tom Schindl:
>>> Hi,
>>>
>>> here we go. I've published our code including JDTS Driver on our github
>>> account [1], created a build and published an update-site [2], we are
>>> using CDO inside tomcat (=without OSGi) so please report if you have
>>> problems with it.
>>>
>>> If you look at the code you'll notice it is not really rocket sience ;-)
>>>
>>> Please note we've hardcoded the Blob size currently so that it suites
>>> our needs, maybe we should add a config option for this using
>>> -Dcdo.mssql.blobsize=... but patches are welcome.
>>>
>>> The license is LPGL because JDTS is LGPL!
>>>
>>> I hope this helps.
>>>
>>> Tom
>>>
>>> [1] https://github.com/BestSolution-at/cdo-mssqladapter
>>> [2]
>>> http://foss.bestsolution.at/downloads/cdo-mssqladapter/p2-repos/nightly/site/
>>>
>>>
>>>
>>>
>>> Am 09.01.13 13:52, schrieb Eike Stepper:
>>>> Am 09.01.2013 13:30, schrieb Tom Schindl:
>>>>> Hi,
>>>>>
>>>>> We have implemented a MS-SQL-Adapter sometime ago and use it
>>>>> successfully in production since about 6 months.
>>>>>
>>>>> Let me see how we can make it available to you.
>>>> Wow, that'd be cool!
>>>>
>>>> Cheers
>>>> /Eike
>>>>
>>>> ----
>>>> http://www.esc-net.de
>>>> http://thegordian.blogspot.com
>>>> http://twitter.com/eikestepper
>>>>
>>>>
>>>>> Tom
>>>>>
>>>>> Am 09.01.13 13:16, schrieb Eike Stepper:
>>>>>> Am 09.01.2013 09:18, schrieb Alex Mising name:
>>>>>>> I'm creating cdo-server.xml file for Microsoft sql server:
>>>>>>>
>>>>>>> <repository name="demo">
>>>>>>>
>>>>>>> <store type="db">
>>>>>>> <mappingStrategy type="horizontal"/>
>>>>>>> <dbAdapter name="???"/>
>>>>>>> <dataSource
>>>>>>> class="com.microsoft.sqlserver.jdbc.SQLServerDriver"
>>>>>>> url="jdbc:sqlserver://servername;databaseName=dbname"
>>>>>>> user="user"
>>>>>>> password="psw"
>>>>>>> />
>>>>>>> </store>
>>>>>>> </repository>
>>>>>>>
>>>>>>> what dbAdapter name should I use?
>>>>>> As Erdal already said, we haven't got a DBAdapter for Microsoft, yet.
>>>>>> But we'd certainly be interested in respective contributions. If you
>>>>>> have a look at the other DBAdapters you'll notice that they're
>>>>>> comparingly small and simple.
>>>>>>
>>>>>> Is there an OSGi bundle with the JDBC driver available on the net?
>>>>>>
>>>>>> Cheers
>>>>>> /Eike
>>>>>>
>>>>>> ----
>>>>>> http://www.esc-net.de
>>>>>> http://thegordian.blogspot.com
>>>>>> http://twitter.com/eikestepper
>>>>>>
>>>>>>
Previous Topic:[CDO-Net4j]
Next Topic:[CDO] Compact Revision-History
Goto Forum:
  


Current Time: Tue Sep 23 02:24:44 GMT 2014

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

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