Home » Modeling » EMF » CDO server with Microsoft sql server
| | | | | | | |
Re: CDO server with Microsoft sql server [message #998288 is a reply to message #998151] |
Wed, 09 January 2013 18:20 |
Thomas Schindl Messages: 6651 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 |
|
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
>>>>
>>>>
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 |
Martin Taal Messages: 5468 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 |
Thomas Schindl Messages: 6651 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 #1000686 is a reply to message #1000684] |
Tue, 15 January 2013 08:53 |
Martin Taal Messages: 5468 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 |
Thomas Schindl Messages: 6651 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 |
Martin Taal Messages: 5468 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 |
|
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
>>>>>>
>>>>>>
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
| | | | | |
Goto Forum:
Current Time: Mon Sep 23 09:50:13 GMT 2024
Powered by FUDForum. Page generated in 0.07671 seconds
|