My entity bean is pointing to SQL server 7.0
I have configured jndi name for database in jboss.xml file
thru resource-ref attribute.
also i have updated mssql-service.xml file
JNDI name, i have put like this in xml file
Also other configuration is as follows:
<config-property name="ConnectionURL" type="java.lang.String">jdbc:odbc:FlemingDS</config-property>
<config-property name="DriverClass" type="java.lang.String">sun.jdbc.odbc.JdbcOdbcDriver</config-property>
here FlemingDS is my DSN name
I am able to look up the bean
I am calling the create method and trying to insert a record
It is successfully coming out of the method
But i am not seeing any data in database
Where is my data gone??
When i againg try to insert the same record, it says, Duplicate key violation.....
One more thing my SQL server is on the different system than application server....
Please can any one help me out to find out the data?
chances are it is going to the /jboss/db/hypersonic.
Check in here