Re: maxRequests, help

2005-08-31 Thread Clinton Begin
Those settings are really low.  Are you sure you don't want/need more? What is wrong with the defaults? Cheers, Clinton On 8/31/05, Неверов Дмитрий <[EMAIL PROTECTED]> wrote: Hi,I have SqlMapConfig.xml: http://www.ibatis.com/dtd/sql-map-config-2.dtd">  enhancementEnabled="true"lazyLoadin

Re: maxRequests, help

2005-08-31 Thread Неверов Дмитрий
I just now understand that's wrong. I have BaseDAO and other DAO extends it, and in BaseDAO I just do commitTransaction() and don't endTransaction(). Sorry for disturb. - You wrote 1 сентября 2005 г., 8:43:59: > Hi, > I have SqlMapConfig.xml: > > 2.0//EN" "ht

Re: cacheModel configuration

2005-08-31 Thread H.E. Sum
Hi, thanks all for replying so quickly. Rearranging the order of the mapping files helped solve the problem. What is a good solution for doing it bidirectionally? e.g. if I have my Article.xml specify a flush when an update statement in Author.xml is invoked and vice versa? Thanks again. - H.E.

user-java@ibatis.apache.org

2005-08-31 Thread Неверов Дмитрий
Hi, I have SqlMapConfig.xml: http://www.ibatis.com/dtd/sql-map-config-2.dtd";> insert: insert into sp_gost (name_gost) values (#gostName#) and sprGosts.jsp, that used to insert new Gost: String gostName = WebUtils.getStringParameter

RE: iBatis logging

2005-08-31 Thread Paul Glezen
I was hoping to see some output from whatever implements SqlMapClient.  For example, I'm seeing the following based on tracing from an Oracle JDBC driver, 1. I sandwhich a read-only query between sqlMap.startTransaction() and sqlMap.commitTransaction.  But I see no commit issued to the driver

RE: iBatis logging

