sybase « Database « Spring Q&A





1. BeanPropertySqlParameterSource and Doubles    stackoverflow.com

Have a table and a sproc setup in Sybase as follows: create table testtab (f float)

create proc insert_testtab @f float as insert testtab values(@f) And a java object that holds a Double

class TestObj ...

2. SimpleJdbcCall: get result of Microsoft/Sybase stored procedure call    stackoverflow.com

I've a Microsoft and Sybase stored procedures that return result as "return @value". I need to read the value from Java via SimpleJdbcCall. Is it possible?

3. Problem mapping timestamp column in sybase through ibatis 2.3 to a POJO    stackoverflow.com

I am using ibatis 2.3and sybase 15.0.3 with spring 3 and jconn2-5.5 I tried to map a timestamp column [ varbinary (8)] with byte array in my POJO. I received the ...

4. How to call stored procedures in Sybase correctly    stackoverflow.com

I'm trying to call some legacy stored procedures on a Sybase Database (ASE 15) using Spring JDBC. I've got it working pretty good but I can't figure out how to get ...

5. Problem mapping timestamp column in sybase through ibatis 2.3 to a POJO    forum.springsource.org

Problem mapping timestamp column in sybase through ibatis 2.3 to a POJO 0 down vote favorite Hi all, I am using ibatis 2.3and sybase 15.0.3 with spring 3 and jconn2-5.5 I ...

6. MessageStore SQL needs tweaks for Sybase 12.5    forum.springsource.org

