Re: [Interest] [Help]A big problem about accessing database using OCI driver plugin from qt application.
Hello, Your solution is great.When I set OCI_ATTR_PREFETCH_ROWS option, the accessing speed becomes so fast. Thank you so much :) Have good time!BR,Eric2012.10.31 Date: Tue, 30 Oct 2012 20:13:19 +1000 From: a1291...@gmail.com To: xiaogangwang2...@hotmail.com; interest@qt-project.org Subject: Re: [Interest] [Help]A big problem about accessing database using OCI driver plugin from qt application. On 30/10/12 5:25 PM, Xiaognag Wang wrote: You mean this big difference (7 seconds and 30 millisecond ) was caused by cache? Oh yes. There's a big difference between having 1 chunk of data sent from the server to the client and having the client poll the server every time your app says fetchNext(); The effect becomes even more pronounced as you increase the latency between your app and the database server (eg. if it's on a network instead of on the local machine). In my testing, query.next() just retured 256 records. and I can not find methods to set cache enable in qt, should I set cache at oracle side? If you're using oracle, you want to look at OCI_ATTR_PREFETCH_ROWS and/or OCI_ATTR_PREFETCH_MEMORY. See QSqlDatabase::setConnectOptions(). -- Link ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
[Interest] '__fastcall' incompatible with the '/clr'
Hello list, i am evaluating a possible change of vs2005+qt-4.4.3 to at least vs2010+qt-4.8.3, and perhaps qt5.X some time later on... several of our projects use managed code, too, so we must compile with /clr option, but with this last qt version i get many warnings like: ..\qchar.h(311): warning C4561: '__fastcall' incompatible with the '/clr' option: converting to '__stdcall' i have searched the list and internet, but didn't find any explanation which really says: yes, this is NO problem. as long can someone give me some more hints or explanations? is it just a problem when calling qt methods from managed code, or will it be save due to the conversion to __stdcall, or is there more to this problem? can i work around by not compiling whole modules with /clr but rather switch the mode of the code parts explicitly with e.g.: // unmanaged #pragma managed(push on) // some managed classes used #pragma managed(pop) // unmanaged, qt classed used, again i would appreciate some informations thanks for listening alex -- The significant problems we face cannot be solved at the same level of thinking we were at when we created them. -Albert Einstein signature.asc Description: PGP signature ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
Re: [Interest] '__fastcall' incompatible with the '/clr'
On quarta-feira, 31 de outubro de 2012 10.10.58, alexander golks wrote: ..\qchar.h(311): warning C4561: '__fastcall' incompatible with the '/clr' option: converting to '__stdcall' i have searched the list and internet, but didn't find any explanation which really says: yes, this is NO problem. as long can someone give me some more hints or explanations? is it just a problem when calling qt methods from managed code, or will it be save due to the conversion to __stdcall, or is there more to this problem? You simply cannot call those methods that are __fastcall from managed code. -- Thiago Macieira - thiago.macieira (AT) intel.com Software Architect - Intel Open Source Technology Center signature.asc Description: This is a digitally signed message part. ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
Re: [Interest] Why we have to remove Qt3D in Qt5.0 release?
If QtWebkit requires qtlocation and qt3d, then does this mean webkit will also no longer be included with Qt5? On Mon, Oct 29, 2012 at 8:20 PM, Loaden loa...@gmail.com wrote: See: https://codereview.qt-project.org/#change,38442 And: https://bugreports.qt-project.org/browse/QTBUG-27736 The use of qt5.git is still recommended by some wiki pages, but it contains repos which are not part of the Qt 5.0 release. These should be removed from the qt5.git repo: *qt3d* qtconnectivity qtfeedback qtlocation qtpim qtsensors qtsystems qtwayland They are not part of 'Qt 5', and having them there causes confusion. ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
[Interest] FOSDEM CrossDesktop DevRoom 2013 - Call for Talks
Hello, The Call for Talks for the CrossDesktop DevRoom at FOSDEM 2013 is now officially open. Please do not wait till the last minute! --8--- * FOSDEM is one of the largest gatherings of Free Software contributors in the world and happens each February in Brussels (Belgium). One of the tracks will be the CrossDesktop DevRoom, which will host Desktop-related talks. We are now inviting proposals for talks about Free/Libre/Open-source Software on the topics of Desktop development, Desktop applications and interoperativity amongst Desktop Environments. This is a unique opportunity to show novel ideas and developments to a wide technical audience. Topics accepted include, but are not limited to: Enlightenment, Gnome, KDE, Unity, XFCE, Windows, Mac OS X, general desktop matters, applications that enhance desktops and web (when related to desktop). Talks can be very specific, such as developing mobile applications with Qt Quick; or as general as predictions for the fusion of Desktop and web in 5 years time. Topics that are of interest to the users and developers of all desktop environments are especially welcome. The FOSDEM 2012 schedule might give you some inspiration: https://archive.fosdem.org/2012/schedule/track/crossdesktop_devroom.html https://archive.fosdem.org/2012/schedule/track/crossdesktop_devroom.html Please include the following information when submitting a proposal: - Your name - The title of your talk (please be descriptive, as titles will be listed with around 250 from other projects) - Short abstract of one or two paragraphs - Short bio - Requested time: from 15 to 45 minutes. Normal duration is 30 minutes. Longer duration requests must be properly justified. The deadline for submissions is December 14th 2012. FOSDEM will be held on the weekend of 2-3 February 2013. Please submit your proposals to crossdesktop-devr...@lists.fosdem.org (subscribtion page for the mailing list: https://lists.fosdem.org/listinfo/crossdesktop-devroom ) -- The CrossDesktop DevRoom 2013 Organization Team* --8--- -- Pau Garcia i Quiles http://www.elpauer.org (Due to my workload, I may need 10 days to answer) ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
[Interest] QtWinMigrate and QThread event loop (4.8.3)
Hi, I've recently discovered that if an application creates a new background QThread and calls QThread::start() to start the thread's event loop, that thread will sometimes process QMfcApp::winEventFilter, which in turn will cause MFC events to be processed in the background thread. However, this will cause some problems because the MFC events are only meant to be processed in the application's main thread. Would it be appropriate to do a thread check inside QMfcApp::winEventFilter and only allow it to proceed if the current thread is the main thread? I'm not familiar with the lineage of this class, but the way it's written, I think there was an assumption that it would only get called from the main thread. Thanks, Doug___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
[Interest] Spell checking.
Hello: I am adding spell checking to my application. I have the spell checking engine. I can see how to use the QSyntaxHighlighter to to underline words that are spelled incorrectly in a QTextEdit. I understand that I can configure a QTextEdit to behave as a single line widget for use in place of a QLineEdit. But, how do I add spell checking to the single line QLineEdit of a QComboBox? Thanks. Bill ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
Re: [Interest] Spell checking.
Since combobox is using QLineEdit for editing, it provides a pointer to it with: QLineEdit * QComboBox::lineEdit () const Also you force it to use QLineEdit subclass with setLineEdit() Alex On Wed, Oct 31, 2012 at 10:07 AM, Bill Crocker william.croc...@analog.com wrote: Hello: I am adding spell checking to my application. I have the spell checking engine. I can see how to use the QSyntaxHighlighter to to underline words that are spelled incorrectly in a QTextEdit. I understand that I can configure a QTextEdit to behave as a single line widget for use in place of a QLineEdit. But, how do I add spell checking to the single line QLineEdit of a QComboBox? Thanks. Bill ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
Re: [Interest] Spell checking.
On 10/31/2012 06:54 PM, Alex Malyushytskyy wrote: Since combobox is using QLineEdit for editing, it provides a pointer to it with: QLineEdit * QComboBox::lineEdit () const Also you force it to use QLineEdit subclass with setLineEdit() But, I don't know how to add spell checking to a QLineEdit so being able to replace the QLineEdit of a QComboBox with anything related to a QLineEdit does not do any good. I *do* know how to turn a QTextEdit into a single line widget with spell checking, but I can not then pass it to the QComboBox because it does not derive from a QLineEdit. I suppose I could subclass QLineEdit and then override the paint event, but I looked at the existing paint event code and got scared. :-) Alex On Wed, Oct 31, 2012 at 10:07 AM, Bill Crocker william.croc...@analog.com wrote: Hello: I am adding spell checking to my application. I have the spell checking engine. I can see how to use the QSyntaxHighlighter to to underline words that are spelled incorrectly in a QTextEdit. I understand that I can configure a QTextEdit to behave as a single line widget for use in place of a QLineEdit. But, how do I add spell checking to the single line QLineEdit of a QComboBox? Thanks. Bill ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest ___ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
[Interest] connect sql server via odbc
Hi everyone.
I connected MSSQL (on windows) via odbc on linux redhat 64bit.
I executed sql command via isql or tsql(unixODBC) is perfect, but it always
fail.
So, maybe DSN string problem?
Could anybody help me?
Thanks
Ken
Below is odbc and freetds configuration files.
---freetds.conf:
[FreeTDS]
host=172.21.32.20
port=1433
tds version=7.2
client charset = GB2312
-odbcinst.ini
[TDS]
Description = TDS
Driver = /usr/local/lib/libtdsodbc.so
Trace = Yes
TraceFile=/tmp/odbcinst.log
UsageCount = 1
odbc.ini:
[SQLSERVER]
Driver = TDS
Description = sql server dsn
Trace = NO
Server = 172.21.32.20
Database = Live
Port = 1433
TDS_Version = 7.2
TraceFile=/tmp/sqlserver.log
--Snippets:
QString f3ErpDsn =
QString::fromLocal8Bit(Driver={SQLSERVER};server=172.21.32.20;database=Live;uid=inp;pwd=inp;);
QSqlDatabase f3ErpDb= QSqlDatabase::addDatabase(QODBC);
f3ErpDb.setDatabaseName(f3ErpDsn);
// f3ErpDb.setDatabaseName(SQLSERVER);
f3ErpDb.setUserName(inp);
f3ErpDb.setPassword(inp);
QString sqlCmdStr = select * from dbo.Table_Drilling_Data01 where status=1;
if ( ! f3ErpDb.open() )
{
qDebug() f3ErpDb.lastError().text();
return 1;
}
QSqlTableModel model;
model.setTable(dbo.Table_Drilling_Data01);
model.setFilter(status=3);
model.select();
qDebug() model.lastError().text();
--Error messages:
f3ErpDb.setDatabaseName(f3ErpDsn);
1. If setDatabaseName is f3ErpDsn error message is:
QODBC3: Unable to connect, [unixODBC][Driver Manager]Data source name not
found, and no default driver specified)
I had defined SQLSERVER in odbc.ini. Why it said can not find it?
2. But if I changed f3ErpDb.setDatabaseName(SQLSERVER);, error message is:
[FreeTDS][SQL Server]The incoming tabular data stream (TDS) remote procedure
call (RPC) protocol stream is incorrect. Parameter 1 (): Data type 0x00 is
unknown. QODBC3: Unable to execute statement
___
Interest mailing list
Interest@qt-project.org
http://lists.qt-project.org/mailman/listinfo/interest
