RE: Help, DB2 integration problem #2

2002-09-27 Thread Jason Richardson 

There is '3' problem which i submitted a bug for about a month ago.  I
believe the db2 script is missing the ID table creation also, or atleast
it did at the time i last tried it.  


Jason Richardson

>>> [EMAIL PROTECTED] 09/27/02 08:39AM >>>
I'll try it out this weekend with the free developers edition of db2
What kind of problems are you having?

> -Original Message-
> From: Woody Sturges [mailto:[EMAIL PROTECTED]] 
> Sent: 27 September 2002 14:02
> To: [EMAIL PROTECTED] 
> Subject: RE: Help, DB2 integration problem #2
> 
> 
> Hi David,
> 
>   We manually modified and ran the scripts, but Jetspeed had 
> problems interacting with DB/2 even after the DB was setup.  
> Our location would be VERY interested in getting DB/2 support 
> back up to speed...  (no pun
> intended)
> 
> Thanks,
> Woody
> 
> >>> [EMAIL PROTECTED] 09/26/02 06:19AM >>>
> Sorry about the DB2 scripts.
> I tested on Hypersonic, MySQL and Oracle.
> Do you know if DB2 has a free database download that I can 
> test on? I think I could get it fixed fairly quickly...
> 
> 
> > -Original Message-
> > From: Marian Skalsky [mailto:[EMAIL PROTECTED]] 
> > Sent: 26 September 2002 07:35
> > To: Jetspeed Users List
> > Subject: Re: Help, DB2 integration problem #2
> > 
> > 
> > Hi Philipp!
> > This will NOT help you, but I have JetSpeed 1.4b1 successfuly
> > working with ORACLE database and had no problems with scripts 
> > provided. $kala.
> > 
> > - Original Message -
> > From: "Philipp Schoepf" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 25, 2002 6:52 PM
> > Subject: Help, DB2 integration problem #2
> > 
> > 
> > Hi all,
> > 
> > I'm in really big trouble with my DB2-Jetspeed integration.
> > Like a said in my previous thread there are some problems 
> > using the turbine-db2.sql und populate-db2.sql scripts for 
> > the creation of a jetspeed db2 database. Could anyone tell 
> > me, if he ran into similar problems when integrating DB2 and 
> > Jetspeed? The provided scripts seem totally wrong! The error 
> > I got before was just because of the ";" in the scripts. 
> > After I deleted the ";" I was able to create the tables. But 
> > the next problem was not far away... The populate-db2.sql 
> > script seems as faulty as the turbine-db2.sql script. For 
> > example it tries to insert values into the user_id colums 
> > although this is permitted  by db2 (just because the id'sare 
> > generated automatically using the GENERATED ALWAYS AS 
> > IDENTITY statement). There is also an error when inserting 
> > the long value into the blob colum for the user infos. Did I 
> > download the wrong version of jetspeed (1.4b1) or did I make 
> > a wrong db2 configuration?
> > 
> > This is going to make me mad, so I would be very  grateful if
> > someone could help me
> > 
> > Best regards,
> > 
> > --
> > --
> > --
> > Philipp Schöpf
> > IBM e-business Innovation Center
> > Alter Wandrahm 10, 20457 Hamburg
> > Fon: +49 (0)40/41912-461
> > Web: http://www.ibm.com/services/de/innovation 
> > --
> > --
> > --
> > 
> > 
> > --
> > To unsubscribe, e-mail:   
> > <mailto:jetspeed-user-> [EMAIL PROTECTED]>
> > For
> > additional commands, 
> > e-mail: <mailto:[EMAIL PROTECTED]>
> > 
> 
> 
> BBCi at http://www.bbc.co.uk/ 
> 
> This e-mail (and any attachments) is confidential and may contain 
> personal views which are not the views of the BBC unless specifically

> stated.
> If you have received it in error, please delete it from your 
> system, do
> 
> not use, copy or disclose the information in any way nor act in 
> reliance on it and notify the sender immediately. Please note that
the
> 
> BBC monitors
e-mails sent or received. Further communication will 
> signify your consent to this.
> 
> 
> --
> To unsubscribe, e-mail:  
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> 
> 
> --
> To unsubscribe, e-mail:   
> <mailto:jetspeed-user-> [EMAIL PROTECTED]>
> For 
> additional commands, 
> e-mail: <mailto:[EMAIL PROTECTED]>
> 


