Hi Martin,
first answer.
Martin Bartosch wrote:
As far as I know SQL command concatenation is not possible using many SQL interfaces when using the native bind mechanism. Oracle OCI does NOT support it, and if I remember correctly, it is also not supported explicitly by Perl DBI. If it works for, say, mysql, you should consider it as a bug.
So please don't use ';' to concatenate SQL queries via Perl DBI!
Accepted.
this is a good questions ;)The major issue which is not really clear for me is the transaction handling if you use more than one table. You can use different types of backends for tables in one database. So how should the transaction stuff work under such circumstances? This is the reason why I don't use mysql. If somebody can explain this to me then I would use mysql too.
This depends on the "transaction isolation level" that is set for the database instance. Mysql supports all levels, but only for InnoDB. Oracle supports all levels, of course. Please google for the term and you will get some information about it.
We still use BDB. If I remember correctly then Michael Konietzka requested such a change some time ago too. Does it be enough if I change "Type=BDB" to "Type=InnoDB"? If this makes sense then I would this.
Michael -- _______________________________________________________________
Michael Bell Humboldt-Universitaet zu Berlin
Tel.: +49 (0)30-2093 2482 ZE Computer- und Medienservice Fax: +49 (0)30-2093 2704 Unter den Linden 6 [EMAIL PROTECTED] D-10099 Berlin _______________________________________________________________
------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
