Posted by karthik Jayaraman on
URL: https://discuss.orbeon.com/Form-populate-with-data-from-sql-tp1678998p1680096.html

Thanks for your help !! I have a DB named orbeang3 and it contains tables

1. orbeon_form_data
2. orbeon_form_data_attach
3. orbeon_form_definition
4. orbeon_form_definition_attach

It is the table used by orbeon. I have created another table in this DB named employee, contains first-name and last-name fields.

In my tomcat server's conf/server.xml i have included the lines to access my datasource which s as follows


<Resource name="mysql" auth="Container" type="javax.sql.DataSource"
 username="root"
 password="root"
 driverClassName="com.mysql.jdbc.Driver"
 url="jdbc:mysql://localhost:3306/orbeong3"
 maxActive="15"
 maxIdle="7"  />


and i configured database service and action as given in the screenshot. But if i enter the first-name and click last-name loading symbol appears and nothing happen after that.

PLS HELP ME ...

-------------------------------------UPDATE--------------------------------------------

I have checked orbeon log and it says

" Name mysql is not bound in this Context" error . I cant figure out what's wrong

------------------------------------UPDATE 2-------------------------------------------

And now i am gettin this excption after writing my datasource details in web.xml of tomcat



java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getDriver(DriverManager.java:243)


Please any one help me soon