BBCi at http://www.bbc.co.uk/ 

This e-mail (and any attachments) is confidential and may contain 
personal views which are not the views of the BBC unless specifically 
stated.
If you have received it in error, please delete it from your system, do

not use, copy or disclose the information in any way nor act in 
reliance on it and notify the sender immediately. Please note that the

BBC monitors e-mails sent or received. Further communication will 
signify your consent to this.


--
To unsubscribe, e-mail:  
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Help, DB2 integration problem #2

2002-09-27 Thread David Sean Taylor 

I'll try it out this weekend with the free developers edition of db2
What kind of problems are you having?

> -Original Message-
> From: Woody Sturges [mailto:[EMAIL PROTECTED]] 
> Sent: 27 September 2002 14:02
> To: [EMAIL PROTECTED]
> Subject: RE: Help, DB2 integration problem #2
> 
> 
> Hi David,
> 
>   We manually modified and ran the scripts, but Jetspeed had 
> problems interacting with DB/2 even after the DB was setup.  
> Our location would be VERY interested in getting DB/2 support 
> back up to speed...  (no pun
> intended)
> 
> Thanks,
> Woody
> 
> >>> [EMAIL PROTECTED] 09/26/02 06:19AM >>>
> Sorry about the DB2 scripts.
> I tested on Hypersonic, MySQL and Oracle.
> Do you know if DB2 has a free database download that I can 
> test on? I think I could get it fixed fairly quickly...
> 
> 
> > -Original Message-
> > From: Marian Skalsky [mailto:[EMAIL PROTECTED]]
> > Sent: 26 September 2002 07:35
> > To: Jetspeed Users List
> > Subject: Re: Help, DB2 integration problem #2
> > 
> > 
> > Hi Philipp!
> > This will NOT help you, but I have JetSpeed 1.4b1 successfuly
> > working with ORACLE database and had no problems with scripts 
> > provided. $kala.
> > 
> > - Original Message -
> > From: "Philipp Schoepf" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 25, 2002 6:52 PM
> > Subject: Help, DB2 integration problem #2
> > 
> > 
> > Hi all,
> > 
> > I'm in really big trouble with my DB2-Jetspeed integration.
> > Like a said in my previous thread there are some problems 
> > using the turbine-db2.sql und populate-db2.sql scripts for 
> > the creation of a jetspeed db2 database. Could anyone tell 
> > me, if he ran into similar problems when integrating DB2 and 
> > Jetspeed? The provided scripts seem totally wrong! The error 
> > I got before was just because of the ";" in the scripts. 
> > After I deleted the ";" I was able to create the tables. But 
> > the next problem was not far away... The populate-db2.sql 
> > script seems as faulty as the turbine-db2.sql script. For 
> > example it tries to insert values into the user_id colums 
> > although this is permitted  by db2 (just because the id'sare 
> > generated automatically using the GENERATED ALWAYS AS 
> > IDENTITY statement). There is also an error when inserting 
> > the long value into the blob colum for the user infos. Did I 
> > download the wrong version of jetspeed (1.4b1) or did I make 
> > a wrong db2 configuration?
> > 
> > This is going to make me mad, so I would be very  grateful if
> > someone could help me
> > 
> > Best regards,
> > 
> > --
> > --
> > --
> > Philipp Schöpf
> > IBM e-business Innovation Center
> > Alter Wandrahm 10, 20457 Hamburg
> > Fon: +49 (0)40/41912-461
> > Web: http://www.ibm.com/services/de/innovation
> > --
> > --
> > --
> > 
> > 
> > --
> > To unsubscribe, e-mail:   
> > <mailto:jetspeed-user-> [EMAIL PROTECTED]>
> > For
> > additional commands, 
> > e-mail: <mailto:[EMAIL PROTECTED]>
> > 
> 
> 
> BBCi at http://www.bbc.co.uk/ 
> 
> This e-mail (and any attachments) is confidential and may contain 
> personal views which are not the views of the BBC unless specifically 
> stated.
> If you have received it in error, please delete it from your 
> system, do
> 
> not use, copy or disclose the information in any way nor act in 
> reliance on it and notify the sender immediately. Please note that the
> 
> BBC monitors e-mails sent or received. Further communication will 
> signify your consent to this.
> 
> 
> --
> To unsubscribe, e-mail:  
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> 
> 
> --
> To unsubscribe, e-mail:   
> <mailto:jetspeed-user-> [EMAIL PROTECTED]>
> For 
> additional commands, 
> e-mail: <mailto:[EMAIL PROTECTED]>
> 


