Here is the example from the site:
1. ..
2. Statement stmt = connection.createStatement();
3. ResultSet rs= stmt.executeQuery("SELECT * FROM emp_table");
4. if(rs.next()) {
5. java.sql.Struct empType = (java.sql.Struct)rs.getObject(1);
6. System.
I would be happy to use a different method if it will be easier,but I
can not access that link. I am told it is only available to
ParnerNetwork Program Partners.
Thanks
Guy Rouillier wrote:
I've never had the need to use Oracle struct datatype, but I just used
Google to find this:
http://w
This is was the problem. I had a feeling it was a ClassLoader issue, but
the cause eluded me. I eventually found that I had the ojdbc6.jar in
both the tomcat/lib and web-inf/lib. So, even though the same class was
loaded they were not equal.
Thanks
cowwoc wrote:
On 26/04/2010 3:48 PM, Guy Ro
On 26/04/2010 3:48 PM, Guy Rouillier wrote:
Caused by: java.lang.ClassCastException: oracle.sql.STRUCT cannot be
cast to oracle.sql.STRUCT
Sounds like a ClassLoader issue to me. The only time two classes
with the same name are not equal to one another is when they're
instantiated by diff
I've never had the need to use Oracle struct datatype, but I just used
Google to find this:
http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/objects/ObjectTypes.html
The example is doing things differently than your code is. Perhaps
following the example will produce us
