Databases
StackOverflow2013
Postsdbo
POSpring Transaction with Sybase
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSpring Transaction with Sybase
    primarykey
    data
    text
    <p>I am using Spring in my Web Application , with the underlying database as Sybase.</p> <p>I have 3 complex stored procedures to be executed. The procs , have <strong>create table</strong> and <strong>drop table</strong> commands to hold temporary result sets.</p> <p>The tables are created in the user db space , rather that in the tempdb space. Hence, I am faced with the need to ensure that the entire service operation from the service bean , that would have DAO objects calling the stored procs, to be serialized. Does simply making the service bean method a Spring Transaction, ensure a solution to potential concurrency related problems in my case? </p> <p>Another thing that I noticed is that, annotating my service method as @Transactional , made the sybase database throw an error : "Create table command cannot be executed within a transaction". Does this mean that Spring makes the entire database operation a transaction? I am really not clear about this , and any explanation would be welcome. Meaning if I have a stored proc named <strong>myproc</strong> . The sybase statement would be <strong>exec myproc</strong>. This,say, is executed by the DAOobject from the service method, annotated as @Transactional. Now does Spring make the database operation as "<strong>begin tran exec myproc end tran</strong>". My observation seems to suggest that. Please explain.</p> <p>And also explain, if just annotation of @Transactional , will solve my concurrency issues. I , actually don't want 2 instances of my stored proc to be running on the database , at a time.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USskaffman
    1. USThe Machine
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CODo the names of the tables that are created start with a # symbol? Are the names fixed, or are they somehow generated on a per-request basis?
      singulars
      1. POSpring Transaction with Sybase
      1. USmartin clayton
    2. COThe tables are not prefixed # , i.e the tables are created in the user db space, rather than the tempdb space. The names are fixed, though the table schema is generated dynamically through dynamic sql, based on the request.
      singulars
      1. POSpring Transaction with Sybase
      1. USThe Machine
    3. CODDL (like create and drop table statements) typically does an implicit commit so you cannot do that as part of a transactional statement hence the error.
      singulars
      1. POSpring Transaction with Sybase
      1. USDoug Porter
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload