Re[2]: Abator installation

/5/06, Sergey Livanov [EMAIL PROTECTED] wrote: Can I install abator on the WebSphere Studio 5.1.2 ? -- regards, Sergey mailto:[EMAIL PROTECTED]

stored procedure question .

Invocation of stored procedures procedure id=... { call sp(?) } /procedure works in Oracle 9i with classes12.jar ? -- regards, Sergey mailto:[EMAIL PROTECTED]

Spring iBatis question

I use Spring Dao + iBatis and I have to run into the one transaction inserts order document. ( insert into header values( docpk, docnum, docdate, client ) and many inserts as insert into( docfk, itempk, good, price, quantity ). I do not know how to create one transaction in the case of spring

Re: Spring iBatis question

]: On May 17, 2007, at 10:34 AM, Sergey Livanov wrote: I use Spring Dao + iBatis and I have to run into the one transaction inserts order document. ( insert into header values( docpk, docnum, docdate, client ) and many inserts as insert into( docfk, itempk, good, price, quantity ). I do

sql server paging

I want to make paging for mssql server. I use a design SELECT * FROM ( SELECT TOP #quantity # * FROM ( SELECT TOP #offset# * FROM c1db.dbo.accounts a ORDER BY DOCDATE desc, docnum desc) as acc

Oracle11g question .

I installed Oracle11g and can not set up driverClassName and url parameters of connection. Help me please, who install already please. ( I downloaded ojdbc5.jar and orai18n. ) NLS_LANG=UKRAINIAN_UKRAINE.CL8MSWIN1251 error : java.lang.NoSuchMethodError:

Re: Oracle11g question .

driver , url, user pwd. jdbc.ORAdriverClassName=oracle.jdbc.driver.OracleDriver jdbc.ORAurl=jdbc:oracle:thin:@192.168.1.15:1521:ORCL jdbc.ORAusername=servers jdbc.ORApassword=servers 2009/3/21 Sergey Livanov sergey.liva...@gmail.com I installed Oracle11g and can not set up driverClassName

Re: Oracle11g question .

, Mar 20, 2009 at 9:35 PM, Sergey Livanov sergey.liva...@gmail.com wrote: driver , url, user pwd. jdbc.ORAdriverClassName=oracle.jdbc.driver.OracleDriver jdbc.ORAurl=jdbc:oracle:thin:@192.168.1.15:1521:ORCL jdbc.ORAusername=servers jdbc.ORApassword=servers 2009/3/21 Sergey Livanov

MySql get primary key error

Could you please help me ... I want to get primary key value after insert a record ( MySQL 3.1... ). I wrote after insert statement insert resultclass=int insert into mytable ( fld1, fld2 ) values ( #fld1#, #fld2# ) select last_insert_id() as value But the system gives me

Re: AW: AW: String parameter problem

What database do you use ? 2009/7/9 Cax cahyadiherma...@gmail.com i try to change the sql not to get the parameter, like this : select PX_IR025_PAN as pan, F9_IR025_CRN as CRN, FX_IR025_EMB_NAME as name, FX_IR025_CRD_PGM as crdPgm, FX_IR025_UPD_UID as updId

Re: Ibatis sql question

isNotEqual prepend=#parameter# property=maxprice compareValue=1 price BETWEEN #price# AND #maxprice# /isNotEqual isNotEqual prepend=#parameter# property=maxprice compareValue=0 price =#price# OR price=#maxprice# /isNotEqual 2009/7/24 Odelya YomTov ode...@jpost.com Hi! I would

cache question

I use iBatis 2.6. v. Does the cache work, when I call the sql statement by stored procedure ?

maxTransaction quantity

I read, that maxrequest, maxsessions, maxtransactions were remote from ibatis. I use ibatis 2.6 + spring2 + Glassfish. How I can set the unlimited amount of concurrent transactions ?

Best practices

I have an idea to run sql operators from the stored procedures. For me it has become a necessity because every client has their own data structure and when a new version is released errors spring up. In transfering a variable code to the level of database mistakes can be avoided. But in