Don't you hate it
when a simple database change breaks your app?
You spent months building your software just to scrap a big chunk of it due to a simple database update. Definitely not fun.
To make things worse, most of the broken code is boring, repetitive stuff. You fire up your IDE and start slogging. After fixing one tenth of your queries you consider bringing a crossbow to the next meeting with DBA. Only few hundreds more to go...
Remember that vague feeling that you forgot to fix some code?
Your code compiles and all the tests are green again. Everything should work without a glitch. Than again, maybe you let something slip through? When your application crashes, it costs you real money. Every single minute of outage.
After a few such cycles you start to dread every change. The code diverges from the database and soon it's nearly impossible to change anything in the application.
Stay agile, stay flexible, iterate faster.
OneWebSQL lets you iterate your project faster. Code generator relieves you from boring and repetitive programming. Get your database access layer for free. Generated constants, fluent Java API and IDE code completion helps you build SQL queries fast and without errors.
Regain control despite the changing requirements. Need to change a table or a column? No problem: just update the model, regenerate the sources and compile them again. Need to know which classes were affected by the change? With OneWebSQL every incompatibility is a compilation error. How long did it take you last time to find them?
OneWebSQL stays out of the way
We believe that no solution is perfect for all situations. You can use OneWebSQL as a whole or just some of its parts. If something doesn't quite fit your problem, you can mix and match basic building blocks as needed. They all blend seamlessly with other Java database technologies.
For those cases when the generated code is not enough we give you our JDBC toolkit. You can use any vendor extension or database feature in exception safe and SQL-injection safe way. You don't have to pollute your code with pages of boilerplate JDBC setup and exception handling code. Just focus on important stuff.
- Over 5 millions users use systems built with OneWebSQL.
- OneWebSQL is used in over 30 commercial, enterprise class systems.
- OneWebSQL generated code for over 6,500 tables and views.
- OneWebSQL generated over 6,000,000 lines of code to date.
- OneWebSQL generated over 250 MB of source code to date.
- Last year over 700 millon dollars flew through the systems that use OneWebSQL.
- OneWebSQL is used to build the systems that handle over 1500 TPS (database transactions per second).
- OneWebSQL is used by ING, Amway, Raiffeisen, AEGON and PricewaterhouseCoopers.
It's impossible to make an error
OneWebSQL guards you completely from syntax error. You write SQL queries using object oriented, type-safe, fluent Java API. That makes sure that your queries are always valid. Invalid ones won't compile. Forget about stupid spelling mistakes.
OneWebSQL is SQL-injection safe. Every database command issued by OneWebSQL uses PreparedStatement. Even if you concatenate strings yourself, there's no possibility that OneWebSQL will use it unquoted. Check that worry off your list.
Our JDBC toolkit takes care of connection retrieval, constructing objects in a type-safe way, proper exception handling and cleanup. Do you remember that closing ResultSet can throw SQLException? What about PreparedStatement and Connection? We handle such issues for you.
Learn from our painful mistakes
We, e-point SA programmers, are giving you the years of our programming experience. OneWebSQL reflects our philosophy of how Java should talk to a database.
We value simplicity. We don't believe in magic. OneWebSQL does exactly what you'd expect of it and nothing more. Its operations translate directly to SQL, without any unnecessary logic that tries to know better than you. Remember that nasty surprise when you learned about lazy fetching?
When hunting bugs you want to get to the root cause as fast as possible. What SQL was sent to the database? What data was returned? OneWebSQL gives you full control and visibility with no overhead.
Standard compliance, modern features, IDE support
OneWebSQL makes heavy use of SQL and JDBC standards. We avoid using vendor specific features. When it's not possible we put the necessary code in a dialect specific database adapters.
We rely on modern Java features: fluent APIs, generics and static imports. Write your code in clean, direct style that reflects SQL syntax. Use generated constants and dictionaries together with IDE code completion to code lightning-fast and without errors.
Generics protect you from stupid casting mistakes that are possible when using JDBC directly. Don't worry about column names, types or runtime errors. If your database changes the compiler will flag all invalid code as compilation errors.
Don't waste your talent coding things machine can generate
Code generator takes your graphical database model and spits out all necessary Java sources for your database access layer. You don't have to code anything by hand. What used to take you months of coding now is ready in just a few seconds. Enjoy you free DAOs, DTOs, naming constants, dictionaries, type-safe object builder and more.
Need to change a table or a column? No problem - just update the model, regenerate the code and compile it. Every incompatible change becomes a compilation error. Generator will happily generate everything again. No complaints, no mistakes, perfect reliability. Focus on important code. Leave the boring stuff to the machine.
Powered by e-point SA is a Polish software company. We specialize in Internet Java applications and we are known for our expertise and involvement in Polish Java community. We have almost 16 years of experience in creating and maintaining systems and application which help companies grow using the potential of internet technologies. | Quick Links If you have any questions just drop us an email at contact@OneWebSQL.com | Subscribe to newsletter Get a not-so frequent e-mails about new releases, any updates and new articles. |
