Topic
  • 3 replies
  • Latest Post - ‏2012-11-07T11:58:09Z by SystemAdmin
jmblaise
jmblaise
21 Posts

Pinned topic java.sql.SQLException: JZ0SA

‏2012-06-22T13:14:22Z |
Hi,

I am trying to use IDMT b2119 and I get this when connecting to Sybase: "no user schema found in database" ( so no "dbo") and console stack trace is:

http://2012-06-22 15.13.32.119 Database Major Version :15
http://2012-06-22 15.13.32.119 Database Minor Version :5
java.sql.SQLException: JZ0SA: Instruction prÚparÚe : paramÞtre d'entrÚe non conf
igurÚ, index : 0.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.tds.TdsParam.prepareForSend(Unknown Source)
at com.sybase.jdbc3.jdbc.ParamManager.checkParams(Unknown Source)
at com.sybase.jdbc3.tds.Tds.rpc(Unknown Source)
at com.sybase.jdbc3.jdbc.SybCallableStatement.sendRpc(Unknown Source)
at com.sybase.jdbc3.jdbc.SybCallableStatement.executeQuery(Unknown Sourc
e)
at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.if(Unknown Source)
at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getSchemas(Unknown Source)
at ibm.IBMExtractUtilities.GetSchemaList(IBMExtractUtilities.java:2120)
at ibm.StateExtractTab.actionPerformed(StateExtractTab.java:878)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour
ce)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Do you have any idea ?

Thanks,
JMB
Updated on 2012-11-07T11:58:09Z at 2012-11-07T11:58:09Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: java.sql.SQLException: JZ0SA

    ‏2012-10-23T10:56:39Z  
    Hi,

    We are facing the same issue with the error "no user schema found in database".

    The version of Sybase is 15.0.3 and IDMT is the latest version, 2.00-b2124.

    We are trying to replicate the issue but without success.

    @jmblaise, do you find out what your issue was?

    Thanks in advance,
    Kind Regards,
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: java.sql.SQLException: JZ0SA

    ‏2012-10-23T13:14:53Z  
    Hi,

    We are facing the same issue with the error "no user schema found in database".

    The version of Sybase is 15.0.3 and IDMT is the latest version, 2.00-b2124.

    We are trying to replicate the issue but without success.

    @jmblaise, do you find out what your issue was?

    Thanks in advance,
    Kind Regards,
    You can look list of schema that we exclude in SchemaExcludeList.properties, which is in tool's jar file. Open JAR in winzip and look this file.
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: java.sql.SQLException: JZ0SA

    ‏2012-11-07T11:58:09Z  
    You can look list of schema that we exclude in SchemaExcludeList.properties, which is in tool's jar file. Open JAR in winzip and look this file.
    Hi,

    Thanks, I had a look at that file, but we are able to see the schemas... in a customer test he is facing that issue and we are trying to reproduce that error, so we are trying to understand where it comes from, if it's the jdbc jar file, the stored procedures on sybase server, or what...

    It would be very useful to have more information on how this error was solved and also how internally IDMT connects to a Sybase database...

    Thanks :)