Is there no notion of a column's default value is SimpleORM? For example, when I call SDataSet.create() or SSessionJdbc.create(), I'd like the SRecordInstance...
Hi, you're not missing anything, and a default value would indeed be a valuable feature. I think we could think of it, to find where it would best fit : ...
Hmm. Defaulting can mean a number of things. 1. Values to be set to the fields when a record is initially created. 2. Values to be written to the database...
#1 is all I'm getting at. Setting them constructor sounds fine, I just thought it would be nice to define them "next to" the field, like: public static final...
You raise a valid point though. Maybe setInitialValue rather than setDerfault. And we should think about triggers and dirty behaviors to enable explicit...
Anthony & Melissa Ber...
berglas@...
Nov 13, 2008 1:23 am
1686
Hello John, Rewriting SDriver for a non-SQL database is certainly possible, although it has not been done before. You might like to focus on the DML, and just...
Anthony & Melissa Ber...
berglas@...
Nov 25, 2008 10:50 am
1687
Hello Martin, The generator had not been upgraded to 3.0, so your work is much appreciated. meta.findOrCreate is now SSessionJDBC.findOrCreate and friends....
Hi, I have found that if you try to create a record for a table that only has one column, you get an error (assertNewRow() fails). Has someone else experienced...
SimpleORM traditionally did not allow key only tables at all, but Franck added that in. Will have a look at your single column example. But it does seem very...
Anthony & Melissa Ber...
berglas@...
Dec 3, 2008 3:10 am
1690
It is easy to create a generic method that will populate POJOs, see the mailing list http://tech.groups.yahoo.com/group/SimpleORM/message/1675 Would not be...
Hello Martin, I have checked in your code. Made minor changes to build, move example to test. Test task designed to run with simpleorm tests. Compiles, but I...
Hi, I will check out fresh and work from that from now on. I already have a sourceforge account, my username is Holiman. Â Thanks, /Martin ... -- Martin Holst...
Is there any way to do case insensitive string comparison with SQuery without resorting to rawPredicate? If not, it seems that all the drivers would need to...
No. To keep it simple, SQuery is only designed to cover the 80% of easy, common cases. The others can be dealt with using rawPredicate as you mention. SQL 92...
Anthony & Melissa Ber...
berglas@...
Dec 10, 2008 12:24 am
1695
If you check out the trunk of simpleorm, run ant demo cd extras\simpleormgenerate ant test you will see the generator run on hsql. Could do with a bit more...
Hi, The tables I was using were MySQL tables with auto-increment primary keys. As I have gathered now from earlier discussions, that does not work very well,...
Hi all, I commited a patch that will remove a record from the dataset cache if the record has been deleted, once the deletion has been flushed. This allows to...
Hello Philippe, I have some slides that I prepared for QJUG a while ago. I'll tidy them up and send them to you. (They will be checked in under webset/sorm.) ...
Anthony & Melissa Ber...
berglas@...
Dec 12, 2008 7:24 am
1699
Hello Martin, Good point about "auto-increment" keys that are only generated at INSERT time. Normally default auto-increment keys are only generated if no...
After a bit of stuffing about I have added the INSERT IDENTITY functionality for HSQLDB. Have also cleaned it up a bit. It is tested by GeneratorTest. To...
Hi, I am a newbie with simpleORM. the examples provided with the distribution and the white paper on the site (simpleorm.org) are too complex for me. I can't...
SFieldBooleanChar's defaultSqlDataType() method returns "VARCHAR", which doesn't work with MySQL when creating a table. I'm using this as a workaround: class...
Hello, Your code looks generally OK. But there is a lot to read through without some diagnostics. When you say it "does not work" what does it actually do?...
You found a bug. The bug is that no max size is specified for that VARCHAR. Some dbs accept this with sensible defaults (no limit) others with stupid defaults...
Anthony & Melissa Ber...
berglas@...
Jan 12, 2009 12:59 am
1706
Hello, I'm getting errors trying to deserialize some SimpleORM objects. (using serialization is necessary due to the the way I am integrating SimpleORM with...
Hello Franck, I had a very brief look through the change log. What happens if a record is created, with initial value on column C that is not later set. C is...
berglas@...
Jan 26, 2009 11:25 pm
1709
Hi Anthony, Thanks for reviewing my changes. I have added tests (in BasicTests) to test the various cases you mention. Everything seems to works fine... ... C...
Hello Carl, I did not write the serialization part. Looks like it needs a bit more thought. The page you refer to is rather unintelligible, but the idea that...