I am currently using 2.3.4 of iBatis and my client is going to upgrade their
version of Oracle from 9 to 10 or 11 (they aren't sure which, yet). Does
anyone have any thoughts/gotchas/experience that you would be willing to
share. I'm expecting that there are no issues between iBatis and either of
My client has requested that we upgrade from our current iBatis version
(2.3.0) to 2.3.4. Since this is a 'minor version' upgrade, I don't
anticipate any issues, but I was wondering if the community has any
'gotchas' that I should be on the lookout for.
We are running all web applications in webl
> individual(s)
> >> or entity(ies) named above and may contain information which is
> privileged
> >> and/or confidential. If you are not the intended recipient, be aware
> that
> >> any disclosure, copying, distribution, dissemination or use of the
> conten
t;
> This footnote confirms that this email message has been scanned by
> PineApp Mail-SeCure for the presence of malicious code, vandals & computer
> viruses.
>
>
>
--
--
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19
wice, first to replace the $$
> placeholders and then to replace the ## placeholders _including_ the
> placeholders that where set within my $$ placeholder.
>
> Hope I made it more clearly now.
>
> Regards,
> Wessel
>
--
--
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19
n pools set up the same on both servers?
>
> Is your test(slower) server located somewhere else geographically?
>
> Maybe just provide us with a bit more data.
>
>
> On Mon, Apr 27, 2009 at 1:26 PM, Chris O'Connell <
> oconn...@gorillachicago.com> wrote:
>
he's using a SimpleDataSource , so I guess, the
>> connection pool is implemented by iBatis
>>
>> I bet for a "firewall issue". Some is resetting the connection.
>> (Connection reset)
>>
>>
>>
>> 2009/4/24 Chris O'Conn
I know that if I were to get a DBA involved, I could get some further
details, but I'm trying to get as much information as I can before I start
to get the bureaucracy involved...
Anyway, I am able to log my sql and the results with no problems. The issue
I have is that stuff is just running so sl
ibatis do so?
>
>
> On Fri, Apr 24, 2009 at 11:52 AM, Chris O'Connell <
> oconn...@gorillachicago.com> wrote:
>
>> There are certainly wiser minds here, but it sounds like the database is
>> thinking that the connection has been abandoned (because it hasn't been
ne.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)
>> at
>>
>> com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
>> at
>>
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
>> at
>>
>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
>> at
>>
>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
>> at
>>
>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
>>
>>
>
--
--
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19
utorDelegate.java:567)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94)
>
--
--
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19
gt;
>>
>> I dont want the user name and password to be exposed as clear text in a
>> config file.
>> Is there a way to hide this information, maybe by passing the information
>> programmatically or using another way.
>> My main concern is to not keep the user credentials in clear text in a
>> config file.
>> Thanks
>> Rishi...
>>
>>
>
>
>
--
--
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19
not find any more info about why is this a case!? Can anyone elaborate
>> on this? Is this because reflection is slow in general?
>>
>
>
--
--
Chris O'Connell
Application Developer
Gorilla
312.243.8777 x19
t; generated value as the return of the sqlmap.insert() call.
>
> Additionally in your use case below, if the 'RegisteredUser' object has a
> 'ID' attribute, ibatis will set it to the db generated value. You can also
> control the attribute that ibatis will set the value
Is there any way to find my position while iterating through a collection in
the sqlMap file. For example, I want to do something like this:
,(
SELECT TEMP_PA.PRODUCT_ID
FROM PRODUCT_ATTRIBUTES TEMP_PA,
ATTRIBUTES
I have used Spring to configure multiple instances of the same set of DAO's
to hit different databases. Right there Spring has a huge advantage over
having to hardcode a specific config file right into the code. Also, using
DI makes it easier to code against interfaces and let Spring worry about
Rick,
I certainly understand your point (and I'm not trying to be combative), but
I think you are asking the wrong question. You can ask "Why should I
require my end user to use Spring"? But, I'll ask you back, why are you
requiring them to use iBatis? They just really want to get at data in a
Do you need to use IBATIS? What is your database? Many (most?) databases
have tools which are well suited to these sorts of tasks. Depending on your
database, I would look at using one of them instead of IBATIS.
From: Rajaram, Naresh [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10,
Sorry if this seems too simplistic, but why don't you let the database
server worry about it? You would do something like:
Update table set update_date = sysdate;
Instead of:
Update table set update_Date = #currentTime#
-Original Message-
From: Jonathan Slate [mailto:[EMAIL PROTECTED]
What about a query with something like
Select * from table where upper(NAME_COLUMN) like '%input_variable%'
From: Robert Glover [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2008 5:10 PM
To: user-java@ibatis.apache.org
Subject: Is there a way using Ibator to do a case-insensitive L
I'm certainly not an expert at this, but what if instead of passing the list
right into the query, you created a map and put the list into the map with
the key "conditions" (then pass the map into the query).
Then, put something like this in the mapping:
$conditions[].condition$ $conditi
Are you using Spring? The Spring SqlMapClientTemplate converts all those
SQLExceptions into a runtime exception, so your IDE won't see any exception
that you need to 'catch'.
-Original Message-
From: John Chien [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2008 1:33 PM
To: user-java
Sorry for the original long post. For anyone who is interested, the
solution was that the 'included' result map also had a groupBy. I didn't
need that. As soon as I removed the groupBy from the resultMap for the
ITEMS, problem solved.
Chris
-Original Message-----
From:
I'm trying to get the iBatis groupBy to work for a join between two tables
with a parent child relationship.
I have two tables, KPF_FOLDER_ROOM_TYPES and KPF_FOLDER_ITEMS (this is a
legacy table, so I am not responsible for anything, including names. Nor
can I change anything). The FOLDER_ROOM_
When I am trying to execute an update through iBatis, I get a SQL Exception:
java.sql.SQLException: Invalid column type
Here is the mapping:
UPDATE USER_USERS SET
PASS = #pass#,
FIRST_NAME= #firstName#,
LAST_NAME = #lastName#,
TITLE
I don't think iBatis does this for you. You have to implement either a
pessimistic locking solution (select for update) or use optimistic locking.
Add a version or timestamp to the table. When you update the record, do
something like this
Update josh set name = #name#, weburl = #weburl#, vers
ECTED]
Sent: Friday, May 09, 2008 9:43 AM
To: user-java@ibatis.apache.org
Subject: Re: How to get the generated key from insert with Oracle
Easy enough to test... open two sqlplus sessions and step through an
example...
Clinton
On Fri, May 9, 2008 at 8:12 AM, Chris O'Connell
<[EM
with a sequence, I've been told that they are 'session' aware, so
if you get id 123 in your session, no one else ever will.
Larry
On Thu, May 8, 2008 at 4:21 PM, Chris O'Connell
<[EMAIL PROTECTED]> wrote:
> Even if I am executing all of this inside a transaction,
Even if I am executing all of this inside a transaction, don't I still have
concurrency issues with this approach?
-Original Message-
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 08, 2008 5:12 PM
To: user-java@ibatis.apache.org
Subject: Re: How to get the generated ke
So, I need to insert a User record. I cannot change the database tables, so
I am stuck with the current behavior of my database. On insert, there is a
trigger that selects a value from a SEQUENCE and updates the key with that
value. I would like to return that value from the insert statement to
Sara,
Someone else pointed out that is actually a warning about your using an
untyped list. You may be new to java5 as well as iBatis.
This is a good overview of what generics are:
http://java.sun.com/j2se/1.5.0/docs/guide/language/generics.html
Good luck. Once you get the hang of them, you wi
I'm a little confused by this. Is this some sort of asynchronous process
where the user clicks a button and it causes a message to get dropped on a
queue (for example) which causes the system to execute this bit of work as
quickly as it can? If this is the case, then you *do* have a pending stage
I only counted 60 "?" in your sql. Are you missing one?
-Original Message-
From: Jens Borrack [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 11:29 AM
To: user-java@ibatis.apache.org
Subject: "invalid row index" parameter registration Problem
Problem:
The "invalid row index" Prob
Oops. Pilot error. Why is it you can look at something for hours, and then
as soon as you ask for help you figure out the problem?
_
From: Chris O'Connell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 20, 2007 10:23 AM
To: 'user-java@ibatis.apache.org'
Sub
I am lazy loading a list. When I am debugging my code, I see that for my
attribute, there is a class that is a Proxy, not my real class (in the
config file, I am specifying that the class is a java.util.List). So, when
I try to 'get' that List, I get a class cast exception. I am following the
st
35 matches
Mail list logo
