Re: [GS/SS Beta] SQL support from GLASS

Dale,

As far as SQL database connectivity goes, we have a commercial product called GemConnect[1] that provides connectivity to Oracle.

Other than that I suppose that something like DBXTalk can be ported to GemStone ... I haven't looked at DBXTalk, but at least with the FFI support GemStone 3.x it should be easier to get the port working...

Dale

[1] http://community.gemstone.com/display/GSS64/GemConnect+2.2.x+Documentation
[2] http://dbxtalk.smallworks.com.ar/

----- Original Message -----
| From: "Dario Trussardi" <[hidden email]>
| To: "beta discussion Gemstone Seaside" <[hidden email]>
| Sent: Saturday, March 23, 2013 5:26:35 AM
| Subject: [GS/SS Beta] SQL support from GLASS
|
| Ciao,
|
| i need to do demo how to interface GLASS  with SQL database.
|
| Can someone help me to understand the state of the art in this regard?
|
| Thanks for any considerations,
|
| Dario
|

I do some test for integrate DBXTalk

I do not know too much about gemstone. But I'm pretty sure it includes metacello. You can try evaluating the following expression to install opendbx 1.2:

Gofer it

    url: 'http://www.smalltalkhub.com/mc/DBXTalk/DBXTalkDriver/main';

    package: 'ConfigurationOfOpenDBXDriver';

    load.

I load it into Gemstone.

When execute:

((Smalltalk at: #ConfigurationOfOpenDBXDriver) project version: '1.2') load.

the system answer:

'a Halt occurred (error 2709), Debug Warning: Warning: The following definitions had errors while loading.  Press Proceed to try to load them again (they may work on a second pass):

  OpenDBXUnix>>apiBind:database:name:password:method:

  OpenDBXUnix>>apiError:number:

  OpenDBXUnix>>apiErrorType:number:

  OpenDBXUnix>>apiFinalize:

  OpenDBXUnix>>apiGetOption:option:value:

  OpenDBXUnix>>apiInitialize:backend:host:port:

  OpenDBXUnix>>apiOpenLarge:handle:value:

  OpenDBXUnix>>apiQuery:query:length:

  OpenDBXUnix>>apiQueryColumnLength:index:

  OpenDBXUnix>>apiQueryColumnName:index:

  OpenDBXUnix>>apiQueryColumns:

  OpenDBXUnix>>apiQueryColumnType:index:

  OpenDBXUnix>>apiQueryFetchRow:

  OpenDBXUnix>>apiQueryFieldValue:index:

  OpenDBXUnix>>apiQueryFinalize:

  OpenDBXUnix>>apiQueryResult:handle:timeout:chunk:

  OpenDBXUnix>>apiQueryRowsAffected:

  OpenDBXUnix>>apiSetOption:option:value:

  OpenDBXUnix>>apiUnbind:

  OpenDBXWin32>>apiBind:database:name:password:method:

  OpenDBXWin32>>apiError:number:

  OpenDBXWin32>>apiErrorType:number:

  OpenDBXWin32>>apiFinalize:

  OpenDBXWin32>>apiGetOption:option:value:

  OpenDBXWin32>>apiInitialize:backend:host:port:

  OpenDBXWin32>>apiOpenLarge:handle:value:

  OpenDBXWin32>>apiQuery:query:length:

  OpenDBXWin32>>apiQueryColumnLength:index:

  OpenDBXWin32>>apiQueryColumnName:index:

  OpenDBXWin32>>apiQueryColumns:

  OpenDBXWin32>>apiQueryColumnType:index:

  OpenDBXWin32>>apiQueryFetchRow:

  OpenDBXWin32>>apiQueryFieldValue:index:

  OpenDBXWin32>>apiQueryFinalize:

  OpenDBXWin32>>apiQueryResult:handle:timeout:chunk:

  OpenDBXWin32>>apiQueryRowsAffected:

  OpenDBXWin32>>apiSetOption:option:value:

  OpenDBXWin32>>apiUnbind:

'

Proceeding the system report:

'Compile error in Class: #''OpenDBXUnix'' method: apiBind: handle database: databaseName name: userName password: password method: method "int odbx_bind(odbx_t* handle, const char* database, const char* who, const char* cred,int method )" <cdecl: long ''odbx_bind'' (ulong char* char* char* ulong) module: ''opendbx''> * ^1 ^self externalCallFailed 1: [1034] unexpected token '

I think "opendbx" as comment is not correct

By Guillermo Polito:

Ok, when loading OpenDBX in pharo, I get the following method:

OpenDBXUnix>>apiBind: handle database: databaseName name: userName password: password method: method

"int odbx_bind(odbx_t* handle, const char* database, const char* who, const char* cred,int method )"

<cdecl: long 'odbx_bind' (ulong char* char* char* ulong) module: 'opendbx'>

^self externalCallFailed

So, there is not really a comment in there :/. Maybe asking in some Gemstone mailing list?

I reversal the question.

Thanks,

Dario