[Gambas-user] gambas2 - bug using the example Database project with oracle odbc
Benoît Minisini
gambas at ...1...
Wed Jun 30 18:02:08 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
>
Oops, your mail is unreadable without any newline: can you try to post it
again differently so that I can read it?
--
Benoît
More information about the User
mailing list