Submitted by admin on Wed, 08/28/2013 - 11:57
Below are some Hibernate/JPA JDBC Settings for MySQL and SQL Server.
The purpose is mostly to remind myself, but may it will save someone else a few minutes.
MySQL JDBC Data Source
property name="driverClassName" value="com.mysql.jdbc.Driver"
property name="url" value="jdbc:mysql://localhost:3306/example"
SQL Server JTDS JDBC Data Source
property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver"
property name="url" value="jdbc:jtds:sqlserver://localhost:1433/example;"
Submitted by admin on Mon, 09/12/2011 - 11:38
This morning, I took a snapshot of a production, Ruby on Rails database (via rake db:dump), and then applied the production / schema data to other environments.
- Database is Oracle 11
- Application server runs Redhat Enterprise Linux
Assumptions and challenges:
- The Development and QA (Quality Assurance) instances are probably not at the same software revisions or migration version numbers. So... keep that in mind.
Submitted by admin on Sun, 08/14/2011 - 02:38
I have a rake task "db:update_last_status", which I need to have run on remote servers, nightly, to update cached status fields - which are used for fast search capabilities in an RoR application. The RoR application runs on Red Hat Enterprise Linux, an an Oracle database. It would be simple to script that with Cron, but that doesn't lend itself to monitoring or work within the enterprise standards. Capistrano works great, but also isn't within the Enterprise standards.
Submitted by admin on Thu, 06/23/2011 - 04:09
Submitted by admin on Thu, 06/23/2011 - 03:23
# Swap aliases parameter with the principal name
SWAPALIASWITHPRINCIPALNAME( 'Fin_Position' , 'Rename',0 ) ;
IBM Lists the function name, but no documentation of how it works.
Renaming Elements - Provides unofficial documentation on this function.
Submitted by admin on Tue, 05/24/2011 - 09:38
Interacting Debugging Techniques for Coeus, using Eclipse and Tomcat
Presentation notes - from the Kuali Coeus User Conference 2011
Why would you want to do that?
Understanding the architecture
Greater speed in solving problems
Quickly test changes, fixes, or enhancements!
Assist in making Institution-specific changes
Frustrated with lack of documentation
Needed to understand the architecture
Submitted by admin on Tue, 02/15/2011 - 02:30
Back to seeding databases. My previous database seeding post addressed seeing with SQLite. This time, I'm using Oracle 11g as the back-end database, with the Oracle-Enhanced ActivieRecord adapter.
Submitted by admin on Tue, 12/14/2010 - 04:52
I'm the process of upgrading from Coeus 4.3.7 to version 4.4.3. Coeus version 4.4 now uses Apache FOP 0.93. This is a major upgrade from FOP 0.20.x. Coeus uses FOP transform data into reports, through the use of XML and XSL. I've performed the same upgrade for another client, several years back, in an dental-insurance application that managed / generated benefit documents. Due to the changes in FOP, it is necessary to rework some of the Customized reports (expressed as XSL).
These elements rendered fine in Apache FOP 0.20.x, but are show-stoppers in FOP 0.93 and later.
Submitted by admin on Wed, 11/03/2010 - 02:34
Formtastic is a powerful form library for Ruby on Rails. The documentation and tutorials I've read describe using it for the New and Edit actions, for an ActiveRecord, CRUD controller. However, ... wouldn't it be useful to re-use the same Formtastic partials the controller's Show action?
Submitted by admin on Fri, 10/15/2010 - 02:19