Activity for JSqlParser
-
Jinxin Liu posted a comment on discussion Open Discussion
I'm using JSqlParser to parse a long INSERT statement, and it turned out that some values got dropped from the item list. I'm using Oracle, and the table consists of 200 columns of varchar2(400) type, in addition to an auto generated pk column. The INSERT statement is to insert 200 pieces of the msg "Mary has a little lamb, little lamb, little lamb." to the table. It turns out that, in the generated Statement object, the "columns" field contains all 201 columns, but the "itemList" field only contains...
-
Nate Reed posted a comment on discussion Open Discussion
The following statement generates a parsing error: CREATE TABLE foo ( id BIGINT NOT NULL UNIQUE PRIMARY KEY, edit_locked BOOLEAN NOT NULL DEFAULT false, PRIMARY KEY (id) ) Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "true" "TRUE" Looking for some guidance on how I can update the grammar for Psql, as I'm unfamiliar with JavaCC.
-
Martin Lichtin posted a comment on discussion Open Discussion
Forgot to say I'm using version 1.4. Hmm, I don't see class "CCJSqlParser" at https://github.com/JSQLParser/JSqlParser/tree/master/src/main/java/net/sf/jsqlparser/parser even though it should be there?
-
wumpz posted a comment on discussion Open Discussion
Could you check, if the fork at GitHub has the same problem? Cheers Tobias -------- Ursprüngliche Nachricht --------Von: Martin Lichtin lichtin@users.sourceforge.net Datum: 13.09.19 09:53 (GMT+01:00) An: "[jsqlparser:discussion]" 360150@discussion.jsqlparser.p.re.sourceforge.net Betreff: [jsqlparser:discussion] Use of LookaheadSuccess exception LookaheadSuccess exception is used for some logic inside CCJSqlParser. This exception should be declared as "static" Currently a new instance is created for...
-
LookaheadSuccess exception is used for some logic inside CCJSqlParser. This exception should be declared as "static" Currently a new instance is created for each parse() call.
-
pranob Gorain posted a comment on discussion Open Discussion
I am new to JsqlParser.. Can someone please guide in finding all the contraints of a table in Create table statement
-
Mahender posted a comment on discussion Help
Encountered " <s_identifier> "unpivot "" Encountered " <s_identifier> "for "".</s_identifier></s_identifier> The query we are using is: SELECT Xaxis, Xaxiscode, Xaxissub, Yaxis FROM ( SELECT PLN_FNDATE.MONTHNAME_ENGLISH + ' ' + convert(varchar, PLN_FNDATE.[YEAR]) as XAxis, convert(varchar, PLN_FNDATE.[MONTH]) + '/' + convert(varchar, PLN_FNDATE.[YEAR]) as XAxisCode, Convert(Numeric(5,2), SUM(CASE WHEN ORD.STATDAT5 <= ORD.DATGEWGER THEN 1 else 0 END) / Convert(Numeric(9,2),COUNT(ORD.SYSCODE))) * 100...
-
You could give the fork at GitHub a try. Cheers Tobias -------- Ursprüngliche Nachricht --------Von: Karteek pain77@users.sourceforge.net Datum: 22.08.18 11:44 (GMT+01:00) An: "[jsqlparser:discussion]" 360151@discussion.jsqlparser.p.re.sourceforge.net Betreff: [jsqlparser:discussion] net.sf.jsqlparser.parser.ParseException: Encountered " "WITH" "WITH "" HI, select top 1 * FROM [dbo].[DeathMasterFile] WITH(NOLOCK) when i try to use this query i am getting net.sf.jsqlparser.parser.ParseException: Encountered...
-
Karteek posted a comment on discussion Help
HI, select top 1 * FROM [dbo].[DeathMasterFile] WITH(NOLOCK) when i try to use this query i am getting net.sf.jsqlparser.parser.ParseException: Encountered " "WITH" "WITH "" Was expecting one of: <EOF> "AS" ... "DO" ... "ANY" ... "KEY" ... "PERCENT" ... "END" ... "JOIN" ... "LEFT" ... "CROSS" ... "OPEN" ... "FULL" ... "TABLE" ... "WHERE" ... "FOR" ... "PIVOT" ... "XML" ... "UNION" ... "GROUP" ... "INNER" ... "ORDER" ... "RIGHT" ... "VALUE" ... "HAVING" ... "INSERT" ... "VALUES" ... "NATURAL" ......
-
Divya Madhiyazhagan posted a comment on discussion Help
Hi, select colName COLLATE Latin1_General_CI_AS from tableName I am trying to parse the above select statement in which I got ParseExecption. How do I resolve it? If this is an issue, let me know the time frame on when it is getting fixed. Let me know, if any detail needed from my side. Thanks, Divya M
-
Just create an issue at the main project BN and ask your question. If you want to provide pull request you could use your fork. Tobias -------- Ursprüngliche Nachricht --------Von: Nir Peterson tenstriker@users.sf.net Datum: 19.01.18 18:32 (GMT+01:00) An: "[jsqlparser:discussion]" 360151@discussion.jsqlparser.p.re.sf.net Betreff: [jsqlparser:discussion] ColumnNamesFinder from expression Sorry where should I create a request? I forked the repo here if that's what you meant. https://github.com/tenstriker/JSqlParser...
-
Nir Peterson posted a comment on discussion Help
Sorry where should I create a request? I forked the repo here if that's what you meant. https://github.com/tenstriker/JSqlParser
-
Using the fork from GitHub the visitor implementation is quite simple. There are Adapter classes for all kinds of visitors. If you file there a request I will happily provide a minimum example for your request. Cheers Tobias -------- Ursprüngliche Nachricht --------Von: Nir Peterson tenstriker@users.sf.net Datum: 18.01.18 23:49 (GMT+01:00) An: "[jsqlparser:discussion]" 360151@discussion.jsqlparser.p.re.sf.net Betreff: [jsqlparser:discussion] ColumnNamesFinder from expression Is there any method other...
-
Is there any method other then implementing Visior to get list of all columns from expression. I am trying to parse sql function. e.g. sum(t1.amount)/count(t1.name) and get all column names. i.e. {"t1.amount", "t1.name"} Thanks
-
Is there any other method other then implementing Visior to get list of all columns from expression. I am trying to parse sql function. e.g. sum(t1.amount)/count(t1.name) and get all column names. i.e. {"t1.amount", "t1.name"} Thanks
-
Is there any easier method other then implementing Visior to get list of all columns from expression. I am trying to parse sql function. e.g. sum(t1.amount)/count(t1.name) and get all column names. i.e. {"t1.amount", "t1.name"} Thanks
-
If there is a problem with getTableList using JSQLPARSER from github, actual version 1.1, file an issue there. Create statements are processed, but maybe there is a bug. Add an example of what you try to achieve. -------- Ursprüngliche Nachricht -------- Von: Gabor Markon markonixx@users.sf.net Datum: 08.10.2017 10:58 (GMT+01:00) An: "[jsqlparser:discussion]" 360151@discussion.jsqlparser.p.re.sf.net Betreff: [jsqlparser:discussion] AW: [jsqlparser:discussion] getTableList question @wumpz: I WORK...
-
Gabor Markon posted a comment on discussion Help
@wumpz: I WORK actually with the getTableList. The problem is, it does not process the TABLE CREATE right. I suppose the code is prepared to process it, just like SELECT, INSERT,... but is (still) not fully implemented.
-
The fork from github does that already. There you have a getTableList for statements. -------- Ursprüngliche Nachricht -------- Von: Gabor Markon markonixx@users.sf.net Datum: 04.10.2017 11:56 (GMT+01:00) An: "[jsqlparser:discussion]" 360151@discussion.jsqlparser.p.re.sf.net Betreff: [jsqlparser:discussion] getTableList question Hello all, I've tried to use the TablesNamesFinder for a TABLE CREATE statement, which obviously not usable, because the getTableList function is only valid for DeleteIinsert/Replace/Select/Update....
-
Hello all, I've tried to use the TablesNamesFinder for a TABLE CREATE statement, which obviously not usable, because the getTableList function is only valid for DeleteIinsert/Replace/Select/Update. Is there any way to make this possible? Greetings Gábor
-
As you are talking about V1 maybe you are using the github fork? Didn't you file...
-
Devanshi Shah posted a comment on discussion Open Discussion
Thanx Leonardo Francalanci Can you please suggest me any other option for this? Because...
-
Leonardo Francalanci posted a comment on discussion Open Discussion
alter table/drop index are not managed yet...
-
I am getting the following exceptions 1)Caused by: net.sf.jsqlparser.parser.ParseException:...
-
Since it instantiates everyone a new Parser instance and the parser is built not...
-
Piotr Jurgaś posted a comment on discussion Open Discussion
Hello everybody Does anybody know if the class CCJSqlParserManager is thread saf...
-
JSQLPARSER fork at github allows hopefully all UTF8 defined letters. Therfore your...
-
beekay posted a comment on discussion Help
Unable to parse the following statement containing latin small letter I, SELECT [Categorías].[Categoría]...
-
Tom Moore posted a comment on discussion Help
Belay that. There is a handy method in the CCJSqlParserUtil class that parses multiple...
-
I have files containing SQL code that I would like to parse. Most of these files...
-
Salil John posted a comment on discussion Help
I need to enforce the use of a field in all the where claused being fired against...
-
Jsqlparser at github supports at least oracle's special join. -------- Ursprüngliche...
-
shiyasong posted a comment on discussion Help
The Second Problem is The Lock SQL: SELECT * FROM TABLE WHERE COL1='A' FOR UPDATE...
-
My Dear Friends : The frist, my english is not good. i'm from china. Then , i have...
-
Nvl and decode are parsed as functions using the version at github. O.9.5 was just...
-
varun kashyap posted a comment on discussion Open Discussion
Hi I am new to JSQLParser and we want to use it to automate schema creation in a...
-
This class was introduced within the fork at github jsqlparser/jsqlparser. Currently...
-
VictorS posted a comment on discussion Open Discussion
Hello I downloaded jsqlparser-0.7.0.jar and I included it in my project but the class...
-
codeFresher posted a comment on discussion Open Discussion
Hi, I am new to JSQL Parser. I was trying to parse the following query using JSQLParser...
-
Forked version 0.9.x at github already includes this kind of cast. -------- Ursprüngliche...
-
Jussier Ramos posted a comment on discussion Help
I have query with implicit conversion (::bigint) in PostgresSQL: SELECT te.ci_etapa,...
-
I have query with implicit conversion (::bigint) in PostgresSQL: SELECT te.ci_etapa,...
-
I am new to JSQL parser and while working with the parsing, I found that the columnreference...
-
jiangjin posted a comment on a wiki page
1:Test Code: try { Statement stat = (Statement) new CCJSqlParserManager().parse(new...
-
daxiang posted a comment on discussion Open Discussion
Hi All, I meet a problem while using jsqlparser.jar, there may be a bug of the jar....
-
JSqlParser released /OldFiles/jsqlparser-0.1.jar
-
aj250037 modified a comment on discussion Open Discussion
getMessage from JSQLParserException spits out - null... using version - 0.7.0 ===========================================================...
-
getMessage from JSQLParserException spits out - null ===========================================================...
-
shanawaz modified a comment on discussion Help
Hi , Please find below one of the sample update query in teradata update t1 From...
-
-
Hi , Please find below the one type sample update query in teradata update t1 From...
-
Hi , Please find below the one type sample update query in teradata update t1 From...
-
Hi , Please find below the sample update query in teradata update t1 From table t1...
-
Could you give an example? -------- Ursprüngliche Nachricht -------- Von: shanawaz...
-
i am trying parse teradata sqls , but parser was getting failed for most of the sql,...
-
highnoon modified a comment on discussion Help
Thanks, I figured it out and posted the code in help. I'm now running into couple...
-
Thanks, I figured it out and posed the code in help. I'm now running into couple...
-
I am reading files that have multiple statements in them with comments. I want to...
-
Okay figured out how to read in file with multiple statements. CCJSqlParser parser...
-
I am reading files that have multiple statements in them with comments. I want to...
-
Okay figured out how to read in file with multiple statements. CCJSqlParser parser...
-
The fork at github has statements processing included. Look at the examples. I don't...
-
I am reading files that have multiple statements in them with comments. I want to...
1