You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by Mustafa Taşdemir <ta...@bilisim.com.tr> on 2006/02/23 14:29:35 UTC

jdbc type error

Hi,
I am trying to run Jetspeed but when I start Tomcat I get the following error. This error occurs both with Oracle and Derby.
Can somebody help?

Caused by: org.apache.ojb.broker.OJBRuntimeException: Can't assign the specified jdbc field-type 'BIGINT' for field: 
      <field-descriptor 
        name="maxKey"
        column="MAX_KEY"
        jdbc-type="BIGINT"
        access="readwrite"
      />

in class: 
org.apache.ojb.broker.metadata.ClassDescriptor@e29820[
  classNameOfObject=org.apache.ojb.broker.util.sequence.HighLowSequence
  tableName=OJB_HL_SEQ
  schema=<null>
  isInterface=false
  extendClassNames=[]
  {org.apache.ojb.broker.metadata.FieldDescriptor@3afb99[columnName=TABLENAME,columnType=VARCHAR,isPrimaryKey=true,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar@5c3987[jdbcType=12,jdbcTypeString=VARCHAR,associatedFieldType=org.apache.ojb.broker.metadata.FieldTypeClasses$StringFieldType@46b90a[sqlType=12,sqlTypeAsString=VARCHAR,isMutable=false]],super_class_fields ==> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@11e67ac[rootType=class org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=tableName], field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence, custom attributes [null],
],org.apache.ojb.broker.metadata.FieldDescriptor@190ef12[columnName=FIELDNAME,columnType=VARCHAR,isPrimaryKey=true,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar@5c3987[jdbcType=12,jdbcTypeString=VARCHAR,associatedFieldType=org.apache.ojb.broker.metadata.FieldTypeClasses$StringFieldType@46b90a[sqlType=12,sqlTypeAsString=VARCHAR,isMutable=false]],super_class_fields ==> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@3f96ee[rootType=class org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=fieldName], field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence, custom attributes [null],
],org.apache.ojb.broker.metadata.FieldDescriptor@ce16ad[columnName=MAX_KEY,columnType=BIGINT,isPrimaryKey=false,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=<null>,super_class_fields ==> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@32bd65[rootType=class org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=maxKey], field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence, custom attributes [null],
]}
]
 at org.apache.ojb.broker.metadata.FieldDescriptor.lookupJdbcType(FieldDescriptor.java:206)
 at org.apache.ojb.broker.metadata.FieldDescriptor.setColumnType(FieldDescriptor.java:147)
 at org.apache.ojb.broker.metadata.RepositoryXmlHandler.startElement(RepositoryXmlHandler.java:397)
 ... 55 more
Caused by: org.apache.ojb.broker.OJBRuntimeException: The type BIGINT can not be handled by OJB. Please specify only types as defined by java.sql.Types.
 at org.apache.ojb.broker.metadata.JdbcTypesHelper.getJdbcTypeByName(JdbcTypesHelper.java:142)
 at org.apache.ojb.broker.metadata.FieldDescriptor.lookupJdbcType(FieldDescriptor.java:201)
 ... 57 more
2006-02-23 15:10:02,649 [main] INFO  org.apache.jetspeed.engine.JetspeedServlet - Jetspeed Initialization complete, Ready to service requests.

Re: jdbc type error

Posted by ta...@bilisim.com.tr.
Hi Armin,
You are right, it was a localization problem.
My locale was Turkish, I set it to English and problem solved.
Thank you very much
Mustafa


> Hi Mustafa,
>
> I never notice such an issue.
> Maybe it's a localization problem. In method
> JdbcTypesHelper.getJdbcTypeByName OJB use typeName.toLowerCase() to
> convert the specified String to lower case:
> BIGINT --> bigint
> Do you use a specific localization?
>
> regards,
> Armin
>
> Mustafa Taşdemir wrote:
>> Hi,
>> I am trying to run Jetspeed but when I start Tomcat I get the following
>> error. This error occurs both with Oracle and Derby.
>> Can somebody help?
>>
>> Caused by: org.apache.ojb.broker.OJBRuntimeException: Can't assign the
>> specified jdbc field-type 'BIGINT' for field:
>>       <field-descriptor
>>         name="maxKey"
>>         column="MAX_KEY"
>>         jdbc-type="BIGINT"
>>         access="readwrite"
>>       />
>>
>> in class:
>> org.apache.ojb.broker.metadata.ClassDescriptor@e29820[
>>   classNameOfObject=org.apache.ojb.broker.util.sequence.HighLowSequence
>>   tableName=OJB_HL_SEQ
>>   schema=<null>
>>   isInterface=false
>>   extendClassNames=[]
>>   {org.apache.ojb.broker.metadata.FieldDescriptor@3afb99[columnName=TABLENAME,columnType=VARCHAR,isPrimaryKey=true,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar@5c3987[jdbcType=12,jdbcTypeString=VARCHAR,associatedFieldType=org.apache.ojb.broker.metadata.FieldTypeClasses$StringFieldType@46b90a[sqlType=12,sqlTypeAsString=VARCHAR,isMutable=false]],super_class_fields
>> ==>
>> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@11e67ac[rootType=class
>> org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=tableName],
>> field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence,
>> custom attributes [null],
>> ],org.apache.ojb.broker.metadata.FieldDescriptor@190ef12[columnName=FIELDNAME,columnType=VARCHAR,isPrimaryKey=true,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar@5c3987[jdbcType=12,jdbcTypeString=VARCHAR,associatedFieldType=org.apache.ojb.broker.metadata.FieldTypeClasses$StringFieldType@46b90a[sqlType=12,sqlTypeAsString=VARCHAR,isMutable=false]],super_class_fields
>> ==>
>> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@3f96ee[rootType=class
>> org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=fieldName],
>> field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence,
>> custom attributes [null],
>> ],org.apache.ojb.broker.metadata.FieldDescriptor@ce16ad[columnName=MAX_KEY,columnType=BIGINT,isPrimaryKey=false,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=<null>,super_class_fields
>> ==>
>> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@32bd65[rootType=class
>> org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=maxKey],
>> field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence,
>> custom attributes [null],
>> ]}
>> ]
>>  at
>> org.apache.ojb.broker.metadata.FieldDescriptor.lookupJdbcType(FieldDescriptor.java:206)
>>  at
>> org.apache.ojb.broker.metadata.FieldDescriptor.setColumnType(FieldDescriptor.java:147)
>>  at
>> org.apache.ojb.broker.metadata.RepositoryXmlHandler.startElement(RepositoryXmlHandler.java:397)
>>  ... 55 more
>> Caused by: org.apache.ojb.broker.OJBRuntimeException: The type BIGINT
>> can not be handled by OJB. Please specify only types as defined by
>> java.sql.Types.
>>  at
>> org.apache.ojb.broker.metadata.JdbcTypesHelper.getJdbcTypeByName(JdbcTypesHelper.java:142)
>>  at
>> org.apache.ojb.broker.metadata.FieldDescriptor.lookupJdbcType(FieldDescriptor.java:201)
>>  ... 57 more
>> 2006-02-23 15:10:02,649 [main] INFO
>> org.apache.jetspeed.engine.JetspeedServlet - Jetspeed Initialization
>> complete, Ready to service requests.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
>



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Re: jdbc type error

