RE: transaction delete problem

2004-03-16 Thread Anhaus, Thomas
Oscar Radio wrote : >Hi all, > I have a strange problem with transactions and deletes with foreign keys. >I have these tow tables: Table A) > Code numeric(10) primary key, > description varchar(20) >

Error creating instance

2004-03-16 Thread Zavier Sheran
I created a new instance on RH9 with 50GB of diskspace available, and I get this error. Date Time TID Typ MsgID Label Message-Text 2

Problems with loadercli

2004-03-16 Thread Andris Spruds
Hello, In the beginning I created all my tables/etc as DBA user. However, now I would like to deploy my application, so obviously I need to migrate all my data to a regular user, which has no administrative permissions. I tried using loadercli, but it complains that 'Error 25109 Command not implem

Re: upgrading minor kernel versions

2004-03-16 Thread Daniel Dittmar
Ajit Aranha wrote: Hi, Can someone quickly give me info on updgrading my database kernel from 7.3.0.30 to 7.3.0.47. Just call SDBUPD instead of SDBINST and you'll get a menu of updatable databases. where is the kernel change log located?? http://www.sapdb.org/new_relinfo.txt Daniel Dittmar -- D

FW: REQTIMEOUT in lockstatistics & db deadlocks detection

2004-03-16 Thread Ajit Aranha
: Contents of lockstatistics. : can someone tell me why REQTIMEOUT is null?? I cant figure out why the db deadlocked in this case. So if u have any ideas mail me. "1552"," 4671799","48","ONMOBILE","20040316","00182223","onmumhuttel

REQTIMEOUT in lockstatistics

2004-03-16 Thread Ajit Aranha
Hi, I'm running 7.3.30 and running into deadlocks. Can someone tell me why REQTIMEOUT can be null (?) in LOCKSTATISTICS TABLE?? My clients (jdbc) block forever or until the db is restarted. regards, Ajit

script to db instance

2004-03-16 Thread Andrew Zhu
New to MaxDB. Installed 7.5.0.8 on win xp. everything is fine. when create an instance, the approach of script doesn't work. it prints OK on the screen and exit. No actual database directory is installed on data/wrk/. However use the same commands without a script (ie within dbmcli) to set the pa

RE: Problem after updating JDBC driver to JDBC 3.0

2004-03-16 Thread rweiss
Hello Alexander, thanks for quick answer! Looks like I have to forward it to the OJB users list as we do access over this layer and we changed the ojb release, too. Best Regards, Rüdiger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http:/

Re: Problem with LONG BYTE

2004-03-16 Thread Ertan Kucukoglu
Dear Thomas, After I investigate in detail. I realize that picture of my first record was previously distorted. So, it was a wrong alarm. Somebody played with my picture files on the server I guess. Sorry for the inconvenience. Ertan Küçükog(lu [EMAIL PROTECTED] Ozler Plastik San. ve Tic. A.S.

RE: Problem after updating JDBC driver to JDBC 3.0

2004-03-16 Thread Schroeder, Alexander
Hello Rüdiger, there is no row number 0 in a result set, as row numbers start with 1 in result sets. Your application seemed wanting to navigate to the row 0. Regards Alexander Schröder SAP DB, SAP Labs Berlin > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >

Problem after updating JDBC driver to JDBC 3.0

2004-03-16 Thread rweiss
Hi all, we use apache ojb as persistence layer in our application. Querying our data we retrieve the exception below after updating the jdbc driver to the following version: Manifest-Version: 1.0 Created-By: Apache Ant 1.5 Main-Class: com.sap.dbtech.jdbc.DriverSapDB Name: com/sap/dbtech/jdbc/

FW: upgrading minor kernel versions

2004-03-16 Thread Ajit Aranha
Hi, Oops i meant 7.3.0.46. Do i just install one kernel upon the other?? Is there anything else i need to do? Can anyone tell me where the changelog is located ?? regards, Ajit -Original Message- From: Ajit Aranha [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 6:35 PM To: '[EMA

upgrading minor kernel versions

2004-03-16 Thread Ajit Aranha
Hi, Can someone quickly give me info on updgrading my database kernel from 7.3.0.30 to 7.3.0.47. where is the kernel change log located?? Regards, Ajit

AW: Compilation error while compiling MaxDB 7.5.0.8

2004-03-16 Thread Brunzema, Martin
Hi, if you are compiling under WindowsXP the solution will be to run the pascal-compiler in windows-2000 compatibility mode. You can do this via the properties-dialog. regards, Martin -Ursprüngliche Nachricht- Von: Niranjan K. [mailto:[EMAIL PROTECTED] Gesendet: Montag, 15. März 2004 1

Re: Help! BIG Memoryleak in Pythondriver

2004-03-16 Thread Andre Reitz
On Mon, 15 Mar 2004 15:31:29 +0100 Andre Reitz <[EMAIL PROTECTED]> wrote: > On Fri, 12 Mar 2004 17:27:12 +0100 > "Dittmar, Daniel" <[EMAIL PROTECTED]> wrote: > > > > > I've updated the python modules: > > Linux: ftp://ftp.sap.com/pub/sapdb/bin/linux/sapdb-python-linux-i386-7.4.03.33a.tgz > > Win

Deadlock detection

2004-03-16 Thread Ajit Aranha
Hi, sapdb version: 7.3.0.30 I have a problem where multiple threads deadlock on a table of my DB.(these clients block forever) Is it possible to improve the deadlock detection using db parameters. Regards, Ajit P.S.: It becomes impossible to bring the db offline in this case. Is there a workaround

transaction delete problem

2004-03-16 Thread Oscar Radio
Hi all, I have a strange problem with transactions and deletes with foreign keys. I have these tow tables: Table A) Code numeric(10) primary key, description varchar(20) values: