[Datasource Configuration] - Jboss6: Unable to get managed connection for jdbc with Spring
by amber jboss1999
amber jboss1999 [http://community.jboss.org/people/amberjboss1999] created the discussion
"Jboss6: Unable to get managed connection for jdbc with Spring"
To view the discussion, visit: http://community.jboss.org/message/603536#603536
--------------------------------------------------------------
I am migrating an exisiting web app (war) from apache tomcat 6 to jboss6.
I keep getting:
DEPLOYMENTS IN ERROR:
Deployment "vdpDS" is in error due to the following reason(s): ** NOT FOUND Depends on '*vdpDS*' **
1./WEB-INF/applicationContext:
<jee:jndi-lookup id="*dataSource*" jndi-name="*java:comp/env/vdpDS*" resource-ref="*true*" expected-type="*javax.sql.DataSource*" />
*2.WEB-INF/web.xml*
<resource-ref>
<res-ref-name>*vdpDS*</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
*3.WEB-INF/jboss-web.xml*
<jboss-web>
<resource-ref>
<res-ref-name>*vdpDS*</res-ref-name>
<jndi-name>*vdpDS*</jndi-name>
</resource-ref>
</jboss-web>
4. i think this is for tomcat, but it's there anyway:
*META-INF/context.xml*
<context>
<ResourceLink global="vdpDS" name="*java:comp/env/vdpDS*" type="javax.sql.DataSource"/>
</context>
5. my *vdpDS*-ds.xml, under deploy/<*vdpDS*> subfolder:
<local-tx-datasource>
<jndi-name>vdpDS</jndi-name>
<driver-class>com.inet.tds.TdsDriver</driver-class>-->
<connection-url>jdbc:jtds:sqlserver://server:port;database=db</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name>user</user-name>
<password>pwd</password>
</local-tx-datasource>
6. I also dropped the jdbc.jar in the lib/<*vdpDS*> subfolder
subfolder, using jtds1.2.3.jar
This setup was working for tomcat6.
Can someone help me solve this datasource not found error, please?
*
*
*
*
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/603536#603536]
Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
13 years
[jBPM] - [JDBCExceptionReporter] Large Objects may not be used in auto-commit mode.
by nick tan
nick tan [http://community.jboss.org/people/missedone] created the discussion
"[JDBCExceptionReporter] Large Objects may not be used in auto-commit mode."
To view the discussion, visit: http://community.jboss.org/message/603311#603311
--------------------------------------------------------------
hi, folks
i'm getting an error about "[JDBCExceptionReporter] Large Objects may not be used in auto-commit mode."
when i use postgresql instead of h2
i modified the source code, and configure it with postgresql
things works fine, but when i open http://localhost:8080/jbpm-console http://localhost:8080/jbpm-console, and click "process -> process overview", no process at all (but in fact, i have uploaded 2 process into guvnor, and build the package, can run with the API)
i went to the terminal and find there is exception: [JDBCExceptionReporter] Large Objects may not be used in auto-commit mode.
(see attached log file for more detail, line: 171)
I googled, and people said “BLOB must be accessed in a transaction when using postgresql”, I’m not really sure how to fix this in jBPM/Drools.
can anyone help? thanks
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/603311#603311]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
13 years
[JNDI and Naming] - Change env-entry-value at runtim
by - -
- - [http://community.jboss.org/people/cchene] created the discussion
"Change env-entry-value at runtim"
To view the discussion, visit: http://community.jboss.org/message/603666#603666
--------------------------------------------------------------
Hello
I would like a part of my webapp configuration to be server-dependant, meaning I want to have a different value when deploying in my jboss dev instance and in the production environment. And I would like not to repackage the development WAR before deploying in production env, nor would I like to restart the server to take some config file into account.
I guessed that JNDI could help (but I may be wrong, any comment will be much appreciated...)
But there is no way I can found to edit at runtime the env-entry that I've added to my web.xml file.
I was able to do this with Tomcat using the "admin tool" (I could see the set of env-entries of my web.xml in the "Resources / Environment entries" section).
Here is my web.xml file:
<web-app id="JndiVarUse">
<!-- some servlet and servlet mapping definitions -->
<env-entry>
<env-entry-name>message</env-entry-name>
<env-entry-value>Message from web.xml</env-entry-value>
<env-entry-type>java.lang.String</env-entry-type>
</env-entry>
</web-app>
By the way, here is another question: how come I can't see the env-entry in the JMX JNDIView with JBoss 5.1 whereas it could be seen with JBoss 4.2.3 ?
Thanks for the help !
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/603666#603666]
Start a new discussion in JNDI and Naming at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
13 years
