Re: selectKey with Oracle (resolved)

Being Oracle-challanged myself, I approached my friendly DBA with the problem. I was told that a different function call was used for the same purposed and called after the insert. Perhaps each Oracle shop has their own such function. So I modified the name and flipped the order of my insert st

Re: selectKey with Oracle

The "sequence does not exist" error is an Oracle message. Try it from sql*plus (with the same user/password as iBATIS is using), and let us know how that works. Larry On 8/19/05, Paul Glezen <[EMAIL PROTECTED]> wrote: > > > Hi, Folks, > > I get a "sequence does not exist" error message w

selectKey with Oracle

Hi, Folks, I get a "sequence does not exist" error message when trying to get the key resulting from an insert into an Oracle table. The key is a column called "unique_product_id" which maps to uniqueProductId in my bean. My insert statement looks like this. parameterClass="xyz.ProductEntityBe

Are public enums allowed?

I have a Class Report that has some public enums. I was hoping to map these to data in the database by way of a custom type handler. callback="reporting.viewer.dao.ibatis.FrequencyHandler"/> but I get this error? Caused by: com.ibatis.dao.client.DaoException: Error while configuring DaoM

unsubscribed

__ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: where can I find a simple implementation example

Hi I found that very good blog just explaining only IBatis with a simple example. http://www.j2eegeek.com/blog/2005/01/31/ibatis-where-have-you-been-all-my-life/ Rgds Prashanth --- Salim Madjd <[EMAIL PROTECTED]> wrote: > Hi, > I have read a lot of documentations and I still can not put the wh

Re: Error when web application is unused for a long time

I try this :                                                                                                                                                         it seems to work fine... Thanks everybody TNO a écrit : But I have a problem... I'm

Re: Error when web application is unused for a long time

But I have a problem... I'm using Spring framework... I use Spring to initialize my dataSource in the Spring application-context.xml:           ${jdbc.driverClassName}         ${jdbc.url}         ${jdbc.username}         ${jdbc.password}         ${jdbc.defaultAutoCommit}           ...    

errors with iterate and $$

Hello, I've just switched to datamapper 2.1.5, hoping that i can use list directly as parameter (and not some confugisng listholder with list property). I found the following errors (please correct me if I'm wrong) 1) I had first the following iterate I thought that "value" is magic word, saying t

RE: Error when web application is unused for a long time

It doesn’t have to be a “real” query, following settings worked for me (mysql)   …         … From: TNO [mailto:[EMAIL PROTECTED] Sent: 19 August 2005 03:45 PM To: ibatis Subject: Error when web application is unused for a long time   Hello, I am

RE: How to get table metadata?

Hi All, Thank you very much for your inputs. We would like to generate a report of all tables & columns that are being selected/inserted/updated by our application since the database is shared by many other applications/tools. I will try one of the options suggested by all here, which requires

Re: Error when web application is unused for a long time

Hi, You need to have the PING Query in the sql-map-config.xml. I think that should fix the problem. Rgds Prashanth Sukumaran. --- TNO <[EMAIL PROTECTED]> wrote: > Hello, > > I am working on a web application using Ibatis, Spring and JSP on Jonasz > Server with DB PostGre. > Sometime after 2

Error when web application is unused for a long time

Hello, I am working on a web application using Ibatis, Spring and JSP on Jonasz Server with DB PostGre. Sometime after 2 hours of inactivity, we have this error. With a F5 refresh on the navigator, the application re-works fine. I wonder if Ibatis and my cache configuration can be involved in

Re: NULL Java Integers to Oracle NUMBER

You can use two differnet layouts for this: #propertyName:NUMERIC:0# or #propertyName,jdbcType=NUMERIC,nullValue=0# Anything you can do in a full parameter map, you can do using that second syntax using name=value pairs. Larry On 8/18/05, Mathew Samuel <[EMAIL PROTECTED]> wrote: > > How do

multiple transactions in single flow

Hello, I have recently changed my class from using external connection pool to one integrated into ibatis; I have to commit transaction few times during the flow; my question is - doI have to repeat sqlMapClient.commitTransaction(); sqlMapClient.endTransaction(); sqlMapClient.startTransaction();

Re: A shot in the dark about unit testing.

Just use a file name, filename="file1" mimetype="mime/type1" size="115" data="data/files/1.gif"/> where `data` column is of BLOB type and "data/files/1.gif" is a path relative to process's current path, not to the xml file. Oleg Nathan Maves wrote: We have been using DBUni