springframework-developer

[Springframework-developer] SQL Error Codes for Sybase

[<jue...@we...>]

Thomas,
=20
Do you have a chance to look at
=20
http://opensource.atlassian.com/projects/spring/browse/SPR-130 =
<http://opensource.atlassian.com/projects/spring/browse/SPR-130>=20
=20
for 1.0.2 (scheduled for the end of this week)?
=20
Juergen

Re: [Springframework-developer] SQL Error Codes for Sybase

[Pierre B. <pb...@gi...>]

Hi J=FCrgen,

SQLErrorCodesFactory uses DatabaseProductName to identify the database.=20
We are using Sybase 11.9.2 and here is an extract of our=20
sql-error-codes.xml:

<bean id=3D"Sybase" class=3D"org.springframework.jdbc.support.SQLErrorCod=
es">
     <property name=3D"databaseProductName"><value>Sybase SQL=20
Server</value></property>
     <property=20
name=3D"badSqlGrammarCodes"><value>101,102,103,104,105,106,107,108,109,11=
0,111,112,113,116,120,121,123,207,208,213,257,512</value></property>
     <property=20
name=3D"dataIntegrityViolationCodes"><value>423,511,515,530,547,2601,2615=
,2714</value></property>
   </bean>

So, I don't think there's any issue with Sybase.

Hope it helps.

Pierre Bittner

j=FCrgen h=F6ller [werk3AT] wrote:
> Thomas,
> =20
> Do you have a chance to look at
> =20
> http://opensource.atlassian.com/projects/spring/browse/SPR-130 <http://=
opensource.atlassian.com/projects/spring/browse/SPR-130>=20
> =20
> for 1.0.2 (scheduled for the end of this week)?
> =20
> Juergen
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: SourceForge.net Broadband
> Sign-up now for SourceForge Broadband and get the fastest
> 6.0/768 connection for only $19.95/mo for the first 3 months!
> http://ads.osdn.com/?ad_id%62&alloc_ida84&op=CCk
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>=20
>=20
>=20

Re: [Springframework-developer] SQL Error Codes for Sybase

[Thomas R. <tho...@tr...>]

Thanks for the error codes Pierre.  I have added them to the 
sql-error-codes.xml that is part of the distribution. 

The lookup problem is solved by adding a "databaseProductName" property 
to the bean - here we allow spaces in the value.

Thomas


Pierre Bittner wrote:

> Hi Jürgen,
>
> SQLErrorCodesFactory uses DatabaseProductName to identify the 
> database. We are using Sybase 11.9.2 and here is an extract of our 
> sql-error-codes.xml:
>
> <bean id="Sybase" class="org.springframework.jdbc.support.SQLErrorCodes">
>     <property name="databaseProductName"><value>Sybase SQL 
> Server</value></property>
>     <property 
> name="badSqlGrammarCodes"><value>101,102,103,104,105,106,107,108,109,110,111,112,113,116,120,121,123,207,208,213,257,512</value></property> 
>
>     <property 
> name="dataIntegrityViolationCodes"><value>423,511,515,530,547,2601,2615,2714</value></property> 
>
>   </bean>
>
> So, I don't think there's any issue with Sybase.
>
> Hope it helps.
>
> Pierre Bittner
>
> jürgen höller [werk3AT] wrote:
>
>> Thomas,
>>  
>> Do you have a chance to look at
>>  
>> http://opensource.atlassian.com/projects/spring/browse/SPR-130 
>> <http://opensource.atlassian.com/projects/spring/browse/SPR-130>  
>> for 1.0.2 (scheduled for the end of this week)?
>>  
>> Juergen
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: SourceForge.net Broadband
>> Sign-up now for SourceForge Broadband and get the fastest
>> 6.0/768 connection for only $19.95/mo for the first 3 months!
>> http://ads.osdn.com/?ad_id%62&alloc_ida84&opÌk
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: SourceForge.net Broadband
> Sign-up now for SourceForge Broadband and get the fastest
> 6.0/768 connection for only $19.95/mo for the first 3 months!
> http://ads.osdn.com/?ad_id%62&alloc_ida84&op=click
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>