I'm interested in implement connection pooling on oracle...
I just need some info about creating dllimport functions....
The C function is :
OCIOCIConnectionPoolCreate((OCIEnv *)envhp,
(OCIError *)errhp, (OCICPool *)poolhp,
&poolName, &poolNameLen,
(text *)database,strlen(database),
(ub4) conMin, (ub4) conMax, (ub4) conIncr,
(text *)pooluser,strlen(pooluser),
(text *)poolpasswd,strlen(poolpasswd),
OCI_DEFAULT));
i've began :
//fongarnand
[DllImport ("oci")]
internal static extern int
OCIConnectionPoolCreate(IntPtr envhp,
IntPtr errhp, IntPtr poolhp, ...
But i don't know wich datatype to use...
Le Lundi 28 F�vrier 2005 13:55, Daniel Morgan a �crit�:
> Sure, you can implement. We accept patches.
>
> You could look at System.Data.SqlClient on how it does connection pooling.
>
> Another way is to use some OCI functions for connection pooling. So,
> you might have to create DllImport functions for these OCI functions.
>
> Oracle 9i Call Interface Programmer's Guide
> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96584/oci15re
>2.htm#556061
>
> OCIConnectionPoolCreate
> OCIConnectionPoolDestroy
>
> Hubert FONGARNAND wrote:
> >Thank you for your fix... It works now without any problems...
> >Just a question, do you plan to implement connection pooling on oracle
> > client classes. I've seen that dealing with oracle database works well
> > with mono (now) but it's much more slower than MS.NET when you open and
> > close many connections... Is there a way to speed up this process.
> >I'm ready to help you implementing this, if you need...
> >
> >Le Samedi 26 F�vrier 2005 05:38, vous avez �crit :
> >>I recently committed a fix to svn trunk HEAD for strings in
> >>OracleParameter to use OCIUnicodeToCharSet for Oracle data types dates,
> >>CLOBs, VARCHAR2/CHAR, etc...
> >>
> >>Can you try your tests again to see if they work now? I do not know
> >>French to test the changes. :-)
> >>
> >>Hubert FONGARNAND wrote:
> >>>Thanks to Daniel Morgan
> >>>DataTime and OracleDateTime works now perfectly. There's still a problem
> >>>with charset.When my NLS_LANG variable isn't set (on my mono client),
> >>>french "��" are seen as "??" in the database (MS.NET client see "??").
> >>>The only way to display the "��" correctly is to set my NLS_LANG to :
> >>>NLS_LANG="FRENCH_FRANCE.UTF8" (but normally, the client should adapt
> >>>itself to the server settings)
> >>>but there's still a problem with string length. eg: when I do an
> >>> "INSERT" with a string with some "��" the string is "cut" by oracle, so
> >>> I can not see the entire string in the database...
>
> _______________________________________________
> Mono-list maillist - [email protected]
> http://lists.ximian.com/mailman/listinfo/mono-list
--
Hubert FONGARNAND
Fiducial IT
_______________________________________________
Ce message et les �ventuels documents joints peuvent contenir des informations
confidentielles.
Au cas o� il ne vous serait pas destin�, nous vous remercions de bien vouloir
le supprimer et en aviser imm�diatement l'exp�diteur. Toute utilisation de ce
message non conforme � sa destination, toute diffusion ou publication, totale
ou partielle et quel qu'en soit le moyen est formellement interdite.
Les communications sur internet n'�tant pas s�curis�es, l'int�grit� de ce
message n'est pas assur�e et la soci�t� �mettrice ne peut �tre tenue pour
responsable de son contenu.
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
