I am getting these errors when i tried to test the datasource that i created for connecting to an informix database.
It shows like java.sql.SQLException: Syntax disallowed in this database server.
Help me. Please.
at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:1012)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:233)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:86)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:167)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:217)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.console.resources.jdbc.WAS40DataSourceCollectionAction.execute(WAS40DataSourceCollectionAction.java:171)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
[4/10/06 11:15:08:357 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R Caused by: java.sql.SQLException
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R ... 57 more
[4/10/06 11:15:08:367 EDT] 0000003e SystemErr R java.sql.SQLException: Syntax disallowed in this database server.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269)
at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2157)
at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2132)
at com.informix.jdbc.IfxResultSet.b(IfxResultSet.java:378)
at com.informix.jdbc.IfxStatement.a(IfxStatement.java:1299)
at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:1269)
at com.informix.jdbc.IfxStatement.c(IfxStatement.java:989)
at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:875)
at com.informix.jdbc.IfxSqliConnect.resetDatabaseProperties(IfxSqliConnect.java:1575)
at com.informix.jdbcx.IfxSqliConnReUsableConnection.close(IfxSqliConnReUsableConnection.java:119)
at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:528)
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:456)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1366)
at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:1012)
at mx4j.server.interceptor.InvokerMBeanServerInterceptor.invoke(InvokerMBeanServerInterceptor.java:233)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.SecurityMBeanServerInterceptor.invoke(SecurityMBeanServerInterceptor.java:86)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:128)
at mx4j.server.interceptor.ContextClassLoaderMBeanServerInterceptor.invoke(ContextClassLoaderMBeanServerInterceptor.java:167)
at mx4j.server.MX4JMBeanServer.invoke(MX4JMBeanServer.java:1249)
at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:217)
at com.ibm.ws.console.resources.jdbc.WAS40DataSourceCollectionAction.execute(WAS40DataSourceCollectionAction.java:171)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
at
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:901)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java(Compiled Code))
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:817)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:217)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.console.resources.jdbc.WAS40DataSourceCollectionAction.execute(WAS40DataSourceCollectionAction.java:171)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:275)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:528)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:80)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1657)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:548)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:601)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:934)
[4/10/06 11:15:08:387 EDT] 0000003e SystemErr R at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1021)
[4/10/06 11:15:08:397 EDT] 0000003e SystemErr R at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1332)
[4/10/06 11:15:08:397 EDT] 0000003e SystemErr R Caused by: java.sql.SQLException
[4/10/06 11:15:08:397 EDT] 0000003e SystemErr R at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
[4/10/06 11:15:08:397 EDT] 0000003e SystemErr R at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)
[4/10/06 11:15:08:397 EDT] 0000003e SystemErr R ... 57 more