[Gambas-user] gambas2 - bug using the example Database project with oracle odbc

Wed Jun 30 12:58:35 CEST 2010

Hi, I have some problems using the example of database project with an oracle database trough ODBC.  
I installed gambas 2.20.2 (the latest stable) on Ubuntu 10.4 Desktop.
I installed UnixODBC  2.2.11.21 using the ubuntu software center and installed the oracle 10.2.0.3 ODBC from oracle. I configured it and using isql from terminal, it works.
When i try to use the database example, i use odbc connection and it works but when i try to run a simple query that return almost a row, gambas crashes with error #11 with this log:(gdb) runStarting program: /usr/local/bin/gbx2 -p[Thread debugging using libthread_db enabled]Program received signal SIGSEGV, Segmentation fault.0x01227a91 in SQLColAttributeW ()   from /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1(gdb) bt#0  0x01227a91 in SQLColAttributeW ()   from /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1#1  0x00feb5a4 in SQLColAttribute () from /usr/lib/libodbc.so.1#2  0x00fdf698 in query_fill (db=0x825bba4, result=0x827ddc8, pos=0,     buffer=0x828ec88, next=0) at main.c:1179#3  0x00fd63b7 in load_buffer (_object=0x82fe260, vpos=0) at CResult.c:145#4  0x00fd6d08 in DB_MakeResult (conn=0x825bb98, mode=0, table_temp=0x0,     query=0x8299c58 "select * from mytable") at CResult.c:305#5  0x00fd4037 in CCONNECTION_exec (_object=0x825bb98, _param=0x807f878)    at CConnection.c:454#6  0x0804e92c in EXEC_call_native (exec=0xfd3fd4 <CCONNECTION_exec>,     object=0x825bb98, type=135043168, param=0x807f878) at gbx_exec.c:844#7  0x0804f230 in EXEC_native () at gbx_exec.c:962#8  0x0806bbd8 in EXEC_loop () at gbx_exec_loop.c:1042#9  0x0804f533 in EXEC_function_loop () at gbx_exec.c:703#10 0x0804f809 in EXEC_function_real () at gbx_exec.c:690#11 0x0805d54b in raise_event (observer=0x0, object=<value optimized out>,     func_id=<value optimized out>, nparam=0) at gbx_api.c:490#12 0x0805da63 in GB_Raise (object=0x824aaa8, event_id=16, nparam=0)    at gbx_api.c:594#13 0x00353e44 in gb_raise_button_Click (sender=0x824aec0) at CButton.cpp:44#14 0x003324aa in gControl::emit (this=0xfdfba9, signal=0x0)    at gcontrol.cpp:1482---Type <return> to continue, or q <return> to quit---#15 0x00337950 in bt_click (object=0x820da58, data=0x824aec0) at gbutton.cpp:58#16 0x00a7adcc in g_cclosure_marshal_VOID__VOID ()   from /usr/lib/libgobject-2.0.so.0#17 0x00a6d252 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0#18 0x00a8199d in ?? () from /usr/lib/libgobject-2.0.so.0#19 0x00a82db4 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0#20 0x00a83256 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0#21 0x003f7c7a in gtk_button_clicked () from /usr/lib/libgtk-x11-2.0.so.0#22 0x003f9238 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#23 0x00a7adcc in g_cclosure_marshal_VOID__VOID ()   from /usr/lib/libgobject-2.0.so.0#24 0x00a6b8b9 in ?? () from /usr/lib/libgobject-2.0.so.0#25 0x00a6d252 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0#26 0x00a8123a in ?? () from /usr/lib/libgobject-2.0.so.0#27 0x00a82db4 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0#28 0x00a83256 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0#29 0x003f7d1a in gtk_button_released () from /usr/lib/libgtk-x11-2.0.so.0#30 0x003f7d63 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#31 0x004b5424 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#32 0x00a6b8b9 in ?? () from /usr/lib/libgobject-2.0.so.0#33 0x00a6d252 in g_closure_invoke () from /usr/lib/libgobject-2.0.so.0#34 0x00a815e6 in ?? () from /usr/lib/libgobject-2.0.so.0#35 0x00a82c33 in g_signal_emit_valist () from /usr/lib/libgobject-2.0.so.0---Type <return> to continue, or q <return> to quit---#36 0x00a83256 in g_signal_emit () from /usr/lib/libgobject-2.0.so.0#37 0x005e2636 in ?? () from /usr/lib/libgtk-x11-2.0.so.0#38 0x004ada5d in gtk_propagate_event () from /usr/lib/libgtk-x11-2.0.so.0#39 0x004aee07 in gtk_main_do_event () from /usr/lib/libgtk-x11-2.0.so.0#40 0x00361b4d in gambas_handle_event (event=0x81236e8) at gapplication.cpp:532#41 0x007a339a in ?? () from /usr/lib/libgdk-x11-2.0.so.0#42 0x00af05e5 in g_main_context_dispatch () from /lib/libglib-2.0.so.0#43 0x00af42d8 in ?? () from /lib/libglib-2.0.so.0#44 0x00af44b8 in g_main_context_iteration () from /lib/libglib-2.0.so.0#45 0x004af1b3 in gtk_main_iteration_do () from /usr/lib/libgtk-x11-2.0.so.0#46 0x0035f6de in do_iteration (do_not_block=false, do_not_sleep=false)    at main.cpp:470#47 0x0035fd15 in my_loop () at main.cpp:398#48 0x08061c36 in main (argc=Cannot access memory at address 0x1) at gbx.c:358(gdb) 

this is my odbc.ini[XXXX]Application Attributes        = TAttributes        = WBatchAutocommitMode        = IfAllSuccessfulBindAsFLOAT        = FCloseCursor        = FDisableDPM        = FDisableMTS        = TDriver        = Oracle 10g ODBC driverDSN        = XXXXEXECSchemaOpt        = EXECSyntax        = TFailover        = TFailoverDelay        = 10FailoverRetryCount        = 10FetchBufferSize        = 64000ForceWCHAR        = FLobs        = TLongs        = TMetadataIdDefault        = FQueryTimeout        = TResultSets        = TServerName        = XXXXXXXXXSQLGetData extensions        = FTranslation DLL        = Translation Option        = 0DisableRULEHint        = TUserID        = 

and odbcinst:
[Oracle 10g ODBC driver]Description        = Oracle ODBC driver for Oracle 10gDriver        = /usr/lib/oracle/10.2.0.3/client/lib/libsqora.so.10.1Setup        = FileUsage        = CPTimeout        = CPReuse        = 

I replaced the database name for privacy but with isql t works: if i run select * from mytable i can see the data.the program crashes during the Exec method:PUBLIC SUB btnRun_Click()  DIM rData AS Result  DIM hForm AS FRequest  rData = $hConn.Exec(txtRequest.Text)

Thx in advance for your support and apologize for my bad english.

Stefano Balzani 