Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
Date: Wed, 2 Aug 2017 05:34:44 -0700 (MST)
From: anas4120 <anas_taud@yahoo.fr>
To: user@ignite.apache.org
Message-ID: <1501677284421-15899.post@n6.nabble.com>
In-Reply-To: <1501668065400-15888.post@n6.nabble.com>
References: <759409871.5216233.1501593451202@mail.yahoo.com> <1501654065995-15878.post@n6.nabble.com> <1501665878319-15885.post@n6.nabble.com> <1501668065400-15888.post@n6.nabble.com>
Subject: Re: How to manage sequence with legacy database having auto
 increment id
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
archived-at: Wed, 02 Aug 2017 12:34:51 -0000

What I'm trying to achieve is similar to Spring JDBC framework. In Spring
JDBC template API there is a way to delegate ID incrementation to database,
for example: 

*....
Customer customer=new Customer();
customer.setLogin("toto")
customer.setFirstname("toto");
customer.setLastname(("Skilatchi");
.... 

GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
final Timestamp NOW=new Timestamp(System.currentTimeMillis());
JDBC_TEMPLATE.update(
					(Connection connection) -> {
						PreparedStatement ps = connection.prepareStatement(
							"INSERT INTO CUSTOMER (login, firstname, lastname, phone, email, age,
creation_date, update_date) VALUES (?,?,?,?,?,?,?,?)"
							,new String[] {"id"}
						);
						int index=1;
						ps.setString(index++, customer.getLogin());
						ps.setString(index++,customer.getFirstname());
						ps.setString(index++, customer.getLastname());
						ps.setString(index++, customer.getPhone());
						ps.setString(index++, customer.getEmail());
						ps.setInt(index++, customer.getAge());
						ps.setTimestamp(index++, NOW);
						ps.setTimestamp(index++, NOW);
						return ps;
					}
					,keyHolder
);
customer.setId(keyHolder.getKey().longValue());
...*


After creation, the Customer.id attribute is populated automaticly with the
generated ID in database by using GeneratedKeyHolder. 

Thanks. 


Humphrey wrote
> Look here [1] on how to use the IgniteAtomicSequence.
> You can set a value for which you want to start counting.
> 
> I'm not sure what you are trying to achieve? Why not pass the Id to the
> query?
> cache.query(new SqlFieldsQuery("INSERT INTO CUSTOMER (id, login, email,
> age) VALUES (?,?,?,?)")
>                         .setArgs(
>                             ID
>                             ,customer.getLogin()
>                             ,customer.getEmail() 
>                             ,customer.getAge()
>                         )
> 
> I'm not sure how Ignite should be configured if your database has an
> autoincrement field for ID, how this should be implemented in the cache
> configuration. Maybe just leave the field ID out from the cacheCofig?
> 
> [1] https://apacheignite.readme.io/docs/id-generator


--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-to-manage-sequence-with-legacy-database-having-auto-increment-id-tp15857p15899.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.