headers
Sven Köhler | 2 Jan 2005 21:05
Picon

compiling DBD::MaxDB

Hi,

i've spent the last few hours to write an ebuild for gentoo linux, that 
compiles and installs DBD::MaxDB. Since there is no ebuild for the 
SQLDBC, i tried to link DBD::MaxDB statically against SQLDBC, but i failed.

I'd like the following to be improved:

- the makefile copies libSQLDBC_C.so to 
/usr/lib/perl5/vendor_perl/5.8.4/i686-linux/auto/DBD/MaxDB/libSQLDBC_C.so.
That place is not searched automatically. Either don't copy it there, or 
instruct Perl somehow, to search that place for the library (i don't 
know, if this is possible)
- There is a libSQLDBC.a, but no libSQLDBC_C.a - why? If i'd had a 
libSQLDBC_C.a, i could statically link it into MaxDB.so. You could than 
add an option to Makefile.PL, so that it does not use libSQLDBC_C.so but 
libSQLDBC_C.a instead

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 | 2 comments |
headers
Sven Köhler | 2 Jan 2005 21:34
Picon

Re: compiling DBD::MaxDB

> - There is a libSQLDBC.a, but no libSQLDBC_C.a - why? If i'd had a 
> libSQLDBC_C.a, i could statically link it into MaxDB.so. You could than 
> add an option to Makefile.PL, so that it does not use libSQLDBC_C.so but 
> libSQLDBC_C.a instead

Ohh, i see: libSQLDBC_C.so is a C++ library. Well. how independant is 
the SQLDBC source tree? Could you release the source of the SQLDBC 
library as a seperate package with a neat configure script?

--

-- 
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
Grossmann, Gert | 3 Jan 2005 10:04
Picon
Favicon

AW: OPTIM_CACHE and implications?

Implication as explained(YES:.../NO:...). Therefore we save time for detection of execution plan. The
optimizer works a little bit like a rule based optimizer (unlike our cost based optimizer). If an access
path is good for a query use it for every query with same query template (query w/o parameters). 
IMHO you should set OPTIM_CACHE=YES if you have steady data base and steady queries against this database.
If you have dynamic data base and vary parameters on same query templates this could lead to bad query
execution plans.

Gert

-----Ursprüngliche Nachricht-----
Von: Holger Schurig [mailto:hs4233 <at> mail.mn-solutions.de] 
Gesendet: Donnerstag, 30. Dezember 2004 11:18
An: maxdb <at> lists.mysql.com
Betreff: OPTIM_CACHE and implications?

Hmm, what are the implications of setting parameter OPTIM_CACHE to YES?  
The default is NO.

-----------------
Used to optimize strategy detection (YES/NO)
EXPLAIN
 OPTIM_CACHE 'YES' or 'NO'

 'YES': strategy is only detected once for a parsed statement

 'NO' : strategy is detected at every execution of a parsed statement
-----------------

THis help from "dbmcli -d TST -u dba,dba param_getfull OPTIM_CACHE" did 
not really tell anything. Why is it set to NO, does the cache use too
(Continue reading)

Permalink | Reply | 1 comment |
headers
Zabach, Elke | 3 Jan 2005 10:23
Picon
Favicon

AW: MaxDB fetch into problem with concatenated data in oracle mode with embedded SQL statment in C/C++ programs (vtrace atachment error)

Elbertus Lochtenberg wrote:
> 
> Dear reader,
> 
> I tried to attach the vtrace output file of the MaxDB crash using
> embedded SQL statements in ORACLE mode to the list mail message.
> 
> Because of the original vtrace file size, that in plain text format
> overrides the maximum size of the list mail message (40000 bytes), I
> converted this file in zip format, what didn't give the expected
> results. On the list you only can see rubbish as the zip file is shown
> in plain text format.
> 
> For that if anybody is interested in this vtrace file for
investigation,
> just send me a mail and I will send back the original vtrace file in
> plain text format.
> 
> Best Regards,
> 
> Elbertus Lochtenberg

Hi to all,
We can forget this vtrace as it only shows us that the server works as
expected and (as a private communication between precompiler-guy and
Elbertus shows) the problem is the way the precompiler is used.

Elke
SAP Labs Berlin
(Continue reading)

Permalink | Reply | 0 comments |
headers
Zabach, Elke | 3 Jan 2005 10:28
Picon
Favicon

AW: MaxDB fetch into problem with concatenated data in oracle mode with embedded SQL statment in C/C++ programs (vtrace atachment error)

Fabiano Rech wrote:
> 
> Hi!  forgives the question that must be a little tiring to all, but I
> can´t had success on migration of SapDB 7.3 to MaxDB 7.5.
> I followed all the steps in the message:
> http://lists.mysql.com/maxdb/23792 , but when in restore the
> backup I get the following error:
> 
> -24988 sql error [db_activate RECOVER "DBNAME"DATA]; -71, connection
> broken service state 6
> 
> Somebody knows where I can find good how to?
> 
> 
1. Please use a Subject-line which has something to do with the problem YOU have. Not everyone will read
every mail but pick those which seem to fall into his/her area.
2. What does knldiag says?

Please start over the topic with a new subject-line and the info 
Knldiag-output
7.3.00.xx version you used before
7.5.00.yy version you want to migrate to

Elke
SAP Labs Berlin

> 
> Thank´s !!!
> 
> Fabiano Rech
(Continue reading)

