I would try a structure like this:Set up your SqlMapConfig.xml file to load a properties file, and in that properties file specify the database dialect (i.e., dialect=mysql, or
dialect=oracle, etc...). Then, you can load the common sqlmaps from a common location, and the dialect specific ones usin
I am replying to the list Bruce, in case others have the same problem
later, then they can google and get it.
My guess is that the user connecting to the database does not see the
product table in the default schema. You may need to either connect as
another user, or qualify the table name.
Larry
e 'itemid'.
> Caused by: java.sql.SQLException: [DataDirect][SQLServer JDBC
> Driver][SQLServer]Ambiguous column name 'itemid'.
> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
>
> Thanks,
> Bruce
>
> -Original Message-
> Fro
Add remapResults="true" in the select tag.
There is a performance hit, but it will work.
Larry
On 3/23/06, Daniel Pitts <[EMAIL PROTECTED]> wrote:
> I have a very generic query which has different column names, depending
> on what was passed to it.
>
> SELECT $columns$ FROM $from$ WHER
Sounds like a good time to use JDBC.
Larry
On 3/26/06, sadasiva lingala <[EMAIL PROTECTED]> wrote:
>
> Hi
> I am using Spring and Ibatis for database access. I need a solution for
> defining custom type handler for entire resultset.
>
> for example I have SQL like
> "Select abc, xyz from table_a
On 3/27/06, Lingala, Sadasiva <[EMAIL PROTECTED]> wrote:
A few things to note here.
> Is this difficult or not possible?
Either way, iBATIS or JDBC, you'll be writing the exact same code,
because you are wanting to work with the JDBC metadata.
> I like to find a solution as it provides uniform
Does the view name have a # or $ character in it?
Larry
On 3/29/06, Chema <[EMAIL PROTECTED]> wrote:
> Hello:
>
> I've got this query in sqlmap config file
>
> parameterClass="QueryClass">
> SELECT $c$
> FROM $table$
> WHERE $where$
>
>
>
>
> If $table$ is the n
This is like your neighbor's car breaking down because your aunt's
toaster is unplugged.
I do not see any conceivable way that this could be iBATIS related.
Start here -> http://tinyurl.com/mst7m
Larry
On 4/3/06, Mike Wilson <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> We have an iBATIS app runni
Very good debugging, and thanks for posting the solution. :-)
Larry
On 4/4/06, D. Richter <[EMAIL PROTECTED]> wrote:
> Ok, I found the mistake by myself. It is a type mismatch
> in the Person-Select. The db-type of id ist varchar, so the
> parameterClass must be string. Unfortunately no error or
The number of parameters looks wrong - i see 6 "?" chars, and 7 parameter tags.
The "deleted" parameter seems to think it is OUT only, but it INOUT in
the parameter map.
Larry
On 4/5/06, Miquel Angel Bada Zuazo <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> I'm developing a call to an Stored Procedur
Try this:
,$list[]$
Larry
On 4/5/06, Chris Bowman <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have a problem with a dynamic select, and having searched the archive
> I have found no answer.
>
> The sutuation:
>
> I have a database where customers can add user defined fields to each
>
On 4/6/06, Enrique Ferreyra <[EMAIL PROTECTED]> wrote:
> ok, thanks anyway, my problem is the first / in the resource path.
>
> newbie problem...
Heh, not always - I have had similar problems with needing (or not
needing) that leading slash - I think it varies by classloader. :-/
Larry
queryForPaginatedList()
Larry
On 4/12/06, John Chien <[EMAIL PROTECTED]> wrote:
> Dear sir:
>
> I have a feature that requires me to return query result of a selection
> statment in certain amount of successive records every time.
> This is just like a page.
>
> For example:
>
> SELECT id, name
t; However, I can not keep this list in my server due to concurrecy reason.
> > Does that mean that I have to call the same method every time and give
> > it the page number for it to return me the records ?
> >
> > I am doing the web development.
> > How can I make use o
Just curious: why are you using int instead of Integer?
Larry
On 4/13/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> This is possble yes ...
> I will try to replace my int with a wrapper class.
>
> Is there an option in IBATIS that can be used to to the casting automatically
> ? In the
Try reversing the order of the result map definitions.
Is this the latest version?
Larry
On 4/18/06, Eric Bauld <[EMAIL PROTECTED]> wrote:
> I have been trying to get this to work for 2 days, every time iBATIS
> loads the setVotes(List votes) method in BasicStakeholder the list that
> is pass i
Have you tried straight JDBC?
Larry
On 4/24/06, Ben Munat <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I have a table looks like this:
>
> CREATE TABLE TimesheetASOrder (
> TimesheetId int NOT NULL,
> ActivityGroupId int NOT NULL,
> DisplayOrder int NOT NULL
> )
>
> And this sql ma
After you get the List, do you modify it in any way?
Because you are tell iBATIS that it is read-only, you are gettign a
shared instance of the list. Any changes you make to it will be
reflected in later calls that return the same (shared) list.
Larry
On 4/24/06, Neverov Dm <[EMAIL PROTECTED]>
Another quick-n-dirty way to find these (if you have a unit test) is
to remove columns from the update until it works. The last one you
removed is the problem.
Larry
On 4/26/06, Balaji <[EMAIL PROTECTED]> wrote:
>
> Ali,
>
> It could be because of null value(s) in password date etc. Check the
>
That is not to bad, for reference, I did a jdbc import of 180,674
records in 186.620s, which is only 1032/second.
Any tips learned along the way that you'd like to share?
Larry
I did a search for "if(isWireless()) leakConnection();" and didn't
find anythingso if you unplug your toaster, and put the dog out - I
bet it fixes it. ;-)
Just kidding..I do not see any way that this could be iBATIS related -
it is even hard to imagine that a bad jdbc driver would do that. Are
y
You may be able to get this working, but to me the real question is
"why?", not "how?".
IMO, I'd use Spring for the dao instead of the iBATIS dao.
Larry
On 5/1/06, Christopher Lamey <[EMAIL PROTECTED]> wrote:
Hello,
The one and only time I've used Hibernate, I think I saw that message
when 3
Not implemented, but a cool idea.
If it isn't in JIRA, add it.
Larry
On 5/10/06, Chennupati, Kalyani <[EMAIL PROTECTED]> wrote:
Instead of specifying each ibatis mapping file I would like to specify a
classpath from where to pick up all the mapping files that end with
.ibtm.xml.
I am t
That would be great - i know there is one on the WIKI already, but
take a look and update it if you need to.
Larry
On 5/10/06, Christopher Lamey <[EMAIL PROTECTED]> wrote:
Hello,
It turns out the groupBy attribute references a property in the
resultMap, not a column.
Doh!
It'd be nice if th
Another potential solution would be to use a row handler - more code,
but just one sql call.
You'd do the big join, then as you walk through the rows, look at the
keys and add them to the lists yourself.
Larry
On 5/11/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
It's not really a stupid questi
wHandler
interface gets passed a List along with an Object, but the
RowHandler.java I see in the code doesn't have a List parameter. I'm
looking both in the 2.1.7 release and a two day old co from svn.
So what's the right way to get object back from a RowHandler? Something
like an
Heh, just like all things in the OS world, when it's done. :)
Larry
On 5/12/06, Angel Municio <[EMAIL PROTECTED]> wrote:
Reading through the mailing list it appears that there is a book about
iBatis that is going to be published by Manning. But I haven't been able
to find anything about it in
Check the sqlmapconfig.xml, namespaces are probably enabled in the
settings element.
If they are (a good idea), you have to use the namespace from the sql
map file when you call the mapped statement.
Larry
On 5/16/06, xianwinwin <[EMAIL PROTECTED]> wrote:
ok, I think I'm getting somewhere, I
Don't use the XML support in iBATIS - it's pretty crappy and very
likely going to go away in iB3.
Larry
On 5/21/06, Shepherdz <[EMAIL PROTECTED]> wrote:
Our project needs to use generic result structure to recieve results of a
query, i.e. Map or XML. How can I use Map or XML result in mapping
Are the tables using innodb?
On 5/23/06, Jerome Gagner <[EMAIL PROTECTED]> wrote:
What version of the MySQL JDBC driver are you using? Try turning on
debug for java.sql and see what you're really getting.
On 5/23/06, Gary Efraín Laredo Chacón <[EMAIL PROTECTED]> wrote:
>
>
> Thanks,
>
> Exactly
I do not think I understand the question...if the database doesn't
support auto-generated keys, it'll be awful difficult to get the
auto-generated keys...
Maybe you can clarify your question some.
Larry
On 5/25/06, Valerio Bertoldi [Primeur] <[EMAIL PROTECTED]> wrote:
Hi,
is there any possibi
FG.COMMANDS (id_command,descr)
values (#id_command#,#descr#)
is it possible ?
Thank's
Valerio
Larry Meadors ha scritto:
I do not think I understand the question...if the database doesn't
support auto-generated keys, it'll be awful difficult to get the
auto-generated keys.
Worse than that, the example provided gives you the certainty of never
getting a unique identifier. :-D
Larry
On 5/25/06, Darek Dober <[EMAIL PROTECTED]> wrote:
What's more, it doesn't give you the certainty of unique identifier.
Darek
I think you are going to have to stick with ant trickery for now.
Larry
On 5/26/06, Ben Munat <[EMAIL PROTECTED]> wrote:
Is there any way to import or include extra sqlMapConfig information into a
sql-map-config.xml file? I have different maps that I want to tell ibatis about
depending
on whi
I wouldn't expect that to make a difference as you have described it
so far, but without some more context, I can't say for sure.
Maybe you can provide some more info - data structures, mapped
statements, and result maps would be a good start.
I would expect this to work pretty easily (I know I
Looks like the parameter being passed in is a String instead of an
org.model.employeeMaster instance (that should be EmployeeMaster,
btw).
Also, the first version has a parameter map as well, it is just
created dynamically, so it should cache just fine if you define a
cache model, and add a cache
On 6/1/06, Morone, Bill <[EMAIL PROTECTED]> wrote:
Coming soon, right?
On the contrary, going away.
I'd suggest processing the results of the query manually to create XML
with a row handler if you really need to create xml results.
Larry
. Will your
superclass stuff
stay the same?
Bill Morone
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
Of Larry Meadors
Sent: Thursday, June 01, 2006 4:45 PM
To: user-java@ibatis.apache.org
Subject: Re: When returning mutiple objects and transforming "directly
extend.
Will your superclass stuff stay the same?
>
> Bill Morone
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
> Of Larry Meadors
> Sent: Thursday, June 01, 2006 4:45 PM
> To: user-java@ibatis.apache.org
> Subject: Re:
I would not think that using CHAR(10) for the type would work.
When you had it just CHAR, what were you trying to update when you got
the "inserted value too large for a column" error? Is it possible that
it was more than 10 chars?
Larry
PS: Do not reply to existing messages to start a new thre
If you are OK with using a map, using a rowhandler to generate the xml
will be very simple, and not measurably slower than the current
implementation.
Again, I think this is truly a better approach. Why?
It's fast, because it only goes through the returned results once.
It's very light weight b
Very interesting - seems they like iBATIS, here is another article:
"As great as Hibernate is, a lesser-known Java persistence solution
called iBATIS actually may be a superior technology for your Spring
development in certain situations. Find out which."
I never realized that "certain" was a sy
That means that the query returned more than one row.LarryOn 6/14/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
I am using FireBird
Data base. when i use the following query
select
gen_id(TIMER_GENERATOR,1) from timer_details;
I am
getting the exception
java.sql.SQLException: Error: exe
Hmm, I have never had a case where using the same connection string in
ibatis and in squirrel made the queries work differently..are you
connecting as the same user nad everything? ..because that should
work.
Larry
On 6/14/06, Bernard Lavallee <[EMAIL PROTECTED]> wrote:
I've been trying to
I have had success using a external resultmap and then using "?"
instead of #property# in the mapped statement.
Larry
On 6/14/06, Debasish Dutta Roy <[EMAIL PROTECTED]> wrote:
Dear all
The documentation of SP is so bad it really creates loads of downtime.
Can anyone give me a detailed example
Use dynamic sql after looking at the tutorial and developer giude.
Larry
On 6/14/06, xianwinwin <[EMAIL PROTECTED]> wrote:
Hi guys,
In the old days, where I used to work with JDBC, I had a GUI where the
end-user could have request for info such as:
What is the production of user: ABC locate
Or for java -> http://ibatis.apache.org/javadownloads.html
Larry
On 6/14/06, Daniel Pitts <[EMAIL PROTECTED]> wrote:
Try the ibatis website? http://ibatis.apache.org/dotnetdownloads.cgi
-Original Message-
From: xianwinwin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 14, 2006 1:46 P
I believe that Hibernate does it by wrapping the beans with CGLIB, and
catching calls to the setXxx() methods, and setting a dirty flag if
one is called. I have not tried doing that myself, but suspect that it
can be done...
Larry
On 6/17/06, rs <[EMAIL PROTECTED]> wrote:
Hi,
Am looking for
Looks like "Missing key in referenced table for referential
constraint" is the core problem.
My guess is that the SQL is fine, but the data is not.
Larry
On 6/19/06, Cristiano Monteiro dos Santos <[EMAIL PROTECTED]> wrote:
It's getting clear now.
So the $$ stuff should work transparently in
If your parameterclass is string, there is nowhere to put the generated id.
Use a bean or a map, and set the description on that object to the
description you want to insert.
Also, you'll want to set the keyProperty to "id" in your selectKey element.
Larry
On 6/20/06, jaybytez <[EMAIL PROTECT
Send an email to [EMAIL PROTECTED] to unsubscribe.
Larry
On 6/20/06, harinder nandyala <[EMAIL PROTECTED]> wrote:
Please remove my mail ID from the ibatis distribution list. Thank you
Harinder Nandyala
http://www.ashakiran.org
"The more you strive for humanity, the more civilized you become"
Look at the iterate tag.
Larry
On 6/20/06, puneet arya <[EMAIL PROTECTED]> wrote:
Hi,
How to use IN CLAUSE in a stored procedure . i want to pass multiple
values through IN CLAUSE in stored procedure.
so how to pass it like select * from tablename where column name in (comma
separated va
You know, if someone has access to your filesystem, encrypting that
file is just going to slow you down, not them.
I would focus on securing the filesystem so that only the one user
that needs access to it has access to it, and letting it protect you.
Encrypting that file IMO is a total waste of
[EMAIL PROTECTED] is your friend, use it.
On 6/21/06, Makunda Thapa <[EMAIL PROTECTED]> wrote:
UNSCRIBE THIS USER GROUP
_
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com
Yeah, it's risky, but life is about risks, right? :-)
$generatedSqlStatement$
Larry
On 6/22/06, Edwin Lukaweski <[EMAIL PROTECTED]> wrote:
Hi:
Is there any way of submitting a new . SQL Map
snippet via the Java API. Or, alternatively, is there a way of contructing
an object, from i
mining the result set meta data. Also, I would imagine that the
$generatedSqlStatement$ will also be prepared on each call.
I guess I could go straight to the JDBC driver but will that
interfere
with iBatis' operation?
Thanks,
Edwin
- Original Message -
From: "Larry Meadors
You are correct, there is no API to do that out-of-the-box.
It's easy to build however:
start a transaction
insert parent
get inserted id
optional: start batch
step through child records, set parent id, and insert
optional: execute batch
commit transaction
Done. :-)
Larry
On 6/25/06, Nicolas
Probably the namespace.
Larry
On 6/26/06, Serafín Orillán Chaparro <[EMAIL PROTECTED]> wrote:
Hi all,
I'm tryin to use cacheModel's but i get an error "There is no statement
named... in this SqlMap". I have 5 differents sqlMap files, and the
setting useStatementNamespaces set to "true". I ha
I believe that with they are
all moot - the external transaction manager is a no-op: it does
nothing.
Larry
On 6/27/06, jaybytez <[EMAIL PROTECTED]> wrote:
What do these fields do in relation to allowing CMT to handle transactions in
iBatis?
The documentation is not totally clear, and from
...or just use log4j and enable logging.
Larry
On 6/27/06, Brandon Goodin <[EMAIL PROTECTED]> wrote:
There is no way to substitute your own custom PreparedStatement. We provide
logging for statement debugging. Perhaps you could log the values of your
parameter object before it is passed into i
Hey Rick, I am not 100% sure I understand what you are trying to do,
but let me try to restate it and see..
Do you want a list of employees, each one with another list of
employees (direct reports), and a list of contacts on each one - both
the main employee list and the child employees?
Larry
building the object graph the way you
want it.
Larry
On 7/3/06, Rick <[EMAIL PROTECTED]> wrote:
Bingo!
Yep. Employee has a directReports list which is a list of Employees.
-Original Message-
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: Monday, July 03, 2006 3:19 PM
To: u
It seems like dealing with trees is a fairly common case, so this could be
generalized and put into iBatis.
IMO, I think you should add it so we have a reminder of it...even if
we never implement it.
I wonder if a RowHandler implementation would be faster. I guess if
you are bored you could try
Do you have namespaces enabled in sqlmapconfig?
I bet lunch that you do. :-)
Larry
On 7/7/06, Merritt, Norris <[EMAIL PROTECTED]> wrote:
Obviously there is something wrong with the trivially simple sqlMap file
shown below, but being so new to iBatis I can't figure out what it is.
If some
ent in the right place in the sqlMapConfig file (to
conform to the dtd) and now I am getting past the error. Thanks again!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Larry Meadors
Sent: Friday, July 07, 2006 2:58 PM
To: Merritt, Norris
Subject: Re: "
So...I do not understand..your beans are interfaces?
How often do you swap out the implementation of your beans? ;-)
Larry
On 7/10/06, Paul Benedict <[EMAIL PROTECTED]> wrote:
I have two interfaces: Article and Person. My problem is with my Article
implementation:
public interface Article {
om the getter.
Otherwise I will have to have a diferent getter on my object just for ibatis
that returns the impl.
Paul
Larry Meadors <[EMAIL PROTECTED]> wrote:
So...I do not understand..your beans are interfaces?
How often do you swap out the implementation of your beans? ;-)
Larry
On 7
Do you have a resultMap or resultClass for the select?
Larry
On 7/11/06, jeremy jardin <[EMAIL PROTECTED]> wrote:
Hello,
I'm trying to launch a request using a beanExample .. I've logged the sql
request, and I can see that this request should answers 1 result.
After all. my resultLis
Message d'origine-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors
Envoyé: mercredi 12 juillet 2006 09:39
À: user-java@ibatis.apache.org
Objet: Re: request using beanExample
Do you have a resultMap or resultClass for the select?
Larry
On 7/11/06, jerem
Nope, I think there is something else going on here...iBATIS is not
changing your SQL...so if it says "jobduedate=?" then that is what is
in the SQL map.
How are you building the application?
Larry
On 7/11/06, Fred Janon <[EMAIL PROTECTED]> wrote:
Hi Ted,
Thanks for the suggestion, I looked
The length is probably wrong, and in all SQL dialects I have ever
used, " A" does not equal "A".
Larry
On 7/11/06, jeremy jardin <[EMAIL PROTECTED]> wrote:
A CHAR !!
Why ??
-Message d'origine-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De
Yep.
On 7/11/06, jeremy jardin <[EMAIL PROTECTED]> wrote:
You mean that is my fiel dis CHAR(12)... and the string I put in is only 8 char
long;. It could be problematic ?
-Message d'origine-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Larry Meadors
Envoy
That is the default behavior.
Larry
On 7/13/06, Ben Munat <[EMAIL PROTECTED]> wrote:
I see in the user's manual how one can tell ibatis to interpret a given
property value as
meaning it should insert null into the column... like an int value of -
means insert null.
What I don't see, how
heh, "incubator"? ;-)
[EMAIL PROTECTED] will work better.
Larry
On 7/17/06, Niels Beekman <[EMAIL PROTECTED]> wrote:
To remove your address from the list, send a message to:
<[EMAIL PROTECTED]>
From: Rodolfo García Esteban/CYII [mailto:[EMAIL P
FYI: if your database allows stored procedures, you will most likely
increase performance 2x to 3x by making this a stored procedure...if
that is a possibility, I would strongly suggest that you do it that
way instead.
Larry
On 7/23/06, Jerome Gagner <[EMAIL PROTECTED]> wrote:
What database ar
Why not just use a selectKey element?
Larry
On 7/24/06, Fred Janon <[EMAIL PROTECTED]> wrote:
I am trying to get the last_insert_id() in mySQL after an insert. I read
in a forum that during a transaction, the same connection was guaranteed
to be used for the duration of the transaction. That's
Are there placeholders for the user/password in the dao.xml?
Larry
On 7/24/06, Christina Xu <[EMAIL PROTECTED]> wrote:
Hello All,
I have a requirement to Dynamic set username/password
when create JDBC connection. So what I have is :
...
...
Ouch, ok.
On 7/24/06, Fred Janon <[EMAIL PROTECTED]> wrote:
I am using iBatis v1 not v2, there is no in V1...
Larry Meadors wrote:
> Why not just use a selectKey element?
>
> Larry
>
>
> On 7/24/06, Fred Janon <[EMAIL PROTECTED]> wrote:
>> I am trying
eDriver
url=jdbc.oracle.thin:@hostname:1521:SID
Any help is appreciated. Thanks.
--- Larry Meadors <[EMAIL PROTECTED]> wrote:
> Are there placeholders for the user/password in the
> dao.xml?
>
> Larry
>
>
> On 7/24/06, Christina Xu <[EMAIL PROTECTED]> wrote:
> >
ssword);
Reader reader =
Resources.getResourceAsReader(dbSource);
// I want username , password pass from here
daoManager = DaoManagerBuilder.buildDaoManager(reader,
daoProp);
}
Thanks a lot !!!
--- Larry Meadors <[EMAIL PROTECTED]> wrote:
> Can you post your entire sqlmapconfig.xml
I am starting to sound like a broken record, but if you can do this
with a stored procedure, you'll get *much* better performance in cases
like this - at least 2x better, and depending on the database, even
more.
Larry
On 7/24/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Not really. The recomm
This is a potential solution:
http://www.realdn.net/msblog/PermaLink,guid,bb7ddb2d-c5be-485a-9413-e5da032381d8.aspx
Larry
On 7/24/06, MCCORMICK, Paul <[EMAIL PROTECTED]> wrote:
Thanks. I was hoping a firefox extension or something browser based. None of
the free SVN clients I've tried
If the concern is performance, it's unfounded (unless you are also
using like jdk1.2 or jdk1.3), and using maps instead of beans as
described in option #1 (for the sake of performance) is absolutely
retarded, IMO.
Go with #2.
Larry
On 7/24/06, Sumanta Ghosh <[EMAIL PROTECTED]> wrote:
Hi,
LOL, no, it was 302ms slower on my box...that is significant. ;-)
Larry
On 7/24/06, Clinton Begin <[EMAIL PROTECTED]> wrote:
ARRRGH! It's 2006 and people are still worried about reflection
I advise you find a new client. ;-)
No seriously, what the heck are they worried about???
I am not sure I can take another "Gee, iBATIS is slow, can you make it
faster" thread, but here goes...
On 7/24/06, Mkhitaryan, Aram <[EMAIL PROTECTED]> wrote:
I'm starting a new project where I want to use IBATIS.
Welcome!
But I have written some tests where I found out some problems:
1.
No, what exact version are you using? This exception indicates that it is looking for commons-logging, which has not been a part of iBATIS for many months.Exception in thread "main"
java.lang.NoClassDefFoundError:
org/apache/commons/logging/LogFactoryI'd suggest getting a newer version of iBATIS.
Try:insert into USR_BASIC_INFO values (#userid#, #password:VARCHAR#, #username#, #role#,
#code#, #email#, #phonenumber#, #description#)LarryOn 7/26/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Hi,
I am
using Ibatis as the data mapper between my java classes and MsSql database. When
Can this be done with a stored procedure? Is there a ton of data
input, or is the data generated based on a set of parameters, rules,
etc...
If it is generated, you could get significant performance gains using
a stored procedure instead of a batch.
Larry
On 7/27/06, Albert L. Sapp <[EMAIL
e
stored procedure and still get my exceptions back. I will see what I
can find to read about doing things this way.
As always, this old dog does still try to learn new tricks. :-D
Al
Larry Meadors wrote:
>
>
> Can this be done with a stored procedure? Is there a ton of data
>
Look at the iterate stuff.
Larry
On 7/27/06, Celaya, Tina (GE Indust, ConsInd) <[EMAIL PROTECTED]> wrote:
I want to put somthing like this in de query moths in (1,2,3,4,5,6) and I tried
using month in ($list$) and list have integers 1,2,3,4,5,6 but it doesnt work,
i have an error that says i
This is a known bug.
In your sqlmap config, be sure to include the file with the resultmaps
BEFORE the file with the mapped statements. Also, you may have some
namespace issues, too...kinda hard to tell without more details...
You may also want to look at the and tags for
managing the queries.
I have to agree with Brandon - the JDBC-ODBC driver is total rubbish.
It's only value is to provide you with a way to get your data out of
M$ Access and into a real database.
Trying to do more with it is insane.
Larry
On 7/28/06, Brandon Goodin <[EMAIL PROTECTED]> wrote:
Don't use JDBC-ODBC br
Currently, the class mapped must be instantiable.
Larry
On 7/29/06, Bing Lu <[EMAIL PROTECTED]> wrote:
hi, does the mapper support abstract resultmaps? or
the class mapped must be instantiable
thanks
__
Do You Yahoo!?
Tired of spam? Yahoo! Mai
Hmm, that looks funky. Try this:
insert into table (field) values (#value:VARCHAR#)
Larry
On 7/31/06, Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote:
Hello!
When passing "null" as parameter value for postgresql, the exception is being
thrown: org.postgresql.util.PSQLException: Unknown Types v
I would not reccomend trying to use a single instance for two
databases - just create two.
Remember, you can pass a properties object into the sqlmap client
builder to customize the created sql map client.
Larry
On 7/31/06, Mkhitaryan, Aram <[EMAIL PROTECTED]> wrote:
Oh, I have never used IBA
...and the WIKI:
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+problem
If you follow the instructions on the WIKI and find any issues, please
feel free to add another example, or make corrections.
Larry
On 7/31/06, Jeff Butler <[EMAIL P
So, what happens if you plug in the parameters and run the query with
sql*plus or SQL Developer?
I do not see anything in that query that looks too far out.
Larry
On 7/31/06, Michael Smith <[EMAIL PROTECTED]> wrote:
Hello folks. I'm having an issue with getting parameters to work in an
Oracle
I'd put it in WEB-INF/lib.
In this case, there is no valid reason for it to be in common/lib.
Larry
On 8/1/06, jeb001 <[EMAIL PROTECTED]> wrote:
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
SO, I'm sure to have oracle driver in the common/lib directory of tom
What is the evironment - OS, database, JRE, etc?
Larry
On 8/1/06, Rahesh Kumar <[EMAIL PROTECTED]> wrote:
Hi,
Sometimes , the queries executed thorugh ibais makes the application hang ,
how can this be solved?any guidance on using the IBatis effectively is
welcomed.Thanks
Raheshkumar.R
Then I'd guess it's either corrupt or the wrong jar.
Try this:
jar -tvf | grep Driver.class
Any errors? Do you see the driver class? Is the name right?
Larry
On 8/1/06, jeb001 <[EMAIL PROTECTED]> wrote:
So, I've tried number of places for that jar.. but it does not work wherever
I put it.
801 - 900 of 1221 matches
Mail list logo