database problems »

[Paul Traut]

Hello

I have some problems with the databasee connections.

I create a new connection and check the box for "Use default application connection". Then I type in all information like Server, User and so on. If I now check the connection everything seems fine but when I create the connection the Symbol (the wire-button (dont know how to call it)) says that i am not connected. When i now pusch the Button or try to render a report the LRDesigner craches and I get a core file. Is this a bug or do i something wrong?

[Arin Alex]

I'll check it

[Arin Alex]

Which database server do you use?

[Paul Traut]

Hi,

it is an Oracle (Release 12.2.0.1.0) database.

Hope this is the answer you where looking for.

Paul

[Paul Traut]

I don´t know if it helps, but I get the message "~QOCIResult: unable to free statement handle". Dont know if it is related to this problem or if it is another problem, but in the moment I have many problems with the database connection. 

[Arin Alex]

Hi
I have made some changes in the database connection.
Would you get the latest version of limereport from github and check it?

[Paul Traut]

Yes I will try it, but I have some issues with the installation of the previous version on a system with QT4. There is no problem on the system with QT5. But in this case I need QT4.

I get this message:

g++ -c -pipe -g -I/opt/oracle/product/12cR2/db/rdbms/demo -I/usr/include/oracle/12.2/client64 -O2 -D_REENTRANT -Wall -W -fPIC -DQT_EDITION=QT_EDITION_DESKTOP -DLIMEREPORT_EXPORTS -DHAVE_ZINT -DLIMEREPORT_VERSION_STR="\"1.4.43\"" -DLIMEREPORT_VERSION=\"1.4.43\" -DHAVE_QT4 -DHAVE_UI_LOADER -DINSPECT_BASEDESIGN -DQT_NO_DEBUG -DQT_SCRIPT_LIB -DQT_SQL_LIB -DQT_XML_LIB -DQT_GUI_LIB -DQT_CORE_LIB -DQT_HAVE_MMX -DQT_HAVE_3DNOW -DQT_HAVE_SSE -DQT_HAVE_MMXEXT -DQT_HAVE_SSE2 -DQT_HAVE_SSE3 -DQT_HAVE_SSSE3 -DQT_HAVE_SSE4_1 -DQT_HAVE_SSE4_2 -DQT_HAVE_AVX -D_LARGEFILE64_SOURCE -D_LARGEFILE_SOURCE -DQT_SHARED -I../../mkspecs/linux-g++ -I. -I../../include/QtUiTools -I../../include/QtCore -I../../include/QtGui -I../../include/QtXml -I../../include/QtSql -I../../include/QtScript -I../../include -I. -Iitems -Ibands -Ibase -Iobjectinspector -Idatabrowser -I../3rdparty/zint-2.4.4/backend -I../3rdparty/zint-2.4.4/backend_qt4 -Iunix/release/moc -Iunix/release/ui -o unix/release/obj-shared/lrbasedesignintf.o lrbasedesignintf.cpp
In file included from ../../include/QtGui/qtabwidget.h:1:0,
                  from ../../include/QtGui/../../src/gui/widgets/qmainwindow.h:46,
                  from ../../include/QtGui/qmainwindow.h:1,
                  from ../../include/QtGui/QMainWindow:1,
                  from lrreportdesignwidget.h:35,
                  from lrreportdesignwidget.cpp:30:
../../include/QtGui/../../src/gui/widgets/qtabwidget.h: In constructor ‘LimeReport::ReportDesignWidget::ReportDesignWidget(LimeReport::ReportEnginePrivate*, QMainWindow*, QWidget*)’:
../../include/QtGui/../../src/gui/widgets/qtabwidget.h:168:14: error: ‘QTabBar* QTabWidget::tabBar() const’ is protected
      QTabBar* tabBar() const;
               ^
lrreportdesignwidget.cpp:57:33: error: within this context
      connect(m_tabWidget->tabBar(), SIGNAL(tabMoved(int,int)), this, SLOT(slotTabMoved(int,int)));
                                  ^
In file included from ../../include/QtGui/qtabwidget.h:1:0,
                  from ../../include/QtGui/../../src/gui/widgets/qmainwindow.h:46,
                  from ../../include/QtGui/qmainwindow.h:1,
                  from ../../include/QtGui/QMainWindow:1,
                  from lrreportdesignwidget.h:35,
                  from lrreportdesignwidget.cpp:30:
../../include/QtGui/../../src/gui/widgets/qtabwidget.h: In member function ‘void LimeReport::ReportDesignWidget::slotTabMoved(int, int)’:
../../include/QtGui/../../src/gui/widgets/qtabwidget.h:168:14: error: ‘QTabBar* QTabWidget::tabBar() const’ is protected
      QTabBar* tabBar() const;
               ^
lrreportdesignwidget.cpp:642:46: error: within this context
      for ( int i = 0; i < m_tabWidget->tabBar()->count(); ++i){
                                               ^
lrreportdesignwidget.cpp: At global scope:
lrreportdesignwidget.cpp:638:6: warning: unused parameter ‘from’ [-Wunused-parameter]
  void ReportDesignWidget::slotTabMoved(int from, int to)
       ^
lrreportdesignwidget.cpp:638:6: warning: unused parameter ‘to’ [-Wunused-parameter]
Makefile:81225: recipe for target 'unix/release/obj-shared/lrreportdesignwidget.o' failed



Is it possible that I can use the new limereport also on a QT4 system?

Paul

[Subst]

Sure
The QTabWidget hasn't public function QTabBar *tabBar() in Qt 4.x
http://doc.qt.io/qt-4.8/qtabwidget.html

But there is Protected function

To Alex: may be need to inherit from QTabWidget the class for compatibility?

[Arin Alex]

Subst Yes i did it
Paul Traut I will fix qt4 build soon

[Paul Traut]

Wow thanks,

this is realy fast

[Arin Alex]

Paul Traut
Done
You can get version 1.4.49 and check it
Development branch also has been fixed

[Paul Traut]

I will check it soon, have to wait for some help here

[Paul Traut]

Ok, I have checked the database connection.
Here is my result:

1. the default connection is more stable than before (means it crashes not directly, when i try to push the connect button) but it still crashes after some times.
2. the connect button still stays on "not connected" even if the connection is established.
3. when I delete a connection (default or another) all remaining connections cannot be edited, all the buttons for editing stay gray when I select a connection.

Had no time to check it further, will do this in one week, because I will have holiday for a week.

Paul

[Arin Alex]

Have a nice holiday

but it still crashes after some times

How it's happen? You push the connection button several times and designer is crashed?