[JBoss-dev] jboss not sync'd with external db changes

[David Ward]

I'm goin' a bit crazy here...

If I have a sqlplus window open to my Oracle database, I can see the 
data change as I change values via my CMP Entity Bean.  However, if I 
change a value in the DB using sqlplus (and commit it), my already 
active CMP Entity Bean doesn't pick up the change (it still has the old 
value).

What am I doing wrong?  I've attached my jaws/ejb-jar/jboss xml files. 
I'm going to look real stupid if it turns out the kind of synchronicity 
I'm looking for isn't supported...

Thanks,
David

<?xml version="1.0"?>

<jaws>

	<datasource>java:/OracleDS</datasource>
	<type-mapping>Oracle8</type-mapping>
	<debug>true</debug>

	<default-entity>
		<create-table>false</create-table>
		<remove-table>false</remove-table>
		<tuned-updates>true</tuned-updates>
		<read-only>false</read-only>
		<select-for-update>true</select-for-update>
	</default-entity>

	<enterprise-beans>
		<entity>
			<ejb-name>ProductionFileType</ejb-name>
			<table-name>PRODUCTION_FILE_TYPES</table-name>
			<cmp-field>
				<field-name>fileTypeID</field-name>
				<column-name>FILE_TYPE_ID</column-name>
				<java-type>java.lang.String</java-type>
				<jdbc-type>VARCHAR</jdbc-type>
				<sql-type>VARCHAR2(10)</sql-type>
			</cmp-field>
			<cmp-field>
				<field-name>description</field-name>
				<column-name>DESCRIP</column-name>
				<java-type>java.lang.String</java-type>
				<jdbc-type>VARCHAR</jdbc-type>
				<sql-type>VARCHAR2(35)</sql-type>
			</cmp-field>
			<cmp-field>
				<field-name>duration</field-name>
				<column-name>DURATION</column-name>
				<java-type>java.lang.Long</java-type>
				<jdbc-type>BIGINT</jdbc-type>
				<sql-type>NUMBER(38)</sql-type>
			</cmp-field>
			<cmp-field>
				<field-name>electronicFile</field-name>
				<column-name>ELECTRONIC_FILE</column-name>
				<java-type>java.lang.String</java-type>
				<jdbc-type>VARCHAR</jdbc-type>
				<sql-type>VARCHAR2(3)</sql-type>
			</cmp-field>
		</entity>
	</enterprise-beans>

</jaws>

<?xml version="1.0"?>

<!DOCTYPE ejb-jar PUBLIC '-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 1.1//EN' 'http://java.sun.com/j2ee/dtds/ejb-jar_1_1.dtd'>

<ejb-jar>

	<display-name>DOCS</display-name>

	<enterprise-beans>
		<entity>
			<ejb-name>ProductionFileType</ejb-name>
			<home>corp.docs.ejb.ProductionFileTypeHome</home>
			<remote>corp.docs.ejb.ProductionFileType</remote>
			<ejb-class>corp.docs.ejb.ProductionFileTypeBean</ejb-class>
			<persistence-type>Container</persistence-type>
			<prim-key-class>java.lang.String</prim-key-class>
			<reentrant>False</reentrant>
			<cmp-field><field-name>fileTypeID</field-name></cmp-field>
			<cmp-field><field-name>description</field-name></cmp-field>
			<cmp-field><field-name>duration</field-name></cmp-field>
			<cmp-field><field-name>electronicFile</field-name></cmp-field>
			<primkey-field>fileTypeID</primkey-field>
		</entity>
	</enterprise-beans>

	<assembly-descriptor>
		<container-transaction>
			<method>
				<ejb-name>ProductionFileType</ejb-name>
				<method-name>*</method-name>
			</method>
			<trans-attribute>Required</trans-attribute>
		</container-transaction>
	</assembly-descriptor>

</ejb-jar>

<?xml version="1.0"?>

<jboss>

	<enterprise-beans>
		<entity>
			<ejb-name>ProductionFileType</ejb-name>
			<jndi-name>docs/ProductionFileType</jndi-name>
		</entity>
	</enterprise-beans>

</jboss>