JDBC Problem


EJB programming & troubleshooting: JDBC Problem

  1. JDBC Problem (2 messages)

    Please help me in this exception, i could not able to find the problem.

    i am using MSAccess as the database and using "sun.jdbc.odbc.JdbcOdbcDriver" as ODBC Driver.

    Exception: Unexpected exception in com.test.ejb.emp.EmpBean.getEmployeeNumber(): java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188) at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterFloat(JdbcOdbc.java:857) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setFloat(JdbcOdbcPreparedStatement.java:659)


    Threaded Messages (2)

  2. JDBC Problem[ Go to top ]

    I guess ur Driver doesn't support transaction, so while deploying bean u set Transaction not supposed as Transaction property and then redeploy, then it should work

    If u still have problems, let me know

  3. JDBC Problem[ Go to top ]

    hi ,
          i am using oracle jdbc thin driver.could u please send a sample code for connecting to database and querying to database.in this i am using connection pooling pgm.if u want i will send my pgms to u.

    please give ur reply asap

    advance thanks