IRC Chat : 2008-11-12 - OpenMRS

00:09:53 *** nribeka has quit IRC
00:14:08 *** kapten_yuba has joined #openmrs
00:14:21 *** kapten_yuba has left #openmrs
03:13:27 *** atomicturtle has joined #openmrs
03:15:23 <bwolfe> r0bby: http://www.springsource.org/node/822
03:16:32 <r0bby> i saw
03:16:43 <r0bby> springsource aquired g2one
03:50:17 *** bwolfe has quit IRC
03:53:16 *** njero has joined #openmrs
03:53:16 *** ChanServ sets mode: +v njero
05:58:06 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Point of Contact near the North East US <http://forum.openmrs.org/viewtopic.php?f=11&t=412#p1432>
06:11:15 *** njero has quit IRC
09:58:49 *** nribeka has joined #openmrs
10:18:19 *** nribeka has left #openmrs
10:18:43 *** nribeka1 has quit IRC
11:08:45 *** atomicturtle has left #openmrs
11:40:24 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Resolve Remote Form Entry Errors <http://forum.openmrs.org/viewtopic.php?f=3&t=399#p1433>
12:33:27 *** james_regen has joined #openmrs
12:33:27 *** ChanServ sets mode: +v james_regen
12:58:00 *** bmckown has joined #openmrs
12:58:00 *** ChanServ sets mode: +o bmckown
13:26:24 *** nribeka1 has joined #openmrs
13:30:18 *** kapten_yuba has joined #openmrs
13:30:56 *** kapten_yuba has left #openmrs
13:46:26 *** atomicturtle has joined #openmrs
13:48:19 *** atomicturtle has left #openmrs
13:51:07 *** bwolfe has joined #openmrs
13:51:07 *** ChanServ sets mode: +o bwolfe
14:21:03 *** kapten_yuba has joined #openmrs
14:23:37 *** kapten_yuba has left #openmrs
15:50:42 <nribeka1> hi bwolfe
15:52:09 <bwolfe> hey nribeka1
15:52:50 <nribeka1> i have a question :D
15:53:24 <bwolfe> ok
15:53:52 <nribeka1> the way to get only some part of a class field value from hibernate is through projection?
15:54:08 <nribeka1> for example we have field a, b and c in class
15:54:20 <nribeka1> and we only interested in a and b
15:54:29 <nribeka1> to get it we use projection?
15:54:36 <nribeka1> is there other way to do this?
15:55:18 <nribeka1> hope you understand what i mean bwolfe
15:56:01 <bwolfe> yes, projections are the only way I know of
15:56:39 <nribeka1> next question: :D
15:56:53 <nribeka1> projection return array of object
15:57:27 <nribeka1> so we need result transformer to transform this array of object to anything that we want right bwolfe?
15:57:43 <bwolfe> thats one way, yes
15:57:50 <nribeka1> is there other way?
15:57:54 <bwolfe> but I haven't done that before...I Just use the array of objects
15:58:11 <nribeka1> ah ic ic
16:07:04 <nribeka1> bwolfe, to do projection on object that has one to many relationship do i have to create alias?
16:07:45 <bwolfe> nribeka1: I don't know. I would assume so
16:08:16 <nribeka1> hm ok ok. i will give it a try first
16:08:17 <nribeka1> :D
16:50:43 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Point of Contact near the North East US <http://forum.openmrs.org/viewtopic.php?f=11&t=412#p1434>
17:23:37 *** atomicturtle has joined #openmrs
17:58:25 *** nribeka1 has quit IRC
18:35:04 *** nribeka has joined #openmrs
18:54:48 *** nribeka has quit IRC
18:54:50 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Resolve Remote Form Entry Errors <http://forum.openmrs.org/viewtopic.php?f=3&t=399#p1435>
19:03:00 *** sgrannis has joined #openmrs
19:03:00 *** ChanServ sets mode: +v sgrannis
19:03:17 <sgrannis> james_regen: how're things?
19:05:37 <james_regen> still working through some issues with the module and exception with bad data
19:06:40 <james_regen> i think nribeka is trying the easy-but-could-be-slow solution right now. if it really is slow, then he has an idea for a solution that should be quick, but takes more work
19:07:21 <sgrannis> are the issues related to MySQL configuration access resolved?
19:08:55 <james_regen> it's the same issue. my understanding is that some date or timestamp fields will probably have values that mysql jdbc doesn't like, and our hibernate query includes them
19:20:29 *** nribeka has joined #openmrs
19:20:37 *** nribeka has left #openmrs
19:20:47 *** nribeka has joined #openmrs
19:20:49 <sgrannis> I thought one issues was that the MySQL access information (e.g. user/pass) could be stored in different config files, and we needed to be able to search multiple OpenMRS config files to find teh access credentials. Is that true, or did I misunderstand?
19:21:17 <nribeka> hi sgrannis
19:21:23 <nribeka> did i miss anything?
19:21:25 <sgrannis> hey nribeka
19:21:32 <sgrannis> I thought one issues was that the MySQL access information (e.g. user/pass) could be stored in different config files, and we needed to be able to search multiple OpenMRS config files to find teh access credentials. Is that true, or did I misunderstand?
19:21:33 <james_regen> oh, that was true. that issue was resolved. james came back with another problem
19:21:45 <nribeka> !log
19:21:45 <OpenMRSBot> nribeka: Error: You don't have the owner capability. If you think that you should have this capability, be sure that you are identified before trying again. The 'whoami' command can tell you if you're identified.
19:21:46 <sgrannis> james_regen: OK
19:22:35 <sgrannis> so the other issue is that hibernate formats dates in a way that the generic JDBC driver doesn't like?
19:23:09 <sgrannis> and we need to trnaslate query formats from Hibernate to JDBC?
19:23:45 <james_regen> sort of. valid date values in the database are not valid in java, so the mysql driver throws an exception when it encounters it
19:25:37 <sgrannis> hmmm. so the database representation of a date is not the java data object representation?
19:25:52 <sgrannis> "data" = "date"
19:26:37 <james_regen> the wording used on the MySQL page describing the problem is: These values can not be represented reliably in Java
19:27:10 <nribeka> sgrannis, yes. mysql default value for timestamp is "0000-00-00 00:00:00:0" and like james said these values can not be represented reliably in Java
19:28:06 <sgrannis> what data do we need from the mysql timestamp? just the date portion? can we just transform timestamp to date?
19:29:26 <sgrannis> what's the solution? timestampToDate() ?
19:31:37 <james_regen> the date fields for things such as brith date, death date, date created by, date voided, might end up having that value. i think the assumption that the ones we're interested in for matching, birth date or death date, are unlikely to have that value. but we should exclude other database columns because they're not useful for matching, and are much more likely to have that problematic value
19:32:15 <james_regen> currently, our hibernate object queries with something like a "select *", and the jdbc driver throws the exception then
19:35:54 *** sgrannis has quit IRC
19:46:31 <nribeka> bwolfe, what should i d
19:46:35 <nribeka> ups
19:46:52 <nribeka> cmillet wants to hold a meet up @ pittsburgh area
19:46:53 *** nribeka has left #openmrs
19:47:01 *** nribeka has joined #openmrs
19:47:28 <bwolfe> nribeka: meet him :-)
19:47:29 <bwolfe> heh
19:47:48 <bwolfe> nribeka: give him the datamodel overview that I gave you :-)
19:48:11 <nribeka> ok ok ...
19:48:16 <nribeka> i will try
19:48:17 <nribeka> :D
19:48:27 <nribeka> i will turn on the irc in case i forgot :D
19:51:03 <nribeka> there are some people from baobab health in pitt area right bwolfe?
19:51:17 <nribeka> i think i can invite them too :D
19:51:28 <bwolfe> they could probably help
20:03:35 <nribeka> yep, i hope so
20:03:42 <nribeka> replied cmillet post
20:03:42 *** nribeka has left #openmrs
20:03:47 *** nribeka has joined #openmrs
20:26:58 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Point of Contact near the North East US <http://forum.openmrs.org/viewtopic.php?f=11&t=412#p1436>
20:39:18 *** atomicturtle has quit IRC
20:45:31 *** atomicturtle has joined #openmrs
21:16:44 *** james_regen has quit IRC
21:27:08 *** atomicturtle has quit IRC
21:27:08 *** nribeka has quit IRC
21:44:57 *** atomicturtle has joined #openmrs
21:46:12 *** nribeka has joined #openmrs
21:47:52 *** nribeka has left #openmrs
22:18:28 *** nribeka has joined #openmrs
22:29:08 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Point of Contact near the North East US <http://forum.openmrs.org/viewtopic.php?f=11&t=412#p1437>
22:38:04 *** bwolfe has quit IRC
22:49:42 *** nribeka has quit IRC
22:57:01 *** [mharrison] has joined #openmrs
22:59:11 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Point of Contact near the North East US <http://forum.openmrs.org/viewtopic.php?f=11&t=412#p1438>
23:16:04 *** bwolfe has joined #openmrs
23:16:04 *** ChanServ sets mode: +o bwolfe
23:17:07 *** [mharrison] has quit IRC
23:24:24 <r0bby> meh
23:41:57 *** bmckown has quit IRC
23:42:36 *** agruetz has joined #openmrs
23:42:45 <agruetz> hey Ben you in?
23:43:12 <bwolfe> yep
23:43:57 <agruetz> pm me