Hi,
I get the following message when i try to run a client
based on a simple CMP bean running on the JBoss
server.
[J2EE Deployer Default] J2EE application:
file:/D:/java/JBoss-2.2.1/deploy/market.jar is
deployed.
[MarketBean] java.rmi.ServerException: Store failed;
nested exception is:
[MarketBean] java.sql.SQLException: Unexpected
token: in statement [UPDATE MarketBean SET
name='attws',id=1 WHERE ]
[MarketBean] java.sql.SQLException: Unexpected token:
in statement [UPDATE MarketBean SET name='test',id=1
WHERE ]
[MarketBean] at
org.hsql.Trace.getError(Trace.java:124)
[MarketBean] at
org.hsql.Result.<init>(Result.java:70)
[MarketBean] at
org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644)
[MarketBean] at
org.hsql.jdbcConnection.execute(jdbcConnection.java:540)
[MarketBean] at
org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
[MarketBean] at
org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52)
[MarketBean] at
org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:114)
.
.
.
.
.
I am using the "DefaultDS" datasource, JBoss-2.2.1
The jaws.xml file is as below
<?xml version="1.0" encoding="UTF-8"?>
<jaws>
<datasource>java:/DefaultDS</datasource>
<type-mapping>Hypersonic SQL</type-mapping>
<debug>false</debug>
<enterprise-beans>
<entity>
<ejb-name>MarketBean</ejb-name>
<table-name>MarketBean</table-name>
<create-table>true</create-table>
<cmp-field>
<field-name>id</field-name>
<column-name>id</column-name>
</cmp-field>
<cmp-field>
<field-name>name</field-name>
<column-name>name</column-name>
</cmp-field>
</entity>
</enterprise-beans>
</jaws>
The MarketBean uses a MarketPK which has ID and name
as its properties.
When i try to run the Client instead of inserting the
values into the database why is JBoss doing an UPDATE.
I am sure i am missing something in the configuration
files....
Anyhelp will be much appreciated.
Thanks,-Poorna
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