Permalink | Reply | 1 comment |
headers
ddschaefer | 3 Jan 2005 11:19
Picon
Favicon

JDBC transaction isolation level

hello,

I wanted to set the transaction isolation level of a jdbc connection to java.sql.Connection.TRANSACTION_READ_UNCOMMITTED.
As I discovered some error-messages like "too many lock requests" I wondered, why there are any
lock-requests when I use this isolation-level (dirty reads are ok for these queries).
I looked up the numerical constant of java.sql.Connection.TRANSACTION_READ_UNCOMMITTED and
realized, that it is "1". The manual of MaxDB states, that the numerical value "1" stands for the isolation
level committed and "0" is uncommitted. So there is an inconsistency between jdbc and MaxDB.
The jdbc-driver should translate the requested levels, because nobody uses the numeric values.

kind regards
daniel

--

-- 
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
ddsch001 | 3 Jan 2005 11:21
Picon
Favicon

jdbc transaction isolation level

hello, 

I wanted to set the transaction isolation level of a jdbc connection to
java.sql.Connection.TRANSACTION_READ_UNCOMMITTED. 
As I discovered some error-messages like "too many lock requests" I wondered, why there are any
lock-requests when I use this isolation-level (dirty reads are ok for these queries). 
I looked up the numerical constant of java.sql.Connection.TRANSACTION_READ_UNCOMMITTED and
realized, that it is "1". The manual of MaxDB states, that the numerical value "1" stands for the isolation
level committed and "0" is uncommitted. So there is an inconsistency between jdbc and MaxDB. 
The jdbc-driver should translate the requested levels, because nobody uses the numeric values. 

kind regards 
daniel 

--

-- 
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 | 2 comments |
headers
Paskamp, Marco | 3 Jan 2005 11:50
Picon
Favicon

RE: jdbc transaction isolation level

Hi Daniel,
The JDBC driver already does this translation. For details please have a
look at com.sap.dbtech.jdbc.DriverSapDB:

   static String
    isolevelJdbc2native (
        int isolevel)
    throws SQLException
    {
        String result;
        switch (isolevel) {
            case Connection.TRANSACTION_NONE:
            case Connection.TRANSACTION_READ_UNCOMMITTED:
                result = "0";
                break;
            case Connection.TRANSACTION_READ_COMMITTED:
                result = "1";
                break;
            case Connection.TRANSACTION_REPEATABLE_READ:
                result = "2";
                break;
            case Connection.TRANSACTION_SERIALIZABLE:
                result = "3";
                break;
            default:
                throw new
JDBCDriverException(MessageTranslator.translate(
                    MessageKey.ERROR_INVALIDTRANSACTIONISOLATION,
                    Integer.toString(isolevel)));
        }
(Continue reading)

Permalink | Reply | 0 comments |
headers
Fabiano Rech | 3 Jan 2005 17:02
Picon

Problems migration SapdDb to MaxDb.

I'm sorry Elke, I had click in reply, and forgot to change
subject, I´m so sorry.
Well, my knldiag.err its paste at end. current version:
Sapdb: 7.3.0.40
MaxDb version: 7.5.0.19

The original question is:

>Hi!  forgives the question that must be a little tiring to all, but I
>can´t had success on migration of SapDB 7.3 to MaxDB 7.5.
>I followed all the steps in the message:
>http://lists.mysql.com/maxdb/23792 , but when in restore the
>backup I get the following error:
>
>-24988 sql error [db_activate RECOVER "DBNAME"DATA]; -71, connection
>broken service state 6
>
>Somebody knows where I can find good how to?

--------Begin knldiag.err--------------------------
--------------------------------------------------------------------------------
Date Time TID Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2005-01-03 11:22:18 --- Starting GMT
2005-01-03 13:22:18 7.5.0 Build 019-121-082-363
2005-01-03 11:22:29 3025 ERR 11000 devopen Unknown file MODE
'/db/sapdb/SPDT/data/dat01.sap'
2005-01-03 11:22:29 3025 ERR 11000 d0_vatta Cannot open volume, Bad
file descriptor
2005-01-03 11:22:29 3025 ERR 11000 d0_vatta Volume name
(Continue reading)

Permalink | Reply | 0 comments |
headers
Robert Klemme | 3 Jan 2005 17:45
Picon

Re: jdbc transaction isolation level

> hello, 
> 
> I wanted to set the transaction isolation level of a jdbc connection to
> java.sql.Connection.TRANSACTION_READ_UNCOMMITTED. 
> As I discovered some error-messages like "too many lock requests" I
> wondered, why there are any lock-requests when I use this isolation-level
(dirty
> reads are ok for these queries). 

Could be a bug or a problem with currently held locks.

> I looked up the numerical constant of
> java.sql.Connection.TRANSACTION_READ_UNCOMMITTED and realized, that it is
"1". The manual of MaxDB states, that
> the numerical value "1" stands for the isolation level committed and "0"
> is uncommitted. So there is an inconsistency between jdbc and MaxDB. 
> The jdbc-driver should translate the requested levels, because nobody uses
> the numeric values. 

What makes you think that it doesn't?

robert

-- 
+++ Sparen Sie mit GMX DSL +++ http://www.gmx.net/de/go/dsl
AKTION für Wechsler: DSL-Tarife ab 3,99 EUR/Monat + Startguthaben

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
(Continue reading)

Permalink | Reply | 1 comment |

Gmane