BBCi at http://www.bbc.co.uk/

This e-mail (and any attachments) is confidential and may contain 
personal views which are not the views of the BBC unless specifically 
stated.
If you have received it in error, please delete it from your system, do 
not use, copy or disclose the information in any way nor act in 
reliance on it and notify the sender immediately. Please note that the 
BBC monitors e-mails sent or received. Further communication will 
signify your consent to this.


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Help, DB2 integration problem #2

2002-09-27 Thread Woody Sturges 

Hi David,

  We manually modified and ran the scripts, but Jetspeed had problems
interacting with DB/2 even after the DB was setup.  Our location would
be VERY interested in getting DB/2 support back up to speed...  (no pun
intended)

Thanks,
Woody

>>> [EMAIL PROTECTED] 09/26/02 06:19AM >>>
Sorry about the DB2 scripts.
I tested on Hypersonic, MySQL and Oracle.
Do you know if DB2 has a free database download that I can test on?
I think I could get it fixed fairly quickly...


> -Original Message-
> From: Marian Skalsky [mailto:[EMAIL PROTECTED]] 
> Sent: 26 September 2002 07:35
> To: Jetspeed Users List
> Subject: Re: Help, DB2 integration problem #2
> 
> 
> Hi Philipp!
> This will NOT help you, but I have JetSpeed 1.4b1 successfuly 
> working with ORACLE database and had no problems with scripts 
> provided. $kala.
> 
> - Original Message -
> From: "Philipp Schoepf" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 25, 2002 6:52 PM
> Subject: Help, DB2 integration problem #2
> 
> 
> Hi all,
> 
> I'm in really big trouble with my DB2-Jetspeed integration. 
> Like a said in my previous thread there are some problems 
> using the turbine-db2.sql und populate-db2.sql scripts for 
> the creation of a jetspeed db2 database. Could anyone tell 
> me, if he ran into similar problems when integrating DB2 and 
> Jetspeed? The provided scripts seem totally wrong! The error 
> I got before was just because of the ";" in the scripts. 
> After I deleted the ";" I was able to create the tables. But 
> the next problem was not far away... The populate-db2.sql 
> script seems as faulty as the turbine-db2.sql script. For 
> example it tries to insert values into the user_id colums 
> although this is permitted  by db2 (just because the id'sare 
> generated automatically using the GENERATED ALWAYS AS 
> IDENTITY statement). There is also an error when inserting 
> the long value into the blob colum for the user infos. Did I 
> download the wrong version of jetspeed (1.4b1) or did I make 
> a wrong db2 configuration?
> 
> This is going to make me mad, so I would be very  grateful if 
> someone could help me
> 
> Best regards,
> 
> --
> --
> --
> Philipp Schöpf
> IBM e-business Innovation Center
> Alter Wandrahm 10, 20457 Hamburg
> Fon: +49 (0)40/41912-461
> Web: http://www.ibm.com/services/de/innovation 
> --
> --
> --
> 
> 
> --
> To unsubscribe, e-mail:   
> <mailto:jetspeed-user-> [EMAIL PROTECTED]>
> For 
> additional commands, 
> e-mail: <mailto:[EMAIL PROTECTED]>
> 


BBCi at http://www.bbc.co.uk/ 

This e-mail (and any attachments) is confidential and may contain 
personal views which are not the views of the BBC unless specifically 
stated.
If you have received it in error, please delete it from your system, do

not use, copy or disclose the information in any way nor act in 
reliance on it and notify the sender immediately. Please note that the

BBC monitors e-mails sent or received. Further communication will 
signify your consent to this.


