First, let me say that SimpleORM looks pretty cool, and I'm investigating using it for a project at work. Thanks! Now, on to JTDS. We have SQL Server 2000, for...
Sorry kmfav, don't know, don't use SQL Server. You'll probably find more joy doing a Google search and looking at the MS news groups. But if you do decide to...
Melissa & Anthony Ber...
berglas@...
Apr 10, 2003 4:07 am
354
Hi, I've just downloaded the SimpleOrm package and am trying out my first example. I just met a java exception that I hadn't yet seen, so I already feel my...
Hello, when making a get on a char type field, the result is trimed by mySql. The doumentation says : " When CHAR values are retrieved, trailing spaces are...
Why not replacing the spaces with something before storing and after getting the values back ? Some DBs (Sybase Anywhere) add spaces when doing a getString()...
phil@...
Apr 13, 2003 8:05 pm
358
Try using VARCHAR instead of CHAR. Haven't tried on MySQL but it traditionally does not trim trailing spaces. CHAR is basically a COBOL space padded string,...
Melissa & Anthony Ber...
berglas@...
Apr 13, 2003 8:07 pm
359
Hi Anthony, thanks for your answer. In fact, it comes from MySql which really removed the ending spaces whatever char or varchar field type you use. What is...
That 's another idea but I have something like 200 hundreds fields and in that case and it is a too much work. However, my fields have always to be a certain...
Hi i believe the magic words are SELECT xx FROM tableyy WHERE zzz WITH (NOLOCK) You can check if the table was locked by calling EXEC sp_lock Richard ... using...
One of the future plans noted on SimpleORM website is a "Simple quick start utility that generates SimpleORM record classes based on JDBC meta data." I had a...
Hello Doug, When you say you got an initialization exception, I assume that it was something explicit like java.lang.ExceptionInInitializerError: SException ...
Melissa & Anthony Ber...
berglas@...
Apr 14, 2003 9:12 pm
366
Something of the sort is slated to be an important part of my current project. I'd be happy to be involved in the implementation of this functionality, if...
Yes, sounds good. But please write up a few paragraphs about what you would like to do first. (It will go into the manual.) Yes, generating a class that gets...
We are fussy about giving people roles that allow for creating tables so I tried the tests first using temporary table names (#name in Sybase) with interesting...
Hello Joe, Thanks for your analysis. Maybe we should have a third driver, SDriverMSSybase that has the common stuff. For testing purposes I would like some...
Hi I have attached the sort of output files that I think Quick Start would produce. There would be two sets of files, one for BR and one for the basic mapping....
I have attached the SDriver and SDriverSybase files as well as the examples files with changes needed to make them run with Sybase. Using these I can run most...
Sounds good. Few comments:- 1. The base class is the top of the tree, ie SRecordInstance. Maybe Employee_generated? 2. Let the user of the generator control...
I found a nice package of utility classes on the Web by Kyle Brown http://members.aol.com/kgb1001001/#Articles, and have used them to lay the groundwork for...
It will be necessary to create default mappings between the datatype returned from the metadata query and the SField... type generated in the code. My idea is...
I'm to the point where I generate a base class with all of the fields. I don't know exactly how to go about the roles. I might have a particular problem with...
Put the mappings in the SDriver class. Then the same driver subclasses can be used to override them where necessary. Your mappings look pretty good. Thanks, ...
Melissa & Anthony Ber...
berglas@...
Apr 20, 2003 3:10 am
378
If the JDBC driver does not support foreing keys then just don't map them. Your utility will still be a great help, even if a bit of manual tweaking is...
Melissa & Anthony Ber...
berglas@...
Apr 20, 2003 3:12 am
379
Actually, one thing that you absolutely do need is a primary key. Anthony ... -- Melissa & Anthony Berglas If the correctness test is that the numbers look OK,...
Melissa & Anthony Ber...
berglas@...
Apr 20, 2003 3:13 am
380
You also need to indicate if the field can be null. Richard ... fields. I ... particular ... some input ... far, with all ... them. I used ... unfamiliar...
Robert, Your 3 days are probably over by now, but there are a few problems. When I ran your programs against a Sybase instance I got the following: public...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
