Search:

As the title have stated,

Is it possible to do a resultSet.getXXX("tablename.columnName")?

How do u handle a

select * from table
query where one of the columns is a xmltype?

Somehow I can't retrieve the xmltype column.

The only way I can get it to work now is to do a

Select...

I already posted it on JIRA, stating it a bug. Got reply, and it will rectified in 2.0.9.

Anyway, I think there another underlying issue for this.

Apparently, OracleLobHandler need to work on...

Well, I have found another issue where it point to NativeJdbcExtractorAdapter giving the problem.

At line 108, it return back a null.



094 public Connection...

I got a new clue on my problem. Hope it helps.

It seem that the connection being came from here.



con = getOracleConnection(ps); Line 338 from OracleLobHandler.


FYI, I'm using a...

Basically, I have 2 servers, one that host the database and the datasource. The other host all the applications and stuffs.

One of my application requires to make use of xmltype in oracle, which...

Ok, I got another interesting issue.

Currently my system have 2 managed servers port 1001 and 1003 (Let use the port number for references). Server 1001 is used for creating the datasource and...

Well... I actually stumbled to my solution...

With my original DAO( inside a bean) in my server(I retrieved my bean from my service, rather than using the DAO on it own to do the update), the...

Hm... I tried removing all the ojdbc.jar in the classpath except for the one in the WLS lib. (I guess WLS will still need that to start up the datasource) But to no avail. It still failed with the...

Just some doubts.

In this case, the datasource is retrieved through a jndi lookup. What class or type is this datasource? Is it a SingleConnectionDataSource or what other DataSource?

The reason...

David, are you using weblogic as your server? And if yes, what oracle driver are u using?

I tried that before too. But it would give me another error.



caused by java.io.NotSerializableException: oracle.jdbc.driver.T2CConnection

My Spring config



<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"...

I tried to do what you do. Stripping down everything until a DAO is left. But i still gettting the same error message



Caused by: java.lang.NullPointerException
at...

I'm using Weblogic 9.2 and Spring 2.0.6.

I suspect it the classpath issue too. But i have checked ojdbc14.jar. It all of the new version.

Just 1 question, have u tried inserting a xml string...

Is it possible to do this using a datasource that is retrieved through jndi lookup?

Because I have problems with the initialising the OracleLobHandler

See it in this thread
...

I have tried specifying it in my classpath. But it still fail.

However, I doubt that it is missing from the classpath. Cause if it was to be missing from the classpath, the other method of using...

I tried the WeblogicNativeJdbcExtractor but somehow it still give me the error.

Then i tried the SimpleNativeJdbcExtractor... Well... it now giving me a new error.


...

Okie, I tried creating a new datasource with the driver I wanted. And I did a POJO testing.

But it gave me all these error



org.springframework.dao.DataAccessResourceFailureException: Could...

How can I specify the driver when I'm using JNDI to lookup the datasource?

Eg


<bean id="datasource" class =org.spring.framework.jndi.JndiObjectFactoryBean>
<property name ="jndiName">...