Hi,
I'm converting my home grown custom DAO's over to IBatis sqlMaps and
the IBatis DAO's. I'm finding IBatis a lot simpler to use than my
own. However, I need to do a lot of batch processing and I need to do
it from the DAO tier. With my custom DAO manager, I simply passed the
same connection
Hi Satish,
Just in case you were wondering how to do this. I found this url for
"passing arrays into pl/sql stored procedures"
Read through this. It will help. Nothing to do with iBatis though.
http://asktom.oracle.com/pls/ask/f?p=4950:8:1320218815388063256::NO:::
Hope you will get some h
Hi Satish,
I see that Ibatis has a JDBCTypeRegistry.java that defines all the different
JDBCTypes. It has a
reference to
setType("ARRAY", Types.ARRAY);
May be you can pass a array to the Stored Procedure if not a list.
I don't know if there is documentation for this.
Can a
Looks like a classloader issue. You probably have a newer or older
version of that class in a jar file somewhere. And no, renaming jars
will make no difference. I'd recommend you start by hitting jarhoo:
www.jarhoo.com, which will tell you in what jar files certain classes
are commonly found.
If
Well, as far as I know in Oracle passing arrays to Prepared/Callable
procedures is posible BUT is part of Oracle extensions, i.e. requires
casts to OraclePreparedStatement and OracleCallableStatement.
So at least with Oracle it will be impossible (as SqlExecutor
explicitely uses java.sql.Callable
I am using Oracle. Not sure if it allows "LIST" Data Type.
-Original Message-
From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 10, 2005 5:17 PM
To: user-java@ibatis.apache.org
Subject: RE: Complex type as IN parameter
Hi Satish,
What Database are you using?
Hi Satish,
What Database are you using? Does it allow you to define a DATA TYPE "LIST".
Thanks
Prashanth Sukumaran.
--- "Rao, Satish" <[EMAIL PROTECTED]> wrote:
> Hi Prashanth,
>
> What I want to know is how to pass a list as a IN paramater to stored
> procedure?
> What would the correspondi
Hi Prashanth,
What I want to know is how to pass a list as a IN paramater to stored
procedure?
What would the corresponding sqlMap entry look like and what would the
stored procedure declaration for that IN variable.
-Original Message-
From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED]
Hi Satish,
You must be using a iterator if you are passing a List as a parameter right.
Also
you have defined TBL_ORD_ID as TEST_TABLE.ORD_ID%TYPE.
I have never heard of any database that defines/has a list Data Type. Is there
any???
If not then defined the type of ORD_ID.
Rgds
Prashanth S
Title: Complex type as IN parameter
In one of our stored procedure, we have the following declaration
TYPE TBL_ORD_ID IS TABLE OF TEST_TABLE.ORD_ID%TYPE;
PROCEDURE PRC_ORDER_S
(
IN_TBL_ORD_ID IN TBL_ORD_ID,
……
Hi,
I have tried as suggested renaming the jar files, but this did not fix the
problem as the jar files are simply containers for the classes and it is
fairly irrelevant what their names are.
The problem appears to be that when the
SqlMapClientBuilder.buildSqlMapClient(reader);
is called with t
On a side note I think that using the xml style to configure log4j is
much easier.
You might just try what is on http://opensource.atlassian.com/
confluence/oss/display/IBATIS/How+do+I+get+SqlMapClient+to+log+SQL
+statements%3F
Nathan
On Aug 10, 2005, at 11:50 AM, Prashanth Sukumaran wrote
Hi Max,
In your previous mail you mentioned that you are seeing other debug statements
but you are not
seeing only
"log4j.logger.com.ibatis.*" and "log4j.logger.java.sql.*" rows
seems not to have effect on logging.
This means your log4j Properties Configurator
Max
You can use a servlet which is started when the webapp starts to
configure the log4j Properties Configurator. The Configurator has a
configureAndWatch method that allows you start log4j but also allow
it to be reloaded at runtime.
Set the watch level to something small so you can twe
Sorry for my ignorance, what is the "log4j.PropertyConfigurator.configure",
I only have the log4j.properties file located in my "WEB-INF\classes" project
directory.
How\Where should I use "log4j.PropertyConfigurator.configure" ?
thanks in advance
Max
>-- Messaggio Originale --
>Reply-To: user-j
this is my "log4j.properties" file placed in the "WEB-INF\Classes" project
directory:
-
# Global logging configuration
log4j.rootLogger=DEBUG, stdout, DAILY_FILE
# for ibatis
# SqlMap logging configuration...
log4j.l
On Wed, Aug 10, 2005 at 05:57:05PM +0200, [EMAIL PROTECTED] wrote:
> Hi,
> I had "commons-logging.jar" and "log4j-1.2.8.jar" in my project classPath
> and didn't see logs from iBatis.
> I tried to add even "commons-logging-api.jar" to the classPath but nothing
> changed...
> I'm starting thinking i
I use log 4j on do not have any problems with ibatis debug are you seting the
log4j.PropertyConfigurator.configure wilth your properties?
Steve..
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wed 10/08/2005 16:57
To: user-java@ibatis.apache.org; use
Hi,
I had "commons-logging.jar" and "log4j-1.2.8.jar" in my project classPath
and didn't see logs from iBatis.
I tried to add even "commons-logging-api.jar" to the classPath but nothing
changed...
I'm starting thinking it is Rational (WebSphere Studio) having some problems
in showing logs.
Just fo
On Wed, Aug 10, 2005 at 07:36:19AM -0500, Mitchell, Steven C wrote:
> That is a question for IBM. If you have a JUnit test you can run from the
> command line logging works fine and you can see all the detail you need. It
> just doesn't work from inside of RAD. Let me know if you find the answer
That is a question for IBM. If you have a JUnit test you can run from the
command line logging works fine and you can see all the detail you need. It
just doesn't work from inside of RAD. Let me know if you find the answer
because I have the same issue.
-Original Message-
From: [EM
Hi Andrew,
Try using the JDBC ODBC bridge driver that comes with JDK.
You will get to know whether it is the driver that is the problem.
Priyesh
-Original Message-
From: Ed Griebel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 09, 2005 8:50 PM
To: user-java@ibatis.apache
Hey.
Have you tried just renaming the sun ones (JWSDP) to sun-.jar and
keeping both in your lib directory?
regards
Eoin
Colin Lamond wrote:
Hi,
I have been using SQL Maps for Java for some time now and have just
started work on a project that is using SQL Maps and accessing a web
serv
Hi,
I have been using SQL Maps for Java for some time now and have just
started work on a project that is using SQL Maps and accessing a web
service.
The web service stub code has been built using the Java Web Services
Developer Pack (Java WSDP). My client test project works fine, but as soon
as
On Wed, Aug 10, 2005 at 11:29:34AM +0200, Niels Beekman wrote:
> >From ibatis.apache.org, the very first page:
> iBATIS for Java 2.1.5 Released
> (July 17, 2005) We've released a maintenance release, with a few bonuses
> as well. The most notable changes are: *** 1) iBATIS no longer depends
> on co
>From ibatis.apache.org, the very first page:
iBATIS for Java 2.1.5 Released
(July 17, 2005) We've released a maintenance release, with a few bonuses
as well. The most notable changes are: *** 1) iBATIS no longer depends
on commons logging ***, and 2) the entity resolvers are now smarter so
that t
On Wed, Aug 10, 2005 at 11:23:43AM +0200, Niels Beekman wrote:
> Almost, in 2.1.5 the dependency on commons-logging has been removed, so
> just addding the log4j-libraries should do the trick.
It is just a wish.
Right now it won't work w/o the commons-logging libraries.
--
Eugene N Dzhurinsky
Almost, in 2.1.5 the dependency on commons-logging has been removed, so
just addding the log4j-libraries should do the trick.
Niels
-Original Message-
From: Eugeny N Dzhurinsky [mailto:[EMAIL PROTECTED]
Sent: woensdag 10 augustus 2005 11:23
To: user-java@ibatis.apache.org
Subject: Re: Lo
On Wed, Aug 10, 2005 at 11:19:42AM +0200, [EMAIL PROTECTED] wrote:
> Hi, I think a very simple question: how to log in Log4J with iBatis 2.1.5?
>
> I'm using IBM Rational Software Development Platform Version: 6.0.0.1 and
> iBatis 2.1.5 and I've configured log4j.properties file this way:
you need
Hi, I think a very simple question: how to log in Log4J with iBatis 2.1.5?
I'm using IBM Rational Software Development Platform Version: 6.0.0.1 and
iBatis 2.1.5 and I've configured log4j.properties file this way:
---
30 matches
Mail list logo
