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

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Query MS Access Database


Level 4

OK - I have a customer that wants to write out to an MS Access Database from Livecycle.  I know this is BAD but they have their reasons - i.e. they have a sever shortage of skills for anything more complex.

Firstly - I created a Java program to test the JDBC ODBC connection - this worked fine - ran queries and updated OK (code is attached)

Howver I have tried connecting to Access from within Livecycle in two different ways - both are failing

Firstly - using the JNDI setup for JDBC ODBC e.g.

    <!-- format of URL is "jdbc:odbc:DSNNAME" -->


Calling this within a Livecycle process does not return an error to the process, but the log generates an error:

2009-08-29 23:01:30,768 WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: General error)

I also tried creating a Java Component and importing it - by creating a very basic jar and importing it to livecycle (based on the same code I used in my Java testing)

It also gave me the general error - and I can see it is happening on the line:

        Connection con = DriverManager.getConnection(dbURL, "","");

Any ideas on what is going wrong, or a workaround?  (Assuming that I have to use Access)



0 Replies


Level 4

Can you post the complete stacktrace when you tried using a custom DSC. Use err.printStackTrace in your


Level 4

Sure - Stack trace attached (from Custom Component)

Does this shed any light??


Level 4

Cannot make much from the stacktrace.

  • Is the Access and JBoss are running on same system
  • If yes then under same user account


Level 4

Access and JBoss are both running on the same server

The ODBC connection to Access is setup as a System DSN - which is supposed to be accessible to all users including NT Services.

Is there same way that JBoss wouldn't have access to the System DSN???


Level 4

OK I solved this.  This was only happening on the Win2K3 server - not on my local dev instance

On the server I set the JBoss service to run under the local admin account (in the Services Panel) - after a service restart the jdbc odbc connection worked fine.  It must have been some permissions with the system account

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now