Re: SAPDB/MAXDB ODBC drivers

2004-09-23 Thread Ajit Aranha
Hi, Got the latest MAXDB odbc drivers of the http://dev.mysql.com/downloads/maxdb/clients.html. These seem to be very outdated. (Nov 2003).And upon testing has the memory leak bugs I mentioned earlier. The latest sapdb driver available is ftp://ftp.sap.com/pub/sapdb/bin/win/odbc75.00.12-setup

AW: Stored procedures and Cocoon (jdbc)

2004-09-23 Thread Anhaus, Thomas
Oscar Picasso wrote : > >Hi, > >I use MaxDB with Cocoon, the XML/Web Application framework, >and came across >something strange. > >If I call a MaxDB a recently modified stored procedure from >Cocoon (with jdbc) >I get the results that would have been returned by the old >version of the >proced

SAPDB/MAXDB ODBC drivers

2004-09-23 Thread Ajit Aranha
Hi, The last release of sapdb odbc drivers have some serious showstopper bugs i.e. bad memory leaks and crashes on freeing timed out connections. Is there a release of LGPL SAPDB drivers that work with 7.3 planned. I believe these problems are fixed in the last maxdb ODBC driver release.

Stored procedures and Cocoon (jdbc)

2004-09-23 Thread Oscar Picasso
Hi, I use MaxDB with Cocoon, the XML/Web Application framework, and came across something strange. If I call a MaxDB a recently modified stored procedure from Cocoon (with jdbc) I get the results that would have been returned by the old version of the procedure. However the data returned is uptod

latest 7.4 [was: RE: boolean fields in where clause]

2004-09-23 Thread Döhr, Markus ICC-H
> Please send me the link. ftp://ftp.aubi.de/pub/sapdb/SAPDB/sapdb-server-win-32bit-i386-7_4_3_35.tar.b z2 Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA Tel.:+49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.s

Re: boolean fields in where clause

2004-09-23 Thread Michael MacIntyre
Hi Markus. Yes. Interested, and appreciative. Please send me the link. Many thanks. Michael MacIntyre Döhr, Markus ICC-H wrote: [...] I am using ver. 7.4.3.32 (the last release of 7.4) Win XP SP2 AMD Athlon 2100+ 512M RAM This is NOT the latest version, obviously they didn't publish the

boolean fields in where clause

2004-09-23 Thread Michael MacIntyre
Hello. I do apologize if this (or like it) has been brought up before (or is explained in the documentation and I was simply unable to grasp it) - I found nothing on the list. - I have a table (duh!) and I added a field (called deleted) of type boolean. - I set no default value. - I ran an updat

RE: AW: Optimising SapDB

2004-09-23 Thread Döhr, Markus ICC-H
> You mean the parameter CACHE_SIZE - right? Yes - in 7.5 the name is CACHE_SIZE - in older Versions it was called DATA_CACHE > What about the parameters MAXSERVERTAKS and _IOPROCS_PER_DEV ? MAXSERVERTASKS are the tasks for the "server" for example writes the changed out of DATA_CACHE data to th

Re: AW: Optimising SapDB

2004-09-23 Thread Michael Jürgens
Hello Elke, thank you very much for your response. Some Questions about your answer: Zabach, Elke wrote: Michael Jürgens wrote: Hi, we have a application which should handle a large amount of inserts in a very short time. I´m relative new to sadb database management. Can anybody give me a hint wha

RE: Stored procedure documentation

2004-09-23 Thread Jason L. West, Sr.
Elke, Thanks for the info on the documentation. I guess what I am looking for is something that maybe O'reilly would publish like "MaxDB Cookbook" or "MaxDB Programming". The manual that comes with the software is very difficult to follow at times and provides little to now real world examples.

MaxDB / MoreDB?

2004-09-23 Thread Kaldewey Malte
Hello @ all, what's the different between MaxDB and MoreDB? I've read it in a Documentation on: https://www.sdn.sap.com/content_documents/MaxDB%20by%20MySQL%20Inside%20 SAP.pdf With best regards Malte -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscr

maxDB web admin problem

2004-09-23 Thread Alexander Swen
Hi I was getting a "connection refused" error on http://as81376b:/(webdbm and websql and waadmin) wahttp was stopped (don't know reason) when starting: as81376b:/opt/sdb/programs/web/pgm # ./wahttp ./wahttp: error while loading shared libraries: libwapi.so: cannot open shared object file: N

bug with foreign keys

2004-09-23 Thread Thomas Markus
Hi, i got a problem with foreign keys in 7.4.3-032 2 tables with 2 fks if i run ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_1 ( REFCOL1 ) REFERENCES TABLE2 (ID) ON DELETE RESTRICT; ALTER TABLE TABLE1 ADD FOREIGN KEY FBTABLE1_2 ( REFCOL1 ) REFERENCES TABLE2 (ID)

AW: Optimising SapDB

2004-09-23 Thread Zabach, Elke
Michael Jürgens wrote: > > Hi, > > we have a application which should handle a large amount of inserts in a > very short time. > I´m relative new to sadb database management. > Can anybody give me a hint what are the most relevant db parameters for > handling a large number of inserts? > We are

AW: Stored procedure documentation

2004-09-23 Thread Zabach, Elke
Jason L. West, Sr. Wrote: > > I have been looking for the same thing and it is keeping me from using the > server in a production environment. If there is any documentation for > writing stored procedures for this platform, SAP or MaxDB I would > appreciate > a heads up also. > Please have a loo

RE: ArrayIndexOutOfBounds error when writting blob data...

2004-09-23 Thread Paskamp, Marco
Hi, the JDBC driver you are using seems to be out-of-date. Please try a newer driver available at: http://dev.mysql.com/downloads/maxdb/clients.html Please let me know if this solves your the problem. Regards, Marco -- Marco PASKAMP SAP DB, SAP Labs Be

ArrayIndexOutOfBounds error when writting blob data...

2004-09-23 Thread Michael Seidel
Hi, We're using SAPDB 7.3.0 Build 040-000-091-773 on JBoss 3.2.x and the following JDBC Driver (sapdb-jdbc-bin-7.4.03.06a.jar) Problem: ArrayIndexOutOfBoundsException while updating a table containing two blobs in a row, a timestamp and two strings (varchar) The Code: PreparedStateme