Hello,
I am using ibatis as my persistence layer in an application that I'm
rewriting. I have some older code that uses JDBC directly and I can't
see how to integrate it with iBatis in any useful way.
The old code calls a stored procedure. After contact information is set
the number of argu
Hi everyone,
I have a custom type handler I'm using for Java 1.5 enums to map to a
VARCHAR column in Oracle. I've read the SqlMap doc about TypeHandlers
but there are some missing details...I'm sure my TypeHandler syntax
definition is off, but I'm having a hard time finding the right place
for it
Hi, this is my first project using Ibatis, I did a lot of research to find
some tutorial for using Ibatis with Ingres and have no luck. Right now I am
having problem with just connecting to Ingres. If anyone have any
experiences with this please help.
Thanks
--
View this message in context:
h
If you are running Abator as an Eclipse plugin, then Abator can do a Java
and XML merge. This means that you can add anything you want to the
generated classes and XML files - Abator will merge the changes back in if
you run Abator again.
If you are running Abator outside of Eclipse, then Abator
thank you Jeff...I got it and it's working.
wonder if I can add my own statements to the auto-generated statements or I
should create them in a different file? I'm asking this because I suspect
that if I add a new statement it might be deleted if I revise the db table'
structure (as in adding anot
Hi,
I am currently using iBatis 2.1 and I am having trouble connecting to different
dbs. In my DAOMap.xml, I created to connections to 2 different databases --
when I tested each of the queries in Junit, it works fine, however when I call
via the DaoManager, it keeps throwing this error:
java
Hi,
Managed to get things working with both commons-logging/log4j and ojdbc
stuff.
As you explained below - whenever I set java.sql.Connection to a value
of 'DEBUG' things stop working, when I cast to OracleCallableStatement.
I'm guessing this is what you meant by the usage of "getPs()"
This
I'm thinking we're running into some serious classloading issues here -
with OC4J.
From 10.1.3 on up this part of the J2EE impl of Oracle has been
massively changed.
What's strange though is that everything works as long as we don't do
logging?
Jan Vissers wrote:
Hi Jeff,
Thanks for th
Team,
I happened to be next to a Barnes and Nobel yesterday so I thought I would
swing by the Java section and see if they had the book. They only have 2
now that I snagged my copy. Great to see that this community has something
out there in the press.
As a reviewer of this book I can not expr
iBATIS does different things depending on the logging level. If logging is
enabled on java.sql.Connection, then you'll get the proxied classes (which
are proxied yet again by Oracle). If not, you'll get the actual classes
(again, proxied by Oracle). To be completely safe, you need to allow for
Hi Jeff,
Thanks for this suggestion.
A couple of things to note here;
Not sure whether this is (really) an iBatis issue - it might be that
we're running into OC4J (Oracle's J2EE impl) specific behavior.
OC4J has managed and unmanaged datasources. We're currently using
managed datasources, wh
How about if we add a getPs() method to the PreparedStatementLogProxy that
returned the wrapped PreparedStatement. Then you could cast the wrapped
prepared statement to the oracle callable statement. This would be quick
and easy, and would (I think) solve the issue. This is also similar to what
This is not an iBATIS/Abator problem - it is related to the configuration of
your JDBC driver. See here for more information:
http://support.microsoft.com/kb/313181
Jeff Butler
On 2/5/07, dridi <[EMAIL PROTECTED]> wrote:
hi,
i'm a new user of abator.
i think that you used abator before me
This MUST be a bug right?
49if ("prepareStatement".equals(method.getName())) {
50 PreparedStatement stmt = (PreparedStatement)
method.invoke(connection, params);
51 stmt = PreparedStatementLogProxy.newInstance(stmt, (String)
params[0]);
52 return stmt;
53
Well okay then,
It's just I need to cast to an Oracle specific JDBC CallableStatement,
because I want to retrieve Oracle's
XMLType from the underlying stored function/procedure.
Like so:
ocstmt = (OracleCallableStatement)c.prepareCall(VALUECALL);
ocstmt.registerOutParameter(1, or
:-
I meant don't use casting to oracle types...
Sorry for the bad language...
-Original Message-
From: Jan Vissers [mailto:[EMAIL PROTECTED]
Sent: Monday, February 05, 2007 4:18 PM
To: user-java@ibatis.apache.org
Subject: Re: OracleCallableStatement, log4j => PreparedStatementLogProx
Hi Hofri -
not sure why you are saying: "iBatis, don't use it!!!" (in Dutch).
However - just to make sure I'm not misunderstood - I like the iBatis
framework and we tend to use it
regularly. It's just now and then there is something that is not really
clear (to me). Most of the time
it has to d
iBatis, gebruik het niet!!!
-Original Message-
From: Jan Vissers [mailto:[EMAIL PROTECTED]
Sent: Monday, February 05, 2007 4:08 PM
To: user-java@ibatis.apache.org
Subject: Re: OracleCallableStatement, log4j => PreparedStatementLogProxy
(is this a bug?)
Thank you, but this is not going t
Thank you, but this is not going to help me.
Somewhere along the way the behavior of iBatis with/without logging has
been changed - and I want to now where.
I suspect that the PreparedStatementLogProxy is wrong, as it should
still allow me to get to the OracleCallableStatement.
Also, I'm not
try:
WrappedConnection wrappedConn = (WrappedConnection) conn;
Connection underlyingConn =
wrappedConn.getUnderlyingConnection();
OracleConnection oracleConn = (OracleConnection)
underlyingConn;
-Original Message-
From: Jan Vissers [mailto:[EMAIL PROTEC
Hi,
Environment:
+ OC4J 10.1.3.2.0
+ OJDBC 10g
+ ibatis (2.2.0/2.1.0)
+ with and without logging
Consider the following Java/DAO code:
public class JdbcCallExecutorDAO extends JdbcDaoTemplate implements
ICallExecutor {
OracleCallableStatement ocstmt = null;
String re
If you're using sequences or identity columns in your database, then use
the element in your Abator configuration - and then the
insert will return the new key.
The example class is used for the selectByExample and deleteByExample
methods. There is a page in the Abator documentation regarding t
hi,
i'm a new user of abator.
i think that you used abator before me and you can help in ùy problem.
i want to know an example of how to do the select query with abator using
"selectbyprimaykey or selectbyexample".
i used this java code
//
/
public void testBASSINS
Nereida gmail.com> writes:
>
> Hi all,
> i 'm working with abotor.
i succed to do delete,insert and update queries but i can't do the select one.
please if you can send me an example of java code i 'll be very gratefull.
thank's a lot;
24 matches
Mail list logo
