Page 1 of 1

Error importing PostGreSQL

PostPosted: Tue Jun 30, 2015 2:19 pm
by pmgroen
Hi All,

I'm using QxEntityEditor 1.1.8 (No License............yet) to import a database (PostGreSQL 9.3) ove ODBC, with approx. 49 tables.
If selecting 1 table with 3 columns, immediatedly the message pops-up claiming the table doesn't have any columns, which is not true..
Also if we're using PostGreSQL as driver instead of 'Generic', it will produce a segfault.
We're investigating QxORM for a project and our estimates are based on the useability of this tool.
Are we doing something wrong? Is this a License-thing? We're willing to pay for a license, but only if the application delivers as promised.

[Edit]
Here the terminal output...
[QxEntityEditor] app arguments (0) : ./QxEntityEditor
[QxEntityEditor] [TRACE] : Loading project : Test
[QxEntityEditor] context::ctx_project : full project database file name '/home/pgroen/Documents/QxORM_tests/Test.qxee'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{eab74563-c067-4ef3-a6c5-00c72145f3b7}'
[QxEntityEditor] empty license key
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{0b268484-aa86-431b-b9dd-f36d5ba45f75}'
[QxEntityEditor] context::ctx_project : full project database file name '/home/pgroen/Documents/QxORM_tests/Test.qxee'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{1fe74abe-1ea8-43f4-91be-3cfc1021ada8}'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{90b20263-2642-45cd-b94e-a7aec98131fe}'
[QxEntityEditor] context::ctx_project : full project database file name '/home/pgroen/Documents/QxORM_tests/Test.qxee'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{cb279b54-f990-47f4-ba84-67ad95a4cc64}'
[QxEntityEditor] [TRACE] : Project loaded : Test
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{2b4d994f-755e-45a3-95a6-463e45b83629}'
[QxEntityEditor] context::ctx_project : full project database file name '/home/pgroen/Documents/QxORM_tests/Test.qxee'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{0f3490f4-6418-465a-abd8-5f511ecf4f2f}'
[QxEntityEditor] [TRACE] : Loading project : Test
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{cd45fb50-adb4-405c-bc6a-32d74079b8bb}'
[QxEntityEditor] context::ctx_project : full project database file name '/home/pgroen/Documents/QxORM_tests/Test.qxee'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{90ede9cd-2d9f-41d0-bef0-e0cc6d4ed2dd}'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{fa891951-b05c-4516-adfb-1831759364a5}'
[QxEntityEditor] context::ctx_project : full project database file name '/home/pgroen/Documents/QxORM_tests/Test.qxee'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{b1cbc2cc-3124-48c6-bd65-f2b9da258251}'
[QxEntityEditor] [TRACE] : Project loaded : Test
[QxEntityEditor] [INFO] : Organize diagram layout
[QxEntityEditor] [INFO] : ODBC plugin import process to current project finished (0 entities imported)
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{7731090c-581c-458a-aa46-ceb52dd5a792}'
[QxEntityEditor] context::ctx_project : full project database file name '/home/pgroen/Documents/QxORM_tests/Test.qxee'
[QxOrm] qx::QxSqlDatabase : create new database connection in thread '0x7f468258c840' with key '{914bf5d2-2d3d-40cd-9760-b12cdc6faae2}'



Regards,

Peter....

Re: Error importing PostGreSQL

PostPosted: Tue Jun 30, 2015 7:46 pm
by qxorm
Hello,

It seems that you are working on Linux : I think the crash importing your schema is due to unixODBC.
Which unixODBC are you using : the one deployed with QxEntityEditor or your own unixODBC ?

Anyway, we have a customer who imports a PostgreSQL schema (with more than 49 tables) without any problem.
He had the same issue on Linux but I can't reproduce it : for me it is working fine on Ubuntu 12 with the unixODBC deployed with QxEntityEditor.
So here is how this customer proceeds :
1- run QxEntityEditor on Windows and import the database schema on Windows (not Linux) ;
2- then run the export plugin to generate C++ files ;
3- then run a script (defined in QxEntityEditor) to put all C++ generated files in the Source Control (Perforce, VSS, Git, or whatever...) ;
4- then go back to Linux, you can get the last version from Source Control, and you get the C++ files generated by QxEntityEditor.

Note that you can also share a *.qxee project file on Windows, Linux and MacOSX if you want.

if we're using PostGreSQL as driver instead of 'Generic'

Use the PostgreSQL setting, not Generic.