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

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
    ACCEPTED ANSWER

    Re: java.sql.SQLException: JZ0SA

    ‏2012-10-23T10:56:39Z  in response to jmblaise
    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
      ACCEPTED ANSWER

      Re: java.sql.SQLException: JZ0SA

      ‏2012-10-23T13:14:53Z  in response to SystemAdmin
      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
        ACCEPTED ANSWER

        Re: java.sql.SQLException: JZ0SA

        ‏2012-11-07T11:58:09Z  in response to SystemAdmin
        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 :)