JSqlParser 0,1 travis-ci

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

JSqlParser

Build Status Coverage Status

PayPal donate button

Gitter

Look here for more information and examples: https://github.com/JSQLParser/JSqlParser/wiki.

License

JSqlParser is dual licensed under LGPL V2.1 and Apache Software License, Version 2.0.

News

  • Version 0.9.6 released.
  • Version 0.9.5 released.
  • Please test the actual 0.9.5-SNAPSHOT. It includes some grammar refactorings which eventually results in parse tree changes.
  • Version 0.9.4 released.
  • Please test the actual SNAPSHOT, if there are problems using the extended identifier token.
  • Version 0.9.3 released.

More news can be found here: https://github.com/JSQLParser/JSqlParser/wiki/News.

JSqlParser

JSqlParser is a SQL statement parser. It translates SQLs in a traversable hierarchy of Java classes. JSqlParser is not limited to one database but provides support for a lot of specials of Oracle, SqlServer, MySQL, PostgreSQL ... To name some, it has support for Oracles join syntax using (+), PostgreSQLs cast syntax using ::, relational operators like != and so on.

Support

If you need help using JSqlParser feel free to file an issue or contact me.

Contributions

To help JSqlParsers development you are encouraged to provide

  • feedback
  • bugreports
  • pull requests for new features
  • improvement requests
  • fund new features

Also I would like to know about needed examples or documentation stuff.

Extensions in the latest SNAPSHOT version 0.9.7

  • improved Postgresql JSON - support
  • integrated some Postgresql create table contraints

Extensions of JSqlParser releases

BUILDING from the sources

As the project is a Maven project, building is rather simple by running:

mvn package

This will produce the jsqlparser-VERSION.jar file in the target/ directory.

Maven Repository

JSQLParser is deployed at sonatypes open source maven repository. Starting from now I will deploy there. The first snapshot version there will be 0.8.5-SNAPSHOT. To use it this is the repository configuration:

<repositories>
     <repository>
         <id>jsqlparser-snapshots</id>
         <snapshots>
             <enabled>true</enabled>
         </snapshots>
         <url>https://oss.sonatype.org/content/groups/public/</url>
     </repository>
</repositories>

This repositories releases will be synched to maven central. Snapshots remain at sonatype.

And this is the dependency declaration in your pom:

<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>0.9.6</version>
</dependency>

Related Repositories

Mybatis-PageHelper

Mybatis-PageHelper

Mybatis通用分页插件 ...

RestorableSQLiteDatabase

RestorableSQLiteDatabase

A wrapper to replicate Android's SQLiteDatabase with restoring capability ...

guzzler

guzzler

Stream MySQL binary logs and consume them with Scala actors (RabbitMQ, Kafka). ...

cassandra-jdbc-driver

cassandra-jdbc-driver

Cassandra JDBC driver that works with 2.x and above. It intends to provide bette ...

hbase-sql

hbase-sql

通过sql来查询hbase上的数据 ...


Top Contributors

wumpz CeeKayGit cbockermann georgekankava LionelNirva valdasraps wrobstory skomlaebri davelindquist-egistix bgaborg chiastic-security matthiasblaesing Rodac rotty3000 nhanitvn schweighart shuyangzhou gtss weiznich ig0774 IamJeffG luksrn meganwoods iceflying aalmiray audrium emopers ftaras pabloa packageOk

Releases

-   jsqlparser-0.9.6 zip tar
-   jsqlparser-0.9.5 zip tar
-   jsqlparser-0.9.4 zip tar
-   jsqlparser-0.9.3 zip tar
-   jsqlparser-0.9.2 zip tar
-   jsqlparser-0.9.1 zip tar
-   jsqlparser-0.9 zip tar
-   jsqlparser-0.8.9 zip tar
-   jsqlparser-0.8.8 zip tar
-   jsqlparser-0.8.6 zip tar
-   jsqlparser-0.8.5 zip tar
-   jsqlparser-0.8.4 zip tar