Re: sql server 2k parameterized queries

Can you post the mapped statement?LarryOn 3/22/06, Bob <[EMAIL PROTECTED]> wrote: I'm trying to use ibatis with sql server 2k, and I'm having problemswith parameterized queries.  I have many parameterized queries workingwith mysql, and I'm really confused as to why this is causing aproblem.  The qu

Configuring SQL Server datasource

OK, can you tell I'm struggling? Can't seem to get a break here. Wouldn't have anything to do with SQL Server being a Microsoft product would it!? ;) My latest error: Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

RE: sql server 2k parameterized queries

Hi Bob, I see you're using sql server 2k. I know you need an answer to your question, but could you PLEASE help me. I'm trying to get the jpetstore to work with a physical sql server 2k db. I have the db created with populated tables. I've scoured through docs, wiki, faqs, google all day and ca

sql server 2k parameterized queries

I'm trying to use ibatis with sql server 2k, and I'm having problems with parameterized queries. I have many parameterized queries working with mysql, and I'm really confused as to why this is causing a problem. The query is set up very similarly to all the mysql ones (except it is trying to put

How to configure a SQL Server datasource?

Hello, New user here, sorry for the lame question, but I've spent all day looking through the docs and faqs and can't find exactly how to do this. here's what I have so far: I've created the database, tables and populated them with the scripts (SQL Server 2000). I wasn't sure what to do in the

Re: Sybase JConnect 5.5 & CLOB

I think your problem is that you need to tell iBatis the column type that you are fetching. This is from a previous email in the archive. iBATIS can fetch the BLOB as a stream of bytes. One way of doing what you want is to create get/setters using byte[] that store/read to/from a private Strin

Re: Sybase JConnect 5.5 & CLOB

Chris,   now i am getting Cause: java.sql.SQLException: JZ0TE: Attempted conversion between an illegal pair of types. Valid database datatypes are: 'varbinay, long binary, binary, image   Where should i be changing the datatype in POJO or resultMap?    here is the code (msg field is defined

Re: Sybase JConnect 5.5 & CLOB

You should be reading the CLOB out of the database into a byte[] rather than a String. From there you can convert it into a String and apply any encoding that might be necessary. Chris Mathrusse [EMAIL PROTECTED] Sybase, Inc One Sybase Drive Dublin, CA 94568 (925) 236-5553 "Balaji" <[EMAIL P

Sybase JConnect 5.5 & CLOB

When i try to read a 'TEXT' datatype field from Sybase 12.0 database & JConnect 5.5, - datatype in POJO is String (also tried java.sql.Clob) - jdbcType in resultMap is 'CLOB' i get the following error message shown below. Looks like getClob(string) is not implemented in Jconnect yet. Does anyon

oracle reference cursor for Java

Does Ibatis support reference cursors for Java?  I saw info for .net on the web site, but no examples for Java.  Can someone supply some info and hopefully and example?Thanks,BillR Yahoo! Mail Use Photomail to share photos without annoying attachments.

Re: Sql Map self call

It's corrected now, my lacks about ibatis make me search the error at the wrong place. Thank for your kind help. Robbie.

RE: Problem with dynamic query.

That's the one. Rather than enhancements to the decision tags individually I would like to see some proposals implemented gathered on the wiki 'Improved Dynamic SQL Whiteboard'... Any comments from the iBATIS committers about this? Thanks, Niels -Original Message- From: Reuben Firmin [m

Re: Problem with dynamic query.

http://issues.apache.org/jira/browse/IBATIS-238, in case anybody else wishes to vote on it. :) Niels Beekman wrote: You cannot use an iterated property in the decision tags. I believe there is a JIRA issue for this. --> not allowed Niels -Original Message- From: Daniel Pitts [mailt

RE: Sql Map self call

And how would that error look like? Seems like this should work just fine. Niels -Original Message- From: Sol [mailto:[EMAIL PROTECTED] Sent: woensdag 22 maart 2006 18:04 To: user-java@ibatis.apache.org Subject: Sql Map self call I all, i'm totally new to IBatis so i need some piece of

Sql Map self call

I all, i'm totally new to IBatis so i need some piece of advices ! column="idOperationParent"/> select * from operation where id=#value# Is this kind of map executable by IBatis ? i'm getting a error.

Sql Map self call

I all, i'm totally new to IBatis so i need some piece of advices ! column="idOperationParent"/> select * from operation Is this kind of map executable by IBatis ? i'm getting a error.

embedding existing resultMap to a resultMap

I think that I am missing something here but I can't find the documentation pertaining to this. I have a BillTo class which contains a PaymentTerms object. Of course the BillTo resultMap could read as follows: