[prev in list] [next in list] [prev in thread] [next in thread]
List: esb-java-dev
Subject: Re: [Carbon-dev] Supporting IBM DB2/DB2 Express
From: Senaka Fernando <senaka () wso2 ! com>
Date: 2009-11-30 3:50:27
Message-ID: 8a8d77970911291938n3c5a6a59r43035c629cf07f82 () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi again,
Slight modification to my earlier reply.
"Peter, (the user on our forum) has tried this out on Windows, and managed
to get it to work" should be corrected as "Peter, (the user on our forum)
has had a look at this and believes that it should work on Windows with the
older version." Sorry for the mix-up, caused by my misunderstanding of the
forum post at the first instance.
Thanks,
Senaka.
On Mon, Nov 30, 2009 at 9:02 AM, Senaka Fernando <senaka@wso2.com> wrote:
> Peter, (the user on our forum) has tried this out on Windows, and managed
> to get it to work, and this is what he said about this:
>
> <quote>
>
> I use V3.57.82 ( JDBC 3.0 ) at work and verified that it does not include
> any upper case package names.. I also looked at V4.7.85 ( JDBC 4.0) and it
> does contain an upper case package name, but only for COM. ibm.db2os390
> package all the others are lower case.
>
> You should be able to grab them from the IBM DB2 LUW Support area (
> http://www-01.ibm.com/software/data/db2/support/db2_9/ )
>
> </quote>
>
> [1] http://wso2.org/forum/thread/8811#comment-11199
> Thanks,
> Senaka.
>
>
> On Mon, Nov 30, 2009 at 7:05 AM, Sanjiva Weerawarana <sanjiva@wso2.com>wrote:
>
>> INCREDIBLY sloppy.
>>
>> On Mon, Nov 30, 2009 at 1:24 AM, Sumedha Rubasinghe <sumedha@wso2.com>wrote:
>>
>>> Coincidently, without seeing this mail thread I started to make Carbon
>>> platform compatible with IBM DB2 today :-( . So far I have successfully
>>> converted & tested the database creation script[1].
>>>
>>> But due to a specific package naming on IBM's DB2 JDBC driver
>>> (db2jcc.jar), I encountered a blocker on Windows platform.
>>> Following is a sample extract of JDBC driver jar.
>>> created: com/
>>> created: com/ibm/
>>> inflated: com/ibm/db2/jcc/uw/y.class
>>> inflated: com/ibm/db2/jcc/uw/z.class
>>> ...
>>> ...
>>> inflated: COM/ibm/db2/app/Blob.class
>>> inflated: COM/ibm/db2/app/BlobInputStream.class
>>> created: COM/ibm/db2os390/sqlj/jdbc/
>>> inflated: COM/ibm/db2os390/sqlj/jdbc/DB2SQLJDriver.class
>>>
>>> As you can see, package com.ibm has been used twice with both upper &
>>> lower cases. But the corresponding OSGi bundle we create does not seem to
>>> preserve this difference in cases & we only see a lower case version in the
>>> OSGi bundle inside plugins directory. This causes
>>> 'COM.ibm.db2.jdbc.net.DB2Driver' to be unavailable @ server boot up.
>>>
>>> May be this would work on a case sensitive OS environment, on which I am
>>> yet to try.
>>>
>>> /sumedha
>>>
>>> [1]
>>> https://wso2.org/repos/wso2/trunk/carbon/distribution/carbon-home/dbscripts
>>>
>>>
>>>
>>>
>>> On Sat, Nov 28, 2009 at 11:14 AM, Sanjiva Weerawarana <sanjiva@wso2.com>wrote:
>>>
>>>> +1 to support DB2 .. esp. if someone else is willing to do the work :-).
>>>>
>>>> Sanjiva.
>>>>
>>>> On Sat, Nov 28, 2009 at 8:40 AM, Samisa Abeysinghe <samisa@wso2.com>wrote:
>>>>
>>>>>
>>>>>
>>>>> On Fri, Nov 27, 2009 at 7:26 PM, Senaka Fernando <senaka@wso2.com>wrote:
>>>>>
>>>>>> Hi all,
>>>>>>
>>>>>> How about adding support for IBM DB2/DB2 Express in addition to the
>>>>>> five DBMS types that we support right now? A user has volunteered to try
>>>>>> this out on our forum, [1].
>>>>>>
>>>>>
>>>>> It would also be nice to have some users contribute code for stuff like
>>>>> this :) given the open source model we are...
>>>>>
>>>>> Samisa...
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Carbon-dev mailing list
>>>>> Carbon-dev@wso2.org
>>>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Sanjiva Weerawarana, Ph.D.
>>>> Founder, Chairman & CEO; WSO2, Inc.; http://wso2.com/
>>>> email: sanjiva@wso2.com; phone: +1 408 754 7388 x51726; cell: +94 77
>>>> 787 6880
>>>> blog: http://sanjiva.weerawarana.org/
>>>>
>>>> The Open Source SOA Company
>>>>
>>>> _______________________________________________
>>>> Carbon-dev mailing list
>>>> Carbon-dev@wso2.org
>>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Carbon-dev mailing list
>>> Carbon-dev@wso2.org
>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>>
>>>
>>
>>
>> --
>> Sanjiva Weerawarana, Ph.D.
>> Founder, Chairman & CEO; WSO2, Inc.; http://wso2.com/
>> email: sanjiva@wso2.com; phone: +1 408 754 7388 x51726; cell: +94 77 787
>> 6880
>> blog: http://sanjiva.weerawarana.org/
>>
>> The Open Source SOA Company
>>
>> _______________________________________________
>> Carbon-dev mailing list
>> Carbon-dev@wso2.org
>> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>
>>
>
[Attachment #5 (text/html)]
Hi again,<br><br>Slight modification to my earlier reply. <br><br>"Peter, (the \
user on our forum) has tried this out on Windows, and managed to get it to work" \
should be corrected as "Peter, (the user on our forum) has had a look at this \
and believes that it should work on Windows with the older version." Sorry for \
the mix-up, caused by my misunderstanding of the forum post at the first \
instance.<br>
<br>Thanks,<br>Senaka.<br><br><div class="gmail_quote">On Mon, Nov 30, 2009 at 9:02 \
AM, Senaka Fernando <span dir="ltr"><<a \
href="mailto:senaka@wso2.com">senaka@wso2.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;">
Peter, (the user on our forum) has tried this out on Windows, and managed to get it \
to work, and this is what he said about this:<br><br><quote><br><br>I use \
V3.57.82 ( JDBC 3.0 ) at work and verified that it does not include any upper case \
package names.. I also looked at V4.7.85 ( JDBC 4.0) and it does contain an upper \
case package name, but only for COM. ibm.db2os390 package all the others are lower \
case. <p>You should be able to grab them from the IBM DB2 LUW Support area ( <a \
href="http://www-01.ibm.com/software/data/db2/support/db2_9/" \
target="_blank">http://www-01.ibm.com/software/data/db2/support/db2_9/</a> \
)</p><p></quote></p>
<p>[1] <a href="http://wso2.org/forum/thread/8811#comment-11199" \
target="_blank">http://wso2.org/forum/thread/8811#comment-11199</a><br></p>Thanks,<br><font \
color="#888888">Senaka.</font><div><div></div><div class="h5"><br>
<br><div class="gmail_quote">On Mon, Nov 30, 2009 at 7:05 AM, Sanjiva Weerawarana \
<span dir="ltr"><<a href="mailto:sanjiva@wso2.com" \
target="_blank">sanjiva@wso2.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;">INCREDIBLY sloppy.<br><br><div \
class="gmail_quote"><div>On Mon, Nov 30, 2009 at 1:24 AM, Sumedha Rubasinghe <span \
dir="ltr"><<a href="mailto:sumedha@wso2.com" \
target="_blank">sumedha@wso2.com</a>></span> wrote:<br>
</div><div><div></div><div><blockquote class="gmail_quote" style="border-left: 1px \
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> \
<div>Coincidently, without seeing this mail thread I started to make Carbon platform \
compatible with IBM DB2 today :-( . So far I have successfully converted & tested \
the database creation script[1]. </div><div><br></div>
<div>But due to a specific package naming on IBM's DB2 JDBC driver (db2jcc.jar), \
I encountered a blocker on Windows platform.</div><div>Following is a sample extract \
of JDBC driver jar.</div><div> created: com/</div>
<div> created: com/ibm/</div><div> inflated: com/ibm/db2/jcc/uw/y.class</div><div> \
inflated: com/ibm/db2/jcc/uw/z.class</div><div>...</div><div>...</div><div> inflated: \
COM/ibm/db2/app/Blob.class</div><div> inflated: \
COM/ibm/db2/app/BlobInputStream.class</div>
<div> created: COM/ibm/db2os390/sqlj/jdbc/</div><div> inflated: \
COM/ibm/db2os390/sqlj/jdbc/DB2SQLJDriver.class</div><div> </div><div>As you can see, \
package com.ibm has been used twice with both upper & lower cases. But the \
corresponding OSGi bundle we create does not seem to preserve this difference in \
cases & we only see a lower case version in the OSGi bundle inside plugins \
directory. This causes 'COM.ibm.db2.jdbc.net.DB2Driver' to be unavailable @ \
server boot up.</div>
<div><br></div><div>May be this would work on a case sensitive OS environment, on \
which I am yet to try.</div><div><br></div><div>/sumedha</div><div><br></div><div>[1] \
<a href="https://wso2.org/repos/wso2/trunk/carbon/distribution/carbon-home/dbscripts" \
target="_blank">https://wso2.org/repos/wso2/trunk/carbon/distribution/carbon-home/dbscripts</a></div>
<div><div></div><div>
<div><br></div><div><br></div><div><br></div><br><div class="gmail_quote">On Sat, Nov \
28, 2009 at 11:14 AM, Sanjiva Weerawarana <span dir="ltr"><<a \
href="mailto:sanjiva@wso2.com" target="_blank">sanjiva@wso2.com</a>></span> \
wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); \
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">+1 to support DB2 .. esp. if someone \
else is willing to do the work :-).<div><br></div><div>
Sanjiva.<br><br><div class="gmail_quote">
<div><div></div><div>On Sat, Nov 28, 2009 at 8:40 AM, Samisa Abeysinghe <span \
dir="ltr"><<a href="mailto:samisa@wso2.com" \
target="_blank">samisa@wso2.com</a>></span> wrote:<br> </div></div><blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;"><div><div></div><div><br><br><div \
class="gmail_quote"><div>On Fri, Nov 27, 2009 at 7:26 PM, Senaka Fernando <span \
dir="ltr"><<a href="mailto:senaka@wso2.com" \
target="_blank">senaka@wso2.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); \
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hi all,<br><br>How about adding \
support for IBM DB2/DB2 Express in addition to the five DBMS types that we support \
right now? A user has volunteered to try this out on our forum, \
[1].<br></blockquote><div><br></div></div>
<div>It would also be nice to have some users contribute code for stuff like this :) \
given the open source model we are...</div> \
<div><br></div><div>Samisa...</div><div><br></div></div> \
<br></div></div>_______________________________________________<br> Carbon-dev \
mailing list<br> <a href="mailto:Carbon-dev@wso2.org" \
target="_blank">Carbon-dev@wso2.org</a><br> <a \
href="https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev" \
target="_blank">https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev</a><br> \
<br></blockquote></div><br><br clear="all"><br>-- <br>Sanjiva Weerawarana, \
Ph.D.<br>Founder, Chairman & CEO; WSO2, Inc.; <a href="http://wso2.com/" \
target="_blank">http://wso2.com/</a><br>email: <a href="mailto:sanjiva@wso2.com" \
target="_blank">sanjiva@wso2.com</a>; phone: +1 408 754 7388 x51726; cell: +94 77 787 \
6880<br>
blog: <a href="http://sanjiva.weerawarana.org/" \
target="_blank">http://sanjiva.weerawarana.org/</a><br><br>The Open Source SOA \
Company<br> </div>
<br>_______________________________________________<br>
Carbon-dev mailing list<br>
<a href="mailto:Carbon-dev@wso2.org" target="_blank">Carbon-dev@wso2.org</a><br>
<a href="https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev" \
target="_blank">https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev</a><br> \
<br></blockquote></div><br> \
</div></div><br>_______________________________________________<br> Carbon-dev \
mailing list<br> <a href="mailto:Carbon-dev@wso2.org" \
target="_blank">Carbon-dev@wso2.org</a><br> <a \
href="https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev" \
target="_blank">https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev</a><br> \
<br></blockquote></div></div></div><div><div></div><div><br><br clear="all"><br>-- \
<br>Sanjiva Weerawarana, Ph.D.<br>Founder, Chairman & CEO; WSO2, Inc.; <a \
href="http://wso2.com/" target="_blank">http://wso2.com/</a><br>
email: <a href="mailto:sanjiva@wso2.com" target="_blank">sanjiva@wso2.com</a>; phone: \
+1 408 754 7388 x51726; cell: +94 77 787 6880<br>
blog: <a href="http://sanjiva.weerawarana.org/" \
target="_blank">http://sanjiva.weerawarana.org/</a><br><br>The Open Source SOA \
Company<br> </div></div><br>_______________________________________________<br>
Carbon-dev mailing list<br>
<a href="mailto:Carbon-dev@wso2.org" target="_blank">Carbon-dev@wso2.org</a><br>
<a href="https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev" \
target="_blank">https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev</a><br> \
<br></blockquote></div><br> </div></div></blockquote></div><br>
_______________________________________________
Carbon-dev mailing list
Carbon-dev@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic