I was hoping to develop a blog on this though it's turned more into a rant. I configured a datastore within WLS, which is fairly arbitrary and self-explanatory.. done.

Within the conf-context.xml, the following no longer exists:

<property name="locations"> <!-- <value>file:$RBACX_HOME/conf/jdbc.properties</value> -->

The xml within the OIA 11.1.1.5.4 structure is actually within a 'constructor-arg' though nevertheless value to rem-out is fairly obvious.

Within the dataaccess-context.xml, you are informed to rem-out the default datasource and include a new datasource bean with the jndiName property value.

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean"> <property name="jndiName" value="jdbc/rbacx" />

The issue here is that the 'bean' node isn't closed (I assume there should be another line with </bean>). If the node isn't included, you get the following error with the Weblogic logs:

Caused By: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'bean'. One of '{"http://www.springframework.org/schema/beans":meta, "http://www.springframework.org/schema/beans":constructor-arg, "http://www.springframework.org/schema/beans":property, "http://www.springframework.org/schema/beans":qualifier, "http://www.springframework.org/schema/beans":lookup-method, "http://www.springframework.org/schema/beans":replaced-method, WC[##other:"http://www.springframework.org/schema/beans"]}' is expected.

The scheduling-context.xml doesn't seem to be an issue though even if I make the changes above, I get the following issue

Caused By: java.sql.SQLException: Driver's Blob representation is of an unsupported type: weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB

I did some research on the database driver for the data store and tried many styles, though I am at the point of giving up. I've rectified the JDBC changes and will continue to use the hard-coded datastore version.

Oracle presented it within the document that it's simple enough though I would question if this has been validated in recent time.

About the author