Same relational link, multiple times, different names

Hello, I have a Users table then a Claim table. The Claim table links to the User table many times. For instance: cleric_id, doctor_id, pricer_id ... all of those are different users performing well defined roles with the claim. I know how to link 1 of them via a SqlMap. I have a resultSe

Re: Insert oracle BLOB's with iBatis

Hi This is how I do it. Hope it works for you My java bean class has two attributes MyBean.java Blob myBlob; InputStream myStream; MyBean.xml .. Custom type handler import com.ibatis.sqlmap.client.extensions.ParameterSetter; import com

Re: JDBC.ConnectionURL problem. Changed from 'localhost' to 'IP-number'

Cause: java.sql.SQLException: No suitable driver found for jdbc:mysql:/69.89.12.165:3306/itc_registration_db Looks like you are missing a / there. Larry

Re: ResultMap columns as a superset of select columns

If you carefully design your resultmaps, the "extends" property of the result map could help you. The only precaution you might have to take is that, The order of declaration should be the order of definition in the sqlmap file. On Thu, Sep 25, 2008 at 4:11 PM, Daniel Henrique Alves Lima < [EMAI

RE: ResultMap columns as a superset of select columns

I'm trying to re-use the same ResultMap multiple times, but in the second query (with one column) the JDBC driver will raise an exception because "nm_entity" does not exist in the returned ResultSet. I want to avoid to define a lot of ResultMaps for the same table... Is there an wa

JDBC.ConnectionURL problem. Changed from 'localhost' to 'IP-number'

Hi all, my application runs great on my localhost. now, after all is done, I deploy the application on a remote site. so some changes should apply. on my localhost i have: and on the remote I did: but this doesn't workany suggestions? did I forget anything? Thank you * error message:

iBatis Stored Procedure call

Hello! How can i call stored procedure with OUT parameters return values? I tried with: {call SPSSUSRSTS(?,?,?)} Map parameterMap = new HashMap(); parameterMap.put("CSPRF",httpServletRequest.getUserPrin

Re: AW: Shutting down Connection Pool at runtime (for maintenance)

You don't even need to use RMAN. You can put the database in hot backup mode, back the files up via scripts, and then take it out of hot backup mode. There really is no reason to have downtime running Oracle. 8i is old but its still advanced. Pretty sure RMAN exists in 8i as well but its n

RE: ResultMap columns as a superset of select columns

You can alias your columns in your select. Select foo as cd_entity, bar as nm_entity from table iBatis will use the alias to map the results in the resultMap. -Original Message- From: Daniel Henrique Alves Lima [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2008 2:32 PM To: u

ResultMap columns as a superset of select columns

Hi everybody. First of all: I'm sorry for my bad English. How can define just one resultMap with all necessary columns and reuse it in selects with different columns ? Something like this: select * from entity select cd_entity fr

Re: AW: Shutting down Connection Pool at runtime (for maintenance)

It does, but I think you need 8i enterprise... Larry On Thu, Sep 25, 2008 at 6:40 AM, Ian Zabel <[EMAIL PROTECTED]> wrote: > Thanks, Axel. I'll do some research into this. We don't have a DBA on staff, > and this is how we've been doing it for years. Hopefully Oracle 8i supports > this! (soo old

Re: AW: Shutting down Connection Pool at runtime (for maintenance)

Thanks, Axel. I'll do some research into this. We don't have a DBA on staff, and this is how we've been doing it for years. Hopefully Oracle 8i supports this! (soo old!) Thanks, Ian. On Sep 25, 2008, at 1:38 AM, Leucht, Axel wrote: I have to admit that I know Oracle only very basically, tho

Miles Palis is not available until 09/30/2008

I will be out of the office starting 09/24/2008 and will not return until 09/30/2008. I will respond to your message when I return. Please contact Alan May if you need your questions address prior to my return.