empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele (JIRA) <empire-db-...@incubator.apache.org>
Subject [jira] [Closed] (EMPIREDB-148) how to use DBCommond to create a prepared sql string
Date Tue, 19 Jun 2012 21:12:43 GMT

     [ https://issues.apache.org/jira/browse/EMPIREDB-148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Rainer Döbele closed EMPIREDB-148.

    Resolution: Fixed

Hi Yan,

to answer your questions:
Yes this feature is available.

As with many requests like this, it is always a good idea to first take a look at our two
core example projects:
- the empire-db-example-basic shows the basic principles
- the empire-db-example-advanced is for all who want or need to go beyond that.

For prepared statements there are two things to say:
1) When using a DBCommand you need to declare parameters manually using cmd.addParam().
2) When using DBRecord prepared statements will be used automatically if the corresponding
option is set on the database.
   Use db.setPreparedStatementsEnabled(true) to enable prepared statements for all operations
on DBRecord (insert, update, delete)

If you run the advanced sample (SampleAdvApp.java) you will see in the log output that prepared
statements are used for most things.
Using command params is explicitly demonstrated with the method commandParamsSample(...).

I hope this helped.


P.S. Please do not create JIRA tickets for questions like this.
Tickets should be used for bugs, improvments, patches etc. not for simple questions.

> how to use  DBCommond to create a prepared sql string
> -----------------------------------------------------
>                 Key: EMPIREDB-148
>                 URL: https://issues.apache.org/jira/browse/EMPIREDB-148
>             Project: Empire-DB
>          Issue Type: Wish
>            Reporter: yan zhang
>            Priority: Minor
> I am working a new project and looking for lightweight ORM tools. One feature I need
is to be able to generate sql string and we have our own layer of running query.
> I come across   DBCommand class, and it seems to be able to generate raw sql string.
One feature I am looking to is able to generate prepared update/insert statement. the getInsert()
only returns a regular sql string. 
> Would really appreciate if someone can respond on;
> 1) whether this feature is available?
> 2) if not, if this is in your feature plan?
> 3) if yes, code sample will be very helpful.
> thanks,

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message