- I was chugging along nicely,
- Conflict over the design strategy.
- I decided that I am
- The quote below is
- Last night, I watched The
- Kingdoms
- Taxonomy
- SelectMethod=Cursor
- Homegrown JSP
- OpenJMS Oracle database
- GPS-LAB7 is MS-SQL; GPSLAB8 is Oracle
- I think that I have got it. Remote query results joined at client
- Added "j" counter and runs through query response break to j > 1
- Have to drop and create the temp tables first outside of JDBC!!!!
- import java.util.regex.*; added to ddbmsConnection
- If the query has no "where" clause
- Got table dropped and created and values inserted
- Made my own JDBC connection in loaddb.createtable
- createTable method in LocalDB
- Put the localDB stuff in Ddbms; go_all tests OK
- Where to join the tables?
- To the client and figuring out how to dump the query result into a table.....
- Added "if query equals " to LocalDB to add header info for MLW calendar
- OK, get the tblnames into string variables; now need to get rid of []
- executeDave in DBWorker to call executeQuery directly
- Having trouble with the getOneRowQueryValue
- tblNode HubID column was 1 2 3 4 5 instead of 11111
- Database script and if for frag in exemgr; now won't run; reverting
- Create script to make Calendar fragments on Oracle
- How is the table fragmented? Horizontal or Vertical?
- Second global query--is the global table fragmented and how?
- Got the column labels with the dump of the columns
- Still getting (or getting again) the rollback JDBC message.
- So what if every call to LocalDB sends back column names?
- Added rsmd.getColumnName to LocalDB, but it returns hub info and hangs AP
- How to add the column headings to the message?
- dumpQryRespMsg(aMsg) in DdbmsConnection is replaced with....
- The action moves to DdbmsConnection
- It is simplistic and it is ugly, but....
- After some other investigations, regex still seems best, but...
- Java REGEX
- And this morning, got the query to work with my config
- Late at night
- Finally got the global query to work
- Stringbuffer answer
- XP SP2
- dumpMsg and ddbmsMsg
- Msg interface looks like my boy
- AdHocMessage
- MsgQryResult to bypass ReqProc?
- Queue message analysis, III.....
- Query message analysis, continued
- Realized that I'll have to reinstall SP2 for my laptop to work at UST.
- Progress
- Lists to strings and messages
- REGEX (and Google) to the rescue
- Now that I have the machine of the local table, now what?
- What next?
- Final of the evening
- Query of global table edited and ready to go--spaces
- Extracting the global table name
- Cross-linked IDs error means that it's time to restart OpenJMS
- No carriage returns or new lines in properties files! Yuck. : (
- Got past the null query problem
- ReqProc, MsgGblCmd, MsgGblQry
- Global query
- The flow
- Global query not implemented
- Can now send global query messages, though they fail.
- Top Ten Java mistakes
- Serializable? Hashmap? Do I need these things?
- Back to rock solid
- Okay, I lied.
- Sunday 7:45 Earth Day
- Two weeks to go
- Trying to get a DP to talk to a local database
- OpenJMS and DDBMS
- test entry