I have tried to test the JDBC Auto-Increment feature in eForm 5.0.1
Tested JDBC Lookup, works fine.
but after create a form template, place a field, click on the cell, select 'value', select 'Auto-Increment' using 'JDBC'.
Defined JDBC Connection as did in the JDBC Lookup:
Connection string: jdbc:microsoft:sqlserver://hqdemo1;DatabaseName=CDB
Driver class file: com.microsoft.jdbc.sqlserver.SQLServerDriver
then set the SQL as the follwing:
update FormNumberTable set NextFormNumber =
NextFormNumber + 1;
Select NextFormNumber from FormNumberTable;
After saving the template, test it in the 'Test Mode', however, when I try to 'Assign Next Value', got the following error:
JDBC connections can not be tested in this application
I have double checked the database name, table, and data field name, they are correct, and performs well in Lookup feature.
Anyone has had this kind of prob before???
Any clues , hints are appreciated.
Thanks in advance
This topic has been locked.
5 replies Latest Post - 2009-11-10T08:06:52Z by HannahCH
Pinned topic JDBC Auto-Increment Error: JDBC connections can not be tested in this app
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-11-10T08:06:52Z at 2009-11-10T08:06:52Z by HannahCH
SystemAdmin 110000D4XK53 PostsACCEPTED ANSWER
Re: JDBC Auto-Increment Error: JDBC connections can not be tested in this app2009-11-06T15:26:32Z in response to HannahCHTry:
1. Try Auto-increment using ODBC;
2. On eForms Designer workstation define the ODBC in order to test this from designer
3. On AE server configure in FileNet/Config/AE/eforms-preferences.xml file the ODBC like:
<preferences> <sql> <connection dsn= "<ODBC_NAME>" driver= "" user= "" password= "" url= ""> </connection> </sql> </preferences>
Re: JDBC Auto-Increment Error: JDBC connections can not be tested in this app2009-11-09T02:02:55Z in response to HannahCHThanks cmocanu .
I would like to try the ODBC one later.
However, I am still wondering why the JDBC does not work. Did I miss any prerequisite works???
Still bothers me a lot. Appreciate any points.
Thanks a lot.
Re: JDBC Auto-Increment Error: JDBC connections can not be tested in this app2009-11-09T03:25:17Z in response to HannahCHI found that JDBC connections cannot be tested in the eForms Designer test mode, the template must be deployed to a properly configured Filenet P8 system.
I have checked the template in to workplace, and test it in the workplace, no Numerical value has been automatically assigned to the field, no error message showed.
SystemAdmin 110000D4XK53 Posts
Re: JDBC Auto-Increment Error: JDBC connections can not be tested in this app2009-11-10T08:06:52Z in response to SystemAdminHi cmocanu
my prob has been fixed.
the root cause is the SQL statement issue.
add 'where'condition clause to both 'update' and 'select' statements,
and delete ';' after the 'select' statement,
if placing ';' after the 'select' statement, will get a 'ChainedException' error when testing it.
update FormNumberTable set NextFormNumber =NextFormNumber + 1 where ID = 1;
Select NextFormNumber from FormNumberTable where ID = 1
Hope it helps.