Posted by Armin Waibel <ar...@apache.org>.
Hi Mustafa,

I never notice such an issue.
Maybe it's a localization problem. In method 
JdbcTypesHelper.getJdbcTypeByName OJB use typeName.toLowerCase() to 
convert the specified String to lower case:
BIGINT --> bigint
Do you use a specific localization?

regards,
Armin

Mustafa Taşdemir wrote:
> Hi,
> I am trying to run Jetspeed but when I start Tomcat I get the following error. This error occurs both with Oracle and Derby.
> Can somebody help?
> 
> Caused by: org.apache.ojb.broker.OJBRuntimeException: Can't assign the specified jdbc field-type 'BIGINT' for field: 
>       <field-descriptor 
>         name="maxKey"
>         column="MAX_KEY"
>         jdbc-type="BIGINT"
>         access="readwrite"
>       />
> 
> in class: 
> org.apache.ojb.broker.metadata.ClassDescriptor@e29820[
>   classNameOfObject=org.apache.ojb.broker.util.sequence.HighLowSequence
>   tableName=OJB_HL_SEQ
>   schema=<null>
>   isInterface=false
>   extendClassNames=[]
>   {org.apache.ojb.broker.metadata.FieldDescriptor@3afb99[columnName=TABLENAME,columnType=VARCHAR,isPrimaryKey=true,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar@5c3987[jdbcType=12,jdbcTypeString=VARCHAR,associatedFieldType=org.apache.ojb.broker.metadata.FieldTypeClasses$StringFieldType@46b90a[sqlType=12,sqlTypeAsString=VARCHAR,isMutable=false]],super_class_fields ==> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@11e67ac[rootType=class org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=tableName], field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence, custom attributes [null],
> ],org.apache.ojb.broker.metadata.FieldDescriptor@190ef12[columnName=FIELDNAME,columnType=VARCHAR,isPrimaryKey=true,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar@5c3987[jdbcType=12,jdbcTypeString=VARCHAR,associatedFieldType=org.apache.ojb.broker.metadata.FieldTypeClasses$StringFieldType@46b90a[sqlType=12,sqlTypeAsString=VARCHAR,isMutable=false]],super_class_fields ==> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@3f96ee[rootType=class org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=fieldName], field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence, custom attributes [null],
> ],org.apache.ojb.broker.metadata.FieldDescriptor@ce16ad[columnName=MAX_KEY,columnType=BIGINT,isPrimaryKey=false,isLocking=false,isAutoincrement=false,access=readwrite,sequenceName=<null>,jdbcType=<null>,super_class_fields ==> org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDirectAccessImplNew@32bd65[rootType=class org.apache.ojb.broker.util.sequence.HighLowSequence,fieldName=maxKey], field_belongs_to org.apache.ojb.broker.util.sequence.HighLowSequence, custom attributes [null],
> ]}
> ]
>  at org.apache.ojb.broker.metadata.FieldDescriptor.lookupJdbcType(FieldDescriptor.java:206)
>  at org.apache.ojb.broker.metadata.FieldDescriptor.setColumnType(FieldDescriptor.java:147)
>  at org.apache.ojb.broker.metadata.RepositoryXmlHandler.startElement(RepositoryXmlHandler.java:397)
>  ... 55 more
> Caused by: org.apache.ojb.broker.OJBRuntimeException: The type BIGINT can not be handled by OJB. Please specify only types as defined by java.sql.Types.
>  at org.apache.ojb.broker.metadata.JdbcTypesHelper.getJdbcTypeByName(JdbcTypesHelper.java:142)
>  at org.apache.ojb.broker.metadata.FieldDescriptor.lookupJdbcType(FieldDescriptor.java:201)
>  ... 57 more
> 2006-02-23 15:10:02,649 [main] INFO  org.apache.jetspeed.engine.JetspeedServlet - Jetspeed Initialization complete, Ready to service requests.

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org