--
To unsubscribe, e-mail:  
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Re: Help, DB2 integration problem #2

2002-09-26 Thread Thomas Marsh 

try this link:

http://www14.software.ibm.com/webapp/download/category.jsp?s=c&cat=data


free developers edition.

otherwise go to www.software.ibm.com/db2 and then downloads.


HTH

David Sean Taylor wrote:
> 
> Sorry about the DB2 scripts.
> I tested on Hypersonic, MySQL and Oracle.
> Do you know if DB2 has a free database download that I can test on?
> I think I could get it fixed fairly quickly...
> 
> > -Original Message-
> > From: Marian Skalsky [mailto:[EMAIL PROTECTED]]
> > Sent: 26 September 2002 07:35
> > To: Jetspeed Users List
> > Subject: Re: Help, DB2 integration problem #2
> >
> >
> > Hi Philipp!
> > This will NOT help you, but I have JetSpeed 1.4b1 successfuly
> > working with ORACLE database and had no problems with scripts
> > provided. $kala.
> >
> > - Original Message -
> > From: "Philipp Schoepf" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, September 25, 2002 6:52 PM
> > Subject: Help, DB2 integration problem #2
> >
> >
> > Hi all,
> >
> > I'm in really big trouble with my DB2-Jetspeed integration.
> > Like a said in my previous thread there are some problems
> > using the turbine-db2.sql und populate-db2.sql scripts for
> > the creation of a jetspeed db2 database. Could anyone tell
> > me, if he ran into similar problems when integrating DB2 and
> > Jetspeed? The provided scripts seem totally wrong! The error
> > I got before was just because of the ";" in the scripts.
> > After I deleted the ";" I was able to create the tables. But
> > the next problem was not far away... The populate-db2.sql
> > script seems as faulty as the turbine-db2.sql script. For
> > example it tries to insert values into the user_id colums
> > although this is permitted  by db2 (just because the id'sare
> > generated automatically using the GENERATED ALWAYS AS
> > IDENTITY statement). There is also an error when inserting
> > the long value into the blob colum for the user infos. Did I
> > download the wrong version of jetspeed (1.4b1) or did I make
> > a wrong db2 configuration?
> >
> > This is going to make me mad, so I would be very  grateful if
> > someone could help me
> >
> > Best regards,
> >
> > --
> > --
> > --
> > Philipp Schöpf
> > IBM e-business Innovation Center
> > Alter Wandrahm 10, 20457 Hamburg
> > Fon: +49 (0)40/41912-461
> > Web: http://www.ibm.com/services/de/innovation
> > --
> > --
> > --
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <mailto:jetspeed-user-> [EMAIL PROTECTED]>
> > For
> > additional commands,
> > e-mail: <mailto:[EMAIL PROTECTED]>
> >
> 
> BBCi at http://www.bbc.co.uk/
> 
> This e-mail (and any attachments) is confidential and may contain
> personal views which are not the views of the BBC unless specifically
> stated.
> If you have received it in error, please delete it from your system, do
> not use, copy or disclose the information in any way nor act in
> reliance on it and notify the sender immediately. Please note that the
> BBC monitors e-mails sent or received. Further communication will
> signify your consent to this.
> 
> --
> To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

-- 
Tom Marsh

mailto:[EMAIL PROTECTED]
http://www.nitesco.com

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Help, DB2 integration problem #2

2002-09-26 Thread David Sean Taylor 

Sorry about the DB2 scripts.
I tested on Hypersonic, MySQL and Oracle.
Do you know if DB2 has a free database download that I can test on?
I think I could get it fixed fairly quickly...


