[Pharo-users] Pharo - OpenDBXDriver: Unsupported data type: UNKNOWN
Whenever I try to select a table that has timestamp defined columns I'm getting the following error: "OpenDBXDriverError: OpenDBXDriver: Unsupported data type: UNKNOWN, trying to parse 2011-03-31 17:38:35" I've traced this down into the NBOpenDBX_ApiH>>odbx_column_type:pos: method. I don't know if this is a DBXTalk problem or an OpenDBX problem, or simply that OpenDBX does not support timestamp column types for MySQL database. My system is: Pharo 3.0. MySql DBXTalk Thanks, B Selfridge -- View this message in context: http://forum.world.st/Pharo-OpenDBXDriver-Unsupported-data-type-UNKNOWN-tp4785813.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] Pharo - OpenDBXDriver: Unsupported data type: UNKNOWN
Thank you for responding so quickly. The column in the database is defined as a time stamp. It seems as though OpenDBX doesn't understand that type. I'll try setting up date, date time, time, and timestamp columns and see what happens. - Brad Selfridge -- View this message in context: http://forum.world.st/Pharo-OpenDBXDriver-Unsupported-data-type-UNKNOWN-tp4785813p4786033.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] Pharo - OpenDBXDriver: Unsupported data type: UNKNOWN
Yes, the column type definition is: timestamp. I am trying to use Pharo to access some old legacy MySQL tables. These tables have "timestamps" defined everywhere and there is NO WAY I will be allowed to change them. So, I'm going to have to try to figure out how to get around this problem. Since I'm new to the Pharo camp, (old VASmalltalk'er using DB2 as database), do you think the OpenDBX people would be open to supporting timestamp in their library? Brad Selfridge - Brad Selfridge -- View this message in context: http://forum.world.st/Pharo-OpenDBXDriver-Unsupported-data-type-UNKNOWN-tp4785813p4786116.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] Pharo - OpenDBXDriver: Unsupported data type: UNKNOWN
I've contacted the OpenDBX development group and they seem to be unwilling to add the "UNKNOWN" types to their library. So, that leaves us with solving the problem in the GLORP framework. The big problem is the GlorpOpenDbxDriver is asking the DBXRow for its value - not rawValue, thereby triggering the DBXTypeNotSupported object to throw an exception. My suggestion is that framework needs to be enhanced to deal with this problem and not force every developer to have to bypass/override chunks of the Glorp framework whenever an "UNKNOWN" type is returned. I have some ideas how to overcome this dilemma. However, I think that I may need to move this conversation to the Glorp group. - Brad Selfridge -- View this message in context: http://forum.world.st/Pharo-OpenDBXDriver-Unsupported-data-type-UNKNOWN-tp4785813p4787306.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] Pharo - OpenDBXDriver: Unsupported data type: UNKNOWN
Esteban and Guille, I just realized that you gentlemen are the keepers of DBXTalk. Thank you for kindly corresponding with me. My hat's off to all of you for taking on this task. I have a somewhat grandeur goal for solving this problem. I would like to solve the problem rather than creating a work-around. I feel that the only way for Smalltalk to make a comeback is if it and the supporting tools just "work". If Pharo/GLORP supports MySql, then it should work, etc. etc - no work arounds. If the problem is in the OpenDBXDriver, then it would be nice if this could be fixed (since I have NO C-lang experience there is little that I can help with here) . If the problem is in OpenDBX libraries, then our options are more limited. If we need to modify GLORP to define the types in the mapping Descriptors and simply bypass the types provided by database drivers, then I can help with that. I'm willing to help what I can. My personal goal is to build a GUI interface for GLORP mapping. It would be nice to have this stuff working before I get started. (If the drivers/mappers don't really work, then why build a GUI mapping definition tool)? Thanks, Brad Selfridge - Brad Selfridge -- View this message in context: http://forum.world.st/Pharo-OpenDBXDriver-Unsupported-data-type-UNKNOWN-tp4785813p4787493.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
[Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL
I've used the instructions defined on the "http://dbxtalk.smallworks.eu/"; website to setup the OpenDBXDriver for a MySQL database. When I try to make a connection to the database, I'm getting the "function unavailable". I have this working on a Ubuntu 14.04 32bit OS. I'm wondering if my problem is my 64bit Ubuntu or do I have other problems. My setup: Ubuntu 14.04 64bit. Pharo 3.0 libopendbx.so.1.2.0 i386 version Brad Selfridge - Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-MySQL-tp4790564.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL
It looks like eveything is there. This configuration looks almost identical to my 32os machine. root@brads-linux-laptop:/usr/lib# ldd libopendbx.so.1.2.0 linux-gate.so.1 => (0xf76df000) libdl.so.2 => /lib/i386-linux-gnu/libdl.so.2 (0xf76b8000) libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xf7508000) /lib/ld-linux.so.2 (0xf76e) root@brads-linux-laptop:/usr/lib# - Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-MySQL-tp4790564p4790636.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL
Ill have to check Brad Selfridge 913-269-2385 > On Nov 17, 2014, at 9:41 AM, Stephan Eggermont [via Smalltalk] > wrote: > > Hi Brad, > > You don't tell us if your MySQL is 32 bit? > > Stephan > > > > If you reply to this email, your message will be added to the discussion > below: > http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-MySQL-tp4790564p4790646.html > To unsubscribe from 'function unavailable' when calling OpenDBXDriver for > MySQL, click here. > NAML - Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-MySQL-tp4790564p4790648.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL
My database is 64 bit on my 64bit Ubuntu machine. However, on my 32bit Ubuntu 14.04 machine, I have a 64 debian VM running that has a 64bit MySQL running which I can access just fine from 32bit host machine running Pharo. - Brad Selfridge -- View this message in context: http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-MySQL-tp4790564p4790694.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] 'function unavailable' when calling OpenDBXDriver for MySQL
The "libmysqlclient18:amd64" looks suspicious.
brad@brads-linux-laptop:~$ sudo dpkg -l | grep mysql | awk ' { print $2 } '
libdbd-mysql-perl
libmysqlclient18:amd64
libmysqlclient18:i386
libmysqlcppconn7
libopendbx1-mysql
libqt4-sql-mysql:i386
mysql-client
mysql-client-5.5
mysql-client-core-5.5
mysql-common
mysql-server
mysql-server-5.5
mysql-server-core-5.5
mysql-utilities
mysql-workbench
mysql-workbench-data
python-mysql.connector
brad@brads-linux-laptop:~$
brad@brads-linux-laptop:~$ sudo dpkg -l | grep dbx | awk ' { print $2 } '
libopendbx1
libopendbx1-mysql
brad@brads-linux-laptop:~$
-
Brad Selfridge
--
View this message in context:
http://forum.world.st/function-unavailable-when-calling-OpenDBXDriver-for-MySQL-tp4790564p4790702.html
Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
Re: [Pharo-users] Blitzkrieg!
Steph, I completely agree. This type of hyperbole makes the casual observer think that the Smalltalk community can come off as petty. We're better than this. We should ALL have the goal of promoting Smalltalk. I know that a lot of you have and I applaud all of you for your efforts. The more the merrier. I personally welcome any and all exposure to the benefits of Smalltalk, if it's positive. I may not agree with everything that is promoted, but as long as it has the potential of converting people into looking at Smalltalk, regardless of the version, then I'm OK with that. So, I plead with everyone, both creators and critics, keep it civil, positive, and centered on the goal of promoting Smalltalk. (We can't eat our own and expect to survive). Brad Selfridge - Brad Selfridge -- View this message in context: http://forum.world.st/Blitzkrieg-tp4800165p4800498.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
[Pharo-users] Pharo 4 debugger
In Pharo 3.0 there was a Add/Remove breakpoint (experimental) method popup menu option. I do not see this capability in version 4.0. Is this feature still available or has it been removed? If still available, then how does one get it instantiated? Brad Selfridge - Brad Selfridge -- View this message in context: http://forum.world.st/Pharo-4-debugger-tp4855663.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
