I have a quick question that I hope one of you might help me with. The documentation says that a subset of the total number of fields may be returned but it...
Once again, I hope this is not a stupid/redundant question. Is there anyway to suppress the 'FOR UPDATE' in the resulting sql by indicating that the select is...
Hello Eric, You can say something like (IdentFKeysTest.java) Department d100b = (Department)Department.meta.findOrCreate( "100", SQY_DESCRIPTIVE); Or you can...
Melissa & Anthony Ber...
berglas@...
Jan 5, 2003 4:00 am
166
Exactly. So specify SQY_UNQUERIED. And if you do accidentally attempt to update the record you will get an error. But if you requery the record without...
Melissa & Anthony Ber...
berglas@...
Jan 5, 2003 4:04 am
167
I tried this and it didn't seem to have the suggested effect. It did however, point me towards the constants. After looking there for a bit it I found ...
Anthony, This doesn't seem to work correctly, at least not when using the select method. Whenever I specify this value I get a '[f XX_ID] not covered' where...
Hello Eric, Don't bother digging through this, it is quite tricky. But it is my next priority and I'll recover and build some decent test cases and fix any...
Melissa & Anthony Ber...
berglas@...
Jan 6, 2003 12:08 am
170
Sorry, you are right, SQY_READ_ONLY. From the (updated) white paper:- <p>These queries normally select all the fields from the table. However, it is possible...
Melissa & Anthony Ber...
berglas@...
Jan 6, 2003 12:36 am
171
Hello Eric, For now just send changes to me as you have done. But it all needs to go onto SourceForge sooner than later. You raise an interesting issue. What...
Melissa & Anthony Ber...
berglas@...
Jan 6, 2003 12:55 am
172
Hello Kristian, Sounds like you are doing good things. There are several issues in generating schemas. I have added the following to the white paper. <p>If...
Melissa & Anthony Ber...
berglas@...
Jan 7, 2003 7:30 pm
173
Hello All, I have just released Version 1.01 of SimpleORM. New improvements include:- * The Query builder for non-sql queries. * Foreign Key Constraint DDL...
Melissa & Anthony Ber...
berglas@...
Jan 9, 2003 9:02 pm
174
Congratulations! I'll use this latest version soon, and let you know if I face any problems. Are the new features described in a document, or do we need to...
I have a problem with the new version: 1) SConnection.attach(con, "main"); 2) SConnection.begin(); 3) stmt = User.meta.select("USERNAME = ?", "USER_ID", ...
Hello Turgay, Good to hear from you. The README lists the new features. I always update the white paper with any structural issues, eg. there is an example of...
Melissa & Anthony Ber...
berglas@...
Jan 10, 2003 7:04 pm
177
I have made some minor changes to SRecordMeta to allow for methods that find with out creating anything. I realize that ou may use findorcreate and simply...
Hello Turgay, I have added a few test cases and could not reproduce a problem. Your lack of other trace messages is wierd, and almost certainly unrelated to...
Melissa & Anthony Ber...
berglas@...
Jan 11, 2003 12:19 am
179
Hello Eric, Thanks for your proposal, I have had a look. But I am not quite sure what you are trying to achieve. Using your new method one would write:- ...
Melissa & Anthony Ber...
berglas@...
Jan 11, 2003 1:06 am
180
... This is true and it would work nicely as well. ... Its all semantics I guess! In any case your right its probably not worthwile. And PLEASE do not fork the...
Hello Eric, No problem, I very much appreciate your efforts to use and contribute to SimpleORM. I did spend a little time on your proposal, but it was time...
Melissa & Anthony Ber...
berglas@...
Jan 12, 2003 1:38 am
182
Anthony, I saw in your code you never close PreparedStatements; for instance, SConnection.rawUpdateJDBC(String sql, String [] params){...} I had an application...
Anthony, I saw in your code you never close PreparedStatements; for instance, SConnection.rawUpdateJDBC(String sql, String [] params){...} I had an application...
Just downloaded simpleorm. I have been trying to get the build to run with no success. From what I can tell, it is having a problem with creating the...
Hello Sachin, You are right, the 1.3.1 Javadoc does not have an append(StringBuffer). But 1.4 does. But (I think) that I run and test against 1.3.1. Very...
Melissa & Anthony Ber...
berglas@...
Jan 15, 2003 4:29 am
186
Hello Jorge, Good point, have added close()s. They should not really be necessary, but... Have already fixed the StringBuffer issue. For some reason I was ...
Melissa & Anthony Ber...
berglas@...
Jan 15, 2003 4:40 am
187
Hello James, Maybe JSTL could be enhanced for SimpleORM, interested? (Probably easier to write a few taglibs than to have to write lots of empty get/setters.)...
Melissa & Anthony Ber...
berglas@...
Jan 15, 2003 4:52 am
188
Hello Lee, I had thought 1,000 was conservative, but have set it down to 100. It is just an example, go to Employee.java and change the number. In general, it...
Melissa & Anthony Ber...
berglas@...
Jan 15, 2003 4:57 am
189
hi Anthony, I wrote a program which establishes a connection with database and tries to retrieve a record with: String key = "PUESTOS"; FoliosRI newFolio =...
hi Anthony, I wrote a program which establishes a connection with database and tries to retrieve a record with: String key = "PUESTOS"; FoliosRI newFolio =...
Hello, Yes, I assume that PUESTOS is declared CHAR, not VARCHAR. I've fixed this using a loop rather than creating another string object with trim. (And Trim...
Melissa & Anthony Ber...
berglas@...
Jan 15, 2003 5:53 am
192
Hello: Ok. I made the change you suggested and now the build is running fine. Next step was to run the ADemo class per the instructions. The class has...