headers
Sven Köhler | 1 Jan 2006 04:29
Picon

Re: Problem with "ON DELETE SET NULL"

> Why can't I define these two foreign keys? I did not find any restrictions in 
> the docs describing this behavior.

A long time ago, i already reported this. I don't remeber which answer i
got - or if there was any answer at all.

But i really agree with you: why isn't it possible to have 2 foreign-keys?

But wait: have you checked the behaviour of 7.6.0.16?
I didn't do that yet.

Thx
  Sven

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Hermann Mundprecht | 1 Jan 2006 10:57
Picon

Re: compiling maxdb 7.6.0.16 with gcc 3.4.4

Hi !

I found a workaround for this by removing the -fPIC Compiler option from
devtools/bin/toolvars.pl. But i don't know if this is a good idea but it
makes the build possible.
But i still would like to have some asm expert tell me why gcc thinks
that the ebx - register is destroyed even if it pushed before the
operation and poped afterwards.

regards Hermann 

Am Samstag, den 31.12.2005, 12:50 +0100 schrieb Hermann Mundprecht:
> Hi !
> 
> I am currently working on an gentoo ebuild for maxdb 7.6.0.16.
> As gentoo developers decided to switch to gcc version 3.4.4 i am also
> switching the build process of maxdb to gcc 3.4.4.
> 
> For a complete build i had to change the following files:
> src/SAPDB/RunTime/System/RTESys_AtomicOperation.c
> src/SAPDB/RunTime/Communication/RTEComm_URIBuilder.hpp
> src/SAPDB/Interfaces/Runtime/Util/IFRUtil_LinkedList.h
> src/SAPDB/ServerTasks/SrvTasks_JobList.hpp
> src/SAPDB/DataAccess/Data_ChainSplitSpaceBackwardRead.hpp
> src/SAPDB/DataAccess/Data_ChainSplitSpaceForwardRead.hpp
> 
> I will of course send the patches as soon as i have a complete build,
> but for now i need help with the file RTESys_AtomicOperation.c.
> 
> The compiler gives the following errors:
(Continue reading)

Permalink | Reply | 0 comments |
headers
Martin Cordova | 2 Jan 2006 17:05
Picon

Re: Problem with "ON DELETE SET NULL"

Yes, although not a very common case, in yours looks 100% justified.
Maybe you did hit a MaxDB limitiation or a bug. Let's wait to see what
SAP people have to say about it. Did you try with another type of
on-delete-action instead of set null?

Regards & hapy new year,
Martin Cordova
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com

On 1/2/06, Sven Köhler <skoehler <at> upb.de> wrote:
> > I don't think it is because of the number of FKs, I have tables with 2
> > FKs on MaxDB 7.6. I suspect the cause is the fact that both FKs refer
> > to the same table.
>
> Oh, you're possibly right. My 2 FKs were also referencing the same
> table. But that should still be possible, don't you think?
>
>
>
>

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org
(Continue reading)

Permalink | Reply | 1 comment |
headers
Ralf Schneider | 2 Jan 2006 17:18
Picon

Re: Problem with "ON DELETE SET NULL"

Am Montag, 2. Januar 2006 17:05 schrieb Martin Cordova:
> Yes, although not a very common case, in yours looks 100% justified.
> Maybe you did hit a MaxDB limitiation or a bug. Let's wait to see what
> SAP people have to say about it. Did you try with another type of
> on-delete-action instead of set null?

Yes, "ON DELETE CASCADE" works fine.

Ralf.

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org
Permalink | Reply | 0 comments |
headers
Martin Kittel | 2 Jan 2006 18:50
Picon

Re: compiling maxdb 7.6.0.16 with gcc 3.4.4

Hi Hermann,

> I am currently working on an gentoo ebuild for maxdb 7.6.0.16.
> As gentoo developers decided to switch to gcc version 3.4.4 i am also
> switching the build process of maxdb to gcc 3.4.4.

I went through most of this while preparing the MaxDB Debian packages to compile
with gcc 4.0.

Probably most of the relevant patches can be found on the Debian alioth CVS
server, e.g.

http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/maxdb/debian/patches/72_cleanup_assembly.dpatch?rev=1.3&content-type=text/x-cvsweb-markup&cvsroot=pkg-maxdb
http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/maxdb/debian/patches/71_gcc4_compile_fixes.dpatch?rev=1.3&content-type=text/x-cvsweb-markup&cvsroot=pkg-maxdb

I also went of most of the motions to add the missing prototypes for the
buildtools, e.g. here:

http://cvs.alioth.debian.org/cgi-bin/cvsweb.cgi/maxdb-buildtools/debian/patches/42_add_missing_declarations.dpatch?rev=1.2&content-type=text/x-cvsweb-markup&cvsroot=pkg-maxdb

The files mentioned may not include everything you need but should cover most of
it (some fixes found their way into some of the other patches available on the
CVS server).

HTH,

Martin.

--

-- 
MaxDB Discussion Mailing List
(Continue reading)

Permalink | Reply | 1 comment |
headers
Hermann Mundprecht | 3 Jan 2006 00:16
Picon

