Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I have Problem with ISAM I get connection but I can not see the Tabes and only I can use sample sele

f79be486-7864-492f-b365-ef2f370d7ed7May 21 2019 — edited May 22 2019

hey all,

that problem came just with JDBC driver, with ODBC I can see everything. has someone an Idea

log file :

DriverManager.getConnection("jdbc:informix-sqli://informixserver:1521//usr/projects/dbs/f0001:INFORMIXSERVER=informixse;user=user;password=passwd;APPENDISAM=1;IFX_SET_FLOAT_AS_SMFLOAT=1;TRUSTED_CONTEXT=1;IFX_ISOLATION_LEVEL=8U;sslConnection=1;SQLIDEBUG=c:\PoliboyTemp\sqlidebug_informix.trace")

trying com.mysql.cj.jdbc.Driver

trying com.informix.jdbc.IfxDriver

SQLWarning: reason(Umwandlung von Datentyp FLOAT in DECIMAL verwendet) SQLState(01I05)

getConnection returning com.informix.jdbc.IfxDriver

SQLState(42000) vendor code(-201)

java.sql.SQLSyntaxErrorException: A syntax error has occurred.

at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:465)

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443)

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394)

at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3191)

at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3472)

at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2379)

at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2304)

at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1522)

at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1502)

at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:218)

at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1054)

at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:227)

at Drivers.InformixConnection.GetConnection(InformixConnection.java:57)

at Views.User.Login.formWindowOpened(Login.java:414)

at Views.User.Login.access$100(Login.java:45)

at Views.User.Login$1.windowOpened(Login.java:118)

at java.desktop/java.awt.Window.processWindowEvent(Window.java:2065)

at java.desktop/javax.swing.JFrame.processWindowEvent(JFrame.java:298)

at java.desktop/java.awt.Window.processEvent(Window.java:2027)

at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5008)

at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)

at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2762)

at java.desktop/java.awt.Component.dispatchEvent(Component.java:4840)

at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)

at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)

at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)

at java.base/java.security.AccessController.doPrivileged(AccessController.java:389)

at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)

at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)

at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)

at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)

at java.base/java.security.AccessController.doPrivileged(AccessController.java:389)

at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)

at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)

at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)

at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)

at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)

at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)

at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)

SQLState(00000) vendor code(0)

java.sql.SQLException

at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:474)

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443)

at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394)

at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3477)