AW: Incorrect Query Result

2005-03-03 Thread Ryan Warnick
Here is a simple test case that reproduces the problem. This returns all rows in the T1 table, when it should only return one. If you change the LIKE expression to only have a trailing wildcard, then it returns the correct result. The index on the field (F4) that the LIKE expression is applied t

tip of SAPDB parameters to achieve best performance on a machine.

2005-03-03 Thread Clóvis Wichoski
Hi, Here I have a SapDB 7.3.40 installed and running on a RedHad Linux with a Dual XEON (HT) 2.8G processor, 2GB of RAM, and I have doubts, on how to best configure the parameters to achieve the best performance in this machine. The database runs alone in this, machine. any tip? how much sessio

RE: SAPDB Technical Courses

2005-03-03 Thread Dittmar, Daniel
>I apologize for this non-technical question but I have found >references to >two SAPDB classes that would be very useful for data base >administrators and >developers. However, neither the SAP or MaxDB websites contain any >information on these courses. MaxDB course offered by SAP are only par

Re: How to configure a MaxDB connection pool within Websphere 6

2005-03-03 Thread Quint Van Deman
I appear to have found my problem. By making two changes: 1. Changing the 'implementation class name' to: com.sap.dbtech.jdbcext.XADataSourceSapDB 2. Setup a JCA authentication alias for username/password combination I can now connect to the datasource successfully using Websphere's 'Test Connectio

RE: jdbc driver: should a copy ...

2005-03-03 Thread Dittmar, Daniel
>Subject: jdbc driver: should a copy ... > >be placed in each webapp's web-inf/lib folder so it >instantiates its own >copy of the jdbc driver? Right now I have a single copy in the >common/lib >but I experience lags and temp space growth that runs amuck essentially >causing DoS. I don't think h

RE: Please Help! Pythondriver says: ERR -11608 COMMUNIC sql03_request: wrong connection state, state is 'requested'

2005-03-03 Thread Dittmar, Daniel
>so I am pretty sure that there is a big bug uin the python-driver >(Perhaps a threading-proble or a global variable , ) > >could you please give me a hint where the problem could be located? Try the following: - call sql03_init_multi_threaded in vin77.c:initializeRTE after the call to sqlinit

Re: How to configure a MaxDB connection pool within Websphere 6

2005-03-03 Thread Quint Van Deman
Just a self update for the benefit of anyone else who might encounter this in the future, but through some digging I found a sparsely documented parameter named 'enable2Phase' with possible values of true/false. Keying on the original exception of: DSRA8101E: DataSource class cannot be used as one

AW: Incorrect Query Result

2005-03-03 Thread Grossmann, Gert
Please provide a simple test case with data. Gert -Ursprüngliche Nachricht- Von: Ryan Warnick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 2. März 2005 22:16 An: maxdb@lists.mysql.com Betreff: Incorrect Query Result There seems to be a problem with using LIKE expressions with a leadi

RE: Plan to support solaris/AMD

2005-03-03 Thread Döhr, Markus ICC-H
> ... furthermore there is a change to > compile by myself the source code > for solaris/amd? We (employee from Sun) and me are trying to get it run... There are some compiler issues and a libc.so issues we're trying to resolve. See the archive for process. Greetz, SIEGENIA-AUBI KG Informati

Plan to support solaris/AMD

2005-03-03 Thread Stefano Ghezzi
... furthermore there is a change to compile by myself the source code for solaris/amd? thanks in advance -- Stefano Ghezzi ICTeam S.p.A tel 035 4232129fax 035 4522034 email [EMAIL PROTECTED] ur

Problem when data loaded after stored proc defined

2005-03-03 Thread Fabrice Bourdel
Hello, I found a problem and whish to known if there is another solution for it. I use MaxDb 7.5.0.23, on Linux (but same problem on a WinXp system) I have a database script witch : 1 create domains 2 create tables (and indexes) 3 create views 4 creates stored procedures 5 insert "standard

RE: Optimization for system file question

2005-03-03 Thread Fabrice Bourdel
> -Message d'origine- > De : Döhr, Markus ICC-H [mailto:[EMAIL PROTECTED] > Envoyé : mardi 1 mars 2005 19:12 > À : 'Fabrice Bourdel'; 'maxdb' > Objet : RE: Optimization for system file question > > > > What is the best system file for a MaxdbDatabase ? > > This really depends... > > > I h

Re: AW: Function gone/lost

2005-03-03 Thread Dirk Zugenmaier
Hi Thomas, I knew, I had forgotten something... we are currently using MaxDB 7.5.00.23 on Linux Another weired thing: I can create a Function using "create public function foo", I can use it and I can delete it with "drop public function foo". But after dropping it, I cant reuse that name with a

AW: Use of user defined functions in views

2005-03-03 Thread Anhaus, Thomas
Gert de Boer wrote : > >Hi, > >We are trying to include user defined functions in views, but >do not succeed. > >Example: > >create or replace view blubber >as >select test('hello') >from dual > >The error message is: > >General error;-9205 POS(1) System error: AK Catalog >information not found:0

RE: INTERNAL time format

2005-03-03 Thread Becker, Holger
David Taylor wrote: > Simple question. In the INTERNAL time format, "MMSS", > what on earth > are the first two digits used for? > > In every test I've performed and every example I've seen, the > first two > digits are always 00. I'm wary of assuming they'll always be > 00, but I > can'