Re: compiling maxdb 7.6.0.16 with gcc 3.4.4

Hi Martin !

Thanks a lot for posting your patches.
They are very similar to my patches for 3.4.4. Most valuable for me is
of course the asm patch as i did not really know if it was ok to remove
the edx register from the list and i was not happy with my workaround by
removing the -fPIC option.

I think i do not need all of your patches for 3.4.4.
As soon as i finished a successful build on both of my test systems i
will upload the ebuilds for gentoo and the patches to bugs.gentoo.org
and post a message here.

kind regards 

Hermann

Am Montag, den 02.01.2006, 17:50 +0000 schrieb Martin Kittel:

> Hi Hermann,
> 
> > I am currently working on an gentoo ebuild for maxdb 7.6.0.16.
> > As gentoo developers decided to switch to gcc version 3.4.4 i am also
> > switching the build process of maxdb to gcc 3.4.4.
> 
> I went through most of this while preparing the MaxDB Debian packages to compile
> with gcc 4.0.
> 
> Probably most of the relevant patches can be found on the Debian alioth CVS
> server, e.g.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Ralf Schneider | 3 Jan 2006 00:37
Picon

MaxDB with Hibernate 3.1

Hi,

I make some first experiments with Hibernate 3.1 and MaxDB 7.5.0.19. 
Everything works fine, but after some period of time I get an exception 
saying:

ERROR  [03.01.2006 00:13:20]  (JDBCExceptionReporter.java:72) - [-708] Timeout
org.hibernate.exception.JDBCConnectionException: could not execute query
	at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:72)
	at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.doList(Loader.java:2153)
[...]
Caused by: com.sap.dbtech.jdbc.exceptions.ConnectionException: [-708] Timeout
	at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:472)
	at 
com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapDB.java:1646)
	at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:783)
	at 
com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.java:234)
	at 
com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapDB.java:185)
	at 
com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.java:87)
	at 
com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:721)
	at 
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
	at
(Continue reading)

Permalink | Reply | 0 comments |
headers
JUNG, Christian | 3 Jan 2006 11:22

knldiag.err: BD550FieldQueue:PageLeak

Hello,

we had some problems in a SAP R/3-System running with a MaxDB 7.5.0.30 on
Linux. First I thought about some problems with the database and therefore
took a look in the log-files. 

I've found these messages which don't make much sense to me in 'knldiag':

---%<---
2006-01-02 11:04:36  6025     11577 COMMUNIC Cancel request for T91
2006-01-02 11:04:36  6036     53000 B*TREE   BD500: Next cancelled: 91
2006-01-02 11:04:36  6036 ERR 53000 OBJECT   BD550FieldQueue:PageLeak: 113
2006-01-02 11:04:36  6036 ERR 53000 OBJECT   BD550FieldQueue:PageLeak: 19
2006-01-02 11:04:36  6036 ERR 53000 OBJECT   BD550FieldQueue:PageLeak: 54
---%<---

I don't think that's the cause of the R/3-problem but I'm curious to get an
explanation of what happened there. The database runs fine, there a no
problems and a quick search via google didn't reveal anything. Do I have to
worry about these messages?

The exactly build is 'X32/LINUX 7.5.0 Build 030-121-100-791' running on SuSE
SLES 9 with Linux SMP-kernel 2.6.5-7 build 191.

Greets & a happy new year
Chris

phone: +49 6898/10-4987
fax: +49 6898/10-54987
http://www.saarstahl.de
(Continue reading)

Permalink | Reply | 0 comments |
headers
dbsupport | 3 Jan 2006 15:09
Favicon

Event Dispatcher questions (maxdb 7.6)

Did somebody already has experiences with the event dispatcher of maxdb?
I`m running into some problems:
I want to catch the event OUTOFSESSIONS, so i add this event to the event dispatcher (first i changed the
defaultvalue from _MAXEVENTTASKS (2) up to 10.)

dbmevtdisp add <foo.cfg> Name == OUTOFSESSIONS Priority == MEDIUM Command == "bash -c \"do something \""

Result is:
OK

okay, let see what the eventconfigfile says:

dbmevtdisp list <foo.cfg>

ID 0
        condition: ((Name == "OUTOFSESSIONS") && (Priority == MEDIUM))
        Command: bash -c "do something"

okay, force the database with too many user-requests and look what happend:

event with name OUTOFSESSIONS not dispatched (count 1)
event with name OUTOFSESSIONS not dispatched (count 2)

maybe we did something wrong, which events are activated?!

dbmcli -d <FOODB> -u <USER,PASS> event_list
OK

result:
(Continue reading)

Permalink | Reply | 0 comments |
headers
HALLER, KEVIN M (SBCSI | 3 Jan 2006 17:15
Picon
Favicon

How to Install MaxDB?

Hi.
I just installed SAP NetWeaver SP 14.  My company has a licensed version
of the NW software.

I like to now install "MaxDB" and "SQL Studio".  Do you have install
procedures that you can send me?

Thanks,
Kevin

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org
Permalink | Reply | 0 comments |

Gmane