Hello Vicky
The following is the trace from the jboss server.log.
In the first part of the log you can see that I issue a sql query(Select) direct to the database via the ifxjdbc driver.
But in the second part of the log I use JNDI to get a connection and then I execute the same query command but I get the Transaction not support error. It looks as if I can connect to the database but I can issue sql commands. Maybe JBoss is issuing extra commands not supported by the database. Any ideas would be much appreciated.
2002-11-12 11:14:22,686 INFO [STDOUT] Got Driver class
2002-11-12 11:14:22,788 INFO [STDOUT] Now Loading database driver
2002-11-12 11:14:25,116 INFO [STDOUT] Connected to Database
2002-11-12 11:14:25,122 INFO [STDOUT] Getting query
2002-11-12 11:14:25,490 INFO [STDOUT] Got query
2002-11-12 11:14:25,515 INFO [STDOUT] executed query
2002-11-12 11:14:25,520 INFO [STDOUT] in displayresultset
2002-11-12 11:14:25,630 INFO [STDOUT] in displayresultset creating table
2002-11-12 11:14:25,635 INFO [STDOUT] in get details got resultset
**************************************************
2002-11-12 11:15:08,163 INFO [STDOUT] Got Initial Context
2002-11-12 11:15:08,172 INFO [STDOUT] Got DataSource via JNDI
2002-11-12 11:15:08,338 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807
2002-11-12 11:15:08,340 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] internalRegisterPool: about to notify thread: old next: 1037100158339, new next: 1037100158339
2002-11-12 11:15:08,341 DEBUG [org.jboss.resource.connectionmanager.IdleRemover] run: IdleRemover notifying pools, interval: 450000
2002-11-12 11:15:08,362 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Using properties: {user=informix, password=informix}
2002-11-12 11:15:08,362 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Checking driver for URL: jdbc:informix-sqli://223.0.1.16:1536/WEB_DBS/roadload:INFORMIXSERVER=icarus_se
2002-11-12 11:15:08,365 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver already registered for url: jdbc:informix-sqli://223.0.1.16:1536/WEB_DBS/roadload:INFORMIXSERVER=icarus_se
2002-11-12 11:15:09,163 INFO [STDOUT] Got connection from DataSource via JNDI
2002-11-12 11:15:09,169 INFO [STDOUT] Connected to Database
2002-11-12 11:15:09,173 INFO [STDOUT] Getting query
2002-11-12 11:15:09,256 INFO [STDOUT] Got query
2002-11-12 11:15:09,340 INFO [STDOUT] in get details Sql Exception
2002-11-12 11:15:09,345 INFO [STDOUT] Transactions not supported
2002-11-12 11:15:09,351 ERROR [STDERR] java.sql.SQLException: Transactions not supported
2002-11-12 11:15:09,487 ERROR [STDERR] at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java)
2002-11-12 11:15:09,492 ERROR [STDERR] at com.informix.jdbc.IfxSqliConnect.setAutoCommit(IfxSqliConnect.java)
2002-11-12 11:15:09,503 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.checkTransaction(LocalManagedConnection.java:426)
2002-11-12 11:15:09,508 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalConnection.checkTransaction(LocalConnection.java:756)
2002-11-12 11:15:09,513 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalStatement.checkTransaction(LocalStatement.java:771)
2002-11-12 11:15:09,518 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeQuery(LocalPreparedStatement.java:286)
2002-11-12 11:15:09,523 ERROR [STDERR] at Msgdbs3.getTableDetails(Msgdbs3.java:249)
2002-11-12 11:15:09,528 ERROR [STDERR] at Msgdbs3.SendHtml(Msgdbs3.java:60)
2002-11-12 11:15:09,532 ERROR [STDERR] at Msgdbs3.doGet(Msgdbs3.java:47)
2002-11-12 11:15:09,538 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
2002-11-12 11:15:09,543 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
2002-11-12 11:15:09,548 ERROR [STDERR] at org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:446)
2002-11-12 11:15:09,549 ERROR [STDERR] at org.apache.catalina.servlets.InvokerServlet.doGet(InvokerServlet.java:180)
2002-11-12 11:15:09,550 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
2002-11-12 11:15:09,551 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
2002-11-12 11:15:09,551 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
2002-11-12 11:15:09,552 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
2002-11-12 11:15:09,553 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
2002-11-12 11:15:09,554 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
2002-11-12 11:15:09,555 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
2002-11-12 11:15:09,556 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
2002-11-12 11:15:09,557 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
2002-11-12 11:15:09,557 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
2002-11-12 11:15:09,558 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
2002-11-12 11:15:09,559 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
2002-11-12 11:15:09,560 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
2002-11-12 11:15:09,569 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
2002-11-12 11:15:09,574 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
2002-11-12 11:15:09,580 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
2002-11-12 11:15:09,584 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
2002-11-12 11:15:09,589 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
2002-11-12 11:15:09,590 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
2002-11-12 11:15:09,591 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
2002-11-12 11:15:09,592 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
2002-11-12 11:15:09,593 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
2002-11-12 11:15:09,593 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
2002-11-12 11:15:09,594 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
2002-11-12 11:15:09,595 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
2002-11-12 11:15:09,601 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
2002-11-12 11:15:09,601 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
2002-11-12 11:15:09,602 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
2002-11-12 11:15:09,603 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
2002-11-12 11:15:09,604 ERROR [STDERR] at org.apache.catalina.connector.warp.WarpRequestHandler.handle(WarpRequestHandler.java:217)
2002-11-12 11:15:09,605 ERROR [STDERR] at org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:194)
2002-11-12 11:15:09,605 ERROR [STDERR] at java.lang.Thread.run(Thread.java:479)