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
|