JDBC

Hi

anyone has experience with writing and installing a transaction interceptor with jboss AOP?

we have an EJB3 application running on jboss 4.2 and we need to do something before and after a transaction.

 

Thank you for any help.

 

 

shalom 01/12/2009 - 11:52

I can not distribute mysql jdbc driver inside of the my installation bundle, because of GNU license.

 

My question is - may I during installation process (user side) download driver from public repository? is it legal ?

 

Or should I explicitly ask user to refer me to some file?

 

mark 26/08/2009 - 14:38

The following code below wraps Spring's JdbcTemplate, which is a very useful library that let's you use JDBC without the overhead of handling the creation and disposal of JDBC connection, Statement and ResultSet.

 

There are some reasons of using this class instead of using Jdbctemplate directly:

1) The code is very simple to use (only one class).

2) It's a singleton that keeps a cache of javax.sql.DataSource instances.

3) It allows to perform SQL operations (insert, update and query) on many databases without creating a new DataSource each time.

4) The singleton exposes only the most useful API of the JdbcTemplate class.

5) It enforces the usage of Generics when querying for Objects.

 

In order to make this class to run, you need to add the following jar files to your classpath:

org.springframework.core-3.0.0.M3.jar

elad 02/08/2009 - 11:07

Guys, I just came back from a customer who has a problem, they are keeping a large BLOB which contains serialized java classes per each subscriber in their system.

Usually Oracle fetches the BLOB fast enough for them to deliver within their performance goals, but once in a while (about 0.5% of the cases) the fetch takes longer times and causing them delays that are unacceptable.

I have two questions for you:

(1) is that right that Oracle is not a "real-time" system, therefore it will not guarantee response time? why does Oracle sometime takes more time than average to process a query, and can this be optimized by configuration??

(2) does it make sense to store the data not in the database (e.g. file-system, LDAP, SAN, gFS, ...) given that all we need is to be able to lock, read and write the data.

What do you think??

udid 06/10/2008 - 17:40

 This is intended to be used from shell scripts or ant or maven builds to execute SQL scripts. Also it allows to enter SQL commands in interactive mode. In addition to the source code, there is a pre-built binary including all major open-source database drivers. To use Oracle/DB2/MSSQL JDBC drivers you need to download them from the corresponding corporate site.

Hope to hear your feedback.

andrew 07/09/2008 - 09:17
Syndicate content