headers
Anthony & Melissa Berglas | 1 Nov 2005 05:45

Re: Using SProperty / Baracuda / Wings / Spring

Hello Franck,

You are doing the sort of thing that I had in mind.  Map data fields 
directly to ui fields and avoid a lot of book keeping code.

I should really have a new property, DISPLAY_LENGTH which defaults to 
SBYTE_SIZE.

As to prompt, I would default the prompt to the data prompt, but allow 
overriding.  If i18n is really an issue for you for more than a couple 
of languages then more work needs to be done.

(Note that there is nothing to stop you creating your own properties, 
that is precicely the point of having them external.)

As to Swing and transactions, sounds like you have got the hooks to 
work.  If you send me the code fragment I'll include it with the 
distribution as unsupported but useful, much like SConnectionEJB.

Good luck.

Anthony

Franck Routier wrote:
>   Hi,
> 
> I'm sorry I've been so long to respond... quite busy these times :-)
> 
> Anthony & Melissa Berglas a écrit :
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Anthony & Melissa Berglas | 1 Nov 2005 05:56

Re: Maintaining a collection of children data objects in a SRecordInstance, and clean detaching

If performance is really a problem then you could have one loop that 
retrieves the Fipies and a second top level loop that retrieves all 
the lines, ie. just two queries.  You might also be able to use 
getArrayList() to avoid a loop.

I would indeed like to revisit this problem sometime, but it is 
tricky.  I'm certain that Hibernate gets this part wrong, with the 
one end of an association being quite independent of the many.  They 
down grade the database model to the cruder "object" model.

My feeling is that in general this does not cause much pain.  But I 
would welcome any considered contributions.

Regards,

Anthony

