titania424

Colorado

None

Age: 50

Long time software engineer, back to being technical after years of systems engineering and project management. Past experience heavily in C++, C, Unix, Object-oriented design, embedded, telecommunications, aerospace. Ventured into the world of Java/Spring/Web development.

Dec
4
answered Jboss 5, Jersey 2.4, Compressed .war file not working
Oct
9
comment Return multiple values from a Java method - no standard yet?
Other languages do this by having a pass-by-reference syntax (or a pseudo pass-by-reference, like using & (address operator) in C or C++. That was the way people got around it "back in the old days". I'm trying to decide how to do this for something and I may chose the private static class explained below as the selected answer.
Sep
26
answered MySQL Not In Not Working
Aug
29
comment Find single matching record from one table with exact list of matches in join table
Here's what I came up with: SELECT * FROM (SELECT m.metricsid, m.a, m.b, m.c, COUNT(*) AS MATCH_COUNT FROM metrics as m INNER JOIN metrics_grid as mg on m.metricsid = mg.metricsid WHERE m.a = ? AND m.b = ? AND m.c = ? AND mg.gridid IN (?, ?, ?) GROUP BY m.metricsid) TMP WHERE TMP.MATCH_COUNT=3; So this selects from a result that groups it by the metrics id, and counts how many rows match, and that has to match the total number that there should be. Just glad I got it working, it was causing real problems here with recomputing huge amounts of metrics that already existed.
Aug
29
comment Find single matching record from one table with exact list of matches in join table
So after testing, I found I have to add something else that I haven't figured out. The query still returns 2 records when searching for the group, it works when only searching to match the single one. When I get that, I'll post it and you can add it in.
Aug
28
comment Find single matching record from one table with exact list of matches in join table
thanks for thinking about it, Your way may also work, but I found another solution building on the previous one.
Aug
28
comment Find single matching record from one table with exact list of matches in join table
Oh, if you update your answer with this, I'll accept your answer!
Aug
28
comment Find single matching record from one table with exact list of matches in join table
So I was able to make it work by adding this: AND NOT EXISTS (SELECT MG2.GridId FROM Metrics_grid MG2 WHERE M.MetricId=MG2.MetricsId AND MG2.SensorID NOT IN (?,?,?)) This did the part where it excludes any that are not exact matches.
Aug
28
comment Find single matching record from one table with exact list of matches in join table
This does exactly what my other attempts do, it returns both metrics records, the one where it is alone in the list, and the one where it is in a list of multiple. There needs to be a way to check that it matches exactly and only the same list of grids, and that's where I'm struggling.
Aug
28
asked Find single matching record from one table with exact list of matches in join table
Aug
22
comment Possible causes of "java.lang.ClassFormatError: Invalid pc in LineNumberTable"
We are having this problem too, in Eclipse, with JDK 1.7. This has been working, although we had to clean and now it stopped working. That's what seems really strange about it, we switched to Java 1.7 a few months ago, and now it's a problem?
Jul
26
answered Should I use identification numbers for usernames in MySQL?
Jul
19
awarded Autobiographer
Jun
20
awarded Critic
May
24
awarded Talkative
May
24
revised Installing MySQL on a mac
added 14 characters in body
May
24
awarded Yearling
May
24
revised Installing MySQL on a mac
added instructions for putting a path in /etc/paths.d
May
24
comment Installing MySQL on a mac
let us continue this discussion in chat
May
24
comment Installing MySQL on a mac
Yes, there may be just X11. What you need to do is put a file in that directory, call it "mysql" and in the file, it should say /usr/local/mysql/bin (or wherever your mysql is installed). Then when you open new terminals, it should apply to the path.
1 2 3 4 5