Snip
|
What is SQL4J ?
|
|---|
Categories |
|
|---|
For Snip |
loading snip actions ... |
|---|---|
For Page |
loading url actions ... |
What is SQL4J ?
SQL4J is an SQL parser written in Java. SQL4J parses SQL and fills in java structures representing SQL statements and expressions.SQL4J can parse all the queries given as examples in the following SQL test. Some features of the parser include:
- It can recover from errors;
- It can identify the position and token of the error;
- It can identify the position of each syntactic item;
The result of the parsing is an object that represents the tree structure of the SQL statement. See the SQL4J API documentation for more information on the SQL4J structures.
Why SQL4J?
SQL4J is intended to process the SQL instead of executing the SQL. Some example applications are:
 | Migrate SQLs from the legacy system to a new database system; |
| Migrate SQLs from one dialect to another; |
| Translate the SQLs to EJB-QL; |
| Generate the EJBs or DAO from the SQL; |
| Query rewriting for integrating federated database systems. |
HTML |
<h2><font face="Times New Roman"><font face="Arial, Arial, Helvetica">What is SQL4J ?<!--mstheme--></font></font></h2> <font face="Times New Roman">SQL4J is an SQL parser written in Java. SQL4J parses SQL and fills in java structures representing SQL statements and expressions. </font><p><font face="Times New Roman">SQL4J can parse all the queries given as examples in the following <a href="http://www.cs.toronto.edu/%7Ejglu/sql4j/parsable.zip">SQL test.</a> Some features of the parser include: </font></p><ul> <font face="Times New Roman"><li> It can recover from errors; </li><li> It can identify the position and token of the error; </li><li> It can identify the position of each syntactic item; </li></font></ul> <p><font face="Times New Roman">The result of the parsing is an object that represents the tree structure of the SQL statement. See the SQL4J <a href="javaDoc/index.html">API documentation</a> for more information on the SQL4J structures. </font></p><h2><!--mstheme--><font face="Times New Roman"><font face="Arial, Arial, Helvetica">Why SQL4J?<!--mstheme--></font></font></h2> <p><font face="Times New Roman">SQL4J is intended to process the SQL instead of executing the SQL. Some example applications are:</font></p> <!--mstheme--><!--msthemelist--><table border="0" cellpadding="0" cellspacing="0" width="100%"> <!--msthemelist--><tbody><tr><td valign="baseline" width="42"><img src="_themes/jianguoblankhome/blbull1.gif" height="15" hspace="13" width="15"></td><td valign="top" width="100%"><!--mstheme--><font face="Times New Roman">Migrate SQLs from the legacy system to a new database system; <!--msthemelist--></font></td></tr><tr><td valign="baseline" width="42"><img src="_themes/jianguoblankhome/blbull1.gif" height="15" hspace="13" width="15"></td><td valign="top" width="100%"><!--mstheme--><font face="Times New Roman">Migrate SQLs from one dialect to another; <!--msthemelist--></font></td></tr><tr><td valign="baseline" width="42"><img src="_themes/jianguoblankhome/blbull1.gif" height="15" hspace="13" width="15"></td><td valign="top" width="100%"><!--mstheme--><font face="Times New Roman">Translate the SQLs to EJB-QL; <!--msthemelist--></font></td></tr><tr><td valign="baseline" width="42"><img src="_themes/jianguoblankhome/blbull1.gif" height="15" hspace="13" width="15"></td><td valign="top" width="100%"><!--mstheme--><font face="Times New Roman">Generate the EJBs or DAO from the SQL; <!--msthemelist--></font></td></tr><tr><td valign="baseline" width="42"><img src="_themes/jianguoblankhome/blbull1.gif" height="15" hspace="13" width="15"></td><td valign="top" width="100%"><!--mstheme--><font face="Times New Roman">Query rewriting for integrating federated database systems.</font></td></tr></tbody></table> |
|---|