At 11:43 PM 31-10-05, Franck Routier wrote:
>Hi all,
>
>this is the way I handle the common "collection" problem in SimpleOrm :
>
>         List fipieList = new SArrayList();
>         try {
>             SConnection.attach(new SDataSourceJavaX(this.dataSource),
>"getAllPieAndChilds");
>             SConnection.begin();
>             SPreparedStatement stmt = Fipie.meta.select("1=1","1");
>             SResultSet res = stmt.execute();
>             while (res.hasNext()) {
(Continue reading)

Permalink | Reply | 4 comments |
headers
Franck Routier | 2 Nov 2005 17:22
Favicon

Re: Maintaining a collection of children data objects in a SRecordInstance, and clean detaching

Anthony & Melissa Berglas a écrit :

> If performance is really a problem then you could have one loop that
> retrieves the Fipies and a second top level loop that retrieves all
> the lines, ie. just two queries.  You might also be able to use
> getArrayList() to avoid a loop.

Well, I used to getArrayList(), but then I need a way to detach it, or 
else I will end up iterating over it just to detach.

Or is their a way to detach a whole SArrayList, or even a whole 
SConnection ?

>
> I would indeed like to revisit this problem sometime, but it is
> tricky.  I'm certain that Hibernate gets this part wrong, with the
> one end of an association being quite independent of the many.  They
> down grade the database model to the cruder "object" model.

I am not sure of what you mean here... Are you refering to what you 
expose in the White Paper /
Associations and Class Mappings paragraph ?

>
> My feeling is that in general this does not cause much pain.  But I
> would welcome any considered contributions.

Well, in fact, I am pretty happy with the way I have to handle data 
manipulation here.
The main problem I am facing with this approach is that SRecordMeta has
(Continue reading)

Permalink | Reply | 3 comments |
headers
Kathy S | 9 Nov 2005 15:39
Picon
Favicon

Must see : Website of the week

Hello!
Do check the website of the week by visiting
http://newwebsitepick.info .
The website also says how you can nomiate your website
if you have one. 
Regards,
Kathy

		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com

------------------------ Yahoo! Groups Sponsor --------------------~--> 
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/5cFolB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> To unsubscribe from this group, send an email to:
    SimpleORM-unsubscribe <at> yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
(Continue reading)

Permalink | Reply | 0 comments |
headers
sylvainhamel | 9 Nov 2005 21:05
Picon
Favicon

Re: Maintaining a collection of children data objects in a SRecordInstance, and clean detaching

Yo all, long time no see.

A concrete example : 

Invoice (header)
and
Invoice Item (each of the items invoiced) 

In short, for each invoice there is many invoice items. So you have 
2 tables one for the header and one for the items.

Is that a good example?

My 2 cents about your solution :

Its incredibly costly time wise. For each header you make a query to 
fetch all rows so that if you have 1000 invoices with 5 items on 
each thats 5001 queries! Queries to the database are one of the 
worst offenders (if not the worst) when it comes to response time. 
Always try to minimize the number of queries.

You say that the header doesnt mean anything by itself. I would 
doubt that assertion. In my example you might store some calculated 
values in the header. The transaction date is certainly stored in 
the header so that retrieving all the transactions between 2 dates 
only involves the header. The same reasonning applies to the the sub-
table (Invoice Items).

My tips/solution
(Continue reading)

Permalink | Reply | 1 comment |
headers
aco_trebinje | 14 Nov 2005 06:02
Picon

Downloading SimpleORM?

Hi everyone, 

I stumbled into simpleORM after doing a bit of googling and it has 
drawn my interest, sounds like a useful product. However, I can't seem 
to be able to download the software. I went to http://www.simpleorm.
org, filled in the form required to get to the download page and once 
I got there, the link provided didn't work (and still doesn't).

Is there any other place from which I can download simpleORM?

Thank you for your help.

------------------------ Yahoo! Groups Sponsor --------------------~--> 
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/5cFolB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> To unsubscribe from this group, send an email to:
    SimpleORM-unsubscribe <at> yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
(Continue reading)

Permalink | Reply | 1 comment |
headers
Philippe Back (High Octane | 14 Nov 2005 07:36
Picon
Gravatar

RE: Downloading SimpleORM?

It should work.
Maybe in the yahoo group / files section.

/Phil 

> -----Original Message-----
> From: SimpleORM <at> yahoogroups.com 
> [mailto:SimpleORM <at> yahoogroups.com] On Behalf Of aco_trebinje
> Sent: lundi 14 novembre 2005 06:03
> To: SimpleORM <at> yahoogroups.com
> Subject: [SimpleORM] Downloading SimpleORM?
> 
> Hi everyone, 
> 
> 
> I stumbled into simpleORM after doing a bit of googling and 
> it has drawn my interest, sounds like a useful product. 
> However, I can't seem to be able to download the software. I 
> went to http://www.simpleorm.
> org, filled in the form required to get to the download page 
> and once I got there, the link provided didn't work (and 
> still doesn't).
> 
> Is there any other place from which I can download simpleORM?
> 
> Thank you for your help.
> 
> 
> 
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Anthony & Melissa Berglas | 14 Nov 2005 07:43

Downloads Fixed

The download folder listing has broken, so use the following URL to 
get the current
version

<http://simpleorm.org/downloads/SimpleORM-02_21.zip>http://simpleorm.org/downloads/SimpleORM-02_21.zip 

(I'm looking into it, and the README now has the above reference.)

Anthony

EMail: berglas <at> spreadsheetdetective.com

+61 7 3369 4065 (Australian Eastern Standard Time)

If the model seems correct only because the numbers look right,
then why build the model in the first place?

------------------------ Yahoo! Groups Sponsor --------------------~--> 
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/5cFolB/TM
--------------------------------------------------------------------~-> 

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> To unsubscribe from this group, send an email to:
    SimpleORM-unsubscribe <at> yahoogroups.com
(Continue reading)

Permalink | Reply | 0 comments |
headers
ytcui2001 | 17 Nov 2005 17:29

Error in running the test

I am running the ColumnCacheTest using MySQL. I am getting the
following error messages:

3.TestCon  -Begun Connection [SConnection 3_TestCon: 
jdbc:mysql://dev1:3306/EMDEVELOP]
3.TestCon  -Committed Connection [SConnection 3_TestCon: 
jdbc:mysql://dev1:3306/EMDEVELOP]
3.TestCon  -Begun Connection [SConnection 3_TestCon: 
jdbc:mysql://dev1:3306/EMDEVELOP]
3.TestCon ---Get Failure simpleorm.core.SException$Error: ???Cannot 
access unqueried field [F Employee.RESUME] in [Employee 100]
3.TestCon  -Detaching Connection [SConnection 3_TestCon: 
jdbc:mysql://dev1:3306/EMDEVELOP]
Exception in thread "main" SException 
simpleorm.core.SException$JDBC: ???
Executing 'SELECT `EMPEE_ID`, `NAME`, `PHONE_NR`, `SALARY`, 
`NR_DEPENDENTS`, `DEPT_ID`, `MANAGER_EMPEE_ID`, `RESUME`, (SELECT 
NAME FROM XX_DEPARTMENT D WHERE D.DEPT_ID = XX_EMPLOYEE.DEPT_ID) 
FROM `XX_EMPLOYEE`  WHERE `EMPEE_ID` = ?  FOR UPDATE' for [Employee 
100]: java.sql.SQLException: Syntax error or access violation,  
message from server: "You have an error in your SQL syntax.  Check 
the manual that corresponds to your MySQL server version for the 
right syntax to use near 'SELECT NAME FROM XX_DEPARTMENT D WHERE 
D.DEPT_ID = XX_EMPLOYEE."
java.sql.SQLException: Syntax error or access violation,  message 
from server: "You have an error in your SQL syntax.  
Check the manual that corresponds to your MySQL server version for 
the right syntax to use near 
'SELECT NAME FROM XX_DEPARTMENT D WHERE D.DEPT_ID = XX_EMPLOYEE."
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
(Continue reading)

Permalink | Reply | 2 comments |
headers
Anthony & Melissa Berglas | 20 Nov 2005 09:57

Re: Maintaining a collection of children data objects in a SRecordInstance, and clean detaching

Hello Frank,

As well as adding SFieldChildren like classes, 
you can add SProperties to existing 
objects.  SFieldMeta and SRecordMeta both have a 
hash map of properties.  You should never need to 
use reflection and naming conventions.

Anthony

At 02:22 AM 03-11-05, Franck Routier wrote:
>Anthony & Melissa Berglas a écrit :
>
> > If performance is really a problem then you could have one loop that
> > retrieves the Fipies and a second top level loop that retrieves all
> > the lines, ie. just two queries.  You might also be able to use
> > getArrayList() to avoid a loop.
>
>Well, I used to getArrayList(), but then I need a way to detach it, or
>else I will end up iterating over it just to detach.
>
>Or is their a way to detach a whole SArrayList, or even a whole
>SConnection ?
>
> >
> > I would indeed like to revisit this problem sometime, but it is
> > tricky.  I'm certain that Hibernate gets this part wrong, with the
> > one end of an association being quite independent of the many.  They
> > down grade the database model to the cruder "object" model.
>
(Continue reading)

Permalink | Reply | 0 comments |

Gmane