2005-08-31 Thread Niels Beekman
Hi,   The java.sql.*-outputs are from iBATIS too, java.sql does not do any debugging on it’s own… What logging did you expect?   Niels   From: Paul Glezen [mailto:[EMAIL PROTECTED] Sent: woensdag 31 augustus 2005 18:16 To: user-java@ibatis.apache.org Subject: iBatis logging

Broken Wiki FAQ Links Update

2005-08-31 Thread Clinton Begin
Hi everyone, Most of the links on our FAQ are currently broken due to a configuration issue with the server currently hosting Confluence.  It's likely a security policy causing issues related to our use of the "?" symbol in the FAQ wiki titles (which are then used directly in the URL). Atlassian

iBatis logging

2005-08-31 Thread Paul Glezen
Hi Folks, I'm having a some trouble with iBatis logging.  My log4j.properties looks like this for my JUnit tests: log4j.properties log4j.rootLogger=DEBUG,stdout log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.l

Re: Oracle scheme

2005-08-31 Thread Larry Meadors
One way would be to use $prefix$tablename in stead of just tablename. For oracle, prefix would be set to your schema name, for all others, it would be blank. Larry On 8/31/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello all, > > I use iBATIS to access ORACLE, MS SQL and other databases

Re: Oracle scheme

2005-08-31 Thread Jan Vissers
Ok, I think my knowledge of Oracle is getting in the way here. How is creating a synonym any harder than alter session statements. More than that, by using appropriate granting/synonyms structures in Oracle - you can have more secure data paths. You can even use Oracle's own dictionary to have

Re: Oracle scheme

2005-08-31 Thread Koka
I have used kind of 'login trigger' approach - in fact I extended datasource I were using to add execution of alter session set current_schema = "USER" statement to getConnection method. Found it easier then creating sysnonyms >I guess it's a matter of taste.. Agree.

Re: problem retrieving xml results from oracle xmldb

2005-08-31 Thread Jan Vissers
I'm guessing this has to do with the fact that iBatis doesn't support the Oracle XMLType datatype. I've also been looking for a way to deal with this, but more in the area of Custom Type Handling. Would be interested if someone has actually managed to do this. In my situation, due to time const

problem retrieving xml results from oracle xmldb

2005-08-31 Thread Uma S Mudunuri
Hi, I am trying to use iBATIS to retrieve results from Oracle's XML DB database(which stores whole xml documents). It works fine when the results are the text value of an element but when I try to use functions to get whole or part of the xml document it does not return any results. The query work

Re: Oracle scheme

2005-08-31 Thread Fabio Insaccanebbia
The login trigger is executed once for connection and most of the cases it means it is rarely used (example: connection pool). If the number of objects you want to access is large (50+) you'd probably prefer to create a single trigger rather than having to create and "mantain" 50+ synonyms.. I gu

Re: Oracle scheme

2005-08-31 Thread Jan Vissers
"A better approach could be to create a "login trigger" for the user you connect with. The trigger should then change the session to use another schema (VIBSCANNER)" This looks pretty ugly and rather "expensive". Why would you want to do this? Fabio Insaccanebbia wrote: In Oracle "user" an

Re: cacheModel configuration

2005-08-31 Thread Prashanth Sukumaran
Hi Sum, It is the order in which you define the sqlMap files in the sqlmap-config.xml. If you want to reference a statement declared in another sqlMal.xml file put this entry on top of the file that is referencing the statement. Like Assume there is an insert (Transport company) in the

Re: Oracle scheme

2005-08-31 Thread Jan Vissers
Hi, I'm a bit puzzled by "The problem is that under "webtest" more than one databases could managed". Do you mean that you can manage data in tables belonging to a different user/schema residing in the same database instance, or in an actual different database instance? If the former is true

Re: Oracle scheme

2005-08-31 Thread Jeff Butler
I'm definitely not an Oracle guy, but here's a thought...   DB2 allows you to specify a default schema as one of the JDBC connection properties.  Does Oracle support something like that?   Jeff Butler  On 8/31/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello all, I use iBATIS to access ORACL

Re: Oracle scheme

2005-08-31 Thread Fabio Insaccanebbia
In Oracle "user" and "schema" are almost synonyms.. Configure iBatis to connect with VIBSCANNER user and you won't need to prefix the tables with the user name. If you don't want to connect with VIBSCANNER, you could create synonyms for the schema of the user you connect with. A better approach

Re: stored proc doesn't return output parameter

2005-08-31 Thread Jeff Butler
Try reordering the parameters in your parameter map.  The first parameter should be the String OUT parameter, the second parameter should be the Integer IN parameter.   Jeff Butler  On 8/31/05, Deshpande, Bhushan M (IT) <[EMAIL PROTECTED]> wrote: Hi All ,    I am using Ibatis 2.1.5 to execute a

Oracle BLOB

2005-08-31 Thread [EMAIL PROTECTED]
Hello all,I became a SQL exception (see under) if I want to save a byte[] into a column of type BLOB. Can anyone tell me what the problem is and how I can solve it.java.sql.SQLException: E/A-Exception: Connection reset by peer: socket write error at com.ibatis.db.sqlmap.MappedStatement.executeU

Oracle scheme

2005-08-31 Thread [EMAIL PROTECTED]
Hello all,I use iBATIS to access ORACLE, MS SQL and other databases (with the same SQL maps).To access ORACLE databases I have following connection URL:Connection URL: jdbc:oracle:thin:@cm_ora_test:1521:webtest"webtest" indicates the SID of the ORACLE database. The problem is that under "webtest" m

stored proc doesn't return output parameter

2005-08-31 Thread Deshpande, Bhushan M \(IT\)
Hi All ,    I am using Ibatis 2.1.5 to execute a stored proc on sybase databse which retuns a string result . -- Entries in contiguration xml file is Re: cacheModel configuration
Hi Sum, How are your config files? Have you enabled namespaces in your sqlmap-config.xml and declared one for each sqlmap.xml file? Can you post your config files? Cheers, Daniel Silva. On 8/30/05, H.E. Sum <[EMAIL PROTECTED]> wrote: > Does anyone know how to reference a statement in > another