[jira] Closed: (JUDDI-311) Datatype for j3_auth_token.authorized_name should match j3_publisher.authorized_name

["Kurt T Stam (JIRA)" <ju...@ws.apache.org>]

     [ https://issues.apache.org/jira/browse/JUDDI-311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kurt T Stam closed JUDDI-311.
-----------------------------

    Resolution: Fixed

Increased the length to 255.

> Datatype for j3_auth_token.authorized_name should match j3_publisher.authorized_name
> ------------------------------------------------------------------------------------
>
>                 Key: JUDDI-311
>                 URL: https://issues.apache.org/jira/browse/JUDDI-311
>             Project: jUDDI
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.0
>            Reporter: Bryan Pendleton
>            Assignee: Kurt T Stam
>            Priority: Minor
>             Fix For: 3.0.1
>
>
> I found that the column AUTHORIZED_NAME in the "j3_publisher" table is
> defined to be 255 characters long, which seems plenty long, but the
> related column AUTHORIZED_NAME in the "j3_auth_token" table is only
> defined to be 20 characters long.
> This means that if I send the following request to the security service,
> I get an internal error and a stacktrace in the server console.
> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
>                   xmlns:urn="urn:uddi-org:api_v3">
>    <soapenv:Header/>
>    <soapenv:Body>
>       <urn:get_authToken userID="SomeExtremelyLongUserIDWhichExceeds20Characters" cred="xxx"/>
>    </soapenv:Body>
> </soapenv:Envelope>
> The internal error reads:
> Caused by: java.sql.SQLDataException: A truncation error was encountered trying
> to shrink VARCHAR 'SomeExtremelyLongUserIDWhichExceeds20Characters' to length 20.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
>         at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
>         at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
>         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
>         ... 46 more 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.