i have connected webhuddle with mysql its only using one table t_users for authentication user/password etc.
now i need to store some of the data in some other table, i hv created some table my self. how to use the datasource with jdbc to use prepare-statement any other.
have any one done or using plz suggest.
What are you trying to accomplish? Using an external database for authentication doesn't mean you also have to use an external database for all the other WebHuddle data. By default WebHuddle uses it's own database for both.
If can explain what your goal is that would help -- thanks!
i want to insert some of the record like path of recording zip in a table for my other application using webhuddle.
For that whether i need to create a new DataSource in struts-config.xml
and in action file need to use the following code...
String sql="insert into session values("73","xyz","abc");
dataSource = getDataSource(request);
myConnection = dataSource.getConnection();
It will work for insertion of record in table.
thanks for reply.
hello i have created a new DBCP connection in webhuddle in stead of spring connection u provided.
it is working fine and solved my purpose.
thanks for reply
Log in to post a comment.