Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How do I change the database for executeSqlStatement

Not applicable
Hi



I am trying to use an executeSqlStatement in my process flow, which saves my submitted forms data by inserting it into a database.

My question is, how can i change the database that workbench is pointed at from adobe, to my own DB, or if it is possible at all?

I have tried changing the database pointers in adobe-ds.xml and mysql-ds.xml, but that has only succeeded in breaking my livecycle workbench:/



I have had no luck trying to find a solution, so some clarification would be greatly appreciated!

Thanks

Ross Malan
2 Replies
Jasmin_Charbonn
Level 10
Level 10
The executeSqlStatement uses the data source you specify in the data source name. The format is java:/datasource_name.



Now how to setup that data source depends on the application server you are using.



In JBoss, like you mentioned, you need to configure a *-ds.xml file to contain the data source information. You can edit one that already exists or create a new file as long as the file name ends with -ds.xml.



Don't change the data source that are alreay setup. Just add new ones.



At this point this is strictly JBoss configuration. It has nothing to do with LiveCycle.



Jasmin
Not applicable
I will give that a try. Thanks for the help Jasmin