Bug 780352 (SOA-2762)

Summary: Unable to get managed connection for ModeShapeDS
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Pavol Srna <psrna>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED WORKSFORME QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER6CC: psrna, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2762
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
JBDS 4.0.0.beta2, Jboss SOA 5.1.0.ER6, linux 32bit
Last Closed: 2011-01-11 17:42:07 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
server.log
none
modeshape-jdbc-ds.xml none

Description Pavol Srna 2011-01-11 10:08:14 UTC 
Steps to Reproduce: 1) In JBDS create new Teiid Connection Profile
2) Type "ModeShape" in VDB Name text field and fill in all necessary login informations
3) Open  SQL Scrapbook and execute simple query: "select * from nt_base" 
project_key: SOA

Error Code:0 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:0 Message:Error Code:0 Message:Unable to get managed connection for ModeShapeDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for ModeShapeDS)
Comment 1 Van Halbert 2011-01-11 13:37:41 UTC 
Can you run the teiid simpleclient example:

- ./run.sh localhost 31000 ModeShape "select * from nt_base"

This is essentially running the same thing, but not thru JBDS.   If it doesn't work, can you use JOPR and confirm ModeShapeDS datasource is valid.

Also,  I just opened JBDS and did your steps and got results back.
Comment 2 Van Halbert 2011-01-11 15:18:01 UTC 
The problem was not reproducible by myself or the Paul Nittel (QE).   We were both able to query the server and return results via JDBS (SQL Scrapbook).
Comment 3 Pavol Srna 2011-01-11 15:49:52 UTC 
I get the exception also by running the simpleclient example. When looking into admin console the ModeShapeDS seems to be ok. 
Please have a look at the log attached.
Comment 4 Pavol Srna 2011-01-11 15:49:52 UTC 
Attachment: Added: server.log
Comment 5 Van Halbert 2011-01-11 16:24:20 UTC 
Can i get you to attach the modeshape-jdbc-ds.xml from your server?
Comment 6 Pavol Srna 2011-01-11 16:30:36 UTC 
Attachment: Added: modeshape-jdbc-ds.xml
Comment 7 Van Halbert 2011-01-11 16:46:17 UTC 
Ok, we need to start back from scratch and see where something went wrong.

Can you install a new server, and install eds, (do nothing else to any file, other than enable users), then try to simpleclient or the jbds query and see what happens (cause nothing else should be required in order to query modeshape).    And from the installation, what profile are u using?
Comment 8 Pavol Srna 2011-01-11 16:53:51 UTC 
I am using the default profile. Will try from scratch now and let you then know.
Comment 9 Pavol Srna 2011-01-11 17:41:26 UTC 
Well I didn't expect that it will work, because I always try on clean install before reporting an issue. I have a special folder where I keep all pre-installed builds . Then I copy from "clean" to "working" folder. As I can see now, my clean install is corrupt. Anyway thanks for your time it is ok now and I will close the issue.