You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by "Albrecht F.Leiprecht" <al...@mail.ccc-casino.com> on 2001/03/29 00:09:27 UTC
Q: ADABAS D and Turbine (not possible ?)
Hi all...
I'm still a newbie but I've adapted the SQL-Creationscripts
and the DBAdabas Adaptor.
Might be, I'm missing something or not. If you have different
expierences let me know...
1. Adabas only accepts 18 Characters for the Tablename.
Some Turbine tablenames are longer than that. Any Suggestions ??
2. In TURBINE_SCHEDULED_JOB there are 3 Fields with reserved words...
MINUTE, SECOND, HOUR
Any Idea ??
However, the templates to create the adabas sql is almost done, but I'm not
a
pro like you all, so bear with me.
Is there somebody responsible for that part.
I would like to send the material to that person (CVS/eMail/whatever) to
review it. It did work for me, and I would like to contribute that, but
there
are a few subjects in there which I didn't use/convert
(like field based Constraints ...).
Please note:
ADABAS D does currently NOT WORK with the turbine tables. I'm using mysql
for the Turbine tables (e.g. turbine-schema.sql) and adabas for the bussines
side. It seems to work that way.
so long
albi
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: ADABAS D and Turbine (not possible ?)
Posted by "Albrecht F.Leiprecht" <al...@mail.ccc-casino.com>.
I was reading my email again...
Please don't missunderstand me...
The review is for the sake of Turbine.
I have found a working way to do it and I want to share that but
I don't dare to give that to the public without the ok from somebody
in the project...
so long
albi
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: ADABAS D and Turbine (not possible ?)
Posted by John McNally <jm...@collab.net>.
"Albrecht F.Leiprecht" wrote:
>
> > > > 1. Adabas only accepts 18 Characters for the Tablename.
> > > > Some Turbine tablenames are longer than that. Any Suggestions ??
> >
> > How does it deal with long table names? Truncation? Explosion?
>
> It truncates it...
>
I think the table names are supposed to be unique within the first 18
characters, so are you actually having a problem with names greater than
18 characters?
john mcnally
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: ADABAS D and Turbine (not possible ?)
Posted by "Albrecht F.Leiprecht" <al...@mail.ccc-casino.com>.
> > > 1. Adabas only accepts 18 Characters for the Tablename.
> > > Some Turbine tablenames are longer than that. Any Suggestions ??
>
> How does it deal with long table names? Truncation? Explosion?
It truncates it...
> > > 2. In TURBINE_SCHEDULED_JOB there are 3 Fields with reserved words...
> > > MINUTE, SECOND, HOUR
> Ugh.
I don't have enough knowledge about the dependencies..
So I'm not changing anything there... Although for test purposes I did...
> > 3. VARCHAR is max.size 254
> #2 and #3 require schema changes (perhaps #1, too?). I am in favor of
> seeing Turbine work "out of the box" on as many DBs as possible, so
> would be okay with this. However, it means upgrade scripts, which
> aren't currently supported in a generic fashion...thoughts?
I will look into it. If I'm able to contribute something... I will :)
If somebody besides me wants to test it ... I have the Personal edition (10
Conns)
which comes free with Suse Linux...
so long
albi
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: ADABAS D and Turbine (not possible ?)
Posted by Daniel Rall <dl...@collab.net>.
"Albrecht F.Leiprecht" <al...@mail.ccc-casino.com> writes:
> > 1. Adabas only accepts 18 Characters for the Tablename.
> > Some Turbine tablenames are longer than that. Any Suggestions ??
How does it deal with long table names? Truncation? Explosion?
> > 2. In TURBINE_SCHEDULED_JOB there are 3 Fields with reserved words...
> > MINUTE, SECOND, HOUR
Ugh.
> 3. VARCHAR is max.size 254
> That means together with (1.) The line in the id_table-schema.xml
> should be adjusted also :-)
> <column name="TABLE_NAME" required="true" size="18" type="VARCHAR"/>
> because 254 would be wasted here :)
#2 and #3 require schema changes (perhaps #1, too?). I am in favor of
seeing Turbine work "out of the box" on as many DBs as possible, so
would be okay with this. However, it means upgrade scripts, which
aren't currently supported in a generic fashion...thoughts?
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org
Re: ADABAS D and Turbine (not possible ?)
Posted by "Albrecht F.Leiprecht" <al...@mail.ccc-casino.com>.
> 1. Adabas only accepts 18 Characters for the Tablename.
> Some Turbine tablenames are longer than that. Any Suggestions ??
>
> 2. In TURBINE_SCHEDULED_JOB there are 3 Fields with reserved words...
> MINUTE, SECOND, HOUR
3. VARCHAR is max.size 254
That means together with (1.) The line in the id_table-schema.xml
should be adjusted also :-)
<column name="TABLE_NAME" required="true" size="18" type="VARCHAR"/>
because 254 would be wasted here :)
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org