I am using JBOSS v3.2.4, Hibernate 2.1.3 and Oracle9i and when my databse query returns an 'ORA-24777: use of non-migratable database link not allowed'.
Basically we have a postcode table that has been set up as a DBLink table to point to a central database. When we try and execute a query against the postcode table we get an ORA-24777 error. Researching into this Oracle provide the follwoing documentation: ORA-24777 use of non-migratable database link not allowed Cause: The transaction, which needs to be migratable between sessions, tried to access a remote database from a non-multithreaded server process. Action: Perform the work in the local database or open a connection to the remote database from the client. If the multithreaded server option is installed, connect to the Oracle instance through the dispatcher. Creating and maintaining seperate connections to different databases is not a valid option at the moment. Therefore, does anyone know how to configure JBOSS to use a migrateable server process as opposed to what appears to be a the current dedicated server process? Thanks, cK View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3851325#3851325 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3851325 ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
