build validation

2007-01-30 Thread Steven Pannell
Hi, One of the problems I have encountered with ibatis is that some validation is not possible at compile time but only run time. Thus when the application starts ibatis checks the sql-maps to determine if the classes exists, for example, and then bombs out if there is a problem. Does anyone kno

problem with selectKey and parameter map

2006-06-09 Thread Steven Pannell
Hi, I am unable to get the option working with a parameter map. say I have this: select mytable_seq.nextval from dual insert into table(id, name) (#id#, #name#) Running this I get an error because the insert reads the ID

RE: make DB call for every new connection

2006-01-05 Thread Steven Pannell
4, 2006, at 6:59 AM, Steven Pannell wrote: > Hi, > > I want to set some session infomation for a connection I make using > ibatis > on my oracle database. This works fine as follows: > > client.queryForObject("setClientInfo",null); > > executes a stored proc

make DB call for every new connection

2006-01-04 Thread Steven Pannell
a kind of new connection listener. Captures a connection has been made and does something. know what I mean? thx. Steve. -------- Steven Pannell Technical Project Manager zooplus AG Eichenweg 4 Rg. 85774 Unterföhring Tel: +49 (89) 950

Use isNull (in sqlMap) with a Long value?

2005-11-04 Thread Steven Pannell
Hi, I want to make use of the isNull option in the sqlMap using a Long as the parameter class like this: UPDATE log SET new = 10 1000 where ID = #value# But it does not work

Bulk inserts

2005-11-02 Thread Steven Pannell
Hi, Is there a faster way of performing bulk inserts? currently I do something like: for(int i=1;i < list.size(); i++) { MyObject object = list.get(i); sqlMapClient.insert("myInsert", object); } This seems to take forever! Is is possible to pass the complete list or somethi

RE: cannot using a dollar sign in my maps

2005-10-12 Thread Steven Pannell
wiki, but not sure if it still is - use $$ to get a $ in your query. Larry On 10/12/05, Steven Pannell <[EMAIL PROTECTED]> wrote: > Hi, > > I have the following oracle (intermedia indexed) statement map sqlMap file: > > > > > > When I run this st

cannot using a dollar sign in my maps

2005-10-12 Thread Steven Pannell
Hi, I have the following oracle (intermedia indexed) statement map sqlMap file: When I run this statement I get the following error: java.util.NoSuchElementException at java.util.StringTokenizer.nextToken(StringTokenizer.java:332) at com.ibatis.sqlmap.engine.map

cache problem with oscache

2005-09-13 Thread Steven Pannell
Hi, Sometimes when make a SQL call I get a nullpointerException like: java.lang.NullPointerException java.util.HashSet.(HashSet.java:99) com.opensymphony.oscache.base.algorithm.AbstractConcurrentReadCache.getGroup ForReading(AbstractConcurrentReadCache.java:954) com.open

RE: Problem getting BLOB from oracle

2005-08-16 Thread Steven Pannell
. Nathan On Aug 12, 2005, at 9:39 AM, Steven Pannell wrote: > Hi, > > I'm trying to get a BLOB from an oracle 10g DB but all I get are > the first > few bytes. I have the latest jdbc14.jar from oracle and the map > looks like > this: >

Problem getting BLOB from oracle

2005-08-12 Thread Steven Pannell
Hi, I'm trying to get a BLOB from an oracle 10g DB but all I get are the first few bytes. I have the latest jdbc14.jar from oracle and the map looks like this: select document from document_table where id = #value# My bean is as so.. public class TestBean

flashing the cache

2005-08-09 Thread Steven Pannell
Hi, I use the oscache with my data queries and am wondering if there is anyway I can force flush the cache before the timeout period.? I notice some undocumented code: .flushDataCache() for cache model But not sure how I can use this? Anyone have any pointers?? thx. Steve.

cache timeout

2005-08-03 Thread Steven Pannell
Hi, I'm using oscache in my map file like: This is OK but what I would really like is to set the flushInterval using standard cron syntax. OSCACHE supports this. Is this implemented in iBatis?? If so how's it working?. If not any chance of getting the cron syntax ad