Bug 780352 (SOA-2762) - Unable to get managed connection for ModeShapeDS
Summary: Unable to get managed connection for ModeShapeDS
Keywords:
Status: CLOSED WORKSFORME
Alias: SOA-2762
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.1.0.ER6
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-11 10:08 UTC by Pavol Srna
Modified: 2011-01-11 17:42 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
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

Attachments (Terms of Use)
server.log (252.86 KB, text/x-log)
2011-01-11 15:49 UTC, Pavol Srna 		no flags Details
modeshape-jdbc-ds.xml (1.15 KB, text/xml)
2011-01-11 16:30 UTC, Pavol Srna 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-2762 0 None Closed Unable to get managed connection for ModeShapeDS 2012-02-23 01:02:56 UTC

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.
Note You need to log in before you can comment on or make changes to this bug.