> -Original Message-
> From: Marian Skalsky [mailto:[EMAIL PROTECTED]] 
> Sent: 26 September 2002 07:35
> To: Jetspeed Users List
> Subject: Re: Help, DB2 integration problem #2
> 
> 
> Hi Philipp!
> This will NOT help you, but I have JetSpeed 1.4b1 successfuly 
> working with ORACLE database and had no problems with scripts 
> provided. $kala.
> 
> - Original Message -
> From: "Philipp Schoepf" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, September 25, 2002 6:52 PM
> Subject: Help, DB2 integration problem #2
> 
> 
> Hi all,
> 
> I'm in really big trouble with my DB2-Jetspeed integration. 
> Like a said in my previous thread there are some problems 
> using the turbine-db2.sql und populate-db2.sql scripts for 
> the creation of a jetspeed db2 database. Could anyone tell 
> me, if he ran into similar problems when integrating DB2 and 
> Jetspeed? The provided scripts seem totally wrong! The error 
> I got before was just because of the ";" in the scripts. 
> After I deleted the ";" I was able to create the tables. But 
> the next problem was not far away... The populate-db2.sql 
> script seems as faulty as the turbine-db2.sql script. For 
> example it tries to insert values into the user_id colums 
> although this is permitted  by db2 (just because the id'sare 
> generated automatically using the GENERATED ALWAYS AS 
> IDENTITY statement). There is also an error when inserting 
> the long value into the blob colum for the user infos. Did I 
> download the wrong version of jetspeed (1.4b1) or did I make 
> a wrong db2 configuration?
> 
> This is going to make me mad, so I would be very  grateful if 
> someone could help me
> 
> Best regards,
> 
> --
> --
> --
> Philipp Schöpf
> IBM e-business Innovation Center
> Alter Wandrahm 10, 20457 Hamburg
> Fon: +49 (0)40/41912-461
> Web: http://www.ibm.com/services/de/innovation
> --
> --
> --
> 
> 
> --
> To unsubscribe, e-mail:   
> <mailto:jetspeed-user-> [EMAIL PROTECTED]>
> For 
> additional commands, 
> e-mail: <mailto:[EMAIL PROTECTED]>
> 


BBCi at http://www.bbc.co.uk/

This e-mail (and any attachments) is confidential and may contain 
personal views which are not the views of the BBC unless specifically 
stated.
If you have received it in error, please delete it from your system, do 
not use, copy or disclose the information in any way nor act in 
reliance on it and notify the sender immediately. Please note that the 
BBC monitors e-mails sent or received. Further communication will 
signify your consent to this.


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Re: Help, DB2 integration problem #2

2002-09-25 Thread Marian Skalsky 

Hi Philipp!
This will NOT help you, but I have JetSpeed 1.4b1 successfuly working with
ORACLE database and had no problems with scripts provided.
$kala.

- Original Message -
From: "Philipp Schoepf" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 25, 2002 6:52 PM
Subject: Help, DB2 integration problem #2


Hi all,

I'm in really big trouble with my DB2-Jetspeed integration.
Like a said in my previous thread there are some problems using the
turbine-db2.sql und populate-db2.sql scripts for the creation of a
jetspeed db2 database.
Could anyone tell me, if he ran into similar problems when integrating DB2
and Jetspeed? The provided scripts seem totally wrong!
The error I got before was just because of the ";" in the scripts. After I
deleted the ";" I was able to create the tables. But the next problem was
not far away... The populate-db2.sql script seems as faulty as the
turbine-db2.sql script. For example it tries to insert values into the
user_id colums although this is permitted  by db2 (just because the
id'sare generated automatically using the GENERATED ALWAYS AS IDENTITY
statement). There is also an error when inserting the long value into the
blob colum for the user infos.
Did I download the wrong version of jetspeed (1.4b1) or did I make a wrong
db2 configuration?

This is going to make me mad, so I would be very  grateful if someone
could help me

Best regards,


--
Philipp Schöpf
IBM e-business Innovation Center
Alter Wandrahm 10, 20457 Hamburg
Fon: +49 (0)40/41912-461
Web: http://www.ibm.com/services/de/innovation

--


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Re: Help, DB2 integration problem #2

2002-09-25 Thread Thomas Marsh 

I think there's a switch to use when running db2 scripts from the
command line to use the ";" as a line terminator

I haven't looked at the script...

