Re: ArrayDescriptor issue

Can you test whether your code works using just JDBC (without iBatis)? I think that way we'd know direction where to look Koka

RE: ArrayDescriptor issue

I am getting the same error with straight JDBC code -Original Message- From: Koka [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 3:39 AM To: user-java@ibatis.apache.org Subject: Re: ArrayDescriptor issue Can you test whether your code works using just JDBC (without iBatis)? I

RE: ArrayDescriptor issue

I tried it again. It works with straight jdbc but fails with sqlmap -Original Message- From: Koka [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 3:39 AM To: user-java@ibatis.apache.org Subject: Re: ArrayDescriptor issue Can you test whether your code works using just JDBC (wit

RE: ArrayDescriptor issue

Could you paste the JDBC-code, otherwise we are not getting any further :) Niels -Original Message- From: Rao, Satish [mailto:[EMAIL PROTECTED] Sent: dinsdag 16 augustus 2005 16:47 To: user-java@ibatis.apache.org Subject: RE: ArrayDescriptor issue I tried it again. It works with straigh

RE: ArrayDescriptor issue

Here's the standalone code that works. import java.sql.*; import oracle.jdbc.internal.OracleTypes; import oracle.sql.ARRAY; import oracle.sql.ArrayDescriptor; class TestOrder { public static void main(String[] args) throws SQLException { int error_code;

Re: ArrayDescriptor issue

The error you get usually indicates permission problems. So it seems that either you have not created ORD_ARRAY type on the database side or the user you use to open connection does not see it. It would be easier if you'd post JDBC code AND oracle TYPE/procedure Good luck Koka

RE: ArrayDescriptor issue

Just posted the code -Original Message- From: Koka [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 11:00 AM To: user-java@ibatis.apache.org Subject: Re: ArrayDescriptor issue The error you get usually indicates permission problems. So it seems that either you have not created

RE: Problem getting BLOB from oracle

Yes I would like an error message too...but there is none. I just get the first few bytes of the BLOB. the typeHandler has not affect. I tracked this down a little, the handler is working fine, just what I get from the database seems to be cut off. is there anything I have to do to the standard

RE: ArrayDescriptor issue

Ok.. Made some progress Now its going past the following code ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor("NUM_ARRAY", conn); ARRAY array = new ARRAY (descriptor, conn, orderIdArr); arg0.setArray(array)

Re: I want ask you a problem about ibatis.

John,This is really a simple Java issue.When you say that it is not a file you are correct.  It is just a java.lang.btye[].  But on the other hand a java.io.File is not a file either.  It is just a pointer to the actual files in your filesystem.  If you want to write the byte[] out to a new file on

Message: no WRITABLE property

Hi Folks, I'm having trouble with a query for a Product class that has an attribute named "pNoticeComanyNumber." - Begin Error Message -- 12:11:34:895 ERROR ibatis.IbatisProductMaintenance - SQL error: --- The error occurred in productMap.xml. --- The error occurred while ap

Re: Message: no WRITABLE property

Hi, I think this question has been brought up before. I can't find the reference now, but I believe the JavaBeans spec doesn't allow having properties with the first two letters capitalized, hence the 'There is no WRITABLE property" error. As for the second error, I'm not sure what's going o

Re: Message: no WRITABLE property

Hi Paul, make the line to This is ridiculous, I know. I have also wasted so much time on this thing before. But the issue is since it is a privimitive type and if the sql returns a NULL it throws an nullpointer exception. Rgds Prashanth Sukumaran. --- Paul Glezen <[EMAIL PROTECTED]>

Re: Message: no WRITABLE property

Here is the FAQ . http://opensource.atlassian.com/confluence/oss/pages/viewpage.action? pageId=71 ~N On Aug 16, 2005, at 10:23 AM, Aitor Imaz wrote: Hi, I think this question has been brought up before. I can't find the reference now, but I believe the JavaBeans spec doesn't allow h

Re: Message: no WRITABLE property

I think that a getter named getpNoticeComanyNumber *should* work, according the java bean specification. However, I do not think that it will work with iBATIS, but cannot confirm this at the moment. Larry On 8/16/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > Here is the FAQ . > > http://op

Re: Message: no WRITABLE property (resolved)

Hi Folks. After following the advice of the responses: 1. Removing capitals from the first two letters of the property name 2. Adding the nullValue attribute in the result map it works now. Thanks. - Paul Prashanth Sukumaran <[EMAIL PROTECTED]> wrote on 08/16/2005 09:29:50 AM: > Hi Paul,

Dynamic Database URL

Is there a way to dynamically change the db url based on a parameter passed in at run time? We have a program that needs to run against 3 different production databases. The only thing changing is the DB URL. Nathan

Re: Dynamic Database URL

You can pass in a properties object to the sqlmapclient builder that is substituted into the sqlmapconfig.xml file. But, you will need 3 instances of the SqlMap client.. Larry On 8/16/05, Nathan Maves <[EMAIL PROTECTED]> wrote: > Is there a way to dynamically change the db url based on a parame

Log location.

Hi, I used this for logging the slow queries, I need to know the name on the property to decide the locations for the logs. Is there a default location available, if I dont specify it? - javabuddy. Have a great day. :-) -- Check out the next generation mailing list and more...http://ro

Re: Log location.

I presume you mean for MySQL? How would you do it with straight JDBC? Larry On 8/16/05, Gana <[EMAIL PROTECTED]> wrote: > Hi, > > I used this for logging > the slow queries, I need to know the name on the property to decide the > locations for the logs. > > Is there a default location availa

Re: Log location.

In the sql map I found this configuration. /- Gana./ Larry Meadors wrote: I presume you mean for MySQL? How would you do it with straight JDBC? Larry On 8/16/05, Gana <[EMAIL PROTECTED]> wrote: Hi, I used this for logging the slow queries, I need to know the name on the property

Join 2 tables with same column name

Hi Folks, I'm struggling with a query like the following. select a.id, b.id, b.company from prod a, prod_loc b where a.id = b.company I want to map the three attributes to a Product object as follows: product.id --> a.id product.locId --> b.id product.company --> b.company Whe

Re: Join 2 tables with same column name

Paul, What error are you getting? Did you try updating your query to reference a.id and b.id by aliases?  This should work. select a.id as id1, b.id as id2, b.company from prod a, prod_loc b where a.id = b.companyOn 8/16/05, Paul Glezen <[EMAIL PROTECTED]> wrote: Hi Folks, I'm struggling

Re: Join 2 tables with same column name (resolved)

Thanks, Eric.  That worked.  What error are you getting? Did you try updating your query to reference a.id and b.id by aliases?  This should work.select a.id as id1, b.id as id2, b.companyfrom prod a, prod_loc bwhere a.id = b.company

Re: Dynamic Database URL

Not sure that I understand you. Let me explain a little better what I need and see if it is still the solution. I have a program that I need to 3 different instances of, in 3 different VM. I just want to pass some parameters from the command line all the way to the sqlmap config. Pos

RE: Dynamic Database URL

This is possible just create a properties object and pass this to the sqlmap builder name the properties with keys like you have given in the sqlmapconfig. so the properties would have keys driver, url, username etc... i.e SqlMapClientBuilder.buildSqlMapClient(configReader,properties);