Hippo 7.9 and MySQL - Syntax error: Encountered "null" at line 1

Jayakrishnan R

unread,

Dec 10, 2015, 9:59:50 AM12/10/15

to Hippo Community

Hi All,

I am starting fresh on a project for setting up 7.9 on MySQL. I am trying to deploy it on Glassfish 4.1 on Java 7.

While deploying CMS app I am getting this exception. Any help would be appreciated.

ERROR - ConnectionHelper           - Failed to execute SQL (stacktrace on DEBUG log level): java.sql.SQLSyntaxErrorException: Syntax error: Encountered "null" at line 1, column 120

Info:   ERROR - DatabaseFileSystem         - failed to initialize file system
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "null" at line 1, column 120.
    at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
    at org.apache.derby.client.am.Statement.execute(Unknown Source)
    at com.sun.gjc.spi.base.StatementWrapper.execute(StatementWrapper.java:360)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:307)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:292)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:288)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:542)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:296)
    at org.apache.jackrabbit.core.util.db.CheckSchemaOperation.run(CheckSchemaOperation.java:89)
    at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:194)
    at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1165)
    at org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:916)
    at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:262)
    at org.hippoecm.repository.jackrabbit.RepositoryImpl.<init>(RepositoryImpl.java:61)
    at org.hippoecm.repository.LocalHippoRepository$LocalRepositoryImpl.<init>(LocalHippoRepository.java:243)
    at org.hippoecm.repository.LocalHippoRepository.initializeStartup(LocalHippoRepository.java:302)
    at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:263)
    at org.hippoecm.repository.LocalHippoRepository.create(LocalHippoRepository.java:130)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)

marijan milicevic

unread,

Dec 10, 2015, 10:25:56 AM12/10/15

to hippo-c...@googlegroups.com

Hi,

On Thu, Dec 10, 2015 at 3:59 PM, Jayakrishnan R <jk....@gmail.com> wrote:

Hi All,

I am starting fresh on a project for setting up 7.9 on MySQL. I am trying to deploy it on Glassfish 4.1 on Java 7.

While deploying CMS app I am getting this exception. Any help would be appreciated.

ERROR - ConnectionHelper           - Failed to execute SQL (stacktrace on DEBUG log level): java.sql.SQLSyntaxErrorException: Syntax error: Encountered "null" at line 1, column 120

Info:   ERROR - DatabaseFileSystem         - failed to initialize file system
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "null" at line 1, column 120.
    at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
    at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
    at org.apache.derby.client.am.Statement.execute(Unknown Source)

org.apache.derby

are you sure you are using mysql?

cheers

marijan

    at com.sun.gjc.spi.base.StatementWrapper.execute(StatementWrapper.java:360)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:307)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:292)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:288)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:542)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:296)
    at org.apache.jackrabbit.core.util.db.CheckSchemaOperation.run(CheckSchemaOperation.java:89)
    at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:194)
    at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1165)
    at org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:916)
    at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:262)
    at org.hippoecm.repository.jackrabbit.RepositoryImpl.<init>(RepositoryImpl.java:61)
    at org.hippoecm.repository.LocalHippoRepository$LocalRepositoryImpl.<init>(LocalHippoRepository.java:243)
    at org.hippoecm.repository.LocalHippoRepository.initializeStartup(LocalHippoRepository.java:302)
    at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:263)
    at org.hippoecm.repository.LocalHippoRepository.create(LocalHippoRepository.java:130)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)

--
Hippo Community Group: The place for all discussions and announcements about Hippo CMS (and HST, repository etc. etc.)

To post to this group, send email to hippo-c...@googlegroups.com
RSS: https://groups.google.com/group/hippo-community/feed/rss_v2_0_msgs.xml?num=50
---
You received this message because you are subscribed to the Google Groups "Hippo Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hippo-communi...@googlegroups.com.
Visit this group at http://groups.google.com/group/hippo-community.
For more options, visit https://groups.google.com/d/optout.

Jayakrishnan R

unread,

Dec 10, 2015, 10:50:14 AM12/10/15

to hippo-c...@googlegroups.com

Hi Marijan,

Yes. But it seems to be trying to connect to Derby database.

I am using repository.xml as given in here,
http://www.onehippo.org/7_9/library/deployment/configuring/configuring-hippo-7-for-mysql.html

I have also configured the System properties ( repo.config) to read from that specific file. Also changed depreciated PersistenceManager class to the correct one.

You received this message because you are subscribed to a topic in the Google Groups "Hippo Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/hippo-community/0-dThcaBdqY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to hippo-communi...@googlegroups.com.

Visit this group at http://groups.google.com/group/hippo-community.
For more options, visit https://groups.google.com/d/optout.

--

Thanks & Regards
Jay

Jayakrishnan R

unread,

Dec 11, 2015, 6:48:49 AM12/11/15

to hippo-c...@googlegroups.com

Hi Marijan,

Seems to be a glassfish specific issue. I deleted the default JDBC connection in glassfish and it seems to be working. Essentials application cannot be deployed in glassfish because of the issues with CXF over Metro. But managed to make it working. Thanks for the support.

Jeroen Reijn

unread,

Dec 14, 2015, 9:07:04 AM12/14/15

to hippo-c...@googlegroups.com

Great! Thanks for reporting back!

Jeroen Reijn
Hippo

Hippo Amsterdam office - Oosteinde 11, 1017 WT Amsterdam

Hippo USA, Inc. - 71 Summer Street, 2nd Floor, Boston, MA 02110

US +1 877 414 4776 (toll free)
Europe +31(0)20 522 4466
www.onehippo.com

http://www.jeroenreijn.com | @jreijn | http://about.me/jeroenreijn

Reply all

Reply to author

Forward