Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: neutral (athena.apache.org: local policy)
Message-ID: <48DD5252.80205@christopherschultz.net>
Date: Fri, 26 Sep 2008 17:21:22 -0400
From: Christopher Schultz <chris@christopherschultz.net>
User-Agent: Thunderbird 2.0.0.16 (Windows/20080708)
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: jdbc driver fails with tomcat
References: <e64589740809260934r6cfaf5b7g7186ad1f7e23d33b@mail.gmail.com>
	 <48DD147E.4040302@christopherschultz.net>
 <e64589740809261024n8bcfee0v92f3842de4e4f6a5@mail.gmail.com>
In-Reply-To: <e64589740809261024n8bcfee0v92f3842de4e4f6a5@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ziggy,

Ziggy O wrote:
> When i debug the code, it doesnt get to the point where i am initialising
> the OracleCallableStatement object. It failed just after the initialisation
> of the ArrayDescriptor object.

Strange. Are you sure you are working with matching binary and source
versions?

> I have tried to change it to use CallableStatement and im now getting
> another error. Here is how i've changed it to.
> 
> CallableStatement cst =
> conn.prepareCall(stp.SUBMIT_CONSIGNMENT_STORED_PROC);
> 
> ArrayDescriptor rectabDescriptor =
> ArrayDescriptor.createDescriptor("CCS21_CONSIGNMENTLIST_TYPE",conn);

[snip]

> java.lang.ClassCastException:
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper
>     at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:149)
>     at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:115)
>     at com.abbt.ccs21.data.accessors.ConsignmentDAO.submitDeclaration(ConsignmentDAO.java:301)

Now, this stack trace makes more sense to me. It looks like Oracle's
driver expects the Connection object passed into the createDescriptor
method to be an Oracle-specific connection.

Try doing this instead:

ArrayDescriptor rectabDescriptor =
ArrayDescriptor.createDescriptor("CCS21_CONSIGNMENTLIST_TYPE",
(((DelegatingConnection)conn).getInnermostDelegate());

Hopefully, that will get the Oracle-specific Connection object
passed-into that method and then the driver will work properly.

On a side note, could you use the java.sql.Array interface instead of
the Oracle-specific ones? I've never done this, and it isn't entirely
clear how to so it, but this might work:

Array myArray = conn.createArrayOf("dataType", elements);

Then you should be able to use the PreparedStatement.setArray method to
assign it to a parameter. Connection.createArrayOf is part of JDBC 4.0
(Java 6), which you might not be using at this point.

Just a thought.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkjdUlIACgkQ9CaO5/Lv0PBZegCeIuHcpXn6x/eP3ZvFooy4twf0
XOEAoMCf0ZxTBTtxcB86hq8ax1qYM0Fm
=6yjk
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org