1 Reply Latest reply on Jul 26, 2002 6:02 AM by joelvogt

    pointing to unknown database

    sachin_bais

      HI,
      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
      as follows
      JNDI name, i have put like this in xml file
      FlemingDS
      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?
      sachin