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
Don't use JDBC-ODBC bridge... it's horrible and useless. There are no Open Source Access JDBC Drivers. You will need to purchase one. I would recommend that you look into using a real database. Something like MySQL or PostreSQL if you are looking for affordable.
Brandon GoodinOn 7/28/06, Carson Rei
Did you try to close all the connections? It is a bit complicated with
Spring, but I believe if you have every bean to set to
"singleton=false", the connection might get reset.
Thanks.
Carson Reinke
[EMAIL PROTECTED]
P: 248.333.7700 x108
-Original Message-
From: AlexeyG [mailto:[EMAIL
Hello,
I am attempting to use iBATIS and to access MS Access file via JDBC-ODBC
bridge.
(I am using Spring's "SqlMapClientDaoSupport," but that is probably
irrelevant)
All this runs on Tomcat... First time DB gets accessed the LDB lock file is
created. From there on the only way I can remov
Perhaps the JUnit test is using a different sqlMap xml file? Check and
see. If it is, make sure that the JUnit's sqlMap xml file is
valid/correct.
-Original Message-
From: Henry Lu [mailto:[EMAIL PROTECTED]
Sent: Friday, July 28, 2006 11:05 AM
To: user-java@ibatis.apache.org
Subject: IBA
My only questions are these:
1. Are you using the latest version of iBATIS (2.1.7)?
2. Is the DOCTYPE in all of your sqlMap files set to this:
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
The iBATIS build has lots of JUnit tests runnin
Is there any one who has some idea about this issue?
I run a Junit testing and got the following errors:
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'sqlMapClient' defined in file
[C:\devel\webapps\mtrain\WEB-INF\test\app_beans_test.xml]:
Initializat
The #[]# syntax is perfectly valid... I use it all the time. You use it when the parameter
itself is a collection, so you don't have a object.something option to use.
I don't think it works with Maps, however. Jeremy, why did you think you need a map? Oh, I
get it... for the very reason I just
This is on my short list of things to do for Abator, but I haven't started on it yet.
Jeff Butler
On 7/27/06, Jared Blitzstein <[EMAIL PROTECTED]> wrote:
Is there something in the works, or has anyone extended abator, forupdate statements that only update fields present in the object. Like
if I
here is the app_beans_test.sql:
.
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
name="configLocation">WEB-INF/test/sql-map-config_test.xml
..
and here is the sql-config_test.xml:
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
Thanks for your helpful answers. Changing the import order in my
config file fixed the problem. Now it works just as expected. :)
On 7/28/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
This is a known bug.
In your sqlmap config, be sure to include the file with the resultmaps
BEFORE the file with
Hi,
Can you provide us the app_beans_test.xml file?
Antoine
-Original Message-
From: Henry Lu [mailto:[EMAIL PROTECTED]
Sent: vendredi, 28. juillet 2006 13:52
To: user-java@ibatis.apache.org
Subject: error...
I run a Junit testing and got the following errors:
org.springframework.bea
Hi,
Are you expecting more than one result from your
query? If "Yes", then queryForList/queryForMap is the proper method to
call.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 10:47
AMTo: user-java@ibatis.apache.orgSubject: Very
Urgent-Badly need you p
I run a Junit testing and got the following errors:
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'sqlMapClient' defined in file
[C:\devel\webapps\mtrain\WEB-INF\test\app_beans_test.xml]:
Initialization of bean failed; nested exception is
com.ibatis.co
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.
Hi,
Two questions:
1) What's with the "where #DONNE_UUID# in ..."? Did you mean:
"where DONNE_UUID in ..."?
2) Are you sure iBatis understands this syntax: #[]# ? I've read somewhere
that it's not a valid syntax. In the "Developer's Guide" iBatis expect this
parameter to be "a property of type j
On Fri, 28 Jul 2006, Stefan Podkowinski wrote:
Can anyone give advise how to seperate object mappings from statements
in ibatis? We would like to create a file containing a few complex
reporting queries with the intention to use it as a common query
definition base for several applications. The
Since ArrayList implements List
interface.
Child class can be casted to super, but
super cannot be casted to its child
Best,
Aram
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 28, 2006 1:58
PM
To: user-java@i
Hello
Can anyone give advise how to seperate object mappings from statements
in ibatis? We would like to create a file containing a few complex
reporting queries with the intention to use it as a common query
definition base for several applications. The problem is we cannot us
a common result ma
Found the problem and solution.
The
setter method in my code was accepting ArrayList, so it
was throwing the java.lang.IllegalArgumentException: argument type mismatch.
But the Ibatis was returning List
object.
Why Ibatis can not convert from List to
ArrayList. ?
Thanks n
R
Hi,
Can
any one please spend some time for this. I have to deliver the code
today.
I am
doing lazy loading. I am doing basically N+1 loading. I have two tables
which has 1:N relationship.
If the
table have the data with 1:1 ratio then my query is working
fine.
But if
any of master is
Hi Aram,
Thank you for your
reply. I found the exact problem. Can you please help
me now.?
The following query
is working if the user is having exactly one user properties
record.
Here the User is master
table and Properties is detail table.
Re: help problem with select request using 'in' where clause
Hi,
Thanks for your help.. but something still drives me crazy..
It seems that I sould pass a "java.util.Map" object and not a
"java.util.List" in my select tag..
So, I did that :
// that list contains ids I want to add in 'in' clause.
List params = new ArrayList() ;
// I put it in a Map.
23 matches
Mail list logo
