title: Cannot Execute Stored Procedure using JDBC
body: <p>I use sybase database and am trying to update some values into the database.</p>
  
  <p>While trying to run this it throws an exception as :
  com.sybase.jdbc2.jdbc.SybSQLException: The identifier that starts with 'WeeklyStudentEventClassArchiv' is too long. Maximum length is 30.</p>
  
  <p>This table is in another database and thus i have to use the database name along with the table name as dhown below:
  StudActive..WeeklyStudentEventClassArchiv which apparently exceeds 30 characters.</p>
  
  <p>I have to use the databasename..tablename in the stored procudure but its throwing an exception.</p>
  
  <p>This happens even if i physically embed the sql in the java code.</p>
  
  <p>How can this be solved.</p>
  
  <pre><code>The Stored Procedue is as shown:
  create proc dbo.sp_getStudentList(
  @stDate int,
  @endDate int
  )
  as
  begin
  set nocount on
  
        select distinct studCode
        StudActive..WeeklyStudentEventClassArchive      
        where studCode &gt; 0
        and courseStartDate between @stDate and @endDate 
  
  
  
  end
  </code></pre>