Philipp Schoepf wrote:
> 
> Hi all,
> 
> I'm in really big trouble with my DB2-Jetspeed integration.
> Like a said in my previous thread there are some problems using the
> turbine-db2.sql und populate-db2.sql scripts for the creation of a
> jetspeed db2 database.
> Could anyone tell me, if he ran into similar problems when integrating DB2
> and Jetspeed? The provided scripts seem totally wrong!
> The error I got before was just because of the ";" in the scripts. After I
> deleted the ";" I was able to create the tables. But the next problem was
> not far away... The populate-db2.sql script seems as faulty as the
> turbine-db2.sql script. For example it tries to insert values into the
> user_id colums although this is permitted  by db2 (just because the
> id'sare generated automatically using the GENERATED ALWAYS AS IDENTITY
> statement). There is also an error when inserting the long value into the
> blob colum for the user infos.
> Did I download the wrong version of jetspeed (1.4b1) or did I make a wrong
> db2 configuration?
> 
> This is going to make me mad, so I would be very  grateful if someone
> could help me
> 
> Best regards,
> 
> --
> Philipp Schöpf
> IBM e-business Innovation Center
> Alter Wandrahm 10, 20457 Hamburg
> Fon: +49 (0)40/41912-461
> Web: http://www.ibm.com/services/de/innovation
> --

-- 
Tom Marsh

mailto:[EMAIL PROTECTED]
http://www.nitesco.com

--
To unsubscribe, e-mail:   
For additional commands, e-mail:

Re: Help, DB2 integration problem #2

2002-09-25 Thread Woody Sturges 

FWIW, we had the same problems and submitted it to bugtrack.  We were
unable to figure it out, so we're using MySQL for all the Jetspeed
stuff, and DB2 for all of our application stuff.  Hopefully, someone
will fix the DB2 portion in Jetspeed so we can consolidate back to our
preferred DB.

>>> [EMAIL PROTECTED] 09/25/02 11:52AM >>>
Hi all,

I'm in really big trouble with my DB2-Jetspeed integration. 
Like a said in my previous thread there are some problems using the 
turbine-db2.sql und populate-db2.sql scripts for the creation of a 
jetspeed db2 database.
Could anyone tell me, if he ran into similar problems when integrating
DB2 
and Jetspeed? The provided scripts seem totally wrong! 
The error I got before was just because of the ";" in the scripts.
After I 
deleted the ";" I was able to create the tables. But the next problem
was 
not far away... The populate-db2.sql script seems as faulty as the 
turbine-db2.sql script. For example it tries to insert values into the

user_id colums although this is permitted  by db2 (just because the 
id'sare generated automatically using the GENERATED ALWAYS AS IDENTITY

statement). There is also an error when inserting the long value into
the 
blob colum for the user infos.
Did I download the wrong version of jetspeed (1.4b1) or did I make a
wrong 
db2 configuration?

This is going to make me mad, so I would be very  grateful if someone 
could help me

Best regards,

--
Philipp Schöpf
IBM e-business Innovation Center
Alter Wandrahm 10, 20457 Hamburg
Fon: +49 (0)40/41912-461
Web: http://www.ibm.com/services/de/innovation 
--

--
To unsubscribe, e-mail:   
For additional commands, e-mail:

Help, DB2 integration problem #2

2002-09-25 Thread Philipp Schoepf 

Hi all,

I'm in really big trouble with my DB2-Jetspeed integration. 
Like a said in my previous thread there are some problems using the 
turbine-db2.sql und populate-db2.sql scripts for the creation of a 
jetspeed db2 database.
Could anyone tell me, if he ran into similar problems when integrating DB2 
and Jetspeed? The provided scripts seem totally wrong! 
The error I got before was just because of the ";" in the scripts. After I 
deleted the ";" I was able to create the tables. But the next problem was 
not far away... The populate-db2.sql script seems as faulty as the 
turbine-db2.sql script. For example it tries to insert values into the 
user_id colums although this is permitted  by db2 (just because the 
id'sare generated automatically using the GENERATED ALWAYS AS IDENTITY 
statement). There is also an error when inserting the long value into the 
blob colum for the user infos.
Did I download the wrong version of jetspeed (1.4b1) or did I make a wrong 
db2 configuration?

This is going to make me mad, so I would be very  grateful if someone 
could help me

Best regards,

--
Philipp Schöpf
IBM e-business Innovation Center
Alter Wandrahm 10, 20457 Hamburg
Fon: +49 (0)40/41912-461
Web: http://www.ibm.com/services/de/innovation
--