Hi, everybody.
I have two different database in DB2, a in DB2 AS400 and other in DB2 AIX, is possible link this database, similar to link by Oracle?
Thank you in advance.
erva.
I’ve worked on numerous projects where we’ve developed our own frameworks and platforms from scratch and it was never really successful and I’m re-evaluating to rather use a commercial product to assist us with our product development.
If you get a chance to develop an N-Tier system with a SOA layer from scratch would you recommend IdeaBlade with DevExpress? If not what other combinations would you recommend?
Requirements:
- SOA Layer
- Business components
- DAL with database independency as optional
- Developer support
- Easy upgradable
- .NET
- No Royalties
I am on a retained search for a company seeking a Java Developer with Groovy experiencs. They offer a web hosted PBX phone system to small business. This is a permanent position and haveing a tough time finding good talent. Other pluses are JUnit, Scrum,SIP,VXML CCXMLand Junit. Any suggestions, please contact me directly at 727-789-2297 or [email protected]
I'm creating some business logic in the application but I'm not sure how or where to encapsulate it, I've used the repository pattern for data access, I've seen some projects that use DDD that have some classes with the "Service" suffix and the "manager" suffix, what are each of this clases suppose to take care of in DDD?
How to persist XMLType column via JPA/Hibernate? As per oracle documentation, there are two ways in declaring storage clause for XMLType. They are, LOB and Object-Relational. I dont want to go with LOB. I have schema and register into database. I have not have example on how to design my Entity for XMLType. Does any one know please share it?
is there a good database design tool can generate sql script to create database (tables) in major database (Oracle, MySQL, SQL server, Sybase) without any changes?
Which design tool are you think is good.
Hey everyone!
I'm using a Paypal add to cart button for a simple ecommerce website. I had a Paypal IPN handler written in PHP that was successfully working for 'Buy it Now' buttons and purchasing one item at a time. I would run a database query each time to update the store's inventory to reflect the purchase.
Now I'm upgrading this store to a 'cart' version so people could check out with multiple items at a time. Would anyone be able to tell me, in general, how my IPN handler would need to be altered to accommodate this? I'm unsure of what a response from Paypal looks like for a cart purchase as opposed to a buy it now purchase.
Thanks, any help or examples of working IPN cart scripts would be very appreciated! My current code is below..
// Paypal POSTs HTML FORM variables to this page
// we must post all the variables back to paypal exactly unchanged and add an extra parameter cmd with value _notify-validate
// initialise a variable with the requried cmd parameter
$req = 'cmd=_notify-validate';
// go through each of the POSTed vars and add them to the variable
foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}
// post back to PayPal system to validate
$header .= "POST /cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
// In a live application send it back to www.paypal.com
// but during development you will want to uswe the paypal sandbox
// comment out one of the following lines
$fp = fsockopen ('www.sandbox.paypal.com', 80, $errno, $errstr, 30);
//$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);
// or use port 443 for an SSL connection
//$fp = fsockopen ('ssl://www.paypal.com', 443, $errno, $errstr, 30);
if (!$fp) {
// HTTP ERROR
}
else
{
fputs ($fp, $header . $req);
while (!feof($fp)) {
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0) {
$item_name = stripslashes($_POST['item_name']);
$item_number = $_POST['item_number'];
$item_id = $_POST['custom'];
$payment_status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross']; //full amount of payment. payment_gross in US
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id']; //unique transaction id
$receiver_email = $_POST['receiver_email'];
$payer_email = $_POST['payer_email'];
$size = $_POST['option_selection1'];
$item_id = $_POST['item_id'];
$business = $_POST['business'];
if ($payment_status == 'Completed') {
// UPDATE THE DATABASE
}
I've been in the DW business for 15+ years and apart from the Kimball institute and a few blogs, I've yet to find a vital online community for data warehousing topics.
Am I missing out on something or will I need to build it myself?
Question
What is the fastest way to find if an IP address exists in a file that contains IP addresses sorted as:
219.93.88.62
219.94.181.87
219.94.193.96
220.1.72.201
220.110.162.50
220.126.52.187
220.126.52.247
Constraints
No database (e.g., MySQL, PostgreSQL, Oracle, etc.).
Infrequent pre-processing is allowed (see possibilities section)
Would be nice not to have to load the file each query (131Kb)
Uses under 5 megabytes of disk space
File Details
One IP address per line
9500+ lines
Possible Solutions
Create a directory hierarchy (radix tree?) then use is_dir() (sadly, this uses 87 megabytes)
Environment: hudson/sonar/maven2 in ubuntu locally with default parameters
And I got the log from hudson below, I can't figure out where is the problem.
[INFO] Sonar host: http://localhost:9000
[INFO] Sonar version: 2.0.1
[INFO] [sonar-core:internal {execution: default-internal}]
[INFO] Database dialect class org.sonar.api.database.dialect.Derby
[INFO] ------------- Analyzing Game of Life business logic module
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD ERROR
[INFO] ------------------------------------------------------------------------
[INFO] Can not execute Sonar
Embedded error: Can not analyze the project
Cannot stop. Current container state was: CONSTRUCTED
[INFO] ------------------------------------------------------------------------
[INFO] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Can not execute Sonar
Myself mendy, i am designing web application, The business required to integrate payment gateway. I searched on site regarding the flow but i could not get much info on MSDN. I want to make payment gateway using SSL and 3rd party merchant account. How can i do it ? some info regarding payment gateway could guid me to start developing the component.
I was reading the book "Expert C# 2005 Business Objects".
The book describes various base classes to be inherited by various classes to solve real-world problems.
But the book does not provide examples of all those classes.
Can anyone give me all of those examples (with reason) to better understand CSLA?
For example, Which real-world objects are to be considered as Read-only Root Objects (Student/Product/Order, etc.)? And Why?
Hello,
We have a Oracle 9i database and OrderDetails table which has a column to store binary data for product images.
These images can be viewed only using a 3rd party tool. I have no idea which 3rd party tool. and I have no idea of the format of the image.
Is there anyway from the binary data we can find what format is the image?
Thanks
I am sending the messages to Topic using oracle.jms.AQjmsFactory. The messages are stored in DB topic . Using DefaultMessageListenerContainer , the messages are being listen .But the problem is the messages are not dequeueing or deleting from the topic i.e., the messages are stucked in topic.
This article was Part 1 of a two part article.
I cannot find Part 2, "Mastering JList Programming". Google cannot find it.
Did it get lost in the Oracle-Sun move, or was it never published?
Hello!
A friend and I are trying to start our own UK based business.
We both know Java and thought we'd try to implement it using JEE6 and JSP. Can anyone offer some advice on how viable it would be and provide us with resources to consult?
I am hoping to make this question and the answers to it the definitive guide to dealing with daylight saving time, in particular for dealing with the actual change overs.
If you have anything to add, please do
Many systems are dependent on keeping accurate time, the problem is with changes to time due to daylight savings - moving the clock forward or backwards.
For instance, one has business rules in an order taking system that depend on the time of the order - if the clock changes, the rules might not be as clear. How should the time of the order be persisted? There is of course an endless number of scenarios - this one is simply an illustrative one.
How have you dealt with the daylight saving issue?
What assumptions are part of your solution? (looking for context here)
As important, if not more so:
What did you try that did not work?
Why did it not work?
I would be interested in programming, OS, data persistence and other pertinent aspects of the issue.
General answers are great, but I would also like to see details especially if they are only available on one platform.
Summary of answers and other data: (please add yours)
Do:
Always persist time according to a unified standard that is not affected by daylight savings. GMT and UTC have been mentioned by different people.
Include the local time offset (including DST offset) in stored timestamps.
Remember that DST offsets are not always an integer number of hours (e.g. Indian Standard Time is UTC+05:30).
If using Java, use JodaTime. - http://joda-time.sourceforge.net/
Create a table TZOffsets with three columns: RegionClassId, StartDateTime, and OffsetMinutes (int, in minutes). See answer
Check if your DBMS needs to be shutdown during transition.
Business rules should always work on civil time.
Internally, keep timestamps in something like civil-time-seconds-from-epoch. See answer
Only convert to local times at the last possible moment.
Don't:
Do not use javascript date and time calculations in web apps unless you ABSOLUTELY have to.
Testing:
When testing make sure you test countries in the Western and Eastern hemispheres, with both DST in progress and not and a country that does not use DST (6 in total).
Reference:
Olson database, aka Tz_database - ftp://elsie.nci.nih.gov/pub
Sources for Time Zone and DST - http://www.twinsun.com/tz/tz-link.htm
ISO format (ISO 8601) - http://en.wikipedia.org/wiki/ISO_8601
Mapping between Olson database and Windows TimeZone Ids, from the Unicode Consortium - http://unicode.org/repos/cldr-tmp/trunk/diff/supplemental/windows_tzid.html
TimeZone page on WikiPedia - http://en.wikipedia.org/wiki/Tz_database
StackOverflow questions tagged dst - http://stackoverflow.com/questions/tagged/dst
StackOverflow questions tagged timezone - http://stackoverflow.com/questions/tagged/timezone
Other:
Lobby your representative to end the abomination that is DST. We can always hope...
STRAGG function implemention returns a result as a single column value. Implementation for Oracle seems pretty generic and can be consumed for different tables (and relationships). Could similar behavior be achieved for SQL Server. A search in the web, appears to return only hard coded implementations and not a generic one. Do we have any known solution for Sql server?
Hi i am new to ria Services
and i am trying to change the logon from SQL to active-directory and stil using the login form i am using the Silverlight Business Application template as base i have setup ADmembership provider in the website but how do i get Silverlight to use it??
I'm attempting to perform dynamic sorting of data that I'm putting into grids into our MVC UI. Since MVC is abstracted from everything else via WCF, I've created a couple utility classes and extensions to help with this. The two most important things (slightly simplified) are as follows:
public static IQueryable<T> ApplySortOptions<T, TModel, TProperty>(this IQueryable<T> collection, IEnumerable<ISortOption<TModel, TProperty>> sortOptions) where TModel : class
{
var sortedSortOptions = (from o in sortOptions
orderby o.Priority ascending
select o).ToList();
var results = collection;
foreach (var option in sortedSortOptions)
{
var currentOption = option;
var propertyName = currentOption.Property.MemberWithoutInstance();
var isAscending = currentOption.IsAscending;
if (isAscending)
{
results = from r in results
orderby propertyName ascending
select r;
}
else
{
results = from r in results
orderby propertyName descending
select r;
}
}
return results;
}
public interface ISortOption<TModel, TProperty> where TModel : class
{
Expression<Func<TModel, TProperty>> Property { get; set; }
bool IsAscending { get; set; }
int Priority { get; set; }
}
I've not given you the implementation for MemberWithoutInstance() but just trust me in that it returns the name of the property as a string. :-)
Following is an example of how I would consume this (using a non-interesting, basic implementation of ISortOption<TModel, TProperty>):
var query = from b in CurrentContext.Businesses
select b;
var sortOptions = new List<ISortOption<Business, object>>
{
new SortOption<Business, object>
{
Property = (x => x.Name),
IsAscending = true,
Priority = 0
}
};
var results = query.ApplySortOptions(sortOptions);
As I discovered with this question, the problem is specific to my orderby propertyName ascending and orderby propertyName descending lines (everything else works great as far as I can tell). How can I do this in a dynamic/generic way that works properly?
I have been reading about JPA and EJB3 and would like to confirm that my understanding of their relationship is correct. Here's what I think I know...
JPA is a specification that has been implemented by a number of vendors including:
JBoss/Hibernate
Oracle/TopLink Essentials (now EclipseLink)
Apache/OpenJPA
EJB3 is a specification that is implemented in Application Servers including:
Glassfish
JBoss
Is this correct?
Hi,,,
I’m working on an application which has been designed using n-tire application architecture .The application was developed in the .NET platform utilizing C#,VB.NEt, Framework 3.5, Dataset, WCF, asp.net update panel, JavaScript ,Josn, 3rd Party tools.
my current proposed layout is such
presentation layer - Business Logic - WCF - DAL-Data access
The point Is:
Is the above layout the right way to build SOA systems ?
As always, your advice is greatly appreciated
When I being logged it in PayPal follow this link:
https://www.sandbox.paypal.com/cgi-bin/webscr?cmd=_xclick;business=porton_1349611651_biz%40narod.ru;quantity=;item_name=Points;undefined_quantity=1;currency_code=ILS;no_shipping=1;no_note=1;return=http%3A%2F%2Fseostart.co.il%2Fcgi-bin%2Fuser%2Fhome.pl;cancel_return=http%3A%2F%2Fseostart.co.il%2Fcgi-bin%2Fuser%2Fhome.pl;notify_url=http%3A%2F%2Fseostart.co.il%2Fcgi-bin%2Fpaypal%2Fpaypal-notify.pl;custom=user%3D1&invoice=23
I receive message:
You have requested an outdated version of PayPal. This error often
results from the use of bookmarks.
What is the error?
I need to develop a generic entry point for tibco business works based on convention over configuration. Common wsdl that maps our internal complex data model schema in the form of key value approach. I need to develop a palette element that accepts requests and map them in a AESchema objects inside. I have searching about this kind of development with no success.
I have a fairly simple requirement -I have a table with the following (relevant) structure.
with cte as(
select 1 id,'AA,AB,AC,AD' names union all
select 2,'BA,BB' union all
select 3,'CA,CB,CC,CD,CE' union all
select 4,'DA,DB,DC'
)
i would like to create a select statement which will split each "names" column into multiple rows.
For example the first row should produce
1,'AA'
1,'AB'
1,'AC'
1,'AD'
Can we do it using only SQL. This is failry easy to do in Oracle.