I'm trying to create the XMLType Object using Oracle and i tried to pass the java.sql.Connection but its failing with the proxy error and also i tried to typecast with OracleConnection and it didn't work. Did anyone worked on it using the simple SQL-MAP Configuarion.
oracle.xdb.XMLType oracleXMLType = XMLType.createXML(conn, strXMLData);
However if i try to use the new connection like below it works.
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@server:portnum:dbname", "userName", "pwd");
Anyone kind of help would be kindly appreciated.
Thanks