MessageStore SQL needs tweaks for Sybase 12.5 I had some issues with the "org.springframework.integration.jdbc/schema-sybase.sql" file for Sybase 12.5. The file contains this: Code: CREATE TABLE INT_MESSAGE ( MESSAGE_ID CHAR(36) NOT NULL ...

7. Spring 2.5 / SYBASE / Connection Issue    forum.springsource.org

I have created a Spring 2.5 MVC Web Application. The application connects to a SYBASE database using the JDBCTemplate. The SYBASE system keep reporting that a connection from the application keeps ...

8. Strange Sybase Stored Procedure Parameter Issue    forum.springsource.org

Strange Sybase Stored Procedure Parameter Issue Hi All, I am stuck and Your quick help will be much apprecaited !!! I am getting the following exceptions while executing the code below. ...

9. schema-sybase.sql and 2k page size    forum.springsource.org

I have a problem executing schema-sybase.sql, to setup the tables Spring Batch needs, with an instance of Sybase configured with a 2k page size. For instance trying to create BATCH_JOB_EXECUTION Warning: ...





10. Sybase stored procedure resultset problem    forum.springsource.org

Sybase stored procedure resultset problem Am having problems returning a resultset from a Sybase stored procedure when the results from a query are inserted into either a fixed table or a ...

11. Exception while calling stored procedure in sybase    forum.springsource.org

Exception while calling stored procedure in sybase I am trying to call a stored procedure of Sybase whihc returns a result set . But i get the following exception org.springframework.jdbc.UncategorizedSQLException : ...

12. StoredProcedure and output parameter (Sybase)    forum.springsource.org

Hi, I'm trying to read the value of a output parameter for a Sybase stored procedure. What should i do to have this job done? See below the example for such ...

13. StoredProcedure and return values (Sybase)    forum.springsource.org

I have a simple Stored Procedure in Sybase : create proc GetDestinationList AS SELECT ex.ExchangeID, ex.Name FROM Exchanges ex ORDER BY ex.Name RETURN 0 ; How can I get the return ...

14. Sybase and BLOB storing    forum.springsource.org

Sybase and BLOB storing Hi all, Isn't this a easier solution that one provided in imagedb sample? Also pls let me know if you think this is not a correct soln. ...

15. DataSourceTransactionManager on Sybase (Unchained mode)    forum.springsource.org

DataSourceTransactionManager on Sybase (Unchained mode) I would like to call multiple stored procedures inside a single transaction from my Java code. However, all the stored procedures are written exclusively for "unchained ...

16. Problem with running stored procedures on Sybase 12.5 using jConnect 6.0    forum.springsource.org

Problem with running stored procedures on Sybase 12.5 using jConnect 6.0 Hi, We have found that the ColumnMapRowMapper class is returning the column name as opposed to the column label when ...





17. Sybase 12.5 dialect required    forum.springsource.org

Where can i get the dialect for Sybase ASE 12.5. hibrnate 2.1 hs it till 11.9 version of Sybase only. Anyone out there if has used Sybase kindly tell me what ...

18. Using SQLExceptionTranslator on Sybase    forum.springsource.org

Using SQLExceptionTranslator on Sybase Hi, I am using the SQLExceptionTranslator interface to parse my SQLException. In Sybase when the database is not available I get an Error Code 0 and SQL ...

19. imagedb sample connecting to Sybase - problems    forum.springsource.org

Mar 9th, 2006, 12:06 PM #1 wethogs View Profile View Forum Posts Junior Member Join Date Mar 2006 Location Stirling Scotland Posts 1 imagedb sample connecting to Sybase - problems Hi: ...

20. Inserting a Sybase Image through a Stored Procedure    forum.springsource.org

Inserting a Sybase Image through a Stored Procedure Hi, Id like to know if anybody has been able to insert a Sybase Image (or maybe as a BLOB or as a ...

21. Sybase database connectivity error.    forum.springsource.org

Sybase database connectivity error. Trying to connect to Sybase server (version:12.5.3), using jconn2.jar. I get the following error when trying to establish connection [/COLOR][/SIZE]08/09/06 09:44:58 WARN [main] SQLErrorCodesFactory:232 - Error while ...

22. Spring with quartz Failed to obtain DB connection from data source using Sybase DB    forum.springsource.org

I am using the spring with quartz and Sybase DB. I am trying to configure quartz using the Spring SchedulerFactoryBean. Same configuration works fine with Mysql Database but giveing error for ...

23. Sybase and GeneratedKeyHolder    forum.springsource.org

Sybase and GeneratedKeyHolder Hello, I am working with sybase database and need to get primary key of newly inserted record. It would be nice if I didn't have to make another ...

24. How to load the output data of stored procedure into a table in SYBASE?    forum.springsource.org

Hi, I have a stored proceure written in Sybase database. When I run the procedure, it outputs 161 rows. Now, I want to load/insert this rows into a table, by writing ...

25. Calling Stored Procedure and reading return status - Sybase    forum.springsource.org

Calling Stored Procedure and reading return status - Sybase I have a sybase legacy procedure that I call to perform update. This procedure has more than 40 input parameters, there is ...

26. Problem with executing Sybase stored procedure    forum.springsource.org

Dec 21st, 2007, 04:04 PM #1 e3aa3b View Profile View Forum Posts Private Message Junior Member Join Date Dec 2007 Posts 15 Problem with executing Sybase stored procedure Hi, I am ...

27. Use a repository Sybase    forum.springsource.org

Hi, I use m3 version of Spring batch. There isn't "schema" for Sybase in spring batch execution and there isn't support incrementer for Sybase in Spring jdbc. Is it planned to ...

28. Sybase integration    forum.springsource.org

Hi, Does Spring-Batch provide Sybase MaxValueIncrementer for JobRepositoryFactoryBean. I am trying to use Spring Batch to develop some batch jobs, however, it looks like Spring Batch does not provide Sybase stuff. ...

29. RE: Setting Sybase clientapplname using JDBCTemplate    forum.springsource.org

RE: Setting Sybase clientapplname using JDBCTemplate Hi I have found that when i set clientapplname on a database connection via the JDBCTemplate that when I ask the JDBCTemplate to do something ...

30. Workaround for Sybase's 'empty string'    forum.springsource.org

Workaround for Sybase's 'empty string' Hi all Sybase uses a single blank to denote an empty string (this is by design). So, when inserting an empty string '', it is interpreted ...

31. Please help - JdbcTemplate to handle Sybase    forum.springsource.org

Please help - JdbcTemplate to handle Sybase Dear Experts, I am trying to use JdbcTemplate to connect to the Sybase. Below is the connection string I use: jdbc:sybase:Tds:serverAddress:1234/dbServerName - serverAddress is ...

32. Bug in schema-sybase.sql    forum.springsource.org

Hi all, I tried to run schema-sybase.sql to install all tables in the sybase, and I just found out that a few of fields are using BIGINT as the data type. ...

33. JdbcTemplate sybase stored function no return value    forum.springsource.org

JdbcTemplate sybase stored function no return value I am trying to use jdbctemplate to call a sybase stored function that should return a integer. I have tried various ways of doing ...

34. Can't declare a Sybase Cursor for StoredProcedures using Spring    forum.springsource.org

In the Spring documentation you can only seem to use a RowMapper to get results back from a Stored Procedure if you are using a Specific Oracle SQL Type. I'm unable ...

35. CannotGetJdbcConnectionException in weblogic9 with sybase database.    forum.springsource.org

CannotGetJdbcConnectionException in weblogic9 with sybase database. Hi All, We are using Struts2 + Spring in our project. Project is deployed in weblogic9 application server, sybase as database. In weblogic, we configured ...

36. Sybase compatiblity    forum.springsource.org

Sybase compatiblity Hello, We are implementing a batching project using spring batch. We aim at making the application independent of the database type. While moving to version 2.0.0, I am facing ...

37. Spring JDBC and Sybase Temp Tables    forum.springsource.org

Spring JDBC and Sybase Temp Tables I have a problem, which I think is common, but I haven't had any luck finding and answer to. Here is what I need to ...

38. Spring Batch + Sybase Lower version chunk    forum.springsource.org

Spring Batch + Sybase Lower version chunk Hi, I am using Sybase 12.5 and SpringBatch 2.0.0 But in Sybase 12.5 we are not having BIGINT(But In sybase version 15.0 only we ...

39. ASE not equal Sybase?    forum.springsource.org

ASE not equal Sybase? Hi I am using Spring 2.5.6SEC01 And Sybase(ASE) 15 I use jtds 1.2.2 as my driver because i am having problem using jconnect as my driver because ...

40. Numeric Overflow in Sybase    forum.springsource.org

Numeric Overflow in Sybase Hi, I am using Sybase 12.5 and SpringBatch2.0.2 . I could not use BIGINT in sybase 12.5 So i changed to Numeric(38,0) instead of BIGINT in all ...

41. SERIALIZED_CONTEXT set to empty string on Sybase    forum.springsource.org

SERIALIZED_CONTEXT set to empty string on Sybase Hi, I'm having a problem where it seems that the SERIALIZED_CONTEXT is set to empty string at some point during the batch execution (it ...

42. bit in sybase <-> java type mapping    forum.springsource.org

43. SimpleJdbcCall with Double datatype missing decimal values(SYBASE).    forum.springsource.org

SimpleJdbcCall with Double datatype missing decimal values(SYBASE). Hi All, I'm using SimpleJdbcCall for invoking database procedure as below Code: private void setJdbcCall(String procName) { logger.info("JDBCcall invoking stored procedure name:"+procName); this.procCreateInquiry = ...

44. Change case of queries - sybase    forum.springsource.org

By default sybase is case sensitivite. Spring batch queries are all upper case - if the batch control tables are created with lower case, batch fails to start up. Is there ...

45. Sybase & Spring Batch: JSON does not allow non-finite numbers    forum.springsource.org

Mar 28th, 2010, 09:32 AM #1 pjh View Profile View Forum Posts Junior Member Join Date Dec 2007 Posts 3 Sybase & Spring Batch: JSON does not allow non-finite numbers Getting ...

46. Spring Batch with Sybase    forum.springsource.org

Spring Batch with Sybase Hi, I am trying to configure spring - batch with sybase 12.5.4 database. I downloaded the spring-batch-infrastructure-2.0.4.RELEASE for playing around with the code. I have following issues ...

47. Error while starting up the job with sybase    forum.springsource.org

Nov 10th, 2010, 03:57 AM #1 yogi38 View Profile View Forum Posts Private Message Junior Member Join Date Nov 2010 Posts 6 Error while starting up the job with sybase Hi ...

48. Sybase Explain Plan Not Working    forum.springsource.org

Sybase Explain Plan Not Working The "Execute Text Explain Plan" option is not available when connecting to a Sybase ASE 15 server. Manually setting the showplan on has no effect. I ...